Skip to main content
September 30, 2023
Question

Can I change format of profit and loss statement

  • September 30, 2023
  • 1 reply
  • 0 views
Can I change format of profit and loss statement, athe moment owner expenses are deducted from profit  is it possible, to adjust this .somehow ,and deduct from.net income..

1 reply

October 1, 2023

I can see this is useful in your everyday task, @maags. I can share a workaround so you can change the profit and loss format to set it as Net income minus expenses in QuickBooks Online.

 

We export the report to an Exel file as a workaround since the profit and loss are calculated as revenue minus expenses. Once done, you can modify the file from there. Doing this will allow you to edit all the data in the Excel file. 

 

Here's how:

 

  1. Go to Business Overview and select Reports.
  2. Search for and select the report you want to export.
  3. At the top of the report file, select the Export icon. Then choose Export to Excel.
  4. Save the file somewhere you can easily find, like your Downloads folder.

 

Moreover, if you're experiencing missing data when opening a report in Excel, it's likely because the file is in protected view. To view the full report, you'll need to select Enable Editing in Excel. 

 

Alternatively, you can switch between the two views anytime without affecting your accounts or data. It allows you to choose the view that best suits your needs. See this reference: Switch between Business and Accountant view in QuickBooks Online.

 

I'm here to help you with any questions or concerns under the Reports section. Feel free to ask me anything, and I'll do my best to provide you with a helpful response.