Take the mystery out of finding unmatched transactions in Microsoft Dynamics GP. If your AP, AR, or cash sub ledgers don’t match your General Ledger, then try out this handy GP tool, Reconcile to GL.
Reconcile to GL was introduced Microsoft Dynamics GP version 10.0 and since then it has been a helpful tool for managing account balances correctly. It quickly points out where you have missing or unmatched transactions. Here’s how to use Reconcile to GL:
1. Open the Reconcile to GL screen in Dynamics GP.
2. Change the module to Receivables Management
3. Enter a reconciliation date
4. Enter from and to dates
5. Enter the main A/R accounts
6. Enter a place for the Output files
7. Select “Process” (icon on top left corner) and the report will print.
8. Check to see Unmatched Transactions.
Note: You will also see the reconciliation when you scroll to the bottom.
If they do not match you can subtract one from the other to see your difference.
Normally this is what you have in the transactions that are unmatched at the top of the report.
Each change in color on the report is another entry or batch.
If something has hit the subledger and not the GL:
9. Check that there are no batches sitting in the GL waiting to be posted.
10. Check your posting setup that both check marks are in for Post to and Post thru for the series.
11. If you have something in the sub-ledger and not in the GL, you may have to create an entry to the GL balance it.
Tip: Look for a date issue to see if perhaps something is posted in the next month or previous month before making an entry.
For more great Microsoft Dynamics GP tips and tricks visit www.calszone.com/tips
By CAL Business Solutions Inc., Connecticut Microsoft Dynamics GP / 365 BC & Acumatica Partner, www.calszone.com
