When I export Balance Sheet in excel from QBO, no value is exported for the accounts

Thanks for posting here, Nzfarooq.

I understand that you need to export reports to Excel file. 

This issue has been reported already and our product team is now working on a fix. In the meantime, I suggest you contact our Customer Support Team. They'll add you as affected user and you'll receive updates about this behavior.

The new "Help" menu interface: 

1. Click the (?) Help icon and choose the Talk to a human option (then type it again when prompted).
2. When asked by the bot, type "INV-52502".
3. Select I still need a human, then proceed with Contact us.
4. Tap Let’s talk then choose either Get a call or Start messaging. 

For the old "Help" menu:

1. Click the Help icon, then the Contact Us button.
2. Type "INV-52502" in the What can we help you with box.
3. Proceed with the Let's talk button.
4. Select either Start messaging or Get a call button.

You can check these links for more info about reports:

• Customize reports in QuickBooks Online
• Export reports, lists, and other data from QuickBooks Online

Post again here if you have more questions. We'll respond as soon as we can.

I'm having this same issue.  Was a way to resolve determined?  Thanks! 

Hi there, mrsjzed. Thanks for becoming part of the Community.
 

I'd be delighted to help check for updates about the investigation ticket AlexV had referenced. Our Product Investigations Team transferred it to a new case number, INV-52078. They've additionally posted an update.
 

After researching the issues with subscribers reporting that zero balances were displaying on their Excel reports, our team identified that the values are present on exported spreadsheets. If you're using Office 365, they recommend updating your Protected View settings. This can be accomplished by following the process outlined in Microsoft's What is Protected View? article.
 

If you continue encountering a zero balance on reports after updating your preferences, you'll want to get in touch with our Customer Care Team and reference the main case. They'll be able to pull up your account in a secure environment and conduct further research. Detailed steps for reaching them can be found in my colleague's post above.
 

I'll be here to help if there's any additional questions. Have a lovely day!

This worked.  Thank you! 

My reports from QBO won't export with any numbers either - I am running on Excel 2016 and can't seem to get anything but -0- instead of amounts.

This isn't the kind of experience we want you to have when exporting reports from QuickBooks Online (QBO), @HeatherVela1. That's why I'm here to ensure you're able to export the amounts on your reports and manage your company data accordingly.

When you export reports from QBO to Excel, it's recommended to use 64-bit versions of Windows. This way, you can have more resources such as processing power and memory. You can check and update your info by selecting the File tab from the Excel ribbon. Then, choose the Account option and click About Excel. Please see the screenshot below for your reference.

In case the issue persists, you can perform any of the following workarounds:

• Copy the broken report to a new workbook
• Create a new Google Chrome user
• Use alternate browser (i.e., Mozilla Firefox)

Also, financial reports in QBO give you great info about your business. You're able to customize them and focus on the details that matter the most. Then, save its current customization settings to have the same filters when pulling them up again. If you wish to learn more about this, you can check out this article: Memorize reports in QuickBooks Online.

Let me know how it goes in the comments below. If  you have other concerns about exporting reports from QBO, I'm just around to help. Take care always.

It's 2023, and I'm still having this problem. Did it never get fixed?

We appreciate you joining the thread. We'll provide important information to help you get through and export reports with corresponding balances.

Before anything else, please be aware that the recommended system binary digit when exporting reports is 64-bit. It will allow you to collect a ton of data as it has the processing power needed. We'll input the steps to help you check your current setup:

1. Access an Excel file.
2. Click the File tab from the Excel ribbon.
3. Choose the Account option, and click About Excel.

If you're using Office 365, you'll want to review and edit the Protected View settings. With this, you can read a file, and see its content and edit it while reducing the risks of catching viruses, and other potentially harmful malware. See this page for more information: What is Protected View?

In addition, you can visit these articles to help you customize a report, and keep your current settings for future use inside the program:

• Customize reports in QuickBooks Online.
• Memorize reports in QuickBooks Online.

Feel free to inform us on how it goes. We'll be here, ready to help you with managing business reports inside QuickBooks. Keep safe.