Reconcile the Dynamics GP Historical Aged Trial Balance

Use the Dynamics GP Historical Aged Trial Balance to reconstruct receivables at a prior close, then compare it with the general ledger for the same cutoff.
Upload a case

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.

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.