Use this table to link General Ledger cash accounts to codes representing the bank accounts that hold your payroll and accounts payable funds. Based on Bank Account Information records, you can select check records to send to your bank using the Bank Transmission File option, or you can select the appropriate transactions for reconciling against your bank account statement when using the Bank Account Reconciliation option.
When you set up this table for bank account reconciliation, you may also need to add records for bank account fees and interest. Use a valid budget unit (low level Organization Chart record) and expense account combination for each record associated with fees. Use a valid budget unit and revenue account combination for each record associated with earned interest.
You must set up a separate record for each Fund/Account combination that applies to your checking transactions. Accounts payable checks often require multiple records, whereas payroll checks require only one record per bank account.
Menu Path
From the Fund Accounting menu, select Reference Tables. In the Fund Accounting menu, select Bank Account Information.
Set Up and Use Bank Account Information Records
Bank Account Information records are used in two Fund Accounting options: Bank Transmission File and Bank Account Reconciliation. In both cases, you select the appropriate Bank Account code when running the option. The Bank Transmission File option is also available in Human Resources.
The following are brief explanations for setting up records in the Bank Account Information table to ensure your co-workers have the codes they need when using the related Fund Accounting options.
Bank Transmission File
The Bank Transmission File option allows your accounts payable and payroll personnel to select check records from your database, format them using a template that follows bank specifications, and generate a data file to send to the appropriate bank.
Your co-workers will select a Bank Account code, which limits the check records the system includes in the bank file to those for a combination of disbursement fund and cash account.
For payroll checks, you need to set up a Bank Account Information record for the Payroll Fund and Payroll Cash account defined in the Fund Accounting Profile. This fund-and-account combination needs to be set up for each bank account your site uses to issue paychecks. If you use two bank accounts for payroll, then set up two Bank Account Information records with unique Bank Account codes.
For accounts payable checks, set up a record for each bank account you use for issuing payments to vendors. Each record will have a disbursement fund and cash account. If you have a bank account that is associated with more than one disbursement fund and cash account combination, you can create multiple records using the same Bank Account code.
For details, refer to:
Bank Account Reconciliation
For Bank Account Reconciliation to process transactions correctly, the Bank Account Information table must include an entry for each fund-cash account combination associated with a bank account. Do not limit entries to the disbursement fund only. If entries for any fund-cash account combination are missing, transactions for those funds will not load during reconciliation.
The Bank Account Reconciliation option allows your accounting personnel to select transaction records from your database for a specified date range. These transactions can then be reconciled against your monthly bank statement.
In addition to a date range, employees select a Bank Account code, which limits transactions to the disbursement fund and cash account for checks, receipts, and journal entries, based on the fund and account.
In terms of table setup, follow these basic guidelines:
-
Add records for all bank accounts used for checks and receipt deposits.
-
Associate fund and account combinations with the correct Bank Account codes. If needed, you can have multiple records with the same Bank Account code.
-
For each bank account, add a separate entry for every fund and cash account combination that you use, including funds that route payments through a shared disbursement fund. Limiting entries to the disbursement fund only excludes transactions for other funds from reconciliation.
In addition to selecting transactions, the Bank Account Reconciliation option allows you to generate journal entries for bank fees and earned interest reported on a bank account statement. The Bank Account Information table includes the Fee and Interest checkboxes, allowing you to set up records for these purposes. -
To use a Bank Account Information record for processing fee journal entries, enter a valid budget unit and account from the Expenditure Ledger. Also, make sure the Fee field is selected.
-
To use a Bank Account Information record for processing interest journal entries, enter a valid budget unit and account from the Revenue Ledger. Also, make sure the Interest field is selected.
-
For each unique Bank Account code where fees or interest apply, there should be only one associated Bank Account Information record with the Fee field selected and another record with the Interest field selected.
For details, refer to Bank Account Reconciliation.
Add Bank Account Information Records
-
On the Bank File Account Information page, select Add new.
-
Enter data in the fields in the Bank Information Data section.
-
Select Accept to save the record.
Display a List of Bank Account Information Records
-
On the Bank File Account Information page, in the Bank Account field:
-
Enter a bank account number to list the table records for that account.
-
Leave the field blank to display all records in the table.
-
-
Select Search to display records matching your entry.
-
In the List section, use the down arrow key to scroll through the records.
-
If desired, select the Print icon to generate a report of the listed bank accounts. In the Print window, select the destination format. The default name is bankacct.rpt.
-
Select Back to return to the Search Criteria section.
Change a Bank Account Information Record
-
Follow the steps to display a list of records.
-
In the List section, select the record you want to change.
-
Select Accept.
-
In the Bank Information Data section, change the desired fields.
-
Select Accept to save the record.
Delete a Bank Account Information Record
-
Follow the steps to display a list of records.
-
In the List section, select the record you want to delete.
-
Select Delete.
-
In the Confirmation dialog, select Yes.
Fields and Descriptions
Bank Information
|
Field |
Description |
|---|---|
|
Bank Account |
Number identifying a checking account. The bank account number, in combination with the *Budget Unit* and Account codes, identifies a Bank Account Information record. As a result, an account can have multiple records. The limit is 20 characters. |
|
Title |
Enter the name of the Bank. The limit is 35 characters. |
|
Print AP Checks |
Select this option to print AP checks using the bank account number you are creating. If you select this option, the Bank Account for AP Check Print field is not available. |
|
Bank Account for AP Print Check |
Select the bank account to be used for printing AP checks if the Print AP Checks option is not selected. |
|
Print Payroll Checks |
Select this option to print payroll checks using the bank account number you are creating. The Bank Account Information table can have only one record when Print Payroll Checks is selected. If there is an existing record designated to print payroll checks, a message appears for you to confirm if you want to switch the Print Payroll Checks option to the current record and remove it from the previously designated record. |
|
Default Cash Account Number |
This field is optional. The default cash account number that you want to associate with the bank account. If the Full Account Format option is enabled in the Fund Accounting Profile, the cash account must be entered in GL account number format. Otherwise, the default cash key organization and account must be entered. |
Account Details
|
Field |
Description |
|---|---|
|
*Budget Unit* |
Organization Chart code for the ledger account associated with the Bank Account Information record. Generally, this will be a fund (Level 1) record, since both check records and receipts reference funds.
|
|
Account Number |
Account List code for the ledger account associated with the Bank Account Information record. Generally, this will be a cash account in the Assets range from the Fund Accounting Profile. The *Budget Unit*/Account combination must exist on the General Ledger. Multiple bank accounts cannot use the same cash account. Therefore, enter a unique cash account number.
|
|
Cash |
Select the Cash checkbox if the account is a General Ledger account. |
|
Fee |
Select the Fee checkbox if the record is used for processing bank fee journal entries with the Bank Account Reconciliation option. Otherwise, leave the box blank. |
|
Interest |
Select the Interest checkbox if the record is used for processing earned interest journal entries with the Bank Account Reconciliation option. Otherwise, leave the box blank. A Bank Account Information record must never have both the Fee and Interest checkboxes selected. Also, for a Bank Account code that applies interest, there must be only one associated Bank Account Information record with its Interest checkbox selected. |
Check Numbering
The Check Numbering tab appears if the database is set up to use automatic check numbering and based on user resources.
|
Field |
Description |
|---|---|
|
Document Type |
Use the lookup to select one or more document types that use the bank account for processing checks. You can enter different sequences for different check and voucher types. Options may vary depending on whether Print AP Checks or Print Payroll Checks is selected, as well as user resources. For example: If Print Payroll Checks is selected, the list may include:
If Print AP Checks is selected, the list may include:
|
|
Next Number |
Enter the next number to be used for the bank account check series. Be careful to avoid overlapping check numbers. |