Hi there, stellapi.
Thank you for visiting the QuickBooks Community. I'll be sharing details on how exporting reports in Excel works. Then, ensure you'll be able to view the report with accurate information.
As mentioned above, you have to click the Enable Editing button in the upper part of the Excel file to show the correct amount of data in your financial statement. Otherwise, the report appears as zero in Excel.
If the issue persists, you'll have to make sure that you're following the recommended operating systems and internet speeds or the system requirements for QuickBooks Online. This is to ensure that you'll get the best experience when using the software without any issues.
Additionally, I also recommend updating your Excel to isolate the issue. Outdated Excel may have caused exported reports to show all amounts as zero. Let me guide you how:
- Open the Excel file.
- Navigate to the File menu.
- Select Account.
- Click Update Options.
- Select Update Now.
If you don't see the Update Options, this means you already have the latest version of Excel. In this care, I suggest contacting the Microsoft Support team. There, they'll be able to provide you with some steps on how to troubleshoot your Excel.
If the problem continues to occur, I advise reaching out to our QuickBooks Support Team. They have the tools to pull up your account to investigate the cause of the problem so you can get back on track as soon as possible.
Lastly, you may refer to this article to view a table list that contains different reports that are available for your version of QuickBooks Online: Reports included in your QuickBooks Online subscription.
You’re always welcome to post a reply below if you have other concerns exporting reports in your QuickBooks Online (QBO) account. I’ll be around to help you. Keep safe and stay well.
