Entering an invoice date later than the invoice payment date is one of the most common causes of Unapplied Cash Payment Income appearing on your Profit and Loss Report. Payment of a customer invoice should always be made after the invoice’s due date. When you build a customer invoice or an invoice payment in QBO, the current date is automatically entered.

Since not all business owners have time to do their bookkeeping regularly, companies often receive a customer’s payment and record the price before creating an invoice for that customer. 

You can see two accounts for unapplied cash payments if you report on a cash basis. QuickBooks Online creates these accounts automatically for cash-basis reporting, and they can’t be deleted or altered. The following are descriptions of each of the two account types:

Unapplied Cash Payment Income

This account is used to record cash-based revenue from consumer purchases that have not been applied to other sales forms. Simply put, you received the money but never recorded it on a sales form. The payment date is usually before the invoice date to which it is applied. For instance, if you receive payment today, you should invoice the following week. It’ll be “unapplied” before the invoice is paid next week. If an incorrect sum appears in this account, you must apply the payment to an older invoice than the payment date. Unapplied Cash Payment Income is right otherwise. Another possibility is that the invoice’s product or service item is mapped to a bank account form, causing the sum to be deposited into Unapplied Cash Payment Income before actual payment is made. To avoid this from happening, make sure the product or service is mapped to an income account form.

Unapplied Cash Bill Payment Expense

This is the same as receiving cash payments, except on the cost side. It’s for reporting Cash Basis expenses from supplier/supplier payment cheques that haven’t yet been applied to a supplier/supplier billThis can also happen when a bill for a credit card account balance is generated. This will never be seen on a purchase or sales form. If an incorrect amount appears in this account, add the bill payment to a bill that is older than the bill payment.

On your profit and loss statement, unapplied cash payment income

Unapplied cash payment income can appear when you run a Profit and Loss report using the cash method. QuickBooks creates this account to ensure fair tax reporting. 

Unused cash payment income can show up on your tax return if:

  • You were paid in advance by a client, and you reported the payment before creating the sales form (invoice or sales receipt).
  • You didn’t fit payments to sales forms when you joined them.

The steps below will assist you in resolving Unapplied cash payment profits on your Profit and Loss statement.

Step 1: Run the Open Invoices report first.

To run the open invoices report, follow these steps:

  • Navigate to Reports.
  • Enter Open Invoices in the Find report by name area.
  • Select Run report after setting the report time.
  • Look for a transaction marked as a Payment in the Transaction Type column.

Proceed to Step 2 if the Payment transaction corresponds to an open invoice. If there isn’t an available invoice that matches, skip to Step 3.

Step 2: Check to see if the Payment transaction corresponds to an open invoice

Follow these measures if the payment fits an open invoice.

  • To begin, choose a payment date.
  • Check the open invoice under Outstanding Transactions.
  • Close the window after selecting Save.

Step 3: If the Payment transaction does not correspond to an open invoice.

You’ll need to make the transaction if the payment doesn’t fit an open invoice. Take the following steps:

  • Tap on option New
  • Pick Invoice from the Customers menu.
  • Fill in the same client, number, and date as the payment on the form.
  • Choose Save and Exit.
  • Return to the report of Open Invoices.
  • Select the date to open the payment that has not yet been applied.
  • Check the open invoice under Outstanding Transactions.
  • Choose Save and Exit.
  • Check your Open Invoices report to see if there are any additional Payment transactions. If there are more than one, repeat steps 2 and 3 for each one.

Run the Profit and Loss report once more. The Unapplied cash payment profits can no longer be visible.

To End With

You can either adjust your bill’s date so that it isn’t included in the time of your survey, or you can delete it altogether. You may also make a journal entry to reverse the admission made by QuickBooks Online. Just remember to build a reversing entry as a courtesy to all. Since QuickBooks Online will immediately reverse their entry once the bill is paid, you must also reverse your “fix” to ensure that everything is correct going forward.

Share this Link:
Call for Help & Support