There are a few reasons why the exported report from QuickBooks Online shows zeros in the Excel file. Let me outline this to help you resolve this data issue, Mohsin.

First off, have you seen the Enable Editing button at the top of the Excel file? If yes, we can exit Protected View by clicking on Enable Editing to help it show the correct amounts. See the reference below:

However, if that isn't the case, here are several things to consider:

• Sometimes, compatibility issues can cause problems with data export. Make sure Microsoft Excel is updated to the latest versions.
• Ensure that all settings and filters are selected during the export process.
• Sometimes, browsers can cause issues with the export functionality. Clearing your browser cache or using a different browser.

Moreover, we can view this page if you want to pull up other balance sheet reports or compare them to A/R Aging Summary or A/R Aging Detail report: Run a Balance Sheet report in QuickBooks Online.

Lastly, you may refer to this article to view the list of different reports that are available for your version of QuickBooks Online: Reports included in your QuickBooks Online subscription.

It's my pleasure to assist you today with exporting the balance sheet report in QBO. If you need another help, just write your comment below. I'll ensure to respond promptly.