Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have got a monthly profit and loss account. It shows full details of all expenses - they are broken down by category. However, I cannot work out how to break down the income by category - I have 5 different categories of services that I provide and I want to easily see how each one is doing.
Hello Patrick Cox, thanks for posting on the Community page, if you go to reports> profit and loss> on the setting at the top that says Show non-zero or active only- select the option that says ALL for both> run report it should then show you all the information you need.
Hi Patrick, thanks for the screenshot - please click the Customise button to see if you have the option for "Show non-zero or active only! under the Rows/Columns drop-down.
No it doesn't. I don't understand why I have to do this for you, I thought you would know what it shows? I assumed you were familiar with the product as you are part of the Quickbooks team, is this not correct? I attach what it does show. I can change the columns to show breakdown by services but the problem is then it gives the total figure for income from each service but over the entire period rather than on a monthly basis. That is useless to me. I want monthly figures for types of income and types of expenditure. If Quickbooks cannot provide that, then please just say so.
I can imagine the hurdles you've been through to resolve this concern, Patrick. I'll make it up to you by clarifying how the profit and loss report works in QuickBooks Online (QBO).
In QBO, you can customise a Profit and Loss report depending on your subscription version. The Show non-zero or active only option mentioned by my peers above is exclusive to QBO Essentials, Plus, and Advanced.
To clarify, what is the version you're using?
If you're using a QBO Simple Start version, your customisation options are limited to what you see once you click the Customise button. See the screenshot below for your reference:
If you have the higher versions of QBO, you'll have additional customisation options when running the Profit and Loss by Month report.
Furthermore, you can pull up the Profit and Loss Detail report to see the breakdown in each of your income and expenditure accounts.
After customising your reports, you can also export your business data to Microsoft Excel to use it outside of QuickBooks: Export your reports to Excel from QuickBooks Online.
In case you really need this option and want to upgrade your subscription to higher editions, then you can follow this article for the complete process: Upgrade or downgrade your QuickBooks Online.
I'm willing to hear you out if you have more concerns with customising your reports in QBO. I'll be here to help you in any way I can. Stay safe!
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.