cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Patrick Cox
Level 2

Profit and loss account

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.

5 REPLIES 5
Ashleigh1
QuickBooks Team

Profit and loss account

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. 

Patrick Cox
Level 2

Profit and loss account

Hello Ashleigh

 

Where is this setting? I don't see any such setting. Attached is what I have. 

 

Regards

 

Patrick

 

GeorgiaC
QuickBooks Team

Profit and loss account

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. 

Patrick Cox
Level 2

Profit and loss account

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.

Kevin_C
QuickBooks Team

Profit and loss account

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!

Need to get in touch?

Contact us