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.

@Peter31 

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

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

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

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. 

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

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.

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

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!

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.

Nice work around.  Thanks!