Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveWhen 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.
@lp_mi For clarity, any chance you can provide an image of what you're seeing? With any sensitive information blocked out, of course.
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.
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:
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.
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!
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.
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:
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.
"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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here