Location
Tools >> Setup >> Financial >> Advanced Bank Reconciliation >> Bank Setup
Layout
Overview
The Bank Account Setup window is used to create ABR Bank Account IDs. The ABR Bank Account IDs define which GL account(s) are related to which bank accounts. One Bank Account ID should be setup for each account at the bank that will be reconciled.
Note: More than one GL cash account can be associated to each ABR Bank Account ID
Entering in the bank’s information is for reporting purposes only. Account Holder and address information are optional.
Fields
Bank Account ID – A unique identifier for the Bank Account. If you have existing Checkbook IDs, you can use the same name.
Account Number – The bank’s account number. This field is used during the import, along with the routing number, when the bank statement import file contains transactions from multiple bank accounts. This field needs to match the value in the bank file, and can only be changed in SQL Server Management Studio.
Note: If the account number is too long, enter all that will fit and remember to trim the related field on the import definition accordingly. For example, if the Bank Account number is 12345678910123456, only the first 15 digits will fit, so enter 123456789101234 and make sure to set up the Format Definition with “1” for Start and “15” for End. Refer to Statement Import Format (Format Definition) for details.
Description – The description of the Bank Account.
Bank Name – The name of the bank.
Statement Currency – The currency of the bank statement transactions. Statement currency is required regardless of whether or not multicurrency is being used.
Note: If multicurrency is not currently setup and the Dynamics GP functional currency is blank, then it will need to be defined. Refer to Appendix C: Functional Currency for details.
Working Currency – The working currency of the Bank Account. (defaults in from the Statement Currency field.)
Routing Number/ Sort Code – The routing number/sort code for the bank. This field is used during the import, along with the account number, when the bank statement import file contains transactions from multiple bank accounts. This field needs to match the value in the bank file, andcan only be changed in SQL Server Management Studio. .
Note: If the routing number is too long, enter all that will fit and remember to trim the related field on the import definition accordingly. For example, if the Sort Code/Routing Number is
121200003434565678789090, only the first 20 digits will fit, so enter 12120000343456567878 and make
sure to set up the Format Definition with “1” for Start and “20” for End. Refer to Statement Import
Format (Format Definition) for details.
Account Holder – The registered name on the bank account.
Address 1 – The address of the bank branch.
Address 2 – The second line of the address of the bank branch.
City – The city of the bank branch.
County – The county of the bank branch.
Post – The zip code of the bank branch.
Last Statement Number (read only) – The last statement number for this Bank Account.
Last Statement Date (read only) – The date of the last statement for this Bank Account.
Last Statement Balance (read only) – The ending balance of the last statement imported for this Bank Account.
Last Reconciled Date (read only) – The date this Bank Account was last reconciled.
Related Checkbook ID – The GP Checkbook to use for this account. This field is optional. When a Checkbook ID is selected here, the associated GL account will auto populate in the first row of the grid below.
Associated GL Account – The GL account(s) from which ABR will extract transactions for during the Extract Transaction routine. One or multiple GL accounts can be assigned to each Nolan Bank Account. When a Checkbook ID is assigned to a Bank Account, then the GL Account associated to the Checkbook ID will default in to the Associated GL Account field. The first GL Account row is reserved for the GL account assigned to the Checkbook ID. (this row will be blank if no Checkbook ID is selected above) Additional GL accounts can also be added.
Reconciled Account – The account for which a reconciled transaction will be added to during the Reconcile process. For each GL transaction line that is reconciled during the Reconcile process, a duplicate GL entry will be created against the Reconciled Account. This field is not required.
Buttons
Save – Save the current definition
Delete – Delete the current definition. An account cannot be deleted if activity has been processed for the account. The Delete Bank Account utility must be used once activity is processed.
Clear – Clear all fields
Options – The BAI Format Options screen can be accessed from the Options button. This option is applicable only for the selected Bank Account ID. The user can override the company BAI format option for a specific Bank ID from this window when check numbers need to be imported from different BAI fields.
*There are also Bank ID level BAI Format Options, Extract Options, Reconcile Rules and Account Number Aliases.
