cancel
Showing results for 
Search instead for 
Did you mean: 
kellyobrien968
Level 3

Unapplied Cash Payment income

I am running a weekly p&l report and am seeing a $360.00 "unapplied cash payment income" line.  

I have narrowed it down to occurring on a specific date (09/29/2020) but cannot find any corresponding single payment/deposit made that date, and none of the individual payments made that day add up to this amount.  There we only a few transactions that week, so I don't know why this is so difficult to find. 

I've tried running the report of "open invoices" as suggested but cannot get the report to show me only 09/29/2020 activity, so I am seeing EVERY invoice it seems... stuff that is totally unrelated.   How do I "set the report date" to show me exactly what happened on 09/29/2020 ONLY. 

Maybe that way I can sort out what did not get applied properly. 

thanks in advance!
kelly 

 

3 Comments 3
TheresaC
Moderator

Unapplied Cash Payment income

I'm here to help sort things out for you, @kellyobrien968.

 

When you run a Profit and Loss report using the cash method, you may see Unapplied cash payment income. This may appear on your report if:

  • A customer prepaid you and you recorded the payment before creating the sales form (invoice or sales receipt).
  • You entered payments without matching them to sales forms.

To resolve this, let's access your Open Invoices report.

  1. Sign in to your QuickBooks Online account.
  2. Go to Reports menu.
  3. In the Find report by name field, enter Open Invoices.
  4. Choose a date under the Report period dropdown menu.
  5. In the Transaction Type column, locate a transaction listed as a Payment.
  6. Once done, click Run report.

For additional information on how to personalize your report, feel free to check this article: Customize reports in QuickBooks Online.

 

I've also added this great resource you can use to save your customized reports: Memorize reports.

 

I'm just a post away if you need further assistance in running QBO reports. I'll be more than happy to help. Have a great day ahead.

kellyobrien968
Level 3

Unapplied Cash Payment income

Hi! Thank you for the reply and instructions. I had already tried this as it was the same steps as what the "help" button gave, and was not able to find a matching payment in that amount on that date.  It's possible that the deposit was a combination of several payments but I dont see how to find that out. I have NO record of any single payment in that amount for that day or near that date. 

 

kellyobrien968
Level 3

Unapplied Cash Payment income

ok, I found my answer, and it was stupid simple. On the P&L line "unapplied cash payment income" is highlighted in blue... click on it and a popup gives info and link to help with the steps you suggested above. I could not find the error or fix it using that.  BUT, in the right column where the $360.00 figure is, it is also highlighted in blue, so I clicked it and it listed the specific problem invoice. The date on that invoice was wrong and when I corrected it to prior to the first payment date it fixed it.  Knowing to find the info via the $ link would have saved me tons of headache and time. 

Need to get in touch?

Contact us