How to reconcile a QuickBooks Online customer statement
Key facts
Use Balance Forward to explain how the balance changed, Open Item to list unpaid invoices, and Transaction Statement to check what was recorded during a period. For a historical cutoff, compare the Balance Forward closing balance with A/R Aging Detail set to the same report date. Use Open Item for the customer’s current unpaid list.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Choose the statement that answers the dispute
- Balance Forward. Use it when the customer asks how you arrived at the closing balance. It carries the opening balance into the selected period and shows the activity that changed it.
- Open Item. Use it when accounts payable wants a list of invoices to pay. Intuit describes this view as showing unpaid invoices from the selected start date to the present. Check that the start date includes older unpaid invoices.
- Transaction Statement. Use it when the customer asks for the entries recorded within a date range, including a payment or credit they want to identify.
In QuickBooks Online, open Customers & leads in Customer Hub, select the customer, and choose Statement from Batch action. Pick the statement type and its dates. For a sub-customer set to Bill with parent, create the statement for the parent and check that the aging comparison covers the same accounts.
Reconcile the balance at the same cutoff
Fictional example. A customer opens April with $4,000 outstanding on invoice INV-402. You issue INV-417 for $1,200, apply an $800 payment to INV-402, and apply a $100 credit memo to that same invoice. The April 30 balance is $4,000 + $1,200 − $800 − $100 = $4,300.
Run a Balance Forward statement through April 30 and A/R Aging Detail through April 30 using the Report date aging method. The two remaining balances should be $3,100 and $1,200. If a May 2 receipt of $500 brings today’s total to $3,800, the difference is explained by the cutoff. For an unexplained difference, check invoice numbers and dates, the bank and remittance references, and which invoice received each payment or credit.
Reply with the balance and ask for the missing reference
“Our balance at April 30 was $4,300. We applied the $800 payment and $100 credit to INV-402. The $500 receipt dated May 2 is reflected in the current balance. If you’re expecting another payment to appear, could you send its date, amount and bank reference?”
Check the statement preview and recipient before sending. For the software steps, see Intuit’s customer statement instructions and Intuit’s guide to the Report date aging method. For a walkthrough of the invoice-level comparison, see the QuickBooks accounts receivable aging report guide.


.webp)