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:
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.
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.
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.
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.
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:
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.