cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
Jen_D
Moderator

Reply to message

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!