cancel
Showing results for 
Search instead for 
Did you mean: 
Peter31
Level 1

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

 
13 Comments 13
RenjolynC
QuickBooks Team

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

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.

Rustler
Level 15

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

@Peter31 

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

EBITDA
Level 1

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

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

Kass_B - Product Champion
Content Creator

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

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

MarkT7
Level 1

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

thanks for the tip I will try setting up a custom report to get this data.  EBITDA is arguably the next most important report on a business after the Balance Sheet, P&L and Cash Flow. I hope you do more than just suggest an EBITDA report to your product team.  For an accounting software system this is a major oversight. 

jdolan14
Level 3

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

has an ebitda report been added?  i would like an ebitda report within quickbooks, i don't want to have to manually do it in excel

ReyJohn_D
Moderator

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

Being able to pull up an EBITDA report in QuickBooks Online (QBO) is an excellent idea, @jdolan14.

 

While this isn't an option, you can consider following the workaround given by my peer @RenjolynC above. 

 

Also, I'd recommend visiting our QuickBooks Blog page to keep up with the latest news and product enhancements. All details are laid down there so you can check it from time to time. To learn more about the newly added features in the program, you can navigate through the What's New in QBO tab.

 

If you wish to filter your reports in QBO, you can customize them. This way, you'll get personalize info you need the most. Then, you can memorize them to save their current customization settings to keep a copy for quick future access.

 

Feel free to comment back if you have some follow-up questions in mind. I'll be here to help. Take care always.

JessieG
Level 1

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

Anyone have an example of what this report should look like after moving to excel and manually adding the line?

Jen_D
Moderator

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

Thanks for posting here, @JessieG

 

I can share some insights on how you can export your report to Excel and how to customize the information from there. Follow the steps below to export the P&L report:

 

  1. Go to Reports menu, then choose Profit and Loss.
  2. At the top of the report, select the Export icon. Then select Export to Excel.
  3. If you’re missing data when you open the report in Excel, the file's in protected view. In Excel, you’ll need to select Enable Editing to view the full report.
  4. Add a column for EBITDA then use the Formulas menu at the top to add calculations on the Excel report.

 

Save the file somewhere you can easily find, like your Downloads folder or your desktop.

 

Let me know if you need anything else. I'll be right here if you need further help with report customisations. Have a lovely day!

katerjoyce
Level 1

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

No need to export to Excel. Reformat your chart of accounts to move interest, depreciation, etc below the line to other expense. Your report won't say EBITDA but the "Net Operating Profit" or "Net Ordinary Income" (depending on your system) will essentially be true EBITDA.

Mark3826
Level 1

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

Nice work around.  Thanks!

phil1962
Level 1

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

its just a shame that you can't change the "Net Ordinary Income" Heading to "EBITDA"

IntuitSheila
Level 8

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

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.