Reconcile the A/R Aging Detail report in QuickBooks Desktop

Use the A/R Aging Detail report to see which transactions make up a customer's outstanding balance. Set the cutoff and check how the report treats open balances before you compare it with another total.
Upload a case

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.

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.

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.