Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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:
To resolve this, let's access your Open Invoices 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.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here