Unapplied payments in QuickBooks Online are customer payments sitting as credits on a customer’s account because they haven’t been linked to an invoice. They cause problems on your books, particularly on cash-basis Profit and Loss reports, and they make your Accounts Receivable balances look wrong. Two built-in reports can surface these payments quickly, and fixing them usually takes just a few clicks.
Why Unapplied Payments Matter
When a customer payment isn’t matched to an invoice, QuickBooks treats it as money received with no corresponding income declared on a sales form. For cash-basis reporting, QuickBooks automatically creates an account called “Unapplied Cash Payment Income” to handle this. The IRS requires this treatment under the concept of constructive receipt income (detailed in IRS Publication 538): if you received the money, it counts as income even if you haven’t invoiced for it yet.
This means unapplied payments can inflate or distort your Profit and Loss report. You might see revenue in “Unapplied Cash Payment Income” that should be categorized under the correct income account tied to the invoice. Your A/R aging reports will also look off, showing open balances for customers who have already paid. The fix is straightforward once you find the payments.
Find Unapplied Payments With the Transaction List by Date Report
This is the fastest way to pull up every unapplied payment across all customers at once.
- Go to Reports. Search for “Transaction List by Date” in the report name field and open it.
- Set your date range. Choose the period you want to review. If you’re cleaning up your books for the year, set it to the full fiscal year.
- Filter by transaction type. Click Customize, then under the Filter section, set the Transaction Type to “Payment.”
- Add the Open Balance column. In the Customize panel, look for the Rows/Columns section and add “Open Balance” as a visible column.
- Run the report. Any payment that shows a number in the Open Balance column has money that hasn’t been applied to an invoice. That balance is sitting as a credit on the customer’s account.
A payment with an open balance of zero is fully applied and can be ignored. A payment where the open balance equals the full payment amount was never linked to any invoice at all. A partial open balance means part of the payment was applied but some amount remains as a credit.
Find Unapplied Payments With the Open Invoices Report
The Open Invoices report gives you a customer-by-customer view and is especially useful when you’re ready to start matching payments to invoices.
- Go to Reports, then Standard reports. Search for “Open Invoices” in the report name field.
- Set the report period and run it.
- Look at the Transaction Type column. Any row listed as a “Payment” rather than an “Invoice” is an unapplied payment. If that payment has a matching open invoice for the same customer on the same report, you can link them right away.
This report is the better starting point if you already suspect specific customers have unapplied payments, since it groups everything by customer name.
Apply a Payment to an Existing Invoice
Once you’ve found an unapplied payment that belongs to an open invoice, linking them takes about 30 seconds.
- On the Open Invoices report (or the Transaction List by Date report), click the date of the unapplied payment to open the transaction.
- In the payment form, look under “Outstanding Transactions.” You’ll see a list of open invoices for that customer.
- Check the box next to the correct invoice.
- Click Save and close.
The payment’s open balance drops to zero, the invoice is marked as paid, and the “Unapplied Cash Payment Income” line on your Profit and Loss adjusts accordingly.
When There’s No Matching Invoice
Sometimes a payment was recorded before an invoice was ever created, or the invoice was accidentally deleted. In that case, you need to create the invoice first, then link the payment to it.
- Click the “+ New” button (or “+ Create”) and select Invoice.
- Fill out the invoice using the same customer name, amount, and date as the unapplied payment.
- Save and close the invoice.
- Go back to the Open Invoices report. Find the unapplied payment and click its date to open the transaction.
- The invoice you just created will now appear under Outstanding Transactions. Check the box next to it.
- Save and close.
This pairs the payment with a proper sales form, moves the income out of “Unapplied Cash Payment Income,” and clears the customer’s credit balance.
Common Causes of Unapplied Payments
Understanding how these payments end up unlinked helps prevent them from piling up. The most frequent cause is recording a payment before the invoice exists. If a customer pays a deposit today and you create the invoice next week, that payment sits as unapplied until you manually match it. QuickBooks does not auto-link payments to invoices created after the fact.
Another common scenario is importing bank transactions. When you accept a bank feed entry as a payment but skip the step of selecting which invoice it applies to, QuickBooks records the payment without linking it. The same thing happens if you use the “Receive Payment” form but don’t check any invoice in the Outstanding Transactions section before saving.
Duplicate payments also create this problem. If a customer’s payment gets entered twice, the second entry won’t have an open invoice to match and will sit as a credit. In that case, the fix is deleting the duplicate rather than creating a new invoice to absorb it.
Cleaning Up in Bulk
If you have dozens of unapplied payments, start with the Transaction List by Date report filtered to payments with open balances. Export it to a spreadsheet so you can sort by customer name and amount, which makes it easier to match payments to invoices. Work through one customer at a time, opening each payment and checking the appropriate invoice box.
For ongoing maintenance, run this report monthly. Catching unapplied payments within a few weeks of when they’re recorded is far easier than untangling a full year’s worth at tax time. The “Unapplied Cash Payment Income” line on your cash-basis Profit and Loss report is your canary: if it shows a balance, you have payments that need attention.