Trial Balance report, exported to excel is all ZEROS. Why?

Hi there, @ljonesver.

I'll help you view your exported Trial Balance report in Excel. Upon checking, I've got the same error as you. Don't worry, I've already found a solution to fix the problem. 

Once you export your files, they will be downloaded from the internet onto your computer. When you open it in Microsoft Excel, the software uses a Protected View feature to safeguard your data. This is why all numbers in the report are showing zero. 

To fix the issue, simply click the Enable Editing section which is highlighted in the Excel window. This will enable you to view and edit the information on the report. 

I've also added here a link that you can check out about exporting reports in QuickBooks Online: Export reports, lists, and more.

Please let me know if you need further assistance in viewing your reports in Excel. Just add a reply so I can assist you with your task. Have a good one. 

Hi @ljonesver,

Hope you’re doing great. I wanted to see how everything is going about the Trial Balance report concern you had the other week. Was it resolved?

Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

Looking forward to your reply. Have a pleasant day ahead!

It worked, thanks RaymondO!

Hi ljonesver!

I'm glad to know that ReymondO was able to help you! Keep on posting if you have any other concerns. Take care and have a good one!

GOOD MORNING,

I HAVE A CHALLENGE, ONCE MY DATA IS BEING EXPORTED FROM QB TO EXCELL BY BALANCE SHEET BALANCE BECOME UNEQUAL, BUT WHILE IN PDF OR IN QB EVERY THING IS FINE, JUST THE EXCELL EXPORTED COPY HAVE THE IN BALANCE PROBLEM.

Please kindly help

Hi there, GEPIES. I appreciate the details you shared about your issue when exporting from QuickBooks. Let me point you to the right direction on how to address this.

Since exporting your data from QuickBooks Online (QBO) to PDF is functioning properly, the issue is isolated to Excel. I suggest checking your Microsoft Office if it's updated. If you're not sure how to update it, feel free to reach out to your IT support or contact Microsoft Office support directly for help.

Furthermore, you can check this article if you want to focus on specific details in your financial reports: Common custom reports in QuickBooks Online.

If you have any more questions or need further assistance with exporting reports, don't hesitate to reach out. I'm here to help make sure everything runs smoothly for you.