Skip to main content

Posts

Showing posts with the label Microsoft Dynamics GP Subledger to GL Reconcilation

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. ...