October 3, 2026
Unapplied payments and credits in QuickBooks: how to find them, apply them, and why they must be clean before you migrate
The short answer: an unapplied payment or credit is money QuickBooks has recorded but never linked to the invoice or bill it settles. The customer or vendor balance can look right while the invoice still shows as open, so the aging reports, statements and open-item lists are wrong. Find them on the Open Invoices and Unpaid Bills reports (negative amounts), apply them through Receive Payments or Pay Bills, and do it before any conversion. A migration carries open items across one by one, so every unlinked pair arrives in Xero, QuickBooks Online or anywhere else as two open items instead of none.
What “unapplied” actually means
Intuit’s own troubleshooting article for QuickBooks Desktop lists the usual reasons a paid invoice or bill still appears on an open-transactions report. The top two are the ones this guide is about: a credit memo or customer payment entered but not applied to an invoice, and a bill credit or bill payment entered but not applied to a bill. The same article names the reports affected: Open Invoices, A/R Aging Summary and Detail, Unpaid Bills, A/P Aging Summary and Detail, the Customer Snapshot, the Income Tracker and the Reminders list.
QuickBooks Online behaves the same way. Intuit’s help on credit memos says that if a credit is not applied, the Customer Balance Detail report shows both the invoice and the credit memo with open balances, and both appear as Open on the customer and sales transaction pages. If there is no open invoice for a credit to apply to, its status is Unapplied and the customer balance goes negative.
Why it matters more at migration than day to day
In the live file, an unapplied payment is an annoyance: the total owed by the customer nets to the right figure, so nobody chases it. A conversion changes that. Open receivables and payables are moved as individual documents so that customers and suppliers still show what they owe in the new system. If the link is missing, the invoice travels as unpaid and the payment travels as a separate unallocated credit.
Illustrative example. A customer pays a 4,000 invoice in full, but the payment was entered without ticking the invoice. QuickBooks shows the invoice at 4,000 in the 61–90 day column and the payment as −4,000 in current. The customer total is zero. After conversion, the new system holds an overdue invoice that automated reminders will chase and a credit nobody will spend. Multiply that by a few hundred customers and the first month in the new software is spent unpicking it.
It also affects file size. Intuit’s Condense Data utility keeps anything still open, so years of unapplied credits limit how far a large Desktop file can shrink; see our guide to large Desktop files and condensing.
Step 1: find them
QuickBooks Desktop, customers. Go to Reports > Customers & Receivables > Open Invoices and look for negative amounts. Each one is an unapplied payment or credit memo.
QuickBooks Desktop, vendors. Go to Reports > Vendors & Payables > Unpaid Bills. Negative amounts are bill credits or bill payments not linked to a bill.
QuickBooks Online. Run Customer Balance Detail and look for credit memos or payments with an open balance next to invoices that should be closed. Check the Automatically apply credits setting under Settings > Account and settings > Advanced > Automation so you know whether QuickBooks has been linking credits for you.
Export each list to a spreadsheet with customer or vendor, date, amount and reference. That list is your work queue and your audit trail.
Step 2: apply them
| What you found | Where to fix it |
|---|---|
| Desktop: unapplied customer payment or credit memo | Customers > Receive Payments, select the customer, then apply the payment or credit to the right invoice |
| Desktop: unapplied bill payment or bill credit | Vendors > Pay Bills, then apply the credit or payment to the bill |
| Online: open credit memo | + Create > Receive payment, tick the invoice and the credit, leave payment method, deposit to and amount received blank |
| Online: delayed credit | Add it as a line on an invoice; Intuit warns this changes balances for that invoice’s period if the invoice is in a past period |
In QuickBooks Online, turning on Automatically apply credits applies each credit to the oldest unpaid invoice first. That is fast, but before a migration it can link credits to the wrong invoices. If it does, Intuit’s fix is to open the invoice, follow the applied credit link to the payment transaction, and delete that payment transaction, which removes the credit from the invoice.
When a payment refuses to apply
Intuit lists the reasons a link will not form or will not show. In Desktop, an invoice and its payment must use the same A/R account and the same job under the customer, and a bill and its payment must use the same A/P account. Files with several A/R or A/P accounts, or a payment recorded at customer level against a job-level invoice, are the usual cause. Other causes on the same list: aging preferences, wrong terms, a payment dated after the report date, and incorrect workstation or server dates.
If none of those explain it, the transaction or the link between them may be damaged. Intuit notes this kind of damage is often not fixed by the basic utilities, so run Verify Data first; our Verify and Rebuild guide covers the sequence.
Watch filed and closed periods
Applying an existing payment to an existing invoice usually changes the link, not the accrual totals. But if you report or file tax on a cash basis, the date the invoice counts as paid can matter. That includes cash-accounting VAT schemes; see our UK VAT schemes guide. Before you apply anything inside a filed or locked period, run the relevant report before and after on a copy of the file, and agree the approach with whoever signs the return.
A pre-migration checklist
1. Run Open Invoices and Unpaid Bills (or Customer Balance Detail in Online) and export every negative line. 2. Apply each one to the correct invoice or bill, checking A/R and A/P accounts and jobs. 3. Refund, write off or deliberately keep any credits that are real customer credits, and note them for the opening balances. 4. Clear Undeposited Funds and Opening Balance Equity in the same pass. 5. Re-run the aging reports and confirm that A/R and A/P aging totals agree with the balance sheet at the cutover date. Those totals become the opening open-item balances in the new system.
Frequently asked questions
Why does a paid invoice still show on my A/R aging report?
Usually because the payment or credit memo was recorded but not applied to that invoice. Look for a matching negative amount on the Open Invoices report and apply it through Receive Payments.
Why won’t QuickBooks Desktop let me apply a payment to an invoice?
The invoice and the payment must use the same A/R account and the same job under the customer. If they differ, the invoice will not appear as available for that payment.
Should I turn on automatically apply credits before migrating?
Only if applying to the oldest open invoice is correct for your customers. It works oldest-first, so check the result. Auto-applied credits can be removed by deleting the payment transaction that links them.
Can the conversion just carry the unapplied items across?
It can, but each unlinked pair arrives as an open invoice plus an open credit. Applying them first means the new system starts with the open items customers and suppliers actually have.
Related service: QuickBooks support and file cleanup