cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Unlock the full power of QuickBooks with our Training Classes - Discover more
info-cornwallhea
Level 1

I am trying to export a report to excel but i am just getting zeros in excel spreadsheet and not actual numbers from the report

 
1 REPLY 1
Nicole_N
QuickBooks Team

I am trying to export a report to excel but i am just getting zeros in excel spreadsheet and not actual numbers from the report

Hi. I appreciate you taking the time to post your concern here.

 

Let me share a few things about exporting reports to Excel in QuickBooks Online (QBO).

 

When you export a report to Excel, you'll notice that the report shows zero amount in the spreadsheet cell. This simply means that the file is in protected view. To make the actual amounts appear and view the full report, you need to Enable Editing. See the screenshots below for reference.

 

The option to edit is disabled:
 

 

The option to edit is enabled:
 

 

I'm adding this helpful article to learn how to get the most out of your financial reports: Customise reports in QuickBooks Online.


Let me know in the comments below if you have additional questions or concerns about exporting reports in QuickBooks. I'd be glad to assist. Keep safe, and have a nice day.

Need to get in touch?

Contact us