Skip to main content
July 18, 2023
Question

Profit and loss account

  • July 18, 2023
  • 2 replies
  • 0 views

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.

2 replies

July 18, 2023

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. 

July 18, 2023

Hello Ashleigh

 

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

 

Regards

 

Patrick

 

July 18, 2023

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. 

July 18, 2023

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!