Skip to main content
S
snowleopard25
December 8, 2020
Solved

Custom Profit and Loss Report?

  • December 8, 2020
  • 1 reply
  • 0 views

Hi,

 

I wanted to create a simplified custom profit and loss report.

 

With just:

 

1. Revenue 

2. Cost of goods

3. Gross profit

4. Advertising expenses

5. Net earnings

 

Is there anyway to do this? 

 

Currently my profit and loss has all my expenses etc. (more than listed above) which I still also need - however I also just wanted the above basic simplified version for another purpose without having to calculate it manually each time and instead hopefully let quickbooks can calculate it in a report for me?

 

Thanks!

Best answer by jamespaul

Hello, snowleopard25.

 

Happy to offer assistance on how you can simplify your Profit and Loss report. 

 

You can collapse the view of the report and export it to PDF to simplify it (without omitting the needed accounts). Doing it on Excel however will expand the view. Here's how: 

 

  1. Run the Profit and Loss report.
  2. On the report overview, click the small arrow icons beside the account category. You can also click the Expand or Collapse link right above the report header.
  3. After collapsing all accounts, click the Export icon.
  4. Choose Export to PDF.

 

 

You can also filter specific accounts (Income and expense accounts) to simplify your Profit and Loss report. However, this will omit other accounts. In case you want to do it:

 

  1. On the Profit and Loss report, click the Customize button. 
  2. Expand the Filter section.
  3. Check Distribution account, then select the specific account you want to show on the report.
  4. Once done, click Run report.

 

 

If you need more help customizing your Profit and Loss report, please check this article for a guide: Customize reports in QuickBooks Online.

 

You're more than welcome to visit our help articles if you need assistance doing a specific task in QuickBooks. Just browse a topic here and look for an article of your choice. I'm sure they'll guide you in managing your transactions, data and your account. 

 

I can show you what else you can do in QuickBook Online. Just post your questions here, and I'll guide you. 

1 reply

J
jamespaulAnswer
December 8, 2020

Hello, snowleopard25.

 

Happy to offer assistance on how you can simplify your Profit and Loss report. 

 

You can collapse the view of the report and export it to PDF to simplify it (without omitting the needed accounts). Doing it on Excel however will expand the view. Here's how: 

 

  1. Run the Profit and Loss report.
  2. On the report overview, click the small arrow icons beside the account category. You can also click the Expand or Collapse link right above the report header.
  3. After collapsing all accounts, click the Export icon.
  4. Choose Export to PDF.

 

 

You can also filter specific accounts (Income and expense accounts) to simplify your Profit and Loss report. However, this will omit other accounts. In case you want to do it:

 

  1. On the Profit and Loss report, click the Customize button. 
  2. Expand the Filter section.
  3. Check Distribution account, then select the specific account you want to show on the report.
  4. Once done, click Run report.

 

 

If you need more help customizing your Profit and Loss report, please check this article for a guide: Customize reports in QuickBooks Online.

 

You're more than welcome to visit our help articles if you need assistance doing a specific task in QuickBooks. Just browse a topic here and look for an article of your choice. I'm sure they'll guide you in managing your transactions, data and your account. 

 

I can show you what else you can do in QuickBook Online. Just post your questions here, and I'll guide you. 

    S
    snowleopard25Author
    December 9, 2020

    The second option was exactly what I needed - Thank you so much! :)

     

     

    Terms & ConditionsAccessibility statement