|
Automated Control Account Reconciliation for Microsoft Dynamics GP
Developed to aid Accountants, The Reconciler is an invaluable tool which validates transactions that have been entered into Receivables and Payables against their respective control accounts within the GL and supports best practice financial reconciliation guidelines.
The Reconciler improves internal control by searching through vast volumes of data and automatically highlights the cause of any imbalances between the Accounts Receivable or Accounts Payable modules and the General Ledger Control Accounts.
The Reconciler automatically summarizes Receivables or Payables transactions, including AR and AP accrual entries, for any GL Posting Date range, from a single day to an entire financial year. If any issues are evident at the initial Reconciliation summary level, the amount will be displayed in the “Difference box”. Next simply press the “Cross Tick” Button and click on “Show Exceptions”. The Reconciler will do the rest for you! The source transactions causing the imbalance will be identified and displayed for you - totally automatically, ensuring more accurate accounts receivable and accounts payable reports, enhancing accounts receivable and accounts payable internal controls strengths.
Immediate drill-down options are available, such as the one illustrated where you can move directly to the source transactions and their related data.
 |
| Reconciler will identify any accounting differences between RM, PM and GL Control Accounts
|
|
Key Benefits
- Unique Sequential Numbering (USN) of all Receivables & Payables transactions
- Automated reconciliation of Receivables & Payables Modules to GL Control Accounts
- Enhanced drill-down options to view the erroneous source transactions, including AR & AP accrual entries
- Reconciles any number of Control Accounts to source transactions in Receivables & Payables
- Handles reconciliation of currency exchange gain and loss movements generated by Receivables and Payables
- Sorting and printing options available throughout
- Tracks the GL movements arising from Voided transactions in Receivables & Payables
- Efficient and simple to use
- Supports European methods of Accounting and best practice internal control and financial reconciliation guidelines.
- Allows reconciliation of both open and closed financial years
 |
| Use the Day Book option with Reconciler to view your PM, RM and Control Account totals
|
|
The Reconciler works on records from both open and closed years, and can also be used retrospectively to pick up non-reconciling items that occurred prior to its installation.
Setup of Reconciler could not be easier! Once installation is complete all that is required is for you to identify Control Accounts for both the Receivables & Payables series. You will then be ready to start using the Reconciler as an integral part of your daily and monthly routines.
You can even use The Reconciler to print full transaction prints (Day Book Listings) not available anywhere else in Dynamics GP. Now you can view all entries within the period and zoom down to the source documents. Any window within The Reconciler can be printed, producing invaluable period end reports.
 |
| The Day Book Listing ‘zoom’ options will allow you to view all types of different transactions within the specified range. Select File >> Print to retain a hard copy of any Reconciler screen.
|
|
The Reconciler also provides users with the ability to track both sales and purchase transactions effectively through the “Unique Sequential Numbering” (USN) operation. This additional functionality, meeting European Reporting requirements, means that transaction print listings will identify gaps in the Voucher Number sequencing quickly and easily. This additional feature is delivered by attaching a USN to all documents at the time of posting.
The Reconciler is also now available for Inventory accounts. Sold as a seperate module - Inventory Reconciler.
The Reconciler could save you hours -possibly days - each time you use it! You would probably find that the Reconciler would take less than 1% of the time it would take a competent Accountant to do the equivalent reconciliation task “manually”.
Efficient and simple to use, The Reconciler – a natural addition to every GP system!
You can download this information as a PDF Datasheet, the Reconciler for AR & AP User Guide, the Install notes and even the product itself by visiting the Download Centre!
|
