QBDT - P&L report not showing correct income

I appreciate the detailed information you've shared, pjmitchell55. 

Please allow me to help share additional information about running the Profit and Loss Detail report in QuickBooks Desktop (QBDT). 

The Profit and Loss report summarizes your income and expenses for the year to know whether you're operating at a profit or loss. However, you can create/run a report which shows payments in QBDT. As of now, you can start opening the Transaction List by Customer report and make the necessary customization. Here's how:

1. Click on Reports at the top menu bar.
2. Choose Customers & Receivables.
3. Press on Transaction List by Customer.
4. Customize the dates of the report.
5. Tap on Customize report to customize the transaction type to Payment.
6. Go to the Filter column.
7. Look for Transaction Type.
8. Select Payment.
9. Click OK. 

Also, let's make sure it was properly deposit to the correct bank account. To learn more about running and customizing reports in QBDT, you may check these articles:  

• Understand reports 
• Profit and Loss report does not match a sales report

Don't hesitate to leave a comment below if you have any other questions about the report. Have a good one. 

Thank you, however this does not explain what I am asking.  I want to know specifically why a deposit that in every other way appears to have been done correctly does NOT show up in P&L reports (does not matter if run in accrual or cash method).  

I very clearly see the payment made, and applied correctly to the correcty invoice.   I very clearly see the deposit made for the full amount.  But when I run the P&L it is $100,000 under the correct amount.  I do see a line item in the invoice for $100,000.  But the invoice as a whole was paid and applied correctly.

I run customized reports frequently.  THIS is a complete mystery and makes me concerned about what else is not appearing correctly in P&L reports and why it could be happening.

Welcome back to the Community, pjmitchell55.

I appreciate adding more details about the issue. This gives me a clearer view of what happened to the report.

Based on the information shared, we’ll have to run the Verify and Rebuild Data Utilities. These are built-in tools used to validate whether your file is still in good shape and fixes common errors.

To begin, run the rebuild tool after creating a backup of the company file to resolves data integrity issues. Verifying the file identifies the most commonly occurring data issues.

1. Press the File menu at the top to select Utilities and Rebuild Data.
2. Click OK to save a copy of the company file.
3. Hit Save to keep the copy.
4. Then, click the OK button once the Rebuild is completed.
5. Go back to the File menu to choose Utilities and Verify Data.

If it finds an issue, check the damaged transaction/s shown in the QBWin.log and apply the solution. For detailed instructions, follow the instructions in this article and go to the Apply the appropriate fix on the transaction/s. section: Fix damaged transactions in QuickBooks Desktop.

Additionally, this guide provides an overview of how to resolve data issues: Fix data damage on your QuickBooks Desktop company file.

Please let me know if there's anything else you need. I'll be here to keep helping. Take care and have a good one.

Thanks for the response.  I ran the Rebuild & Verify data utilities.  Nothing changed unfortunately.  I am at a loss.  I'll keep exploring why the P&L report is not including that $100K when all looks ok.  Sigh.

HA!  I figured it out - just wanted to update.  I looked at the invoice and the line item for $100k.  I checked the item list for that item and realized the associated account was "contstruction in progress" instead of "construction INCOME" !!.  I changed it and the report is right now.

Hi there, pjmitchell55.

Thanks for dropping by the Community and providing an update. I'm happy to see that you were able to find that discrepancy! 

If you have any other questions, feel free to post here anytime. Thanks for your time and have a lovely day.

I can't seem to get an answer as to why when I run a cash report, it's correct on the P&L but when I run an accrual report it shows very little income.  I have a lot of invoices that were billed for work done and we are awaiting payment.  Those invoices should show up on the accrual method but they do not.  If I put in May, for instance, it shows only outstanding for May and not total outstanding for the year???  It was showing correctly in the past.  what has changed?  how do I fix this so the accrual report is correct

Hello there, @Carolexx.

Please allow me to help share additional information about running the Profit and Loss Detail report in QuickBooks Desktop (QBDT). 

The Profit and Loss report summarizes your income and expenses for the year to know whether you're operating at a profit or loss. However, you can create/run a report which shows payments in QBDT. As of now, you can start opening the Transaction List by Customer report and make the necessary customization. Here's how:

1. Click on Reports at the top menu bar.
2. Choose Customers & Receivables.
3. Press on Transaction List by Customer.
4. Customize the dates of the report.
5. Tap on Customize report to customize the transaction type to Payment.
6. Go to the Filter column.
7. Look for Transaction Type.
8. Select Payment.
9. Click OK. 

Also, let's make sure it was properly deposited to the correct bank account. To learn more about running and customizing reports in QBDT, you may check these articles:  

• Understand reports 
• The profit and Loss report does not match a sales report

Don't hesitate to leave a comment below if you have any other questions about the report. Have a good one.