How to Fix Unapplied Payments in QuickBooks Online
Find customer payments without a matching invoice and understand when Unapplied Cash Payment Income reflects legitimate payment timing.
By CleanUp for QuickBooks · Updated
Check whether this is a matching issue or a timing issue
An unmatched customer payment and the Unapplied Cash Payment Income line on a cash-basis report are related, but not identical. The report can reflect a payment received before its invoice date. Do not change a real transaction date simply to make the line disappear.
Keep the payment record, the invoice, and the report period together while investigating. Confirm whether you are looking at cash-basis or accrual-basis reports.
Find the payment and its supporting invoice
- 1
Run the Open Invoices report for the relevant period. Inspect Payment rows as well as the invoices; use the customer detail to understand what is still open.
- 2
Open the payment and verify the customer, amount, and date against the receipt. Find the invoice the payment was actually intended to settle.
- 3
If a payment belongs to an existing invoice but is not linked, use the payment record to select the correct outstanding invoice and save. Handle partial amounts and credits according to the actual customer balance.
- 4
Reopen the customer detail and rerun the reports with the same dates and reporting basis. Confirm the intended invoice and payment relationship rather than assuming the entire report must become zero.
Worked examples: why the same report line can mean different things
| Synthetic case | What it means | Check |
|---|---|---|
| $500 received August 30; invoice dated September 2 | A cross-period prepayment can explain August's cash-basis line. | Preserve true dates and ask your accountant about the reporting treatment. |
| $500 received September 3; September 1 invoice still open | The intended invoice may not be linked to the payment. | Verify customer and invoice, then inspect the payment application. |
| $500 received against a $700 invoice | A real partial payment leaves a balance. | Expect $200 still due unless a valid credit or other payment explains it. |
If the expected invoice does not exist
Establish what the customer paid for before creating a sales form. A deposit, an advance payment, and payment of an existing invoice may require different handling. Do not create a second sale merely to clear a report line.
If the payment is linked but the cash-basis line still looks unexpected, compare invoice and payment dates and review the account mapping of the product or service. Intuit's explanation below describes these causes.
What the scan cannot confirm
The export-based checker does not have the full live payment-to-invoice relationship or every sales-form setting. Its findings need to be checked against the customer records. A payment alert does not prove that revenue is wrong, and clearing a report line is not itself a tax conclusion.
Continue your cleanup
Sources and further help
QuickBooks menus vary by plan and interface. Use in-app search if a menu label differs. These sources support the workflows; synthetic examples illustrate the checks.
Need a list of entries to review?
Scan a supported General Ledger CSV for possible cleanup issues. See the preview free; the detailed report is $29 one-time. You review and make any changes in QuickBooks.
No QuickBooks connection. Findings are review prompts, not a complete accounting review.