cancel
Showing results for 
Search instead for 
Did you mean: 
snowleopard25
Level 2

Custom Profit and Loss Report?

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!

Solved
Best answer December 08, 2020

Best Answers
jamespaul
Moderator

Custom Profit and Loss Report?

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.

 

simppnl1.PNG

 

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.

 

simppnl2.PNG

 

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. 

View solution in original post

2 Comments 2
jamespaul
Moderator

Custom Profit and Loss Report?

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.

 

simppnl1.PNG

 

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.

 

simppnl2.PNG

 

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. 

snowleopard25
Level 2

Custom Profit and Loss Report?

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

 

 

Need to get in touch?

Contact us