Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 19, 2019
Question

Unapplied Cash Payment Income

  • February 19, 2019
  • 31 replies
  • 95 views

When I run my P and L cash basis, I have a lot of income in Unapplied Cash Payment Income. My  understanding is that this is the account QB uses when payments were received before the invoice was created. My question is that I have cases where the payment was received before the invoice was made, but I subsequently made the invoice and applied the payment to that invoice. Why is this income still being reported as Unapplied Cash Payment Income?

31 replies

HoneyLynn_G
Level 6
February 19, 2019

Hello there, @DG5.

 

Thank you for posting here in the Community. I can share some insights about the Unapplied Cash Payment Income account.

 

Yes, you're right that the account is used when payments were received before the invoice was created. Aside from that reason, another is that you haven't match the payment to the sales transaction.

 

Let's work together to resolve this!

 

Step 1: Let's run the Open invoices report. In the Transaction Type column, locate a transaction listed as a Payment.

 

If the Payment transaction matches on the open invoice, you can proceed to Step 2. Otherwise, go directly to Step 3.

 

 

Step 2: The Payment transaction matches an open invoice:

  1. Click the Payment date.
  2. Under Outstanding Transactions, check the open invoice.
  3. Select Save and close.

 

Step 3: The Payment transaction doesn't match an open invoice:

  1. Click the Plus (+) icon.
  2. Select Invoice.
  3. Enter the same customer, amount and date as the payment.
  4. Select Save and close.
  5. Go back to the Open Invoices report.
  6. Find the unapplied payment and click the date.
  7. Under Outstanding Transactions, check the open invoice.
  8. Select Save and close.

Repeat the same steps until there are no payment transactions anymore. After that, pull up the Profit and Loss report once more.

 

You should no longer see the Unapplied cash payment income, DG5.

 

Let me know the results, @DG5. I'm still here to help you more if you have follow-up questions about reports. Just click the "Reply" button or mention my name. Wishing you all the best!

DG5Author
February 19, 2019

Thanks for responding. None of these payments came up on the Open Invoice report. (A few of them are coming up on the Open Invoice report, but the majority are not.) I believe they have all been applied to invoices, but they are still coming up as Unapplied Cash Payment Income.

HoneyLynn_G
Level 6
February 19, 2019

Thank for getting back and providing the result, @DG5.

 

I've checked my resources to verify if there's an on-going investigation about applied invoices still coming up as Unapplied Cash Payment Income. However, there are none. 

 

To better isolate this issue, I recommend calling our phone support team. They can utilize our screen sharing tool to help identify what's causing this odd behavior in QBO.

  1. Log into your QuickBooks Online company.
  2. Click Help.
  3. Click the Contact us button.

 

Keep me posted how the call goes, DG5. I'd like to make sure this is taken care of. I'm still waiting for your response. Thank you and take care!

 

Level 4
February 21, 2019

@DG5 wrote:

When I run my P and L cash basis, I have a lot of income in Unapplied Cash Payment Income. My  understanding is that this is the account QB uses when payments were received before the invoice was created. My question is that I have cases where the payment was received before the invoice was made, but I subsequently made the invoice and applied the payment to that invoice. Why is this income still being reported as Unapplied Cash Payment Income?


It also depends on the date range of the P&L. Is the invoice dated after the "To" date of the P&L?

DG5Author
February 21, 2019

No, the invoices in question are dated within the date range of the P and L.

QuickBooks Team
February 21, 2019

It's good to see you here with us again, DG5,

 

Let me help share additional information about Unapplied Cash Payment.

 

Upon running a Profit and Loss report using the Cash method, you may see Unapplied cash payment income.

 

Unapplied Cash Payment income is an account being used to report cash basis income from your customer's payments that are received but not applied to any sales forms.

 

Normally, the date of the payment is before the invoice date it's applied to.

 

For more detailed information, I'm attaching a great resource that you can check on: What's Unapplied Cash Payment.

 

If there's anything else you need help with, please feel free to reach back out. Have a great day!

January 15, 2020

Just change the date of your invoice to the date of the payment. If the payment date is prior to the invoice date you get unapplied cash payment income.

February 3, 2020

That will effect reconciliations, so that is not an options. Again dates matter.

We also get prepayments.  What I need to know is how to match them up moving forward so they don't end up in unapplied cash income account.  If anyone knows.  Thank you. SM

QuickBooks Team
February 3, 2020

Thanks for joining on this thread, @SMHVAC.

 

I can see that the dates matter for your business. To ensure that it will not throw off your reconciliation, I suggest consulting with an accountant. They can provide recommendations on how to properly track transactions, so they will not end up in the unapplied cash income account.

 

In regard to the prepayments, I suggest following the resolution provided by @qbteachmt. For an overview of the unapplied cash payment account, check out the What's Unapplied Cash Payment article. 

 

If there’s anything else I can help you with, post a comment below. I’ll be right here to assist further. Have a good one.