Reconcile the A/R Aging Detail report in QuickBooks Desktop
Key facts
Example. An invoice open on October 31 and paid in early November can still show as open on the October 31 report when you choose Report Date. Check today’s balance before sending a reminder.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Open the detail report for the review date
In US QuickBooks Desktop for Windows, go to Reports, then Customers & Receivables, then A/R Aging Detail. Set the review date. Under Customize Report, open Display and then Advanced. Choose Report Date to show balances as of the cutoff, or Current to see what is open today.
Trace differences to individual transactions
Run Open Invoices using the same cutoff, Open Balance/Aging option and applicable filters. If the totals differ, start with one customer and open the entries that make up the balance. Check payment and credit application, the reporting cutoff and any report filters. If a credit is present alongside an unpaid invoice, verify how it was applied before adjusting the collections list.
Turn the report into a follow-up list
Keep the report date and aging settings with your export. Alongside each invoice, record the amount still open, the reason for any hold and the next action. Before sending a reminder, confirm the current balance against activity since the report date.
Sources and related guidance. Intuit’s Desktop report settings · Intuit’s A/R report reconciliation guide · Debitura's accounts receivable guide.


.webp)