To fix unapplied cash payment income on your Profit and Loss report, open each unmatched payment from the transaction detail screen, link it to the correct invoice, and confirm the payment date falls on or after the invoice date. Where no invoice exists, either create one and then apply the payment, or delete the payment entry and replace it with a sales receipt. Work through the list until the balance reaches zero.
Why the Line Shows Up
Cash-basis accounting recognizes income the moment money arrives. Under federal tax rules, you include an item in gross income for the tax year in which you actually or constructively receive it.1Internal Revenue Service. Publication 538 – Accounting Periods and Methods Accounting software follows that rule strictly. When a payment isn’t tied to a specific invoice, the software still counts the deposit as revenue and parks it in a holding account called Unapplied Cash Payment Income so total income matches your bank deposits.
The mismatch usually happens for one of a few reasons. A customer paid before you created the invoice, so the payment date is earlier than the invoice date and the software cannot pair them. Someone recorded the payment without checking the box that applies it to an outstanding invoice. The amount received doesn’t match any single invoice cleanly. Or the transaction was a point-of-sale cash sale that should have been entered as a sales receipt in the first place.
Find the Unmatched Payments
Open your Profit and Loss report and click the dollar amount next to the Unapplied Cash Payment Income line. The transaction detail screen lists every unmatched payment with customer names, dates, and amounts. That list is the working checklist for the cleanup.
Before you start editing, pull together the details you’ll need for each entry: customer name, the date funds hit the bank, payment method and reference or check number, and the invoice number the payment was meant to cover. If no invoice exists, decide whether one should be created or whether the transaction belongs on a sales receipt instead. Having this ready keeps you from introducing new errors mid-correction.
Check for Duplicates First
Sometimes the balance isn’t a documentation gap at all. A payment imported from a bank feed and also entered manually creates a duplicate, and one copy ends up unmatched. Two payments with identical amounts posted to the same customer within a few days are the telltale sign. Delete the duplicate and the unapplied balance drops without any further adjustment. This is worth checking before you spend time hunting for a missing invoice.
Apply the Payment to an Existing Invoice
This is the most common fix. From the transaction detail list, open the unmatched payment. The Receive Payment screen shows the customer’s outstanding invoices. Check the box next to the correct invoice, confirm the amounts match, and save. The software links the payment to the sale and the unapplied balance drops by that amount. Refresh the Profit and Loss report and confirm the line has decreased before moving on to the next entry.
Fixing Date Mismatches
If the payment date is earlier than the invoice date, the software often cannot complete the match. You have two options: adjust the invoice date so it falls on or before the payment date, or correct the payment date if it was entered wrong. For cash-basis purposes, the income is taxable in the year you actually received the funds regardless of which date the invoice ultimately carries, so aligning the invoice date to reality doesn’t change your tax liability.1Internal Revenue Service. Publication 538 – Accounting Periods and Methods
Splitting a Payment Across Invoices
Customers sometimes send a single check covering several outstanding invoices. On the Receive Payment screen you can check multiple invoices at once, and the software tracks a running total as you select each one. If the payment amount equals the combined invoice totals, the entire payment clears from the unapplied account.
When No Invoice Exists
Not every payment belongs with an invoice. If a customer paid at the point of sale and you never intended to bill them separately, the correct document is a sales receipt. Delete the orphaned payment, then create a sales receipt for the same amount and date. A sales receipt records both the sale and the payment as one transaction, so nothing lands in the unapplied account.
If the payment was for goods or services that should have been invoiced but weren’t, create the invoice first. Date it on or before the date you received payment. Then open the Receive Payment screen and apply the payment to the new invoice. This preserves the audit trail linking the work performed to the money you collected.
Partial Payments and Overpayments
When a customer pays less than the invoice total, apply whatever they sent to the correct invoice. The software marks the invoice as partially paid and keeps the remaining balance open. The goal is making sure the full payment amount is linked to something, even if the invoice isn’t fully satisfied. A $400 payment against a $600 invoice is better than $400 sitting untethered.
Overpayments work in reverse. Apply the payment to the invoice for the invoiced amount, and the software will show the excess as a credit on the customer’s account. That credit isn’t earned revenue. If you plan to refund it, record it as a liability. If the customer wants it applied to a future invoice, leave the credit on their account and apply it when the next bill goes out. Either way, the portion that matches your invoice gets linked, and the unapplied line clears for that part of the payment.
Year-End Timing Matters
Unapplied balances are especially risky in late December. Federal tax law includes income in gross income for the taxable year in which you receive it.2Office of the Law Revision Counsel. 26 US Code 451 – General Rule for Taxable Year of Inclusion The constructive receipt rule goes further: income counts as received when it’s credited to your account or made available without restriction, even if you don’t deposit it until the following year.3eCFR. 26 CFR 1.451-2 – Constructive Receipt of Income
A check handed to you on December 30 is that year’s income, even if you don’t record it until January. Publication 538 is explicit that you cannot hold checks or postpone taking possession of property from one tax year to another to delay paying tax on the income.1Internal Revenue Service. Publication 538 – Accounting Periods and Methods If a late-December payment enters your books in January and lands in the unapplied account, you’ve pushed taxable income into the wrong year. Clearing year-end unapplied entries before you close the books avoids that problem.
Keep the Balance at Zero
Cleaning the account once is worth doing. Keeping it clean is worth building into your workflow.
- Use sales receipts, not invoice-and-payment pairs, for point-of-sale transactions. A sales receipt records both sides in one entry.
- Apply payments the moment you record them. Check the box next to the correct invoice on the Receive Payment screen before saving. Skipping this is the single most common cause of unapplied balances.
- Create the invoice before you record the payment when you know money is on the way. An invoice dated on or before the payment date prevents the timing mismatch.
- Pick one entry method for each transaction. Bank feed imports plus manual entries produce duplicates that end up unmatched.
- Review the Unapplied Cash Payment Income line during your monthly close. Fixing a stray entry within a few weeks is far easier than reconstructing it in December.
Five minutes matching a payment correctly today saves hours of detective work at year-end, and it keeps your reported income aligned with what actually landed in the bank.