Clearing Unapplied Customer Payments and Credits in QuickBooks Desktop
Payments and credits are sitting on customer accounts while invoices stay open; here is how to clear unapplied amounts in QuickBooks Desktop.
QuickBooks Desktop has a habit of holding money where you cannot see it. A customer overpays, a credit memo never gets attached to anything, and the balance just sits there. Meanwhile the original invoice keeps aging, statements go out wrong, and the A/R aging disagrees with what your customers actually owe. There are three ways to put that money where it belongs. We use all of them here: hand-applying credits, turning on automatic application, and the built-in fix tool.
Before you start
Do the work in single-user mode, signed in as the admin user. Take a full local backup first (File, Back Up Company, Create Local Backup) and keep it somewhere the nightly rotation will not overwrite. Applying a credit to an invoice changes the open-balance figures for that invoice's period. If those books are closed or already reported, know the effect before you start.
Apply a credit to an open invoice in Receive Payments
Receive Payments is the right place to clear a single credit, because QuickBooks applies it exactly the way it would apply a payment.
- Go to Customers, then Receive Payments.
- Select the customer:job.
- Leave the Amount field at zero. Anything typed there records a new payment, which is the opposite of what you want.
- Select the invoice or invoices the credit should settle.
- Click Discounts and Credits, then open the Credits tab.
- Select the credit or credits to use and click Done.
- Confirm the selected invoices now show as paid in full, then Save and Close.
The Discounts tab beside it works the same way for early-payment discounts. If you want the wider payment workflow, field by field, our general QuickBooks help articles cover the whole Receive Payments window.
Turn on automatic application
The switch that stops the pile-up sits under Edit, Preferences, Payments, on the Company Preferences tab. Find the Receive Payments section, tick Automatically apply payments, then click OK.
From that point QuickBooks applies each incoming payment, and each credit already resting on the account, to the customer's open invoices, oldest first. New credits get consumed instead of accumulating. The preference will not touch the backlog that already exists; it only changes how new payments behave. Clearing history is the tool's job.
Run the Fix Unapplied Customer Payments and Credits tool
Editions that carry the tool list it on the Company menu. Open your file in single-user mode and start it; the tool scans for payments and credits with no invoice behind them and re-links each one to the charges it judges correct. When it finishes, re-run your Open Invoices report and spot-check a few customers in the Customer Center before you trust the numbers.
Three cautions. Back up first, because the tool changes transaction links in place. Pick a quiet moment; on a file with years of history the scan takes a while. Keep everyone out of the company file until it is done.
Your edition does not include the tool
Pro, Premier, and several Enterprise releases have no such entry on the Company menu; the tool ships with the Accountant editions. The practical route is to install a QuickBooks Accountant Edition trial, open your company file from it, and run the tool there.
One warning deserves its own paragraph. A trial is a current-year release. Opening an older file in it upgrades the file format, and that upgrade is one-way: your existing edition will not reopen the file afterwards. So decide before you run anything which edition will keep the books afterwards, or install the trial on a separate machine and work with the upgraded copy there. What you should not do is open your production file in a newer edition casually.
Signs it worked
The Open Invoices report loses its stray negative lines. The Customer Balance Summary matches what customers actually owe, credits counted, and new statements carry the corrected figures. If you switched the preference on, receive one live payment against an old open invoice and watch QuickBooks apply it without being asked.
Unapplied amounts that keep coming back
Occasionally a credit returns to its unapplied state the moment the tool closes, or the tool stops on an error part way through. That points past preferences and menus to damaged link records inside the file, and no amount of re-applying will settle those. Run Verify, then Rebuild, and read the error list honestly. If it fills with damage codes, the file needs repair rather than bookkeeping; that is the work our engineers handle daily through our QuickBooks Verify and Rebuild repair service. A clean backup matters more than any tool on this page.