How to reconcile unapplied cash payment income in QuickBooks Online

Unapplied Cash Payment Income is a line you may see on a cash-basis Profit and Loss report in QuickBooks Online. Start with the existing receipt and the report cutoff to find out whether the payment arrived before billing or needs to be applied to an invoice.
Upload a case

Key facts

Match the receipt to the bank record and customer’s remittance, then compare the receipt and invoice dates. If an open invoice is confirmed, apply the existing payment and verify the invoice balance.

Trace the cash-basis line to the customer receipt

  1. Record the Profit and Loss period and the amount you are investigating. In Reports, open Standard reports and find Open Invoices. Use a date range that includes the receipt and look for a Payment entry.
  2. Open the payment by selecting its date. Check the customer, amount, receipt date and bank reference against the deposit and remittance. Find the invoice by its number and confirm the customer, invoice date and open balance. Two invoices for the same amount can belong to different orders.
  3. For a confirmed match, select the correct invoice under Outstanding Transactions, check the applied amount, and select Save and close. If the receipt is tied to another invoice, verify both invoice balances and the remittance before correcting the application.

Decide whether the dates explain the difference

Fictional example. Your bank shows a $1,200 receipt on September 30. The customer’s remittance identifies invoice INV-3816, dated October 3 for $1,200. The receipt predates the billed sale, so the amount can appear as unapplied on the September cash-basis report. Keep the actual dates, apply the September 30 receipt once the October 3 invoice is available, and confirm the invoice closes with $0 due.

If INV-3816 was instead dated September 25 and remained open after the September 30 payment, compare the receipt’s existing application with the remittance. A missing or wrong link calls for a correction once the match is verified. If the reference is ambiguous, ask for clarification and record why the invoice stays open.

Verify the balance and document what changed

Check the invoice’s remaining balance and rerun the cash-basis Profit and Loss for the original period. Document any timing difference that still explains the reported amount. Keep the receipt reference, receipt and invoice dates, applied amount, remaining balance and reason for closing or holding the item.

See Intuit’s instructions for reviewing unapplied cash payments and its explanation of receipt and invoice dates. For the wider remittance-matching process, see the cash application workflow.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.