How to Setup Bank Deposit Accounts

1. Under "System Setup" go to "Bank Deposit Setup." Please refer to picture below:
systemdefault9.PNG

2. Once you click "Bank Deposit Setup" a browse window will appear labeled "Bank Table" that looks like this:
systemdeafult10.PNG

Each day you are taking many payments that need to be deposited to your bank. You may have multiple funds such as the 2 most common: general fund, and enterprise fund which would be something like utilities. Each of your payments can be made in different ways such as cash, check or credit card. GovCollect sets up all of these accounts for you, you just have to select which ones your city uses. For example: Property Tax, you could have a payment source of Cash, Check, or Credit Card. Say your General Funds are deposited into "Bank 1" and Enterprise Funds are deposited into "Bank 2." Bank Deposit Setups allows GovCollect to separate these funds and also allows you to separate payments. You could have multiple banks where your funds are held.

For example:
You have a payment of $100,
GovCollect will tell you $20 may go to utilities and the other $80 to another account.

This area may be new to you so let's try to keep it simple.
1. You must have an entry for EVERY APPLICATION type you use (Property, License, Utility, Citation, Misc).


2. For each APPLICATION you must have an entry for EACH PAYMENT SOURCE you accept (Check, Cash, Credit Card, etc).  If you do not have it listed in this area, you will get an error during balancing telling you that the TYPE does not exist in the Bank Deposit table. To fix just come in here and ADD it. DO NOT delete any of them.


3. To make it easy on you, GovCollect comes standard with default values for every possible APPLICATON and every PAYMENT SOURCE.  All you have to do is modify these entries with the following correct information.


A. "Cash G/L Account Number From Tranctl" field - Replace this field with your GL CASH account number that you entered into the PAYMENT DEBIT field on your tran codes.  In your demo data the word CASH is used in these fields.  For example, if the APPLICATION = Property (property tax), then you would enter your property tax CASH GL Number in this field.  If the APPLICATION = License (Busines License type revenue), then you would enter your business license CASH GL Number in this field.

B. "Master Deposit GL Number" - This field is the bank account from your chart of accounts that you are depositing these types of funds into. It is a good idea to make it the same as the "cash g/l from tranctl" as long as you are not using the bank table to link to your accounting software. Remember, it is NOT required to set up the bank table to link with your accounting software but may be useful for you moving forward.


C. Bank Account Fields - These are descriptive and not required but helpful.


D. "Produce Root Bank Entries" - To make it easier on you, pushing this button will create bank table entries based upon the APPLICATION for every CASH account you have setup in your tran codes.


In order to change Due To/Due From please consult your accountant. 

This feature is commonly used when you deposit all monies into a single deposit account and then move money to different bank accounts using some kind of online banking transfer system from your bank.

*Note - In this area most items go to the same deposit account but with Credit Cards, if you did not use your normal bank to process credit cards you may need to setup a different deposit account for credit card monies.