Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
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.
lp_mi
Level 3

Why is P&L Transaction Report adding instead of subtracting expenses

When I run a Profit and Loss by Customer report - the total net income amount is correct. Good there, BUT,  I then click on one customer's net income amount to see the Transaction Report details, it opens the Transaction Report, but that report ADDS all of the expenses to the income, giving a grand total for all income & expense transactions added together instead of subtracting the expenses. Why? I want to see the Transaction Report as a detail of the Summary Report for that customer project where the Income is added and the expenses are subtracted to give me the details and the actual net income amount at the bottom of the detailed Transaction Report. I did, after-all, click on the total net income amount to go to the Transaction Report so that's what I want to see. Why doesn't the Transaction Report subtract expenses to give me the same total as on the Summary Report? Did something change within Transaction Reports? Expenses should never show as a positive or be ADDED in any P&L report as this defeats the purpose. 

5 Comments 5
FishingForAnswers
Level 10

Why is P&L Transaction Report adding instead of subtracting expenses

@lp_mi  For clarity, any chance you can provide an image of what you're seeing? With any sensitive information blocked out, of course.

Rea_M
Moderator

Why is P&L Transaction Report adding instead of subtracting expenses

Welcome back to the Community, lp_mi! It's great to see you again! Accurate financial reporting is essential for driving your business growth. You can count on me to guide you through the troubleshooting, ensuring you can manage your business with confidence.

 

I'll make sure to prioritize your Profit and Loss (P&L) report data queries. However, to fully understand your issue and provide the most effective support, I would appreciate some detailed information. Specifically, a screenshot of both reports. This will help me address your matter more accurately.

 

A Profit and Loss report is a financial statement that outlines your business's revenue and expenses over a specific period. Yes, I agree that the latter should be subtracted from the Transaction Report (Profit and Loss Detail) as a detail of the summary or the Profit and Loss by Customer report. Refer to the attached file below.

 

80.png

 

One possible reason you're seeing different amounts on your statements could be that your browser has accumulated too many cached files. QuickBooks relies on the browser's cache to function efficiently, so clearing any outdated files can help improve your viewing experience and overall system performance.

 

Start troubleshooting by pulling up your QuickBooks Online (QBO) account using a private browser (incognito). Here are the keyboard shortcuts:

 

  • Press Ctrl Shift (Google Chrome)
  • Ctrl Shift (Firefox)
  • Control Option (Safari)

 

Once signed in, go to the Reports menu to generate the Profit and Loss by Customer and Profit and Loss Detail reports.

 

If your data matches, return to your default browser and clear its cache. Right after, you can restart your browser and log back into your QBO account to refresh the system.

 

However, if this matter continues, I recommend clicking the browser's Refresh icon (please see the screenshot below) or using other supported browsers

 

Clear Cache.png

 

Additionally, would you like to filter your data to highlight specific accounts or customers? Or perhaps you want to format the layout to ensure the most relevant information stands out? You have the flexibility to customize your reports, allowing you to focus on the important details for your company.

 

Looking forward to working with you again, lp_mi. If there are any additional questions or you need further clarification about the data in your Profit and Loss report, please don’t hesitate to click the Reply button. I’m always here to help. Take care and I hope you have a fantastic day ahead!

lp_mi
Level 3

Why is P&L Transaction Report adding instead of subtracting expenses

Thank you for your replies - Did you get to the Profit & Loss Detail Report by clicking on the Net Income on the Profit & Loss by Customer Report? If not, you may not have experienced the issue I have. I did clear my cache, tried an incognito window and different browser which did not help. Here's what I came up with...


It appears we can no longer click on the Net Income amount at the bottom of the Profit & Loss by Customer Report to get to the Profit & Loss Detail Report. Clicking on the Net Income amount takes you to the Transaction Report which has Income & Expense lines out of order and adds expenses instead of subtracting them. This should not be the case and really needs to be fixed to keep the amounts in order and subtract expenses on the Transaction Report so it lines up with the other P&L reports for the customer.


To work around this inconvenience, I can back out of the Profit & Loss by Customer and go to the Profit & Loss Detail report then filter down to the customer to see the income & expenses in order with the expenses subtracted - BUT - This takes extra steps and time so it would be greatly appreciated if QuickBooks could look into this and make it so we can get directly to the Profit & Loss Detail Report by clicking on the Net Income amount at the bottom of the Profit & Loss by Customer Report. Thank you.


Please forward this to your IT department and will also be putting this into my feedback window.

ShyMae
QuickBooks Team

Why is P&L Transaction Report adding instead of subtracting expenses

I appreciate you sharing thorough information and acknowledge the efforts you've made. Accurate reporting of expenses and income is indeed essential for transparency. I replicated this on my end to ensure I can provide the resolution for your case, lp_mi. 

 

I generated the Profit and Loss by Customer report and was able to click the Net Income amount.



 

Afterward, I was directed to the Profit and Loss Detail report, where the expenses were deducted rather than added to the net income.

 

I agree that expenses should be subtracted from the net income, and I'm glad that the total amount appears correct when you run your Profit and Loss by Customer report.

 

Since you've already tried using an incognito and different browser, but the unusual behavior persists, I recommend contacting our live support team. Our experts can further check and determine why the expenses appear as additions to the net income instead of being subtracted.

 

To contact our live support team, please follow these steps:

 

  1. Hover to the Help icon, then choose the Search tab.
  2. Type in Contact Us in the search bar.
  3. Click Contact Us, and choose the Callback option.
     


For successful communication, please refer to this article to learn about our supporting hours: Get help with QuickBooks products and services.

 

Moreover, you can customize the Profit and Loss by Customer report and memorize it. This feature helps you avoid repeating the customization process, saving you valuable time.


Reaching out to our dedicated live support team ensures a comprehensive review of your financial reports. This process guarantees the accuracy and reliability of all information provided.

Rainflurry
Level 15

Why is P&L Transaction Report adding instead of subtracting expenses

@lp_mi 

 

"Clicking on the Net Income amount takes you to the Transaction Report which has Income & Expense lines out of order and adds expenses instead of subtracting them."

 

Strange.  When I click on Net Income, it directs me to the P&L Detail report for that customer, where expenses are subtracted from income as expected.  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us