Fix cash basis P&L report; transactions are missing

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 Invoices, Payment, Bill, 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.

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

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?

i did what you said and then closed the window. then i ran the p&l again and clicked on cash basis and got the same thing----all the sales were missing. i am an accountant who has been working on QB off and on, for many yrs before i became self employed. I am baffled by this. 

I dont know how to fix it. I know the difference between accrual and cash basis. This is some kind of glitch. 

Hello @Marial1214 

Let's continue our troubleshooting steps by utilizing the QuickBooks integrated tools so you can determine why your transaction is not showing in your report.

A. To Verify Data

1. Go to File.
2. Click Utilities.
3. Select Verify Data.
4. Click OK.

B. To Rebuild Data

1. Go to File.
2. Click Utilities.
3. Select Rebuild Data.
4. Click OK.

In addition, here's an article you can read to learn more about the QuickBooks tools: Verify and Rebuild Data in QuickBooks Desktop.

Lastly, I've also included these helpful articles for ideas to help manage your account and related tasks: Help Articles for QuickBooks Desktop.

Keep me updated in the comments if you have any other questions. Always around ready to lend a hand.

hi,

I am on cash basis and when I run the p and l the cash p and l is missing my interest accounts and on a couple of other expense accounts ending balance  (missing transactions but listed on gl) but reflecting on the same the correct amount on the accrual   I have run the data verification and all is good. Why is my p and L cash  different from the accrual? I have no outstanding invoices. How can this be fixed.

Thanks,

I’ve got some information to share with you, @drod4781.

There are few things you need to know when generating financial reports especially Profit and Loss in QuickBooks.

Income on the accrual basis includes all bills sent to your customers, regardless of whether you've received payment or not. While income on a cash basis only includes revenue that your customers have paid to you. Expenses on the accrual basis include everything you owe, regardless of whether or not you've sent a payment. While Expenses on a cash basis include only the values that you have already paid.

If the missing entries should be included on the cash report, we can utilize the tools in the QuickBooks Tool hub.  QuickBooks Tool hub is a collection of all QuickBooks tools in one application that fixes different issues. However, you’ll want to restore the backup first if you’ve recently rebuild your file.

Here are the steps:

1. Download the most recent version and install the QuickBooks Tool Hub.
2. Open the file you downloaded (QuickBooksToolHub.exe).
3. Follow the onscreen steps to install and agree to the terms and conditions.
4. When the install finishes, double-click the icon on your Windows desktop to open the tool hub.
   

You might want to visit this article about cash and accrual accounting. This provides further information on how each one works so you can choose the best bookkeeping practices for your business.

I want to ensure your success. Please let us know how this goes. We’ll be here to assist you anytime. Have a good rest!

thanks for getting back to me.  I have read the information regarding the tool hub.  Is this the same as the utilitiesin the application.  if so I have run it and it tells me that there is no issues.  

Good work for trying to run the tool, Drod4781. 

I suggest reaching out to our customer care support since you're still having the same issue. A live agent has more tools to take a better look at this. Let me guide you:

1. Click Help inside QuickBooks.
2. Go to QuickBooks Desktop Help.
3. Click Contact Us.
4. Enter "Profit and Loss report issue" in the description field, then click Continue.
5. Select either Message an Agent or Talk to a Specialist. 

You can take note of our support hours so you can immediately get in touch with an agent.

You're always welcome to visit the Community. Don't hesitate to get back to us if you have other concerns. Take care!