When I export a profit and loss comparison report to excel, it is opening in excel showing zeroes in the entire report. It is importing the format but not the numbers.

When exporting a Profit and Loss comparison report from QuickBooks Online to Excel, the entire report may display as zeros if the Excel file is opened in Protected View, accounting658. This is due to a security feature that limits editing and can sometimes display values as zeros. Let me share additional information.

To view the accurate values on your financial statement, click the Enable Editing button located at the top of the Excel file.

When you export reports to Excel, the file will open in Protected View. Here's an article from Microsoft that provides further information on this topic: What is Protected View?

If the issue persist, I recommend contacting the Microsoft Support team. They can provide you with troubleshooting steps for Excel-related problems.

In addition, here are resources you can refer to for managing reports within the program: Customize reports in QuickBooks Online.

If there's anything else you need assistance with exporting data from QuickBooks. Feel free to reach to us. We're always here to help!