How to use the QuickBooks accounts receivable aging report
Key facts
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Set the snapshot date and export the detail
- Choose a report date. If you are recreating a past weekly snapshot, check General options → Aging and use Report date for the aging method. Intuit notes that aging can default to the current date. Use the same date and comparable filters if you run the summary as a control. Intuit’s guide to matching aging reports.
- In the open report, choose Export/Print → Export to Excel. In classic view, use the Export icon for the same Excel option. Keep the original file with the report date and QuickBooks company name. Work from a copy. Intuit’s report export instructions.
- Retain invoice rows for follow-up. Set aside subtotals and non-invoice rows such as open credits or unapplied payments. Investigate those entries before confirming what to ask the customer to pay. Recheck the live invoice and recent receipts before contacting the customer or making a handoff.
Map the export to a weekly overdue-invoice queue
| From the report or invoice | Weekly review field | How to use it |
|---|---|---|
| QuickBooks company, Customer and invoice number (Num) | Invoice key and billed customer | Use the company, customer and invoice number together. Confirm the debtor’s legal name and country before a cross-border handoff. |
| Transaction Type, Due Date and report date | Invoice row and days past due | Keep invoice rows in the queue. Days past due is the report date minus the due date. Review rows with a missing or questionable due date separately. |
| Open Balance | Open amount as of the snapshot | Use the remaining balance after posted allocations. If the export lacks the invoice currency or shows a converted amount, open the invoice and record the balance and currency there. Sum only amounts in the same currency. |
| Invoice, order and delivery or service records | Evidence status | Mark documented when the records support the billed party, charge and open amount. Record any missing item and who will find it. |
| Customer correspondence and payment records | Disputed amount, verified amount and promise date | Record the amount under dispute and the reason. Keep a customer’s promised date alongside the follow-up date. Hold the balance for review if the amount itself is still unclear. |
| Collector’s case record or placement log | Already placed, case reference and owner | Keep it in outstanding AR. Route activity through the owner of the existing case and exclude it from new placements. |
Give each overdue row one owner and one next action date. Use separate evidence, dispute and placement fields. An invoice can be documented and still have a disputed charge or an open case.
Example of three invoices in one weekly review
On 16 November, an equipment supplier reviews three overdue USD invoices. All amounts are fictional.
| Invoice | Open balance | Evidence, dispute and placement | This week’s action |
|---|---|---|---|
| QB-610 | USD 3,600 | Documented. USD 4,800 billed, USD 1,200 allocated. No open dispute or placement. | Credit control reviews the balance for escalation after a 13 November payment promise was missed. |
| QB-611 | USD 2,000 | USD 600 of freight charges disputed. The buyer acknowledges USD 1,400 for goods. No existing case. | Billing checks the freight approval by 18 November. Credit control follows up separately for the acknowledged USD 1,400. |
| QB-612 | USD 900 | Documented and already placed under case C-072. | The case owner checks for a payment or partner update before any further contact. |
The open balance is USD 6,500. USD 3,600 goes to the new escalation review. The USD 2,000 partially disputed invoice stays with the internal team, and the USD 900 stays with its existing case owner.
When the review produces an invoice for escalation
Confirm the current amount and currency, the debtor’s legal name and address, and the invoice reference. Keep the supporting records with the handoff, then see how to move a reviewed invoice from QuickBooks Online to Debitura. Check the current case requirements before starting a case.


.webp)