How to use the QuickBooks accounts receivable aging report

In QuickBooks Online, go to Reports → Standard reports → Who owes you → Accounts receivable aging detail. Use the detail report to build your weekly overdue-invoice list. The Accounts receivable aging summary shows balances by customer and aging period, which helps you decide which accounts to review first.
Upload a case

Key facts

Set the snapshot date and export the detail

  1. 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.
  2. 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.
  3. 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.

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.