Reconcile the Dynamics GP Historical Aged Trial Balance
Key facts
Keep one report export with its cutoff, customer range, currency and date basis. A rerun with different settings can look like a posting discrepancy.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Rebuild the prior-period balance
Run the Historical Aged Trial Balance for the close date. Under Select Transactions For Report Using, choose GL Posting Date when reconciling against the detailed GL trial balance. Save the exact report options alongside the export. Agree which accounts and company the reconciliation covers before comparing totals. Use the detailed listing to identify the documents behind any difference.
Trace the mismatch to individual postings
Match the receivables report and GL balance at the same cutoff. Compare the posting date of a sample invoice, payment and credit on both sides. If the reports still disagree, rerun the receivables report with the date as the only restriction. Check for manual GL entries or transactions posted to a different GL period. Record the document numbers and difference in a short reconciliation schedule.
Send unexplained amounts to the close owner
For example, a February receipt against a January invoice belongs in the February activity review when it explains the difference between a January close and today’s balance. Record the source document and date before proposing a journal. A clean report can then support the overdue-invoice review separately.


.webp)