Thank you for visiting the Community, Nicholas8. We'll be sharing details on how exporting reports in Excel works and make sure you'll be able to view the report with accurate information.
We 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. See the screenshot for your reference:
We can also fix the incorrect report by enabling Marcos. Here's how:
If you get a notification about Macros when exporting, just accept the Macros. You can check out this article for more details about exporting your reports to Microsoft Excel: Export your reports to Excel from QuickBooks Online.
If the issue persists, we 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 on how:
If you don't see the Update option, you already have the latest version of Excel. To export your QuickBooks Online reports and lists, follow the steps in this article: Export data, reports, lists, and more from QuickBooks Online.
Additionally, to know more about personalizing your reports in QBO, you can refer to this article for guidance: Customise reports in QuickBooks Online.
Please don't hesitate to reply to this post if you have further questions about exporting reports to Excel or any QuickBooks-related concerns. The Community always has your back to help you out, Nicholas8.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here