Skip to main content
September 11, 2019
Question

Is there a way to format the P&L report to have an EBITDA line and have Interest and Depreciation reported below that line?Ideally would like an EBITDA and Net Income

  • September 11, 2019
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

RenjolynC
September 11, 2019

Hi Peter31,

 

We're unable to add an EBITDA line in the Profit and Loss report. As a workaround, we can filter the report to show all accounts and exclude the interest, taxes, depreciation, and amortization accounts.

 

Here are the steps:

  1. On the left panel, click Reports.
  2. Under Business Overview, click Profit and Loss.
  3. Click the Customise button and select Filter.
  4. From the Distribution Account drop-down menu, put a check mark on the Select All box.
  5. Un-check the interest, taxes, depreciation, and amortization accounts.
  6. Click Run reports.

Then, export the report to Excel and manually add the EBITDA line. You can also get the Net Income information by running the Profit and Loss Detail report.

 

I'll make sure to forward your suggestion to our product engineers for evaluation.

 

If you need anything else, feel free to reach out to us. Thanks.

June 25, 2020

Can you provide guidance more on the last step mentioned in the reply "and manually add the EBITDA line"? Thanks!

June 25, 2020

Hi EBITDA,

 

As you are removing the accounts that make up the EBITDA, in order to create a line with one total after exporting you would need to firstly calculate what the separate amounts total to. You can run the report without the customisation above to gather the amounts, then once you have customised and exported it can add those amounts together and create the EBITDA line.

 

-Kass

Rustler
September 11, 2019

@Peter31 

The only thing you can do is export to excel and reformat there

July 4, 2024

Hi Peter,

 

I can understand the importance to be able to change the net earnings line in the Profit and Loss report to EBITDA. I recommend sending your product feedback through QuickBooks Online. This way, our product engineers will know of the options/feature you needed in QuickBooks Online. 

 

Here's how you can send feedback:

 

  1. Click on the Settings icon.
  2. Click on Feedback.
  3. Click on Next and choose Feedback under Category option.
  4. Select Save.

 

For now, we're unable to provide a predicted time period. Rest assured; I will share your concern to our team so they can submit this to our product developers. 

 

In the meantime, please continue using the workaround by exporting the report to Excel and manually changing the label to EBITDA.

 

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community.