cancel
Showing results for 
Search instead for 
Did you mean: 
TomG92
Level 2

I exported a custom report to Excel but it is all zeros. It does not bring numbers. The same report exported to PDF perfectly.

In Excel, the format of the report matches the report online. All the categories and classes are there, and the format is the same, it's just that instead of my values, there are zeros.
Solved
Best answer February 15, 2024

Best Answers
ChristineJoieR
QuickBooks Team

I exported a custom report to Excel but it is all zeros. It does not bring numbers. The same report exported to PDF perfectly.

Hello there, TomG92. I'll help you how you can fix this exporting challenge in QuickBooks Online.

 

To ensure the accurate values appear in your financial statement, simply click the "Enable Editing" button located at the top of the Excel file.

 

When you export reports to Excel, the file will be presented in a protected view. Here's an article from Microsoft that provides further information on this topic: What is Protected View?

 

If the issue persists, you can perform the basic troubleshooting steps provided here: Troubleshooting browser problems.

 

I'd also like to share these articles for additional reference: 

 

 

Don't hesitate to reach out to us again if you need anything else. 

View solution in original post

3 Comments 3
ChristineJoieR
QuickBooks Team

I exported a custom report to Excel but it is all zeros. It does not bring numbers. The same report exported to PDF perfectly.

Hello there, TomG92. I'll help you how you can fix this exporting challenge in QuickBooks Online.

 

To ensure the accurate values appear in your financial statement, simply click the "Enable Editing" button located at the top of the Excel file.

 

When you export reports to Excel, the file will be presented in a protected view. Here's an article from Microsoft that provides further information on this topic: What is Protected View?

 

If the issue persists, you can perform the basic troubleshooting steps provided here: Troubleshooting browser problems.

 

I'd also like to share these articles for additional reference: 

 

 

Don't hesitate to reach out to us again if you need anything else. 

TomG92
Level 2

I exported a custom report to Excel but it is all zeros. It does not bring numbers. The same report exported to PDF perfectly.

Thanks, Christine. That was exactly what I needed to do. I appreciate your help!

Tom G

Tori B
QuickBooks Team

I exported a custom report to Excel but it is all zeros. It does not bring numbers. The same report exported to PDF perfectly.

On behalf of my colleague, you're certainly welcome, @TomG92.

 

Please feel free to reach out any time you need a helping hand. We've got you covered. Take care! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us