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 27, 2021
Question

Fix cash basis P&L report; transactions are missing

  • February 27, 2021
  • 9 replies
  • 41 views

My accrual basis P&L appears correctly but when I select the cash basis filter, half the transactions are missing maybe more. The CPA file was emailed to him and he can read it fine. He said he has seen this glitch before but does not know how to fix. I also did my sales tax liability report just now and tried toggling between cash basis and accrual and it was totally empty for cash basis. Something is not right and I dont have a clue how to fix it. 

 

I own and use QB Desktop Pro 2018. Never had a problem before other than when I first downloaded it I could not email out invoices. Everything has been working fine now this issue with the report. 

 

Can anyone tell me how to fix it? 

9 replies

MariaSoledadG
QuickBooks Team
February 27, 2021

Let me share a few information about the difference between cash and accrual basis, Marial1214.

 

An accrual basis is when you enter a transaction and the time when you actually pay or receive cash may be two separate events. This usually shows income regardless of whether your customers have paid your invoices and expenses regardless of whether you have paid all your bills. While cash basis shows income if you have received cash and expenses and if you have paid cash.

 

You'll want to pull up the Custom Transaction Detail report. Then, filter it with paid invoices and bills to review how payments were created since this is where Quickbase will base its reporting. 

  1. Go to Reports.
  2. Select Custom Reports.
  3. Choose Transaction Detail.
  4. In the Display tab, set the date range. Then, mark Paid Date and Amount Paid.
  5. Go to Filters.
  6. Enter Transaction Type in the Search Filters field.
  7. Highlight the Transaction Type and choose Multiple Transaction Types in the drop-down arrow.
  8. Select InvoicesPaymentBill, and Bill Payment. Then, click on OK.
  9. Click on OK to close the Modify Report window.

To help you with the process, I've attached some screenshots below.

 

 

 

 

I've also included these helpful articles in case you'll want to know more information about QuickBooks Online and its features. 

 

Let me know if you need more information about missing transactions in QuickBooks. I'll be right here to help you.

February 27, 2021

in the beginning, Paid Date is not in the list. I only found Amount Paid. What do I do?

February 27, 2021

I found it. i searched for it in the box. I am working through your directions but I dont see much of a change. one second. I did a P&L cash basis again and there was zero income so instead of having 28k net income, it shows -9000 loss. Do you want to see a screenshot of it?