Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowWhen I run a P&L for last year it shows Sales with a total and Services with a total. It's virtually the same total and when I check, it is a duplication of the income. The report is adding the two together for a reported total double what it should be. Which should I be seeing in the P&L Sales or Services and how do I turn off the other so it's not included?
Hello there, @Mike M5.
I'll help you resolve the issue with your Profit & Loss report that shows duplicate transactions for Sales and Services in QuickBooks Online.
To avoid duplications, we can filter your reports to display only the specific accounts you want. However, this may still impact other reports and balances on your Chart of Accounts.
Here's how:
I would also like to know if you are using Banking as well as recording the transactions manually.
If so, you might have added the bank transactions to your register instead of matching. I recommend you undo the categorized transaction and then match or find a match.
You can then pull up the report again and see if there are any changes.
If you have done things differently, I would appreciate if you can provide a screenshot so I can check further of what is showing on your Profit & Loss report.
For future reference, you can read these articles about customizing and memorizing the customization of the reports in QuickBooks Online:
Don't hesitate to click the Reply button below if you need further assistance in running reports with QuickBooks Online.
If the P&L is doubling your income using two separate income accounts, then, somehow, income is being recorded twice. Filtering the P&L shouldn't be necessary. You need to dig in and find out why income is being recorded twice. Are you using bank feeds and possibly duplicating your income by not matching the transactions to the invoices, sales receipts, or payments? That's very common. How do you record sales - using invoices, sales receipts or ??? Also, if your income is overstated by 2x, then you must have another account that is overstated by the same amount. Do you reconcile your bank account monthly? Is there anything on your balance sheet that looks off like an overstated bank account or undeposited funds?
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