Skip to main content
D
drm4610
February 2, 2025
Solved

P&L Report not showing all the transactions

  • February 2, 2025
  • 1 reply
  • 0 views

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.

Best answer by Rainflurry

@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).

   

1 reply

K
KiazzymaeC
February 2, 2025

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!

    D
    drm4610Author
    February 2, 2025

    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
    RainflurryAnswer
    February 2, 2025

    @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).

       

      Terms & ConditionsAccessibility statement