When an invoice the customer has paid still appears in the QuickBooks Online A/R ageing report, the payment or credit has not been applied to that invoice. Four causes are worth checking:
- the bank deposit was added from the bank feed as income instead of being matched to the invoice;
- a payment was recorded but left unapplied;
- a payment was applied to the wrong invoice or the wrong customer;
- a credit note was raised but never applied.
Each leaves the invoice open, and the first also counts the income twice. The fix is to link the money to the invoice, not to delete or write off the invoice, and to check that no income has been duplicated along the way.
Why it matters beyond the report
- Customers are chased for invoices they have paid, which damages relationships and wastes collection effort.
- Receivables are overstated on the balance sheet.
- Income may be counted twice where the deposit was added as income and the invoice is still open.
- Bad debt provisions and write-offs made on the basis of the ageing report will be wrong.
Find the affected customers
Start with the reports that show open items and credits by customer.
- Run A/R Ageing Detail as at today, or as at the period end you are reviewing, and list customers with old open invoices.
- Run Customer Balance Detail for those customers. Look for unapplied payments and credits listed alongside the open invoices.
- For each customer, compare open invoices with recent receipts in the bank account. Matching amounts and dates point to a payment that has not been linked.
Check the obvious first. Is the report's date set where you expect? A report run as at an earlier date will show invoices as open that were paid afterwards.
Cause 1: the bank deposit was added as income
The customer paid, the deposit came into Bank transactions, and someone categorised it to an income account. They did not match it to the open invoice. The bank is right, income is counted twice, and the invoice remains open.
How to spot it: a deposit in the bank register coded to income, with the customer's name or reference, of the same amount as an open invoice.
Fix: remove the duplicated income and link the receipt to the invoice. Find the deposit on the Posted tab of the bank feed and select Undo, which moves it back to Pending. Then Match it to the open invoice instead of categorising it. Matching links the bank transaction to the existing record, so it is not duplicated. If the deposit falls in a period that has already been reconciled, any change affects that reconciliation, so keep the deposit's amount and date unchanged and re-check the reconciliation afterwards.
Cause 2: a payment recorded but not applied
A payment was entered for the customer, but no invoice was ticked against it. QuickBooks treats it as a credit on the customer's account.
How to spot it: an unapplied payment on Customer Balance Detail, alongside an open invoice of similar value.
Fix: following Intuit's steps, go to Sales & Get Paid > Sales transactions, filter the type to Money received, choose the customer, and open the payment with View/Edit. Under Outstanding Transactions, select the invoice or invoices it settles, then select Save and close.
Cause 3: applied to the wrong invoice or the wrong customer
The payment was applied, but to a different invoice of the same customer, or to a customer with a similar name. One invoice shows paid that is really open, and another shows open that is really paid.
How to spot it: the customer's remittance advice or bank reference names a different invoice from the one the payment is applied to. Or a customer shows a credit while a similarly named customer shows an unpaid invoice of the same amount.
Fix: where the invoice is wrong but the customer is right, open the payment as in Cause 2 and, under Outstanding Transactions, clear the wrong invoice and select the right one. Where the customer is wrong, Intuit's steps use a journal entry with two Accounts Receivable lines: a debit naming the customer the payment is moving from, and a credit naming the customer it is moving to. Then open Receive payment for the right customer, check that the journal entry is selected under Credits, apply it to the invoice and save.
Cause 4: credit notes not applied
A credit note was raised, but not applied against the invoice it relates to. Both remain open: the invoice as a debit and the credit as a negative.
How to spot it: an unapplied credit note and an open invoice for the same customer, for related amounts.
Fix: apply the credit to the invoice. Open Receive payment for the customer. Under Outstanding Transactions, select the invoice, and under Credits, select the credit note. Enter the amount of credit to apply against the invoice, leave the amount received blank, and select Save and close.
One further cause: journal entries to accounts receivable
A journal entry that credits Accounts Receivable, with the customer named on that line, leaves an open credit on the customer's account. It appears under Credits when you open Receive payment for that customer, and can be applied to the invoice there. Where possible, use a credit note instead of a journal.
Avoid making it worse
- Do not delete open invoices to tidy the report. The income would disappear, and if the payment was added as income from the bank feed, the books would then be right only by accident.
- Do not write off a paid invoice as a bad debt.
- Do not record a second payment against the invoice. The original payment, or deposit, already exists. Link it.
Keep it clean
- In the bank feed, match customer receipts to invoices. Do not add them as income.
- Review Customer Balance Detail for negative amounts at every month-end.
- Ask customers for remittance advice on part-payments and multi-invoice payments, and apply them as advised.
Where this fits
Unapplied payments also show up on cash-basis reports. See why a cash-basis balance sheet in QuickBooks still shows receivables. Deposits held in Undeposited Funds are a related problem: Undeposited Funds: why the balance keeps growing.
Wissen Solutions cleans up receivables in QuickBooks Online as part of our QuickBooks Online and offshore accounting services.
Sources (checked 26 October 2026; Intuit updates the interface periodically and labels differ between editions)
- Intuit: Resolve accounts receivable or accounts payable balances on a cash basis balance sheet in QuickBooks Online: applying unapplied payments, Customer Balance Detail
- Intuit: Match online bank transactions in QuickBooks Online: Match, Undo
- Intuit: Fix a payment applied to the wrong invoice in QuickBooks Online: journal entry between customers, Credits
- Intuit: Remove duplicate bank transactions in QuickBooks Online: Posted, Undo, Pending
- Intuit: Transfer a credit from one customer to another: journal entry credit to A/R applied under Credits in Receive payment
- Intuit: Create and apply credit notes or delayed credits in QuickBooks Online: applying a credit note through Receive payment
- Intuit: Run an accounts receivable ageing report: A/R Ageing Summary and Detail