Home » What is Unapplied Cash Payment Income In QuickBooks 

What is Unapplied Cash Payment Income In QuickBooks 

Unapplied Cash Payment Income In QuickBooks 

by Dharmendra124
What is Unapplied Cash Payment Income In QuickBooks 

When performing a QuickBooks Online cleanup, you may come across unapplied cash payment income and expenses in the Profit and Loss report. What is the purpose of these accounts, and where did they come from? How do you get rid of the balances in these accounts? Continue reading to find out the answers to these questions, as well as how to clean up unapplied cash payment income and expenses in QuickBooks Online. Here you will read about what is unapplied cash payment income in QuickBooks and if you want to know more about other features like the how-to guide for learning QuickBooks and how to fix com error crashes when mailing on outlook then click on these links.

Have you ever seen an unapplied cash payment income account or an unapplied bill payment expense account on a cash basis Profit and Loss report? These are a mouthful to say, and it’s easy to see why you might be perplexed to see them on the Profit and Loss report.

  • Only when you run the cash basis report do these accounts appear in the Profit and Loss Report.
  • QuickBooks Online creates these accounts in order to balance itself on a cash basis.
  • Accounts cannot be removed.
  • A journal entry will not resolve these issues. Journal entries have an impact on both the cash and accrual bases, but the unapplied cash payment income and expense accounts are only on a cash basis. Journal entries can wreak even more havoc!

What causes a balance in the Unapplied Cash Payment Income account?

Let’s start with QuickBooks Online’s unapplied cash payment income account. How does a balance emerge? What are the reasons?

This account usually appears when a customer payment is received before the invoice date. When this occurs, QuickBooks will add an amount to the unapplied cash payment income account.

It could also occur if a customer payment and an invoice are not applied to each other.

When converting from QuickBooks desktop to QuickBooks Online, you may also see unapplied cash payment income. This could be because journal entries were used to adjust accounts receivable on the QuickBooks desktop.

Another possible (yet uncommon) cause, according to the QuickBooks support website. The invoice’s product or service item may be linked to a bank account type. This results in the amount being added to unapplied cash payment income without any actual payment being received. To avoid this, ensure that the product or service is linked to an income account type.

What causes a balance in the Unapplied Bill Payment Expense account?

What about unused bill-paying expenses? Where does the balance appear?

The most common reason for this is when the date of a bill payment falls before the date of the vendor bill.

It can also occur when a bill payment and a vendor bill are not applied to the same account.

Again, if any journal entries were used to adjust accounts payable during a QuickBooks desktop to QuickBooks Online conversion, those balances are usually also placed in the unapplied bill payment expense account.

How to clean up Unapplied Cash Payment Income and Expense accounts in QuickBooks Online

So, would you like to learn how to do it yourself? To see step-by-step examples from my video, click on the links below. On the profit and loss statement, we’ll look at unapplied cash payment income and unapplied bill payment expense:

How to clean up unapplied cash payment income when payment is dated prior to the invoice

When you run a cash-basis Profit and Loss Report, you’ll see any unapplied cash payment income.

Click on the account to see all of the details to determine the source of this unapplied cash payment income. This will open up all of the transactions and group them by customer name, making it easier to determine which ones need to be cleaned up.

If, as in my example, the payment date is earlier than the invoice date, you must decide whether the invoice date or the payment date must be changed. You’ll notice that the transactions you resolved aren’t listed in the unapplied cash payment income after you change the date, save, and close.

How to clean up unapplied cash payment income when there is no invoice

In our second example, you’ll notice that we have unapplied cash payment income but no invoice.

In this case, all you have to do is create an invoice for this payment. However, before you do so, check with your client to ensure that this payment should have been invoiced.

Even if you entered the invoice with the same date as the payment, the payment will still be recorded as unapplied cash payment income. To correct this, you must apply the payment to the invoice.

An example of an Unapplied bill payment expense on the Profit and Loss report

  • Any unapplied bill payment expenses will be visible when you run a Profit and Loss Report on a cash basis.
  • To view all of the account’s details, click on it. You can group the transactions by name and run a report, just like you did with the unapplied cash payment income. This will sort the transactions by vendor name, allowing you to see which ones require your attention.
  • In our example, we see a bill payment but no accompanying bill. This means that the payment was either not applied to a bill or that no bill was entered.
  • You can look at the vendor history to determine which situation applies.
  • If you need to add a bill, make sure to do so.

Read Also: QuickBooks Enterprise Support

Related Videos

Leave a Comment