Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
When I run a report of income and expenditure by class, the total for each class is wrong in that sales receipts are added to expenditure. So a sales receipt of £50 and an expense of £16.20 should show a total of £33.80, but it shows £66.20.
I must have something basic not set up correctly ?
Solved! Go to Solution.
I've got your back, sooverit2. Here's everything you need to know about running a report by class in QuickBooks Online (QBO).
When you pull up a Class QuickReport in QBO, the total amount per class item is the sum of all transactions regardless of the type. This is why you see that it adds up all the amount of your transactions and subtract only the negative one. To know more information, please check out this article: Run reports by class.
If you want to monitor the total amount of your income and expense accounts per class, you can run the Profit and Loss by Class report instead. This group all the expenses and incomes separately to easily view the totals. To do so, refer to the outlined steps provided by my colleague, Angelyn_T above. Please see the screenshot below for visual reference:
Customising reports in QBO is a breeze. This will further help you easily view the necessary details within a specified time frame. Not just that, the program also allows memorising the modification made for future use. To get started, simply click the Customise button located at the upper part of the page.
It's my top priority to ensure all your queries are taken care of. In case you have additional questions about running a report by class or any QBO concerns, leave a comment below. I'll take every opportunity to help. Have a great week ahead.
Welcome to the Community, @Moray Baby Bank.
I got steps to help you fix the incorrect balance on your Income & Expenditure by Class report. To start, let's first check the expense transaction. Let's make sure that you create this as an Expense or Bill and not a Deposit. To easily locate it, let's run a QuickReport for the specific class:
If the transaction amounting to £16.20 is correctly created as an Expense, your report should have the correct data. If it's created as a Deposit, let's delete and recreate it as an Expense or Bill. Here's how:
When finished, let's check again your Income and Expenditure by Class report. Simply go to the Reports tab, scroll down to the Business overview section and click Profit and Loss by Class report.
Also, QBO can help you personalise and include only the details you need when running financial reports. See this article for guidance: Customise reports in QuickBooks Online.
Feel free to get back here if you need further assistance correcting the balance of your Income & Expenditure per Class report. I'll be around to help. Keep safe.
Hello:
I have checked as you suggested and the expense is created as an expense and not a deposit. Please attached screenshot.
As you can see I have a sales receipt for £200 and an expense for £200, so the balance should be £0, not £400.
Thank you
Hello Moray Baby Bank, Thank you for your response, we are unable to see the attachment on the post could you try uploading that again in your reply? Thank you.
Thank you for getting back, @Moray Baby Bank.
Yes, I can now see the screenshot you've added. Your report is correct. In QuickBooks Online (QBO), this is how the Class QuickReport works. The system will sum up all the transactions categorized under that certain class even if the transaction is an income or expense.
To get the result you need, you can run the Profit and Loss by Class instead. I'll guide you how.
If you want to print the report, tap on the Print icon beside the small envelope.
For more hints about running and customizing your reports, you can open this article: Run reports in QuickBooks Online.
Moreover, here's how you can also memorise your report to save its current settings.
Please let me know how else I can help you with handling your income and expenses and reports. I've got your back, and I'm always here to help. Have a good one!
I've got your back, sooverit2. Here's everything you need to know about running a report by class in QuickBooks Online (QBO).
When you pull up a Class QuickReport in QBO, the total amount per class item is the sum of all transactions regardless of the type. This is why you see that it adds up all the amount of your transactions and subtract only the negative one. To know more information, please check out this article: Run reports by class.
If you want to monitor the total amount of your income and expense accounts per class, you can run the Profit and Loss by Class report instead. This group all the expenses and incomes separately to easily view the totals. To do so, refer to the outlined steps provided by my colleague, Angelyn_T above. Please see the screenshot below for visual reference:
Customising reports in QBO is a breeze. This will further help you easily view the necessary details within a specified time frame. Not just that, the program also allows memorising the modification made for future use. To get started, simply click the Customise button located at the upper part of the page.
It's my top priority to ensure all your queries are taken care of. In case you have additional questions about running a report by class or any QBO concerns, leave a comment below. I'll take every opportunity to help. Have a great week ahead.
I know about the P&L reporting by class.
Sometimes you don't need all of that.
I think this is something that should be fixed in QBO.
Desktop version wins again.
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.