How to reconcile a QuickBooks Online customer statement

When a customer disputes their balance, first agree on the date and the customer account you’re comparing. Then use the QuickBooks Online statement type that answers their question and tie the result to the receivables detail before sending it.
Upload a case

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.

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.

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.