A client was recently struggling to reconcile the General Ledger to the Payables Management module.  Turns out the last time it tied out was nearly twelve months prior.
 

I taught her to use a cool new feature in Microsoft Dynamics GP 10.0 – “Reconcile to GL.”   This  new tool significantly reduces the time  spent reconciling sub-ledgers to the GL.

Here’s how you can use the "Reconcile to GL" tool:

1.  Run the Reconcile to GL routine (Tools> Routines> Financial>Reconcile to GL)

2. Select Individual Accounts to reconcile, and enter a date range for reconciliation 

3.  Process the report

Transactions will be automatically matched, and discrepancies identified. 

Results are displayed in a Microsoft Excel spreadsheet in three segments: unmatched transactions, potentially matched transactions, and matched transactions. 

So back to the client who had not reconciled in a year….

In about one hour, we reviewed the unmatched transactions and identified which had not corrected themselves over time, and narrowed it down to the ones that needed to be corrected.