cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
drm4610
Level 2

P&L Report not showing all the transactions

Hello, 

I am using QuickBooks Desktop. When I create a P&L report for year ending it does not show me all my transactions from customers. Under customer transactions report it does show all the transactions. I have checked the Item List to make sure all the information is correct but I didn't see any errors.

Solved
Best answer February 02, 2025

Best Answers
Rainflurry
Level 14

P&L Report not showing all the transactions

@drm4610 

 

Only customer invoice transactions that have items linked to income accounts will show on your P&L.  When you say "I have checked the Item List to make sure all the information is correct but I didn't see any errors.", are you saying that all items on the invoices in question are mapped to income accounts and are still not showing under income on your P&L?  Invoices with items mapped to non-income accounts will do exactly as you describe - they will show under customer transaction reports but not on your P&L.  If the invoices in question contain items linked to income accounts and are not showing on your P&L it can only be a few things:

1) You may need to rebuild your data. (File > Utilities > Rebuild data)

2) Make sure the invoice date is within the P&L dates (basic, I know).

3) Make sure the invoice is paid if you're running the report on cash basis (also basic).

   

View solution in original post

Sherrie_F
QuickBooks Team

P&L Report not showing all the transactions

Thanks for getting back to this thread, @drm4610. I get how challenging it can be when things don't go as planned—especially when creating a P&L report that doesn't generate all customer transactions for the year. Let's perform some troubleshooting steps to get your financial records back on track.

 

Since you already followed the solution provided by my colleague above, and the transactions are still not fully reflected in the P&L report, I'd recommend verifying and rebuilding your data. This process is designed to identify and resolve errors within the software, ensuring your records are accurate and complete.

 

  1. Go to the File menu.
  2. Select Utilities.
  3. Choose Verify Data, then click OK to close all windows.

 

If you continue to experience problems with your company file, you'll have to rebuild it.

 

Here's how:

 

1. Go to the File menu, then click Utilities.

  • Choose Rebuild Data, then select OK to close all windows. QuickBooks will ask you to make a backup before rebuilding your company file, then select OK. If you don't want to do a backup, choose Cancel to continue rebuilding your company file. If you haven't set up any backup preferences, QuickBooks will ask you to update them. Click the Backup Preferences and edit as needed, then select OK.
  • When the backup's finished, select Show in Finder to locate the backup or select OK if you're done.

 

2. Once the rebuild is finished, select OK.

 

Additionally, I'll drop this article you can browse to learn how to prevent finance charges from being assessed on an invoice, which can be handy for you moving forward: Assess finance charges.

 

Your concerns are important to me, so please don't hesitate to let me know in the comments below if there's anything else you need further assistance with. I'm eager to provide the support you need to streamline your transactions and ensure everything runs smoothly, @drm4610.

View solution in original post

6 Comments 6
KiazzymaeC
QuickBooks Team

P&L Report not showing all the transactions

Hello there, @drm4610.

 

When pulling up a Profit and Loss report, only will show are those posting transactions affecting income and expense accounts. Since, you've mentioned that transactions from a customer aren't showing up, it's important to double-check the filters applied in the Profit and Loss Detail report.

 

Here's how:

 

  1. Go to the Reports menu, then choose Company & Financial.
  2. Select Profit & Loss Detail.
  3. On the page, click Customize Report.
  4. Click the Filters tab.
  5. From there, make the necessary changes. 
  6. Once done, hit OK.

 

Additionally, you may want to learn and understand reports in QuickBooks Desktop.

 

Furthermore, you can also access additional resources for managing your customer and vendor transactions through this links:

 

 

Feel free to comment below whenever you're having trouble regarding your Profit and Loss report. I'm here to help you!

drm4610
Level 2

P&L Report not showing all the transactions

Hey,

 

Thank You for the suggestion. I tired the steps recommended but it is still missing transactions in the report. Just to clarify the transactions which are missing from Customers are invoices sent and invoices paid by customers. It shows some transactions(invoices) for customers but missing others. It looks like QuickBooks is not mapping all the transactions. 

Rainflurry
Level 14

P&L Report not showing all the transactions

@drm4610 

 

Only customer invoice transactions that have items linked to income accounts will show on your P&L.  When you say "I have checked the Item List to make sure all the information is correct but I didn't see any errors.", are you saying that all items on the invoices in question are mapped to income accounts and are still not showing under income on your P&L?  Invoices with items mapped to non-income accounts will do exactly as you describe - they will show under customer transaction reports but not on your P&L.  If the invoices in question contain items linked to income accounts and are not showing on your P&L it can only be a few things:

1) You may need to rebuild your data. (File > Utilities > Rebuild data)

2) Make sure the invoice date is within the P&L dates (basic, I know).

3) Make sure the invoice is paid if you're running the report on cash basis (also basic).

   

Sherrie_F
QuickBooks Team

P&L Report not showing all the transactions

Thanks for getting back to this thread, @drm4610. I get how challenging it can be when things don't go as planned—especially when creating a P&L report that doesn't generate all customer transactions for the year. Let's perform some troubleshooting steps to get your financial records back on track.

 

Since you already followed the solution provided by my colleague above, and the transactions are still not fully reflected in the P&L report, I'd recommend verifying and rebuilding your data. This process is designed to identify and resolve errors within the software, ensuring your records are accurate and complete.

 

  1. Go to the File menu.
  2. Select Utilities.
  3. Choose Verify Data, then click OK to close all windows.

 

If you continue to experience problems with your company file, you'll have to rebuild it.

 

Here's how:

 

1. Go to the File menu, then click Utilities.

  • Choose Rebuild Data, then select OK to close all windows. QuickBooks will ask you to make a backup before rebuilding your company file, then select OK. If you don't want to do a backup, choose Cancel to continue rebuilding your company file. If you haven't set up any backup preferences, QuickBooks will ask you to update them. Click the Backup Preferences and edit as needed, then select OK.
  • When the backup's finished, select Show in Finder to locate the backup or select OK if you're done.

 

2. Once the rebuild is finished, select OK.

 

Additionally, I'll drop this article you can browse to learn how to prevent finance charges from being assessed on an invoice, which can be handy for you moving forward: Assess finance charges.

 

Your concerns are important to me, so please don't hesitate to let me know in the comments below if there's anything else you need further assistance with. I'm eager to provide the support you need to streamline your transactions and ensure everything runs smoothly, @drm4610.

drm4610
Level 2

P&L Report not showing all the transactions

 

Thank You everyone for the help.

AlverMarkT
QuickBooks Team

P&L Report not showing all the transactions

You're most welcome, @drm4610.

 

I'm glad to hear that my colleagues have been of help in resolving your concern about the P&L report not showing all the customer transactions.

 

If you have any other questions or need further assistance, please do not hesitate to reach out. We are always here to help. Have a great day ahead!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us