Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Quckbooks has a pleasing set of Accounts Types, matching those you would expect to be using in just about all Balance Sheet and Profit and Loss Reports.
However, my classically trained view of a Profit Loss account is this:
Income
less Costs of Goods Sold
gives Gross Profit
less Expenses
gives Operating Profit
plus Other Income
less Other Expenses
gives Net Profit (Called Net Earnings in QB Online)
The key points to this arrangement are the ideas that a management accountant is interested in being able to notice and evaluate changes in income and expenditure in order to inform future business decisions. They do not want these decisions affected by unusual income and expenses that will obscure potential adjustments to the business' operations. These abnormal transactions are kept separate by putting them to accounts in the Other Income and Other Expense Account Types which are then used to adjust the Operating Profit to give the Net Profit for the period.
Quickbooks does not respect this arrangement. Instead it puts Other Income after Costs of Goods! and Other Expenses after Expenses!. Further the Total Income and Total Expenses are added or subtracted where they appear. Consequently, no Operating Profit figure can be produced. I do not understnd this logic.
I tried getting a halfway solution which would be a report which excludes Other Income and Other Expenses using the Filter customisation, however, despite their being bulk types to chose from, without clicking every Income, COGS and Expense account individually I was not able to achieve it.
I have looked and looked for a method of getting control over this behaviour, to no avail.
I am hoping you will be able to tell me that there is somewhere I failed to explore.
Hello there, @ATG_Accounts.
I've got some insights to share about rearranging the accounts that will show up on the Profit and Loss report in QuickBooks Online.
At this time, being able to arrange the Profit and Loss report according to your desired view isn't available. However, you may export the said report on Excel and manually customize them based on your trained sequence.
To do that:
From the Excel, you’ll need to select Enable Editing to view and edit the full report.
I know how helpful it would be to have this option available in the system. Know that our developers are always gathering and considering new features to be added so you can run your business easier.
That said, I encourage you to visit our QuickBooks Online Blog site regularly to be updated with our latest happenings.
For your reference, here are some great links that you can visit about the things that can be exported in QBO and on how to customize reports:
Know that you can always visit us here if there's anything else that you need. I'll be around to lend a helping hand. Have a great day!
Thank you Betty.
I wonder if I can automate that process! Sounds hard but could be fun. Tedious to do every month, otherwise.
Hi ATG_Accounts,
To add further to Betty's post, if you do customise a report to your preferred specifications (or close to) in QuickBooks Online, you can save this customisation so you don't need to to redo this every time you run the report. Once you have finished customising, select Save customisation in the top right corner of the screen and give the report a name, then Save. In the future you can run this report straight away by selecting the Reports menu, then the Custom Reports tab.
-Kass
Thanks Kass
I wish that this would solve my problem but the customisation I want is not available, so there isn't anything to save. I shall cross my fingers that the particular flexibility I seek becomes available soon. To be frank, it would be in Quickbooks interests, because as it is, it seems to suggest that its developers are not aware of the purpose of the Other Income and Other Expense account types. But then, maybe I don't understand.
Hi Quickbooks,
Has a report to resolve this issue been created, or do we need to export to excel and customise the report ourselves?
Regards,
Susan
Hi Susan_N,
Thank you for reaching out on this. I have forwarded your feedback to our relevant team so we can continue to improve our product for you. I would also encourage you to submit an in-product feedback for this feature. Here is how:
Thank you and please let us know if you require any additional assistance.
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