GP How to Reconcile Payable/ Receivable Ledger to General Ledger Control Account using "Reconcile to GL"

The “Reconcile to GL” tool helps you find differences between Payables Management (and GL) and Receivables Management (and GL) automatically by coming out a report. The Rule of Thumb, GL balance for the AP Control Account should match up with the total on the Payable Ledger report and the GL balance for the AR Control Account should match the total on the Receivables Ledger report.  "Reconcile to GL" will match each transaction between GL and Sub-ledger based on the setup account and posting date.  Any transactions that don’t match and users have to start digging through detailed transactions to see what went wrong, “Reconcile to GL” can be helpful in this scenario.

To perform Payable/Receivable Reconciliation
Path: Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL

    1.       Type in your date range.
    2.       Select “Module”, either Payable Management or Receivable Management.
    3.       Put in all your A/P or A/R account number. 
       ***Any accounts that not included in the account list will cause system not able to match both sub-ledger and GL transaction, which later categorised as “Unmatched” transaction.
    4.       Set the Output file, to locate the Excel file to be saved after it generated.
    5.       Click “Process” to generate the matching report.  

Example of Payable Managements

Example of Receivable Managements

The result will save in Excel file which you set in <Step 4> after “Process” is selected.

It will lists transactions as either:
     •Unmatched Transactions = likely a problem as system not able to match
     •Potentially Matched Transactions = might be a problem, some field not matching

     •Matched Transactions = no problem found 

Possible Reasons transaction falls under “Unmatched” section
If the sub-ledger do not match the General ledger, then you need to examine through the detail of the transaction data to determine why the GL and sub-ledgers do not match.

Here are some common issues these two details can be different:

     i.       Errors are date related.  
         -     The sub-ledger Batch Posting date was different than the GL Posting date.
     ii.      Missing entries in GL.
         -      A batch could be deleted before the GL has recorded the sub-ledger transaction.  
         -      Voiding can also cause a GL batch to be posted to fully record the sub-ledger transactions
     iii.         General journal entries were posted using AP/AR's control accounts.  
         -      Any adjustments made in the GL using Control Account, it will not be reflecting to the sub-ledger.
         -      Using the same control account on the sub-ledger transactions for both debit and credit value for the same amount.
         -      Control account on the sub-ledger transactions has been altered by user
     iv.         Sub-ledger entries has been posted, but general journal entries were stuck at financial batch remain not posted.

Below list another possible issues that causing difference from Microsoft Support: -


Another way of doing Sub-ledger vs GL reconciliation is using Smartlist report. You may refer to the following link: -


GP How to Reconcile Payable / Receivable to GL using Smartlist.