Advanced Bank Reconciliation (ABR) is a Nolan Business Solutions module for Microsoft Dynamics GP that provides a more automated, multi-currency supported bank reconciliation. This module does not require the Dynamics GP Bank Reconciliation module to be registered.

GP transactions are extracted into the Reconcile Bank Transaction window, directly from the general ledger (GL). The bank statement information  can  either  be  imported  or  manually  entered  into  the  system. Automatic transaction matching occurs by amount when the Propose button is used, however advanced transaction matching occurs either manually or by using Transaction Type defined Reconcile Rules. ABR supports matching transactions that are either a one-to-one, many-to-one, or many-to-many. A full audit trail of all reconciliations can be recorded and printed.

Support is provided for a system with:

1. Multiple bank accounts.
2. Bank accounts tracking transactions in multiple general ledger accounts.
3. Multi-currency transactions.

Advanced Bank Reconciliation Features:

• General Ledger transactions extracted directly from the General Ledger (GL)
  All transactions posted to the “Associated GL Account” for the Bank ID, rather than being generated by a separate posting process. This means that the full functionality of the General Ledger is available, such as multi-currency and recurring transactions.
• Bank statements can be imported or manually entered
  The availability of user defined import formats (.csv) allow you to create and maintain customizable bank import definitions for importing the bank statements. In addition, a BAI format as defined in  Appendix A: BAI File Format.
• Simple reconciliation
  The reconciliation window has been designed to be simple and intuitive, while maximizing the ability to reconcile transactions. The Propose function removes a large amount of labor by matching any transactions that may be automatically recognized by the system. The Reconcile Propose Rules window allows for clear definition of the rules to be used for matching transactions.
• Full reporting and audit information
  The system produces full reconciliation reports with an audit trail for each reconciliation completed.  Where the un-reconciled/reconciled bank account system is being used, reconciliation information is posted through Dynamics GP General Ledger producing the normal reporting and audit information of Dynamics GP. Standard reports are also provided to show reconciled and un-reconciled transactions, from both Dynamics GP General Ledger and the bank statements. For example, the Closing Balance Report shows the detail of the calculated closing balance, based upon the statement ending balance and the un-reconciled transactions.
• Posting in Summary with detailed Reconciliation
  When posting to the GL in Summary within GP, the details of the transactions are typically lost. However, with ABR it is possible to retrieve those lost details from the Payables management module and use them during reconciliation.
  
                 Posted in summary – AP Checks is the only case where ABR can drill back from summary GL.         
                 Posted in detail – AP and AR transactions will attempt to retrieve a check number.         
                 Posted in summary in payroll is not supported in the Advanced Bank Reconciliation module.