cancel
Showing results for 
Search instead for 
Did you mean: 
director21
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

just trying to export to excel. File I get is all zeroes.
18 Comments 18
Ryan_M
Moderator

I get all zeroes when I export reports ?? Just started happening yestereday.

Hi @director21,

 

Let's get your exports from reports to work without any issues.

 

Whenever a web-based application acts unexpectedly, I suggest you open your browser's private window. It isolates the cache, which is the common cause of unusual behaviors in browsers. 

 

  • Google Chrome: Ctrl + Shift + N
  • Microsoft Edge: Ctrl + Shift + P
  • Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N

If that works, go back to your regular browser and clear its cache. Otherwise, open an alternative browser that's available for you. 

 

In case you encounter any other software-related issues, refer to this article: Troubleshooting browser problems. It has a list of troubleshooting steps that are specific to each compatible browser with QuickBooks Online (QBO).

 

Tag me in the comments below if you have further questions about the export process in QBO. I'll get back to you as soon as I can. 

Juanita
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

I am experiencing the same issue. Did you get a resolution? 

BettyJaneB
QuickBooks Team

I get all zeroes when I export reports ?? Just started happening yestereday.

I'm happy to see you here in the Community, @Juanita.

 

I'd like to ensure that this exporting of reports concern gets address so you can have the amount to display accurately in Excel.

 

If you've tried the troubleshooting steps presented by Ryan_M above and the issues persist, I recommend contacting our Customer Care Team. They have the tools to isolate this matter and help identify its root cause. This way, they can apply a resolution.

 

Here's how you can reach them: 

  1. Click on Help at the top menu bar.
  2. Hit on the Contact Us button.
  3. Enter a brief description of the issue in the What can we help you with? box.
  4. Press on Let's talk.
  5. Select on Get a callback.
  6. Key in your contact details, then tap on Confirm my call.

contact us1.PNGContact us2.PNG

 

Please keep me posted on how the conversation goes by leaving a reply below. I'll be around to assist you if you need more help. Have a lovely day!

bbstone56
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

Still broken.

sberti
Moderator

I get all zeroes when I export reports ?? Just started happening yestereday.

Hello @bbstone56, thank you for keeping us up to date on the issues that you and others have been having.

 

Just for confirmation, were you able to go through the troubleshooting steps that my colleagues mentioned above?

 

If the troubleshooting steps left you in the same position that you were in, please reach out to Customer Care.

They will have the tools to look into the issue to identify the cause, that way they can work with the development team to come to a resolution.

 

If you have any other questions please feel free to reach back out so that I may assist you!

sberti
Moderator

I get all zeroes when I export reports ?? Just started happening yestereday.

Hello again, @bbstone56!

 

I wanted to update you with some information regarding the report being all zeros.

We were able to look into this issue and we were able to reproduce the same issue.

 

So thank you, again for letting me know about this issue!

 

The resolutions that we have come up with;

  1. Use a 64-bit version of excel
  2. Copy the broken report to a new workbook in excel
  3. You can also create a new Google Chrome User
  4. The last option would be to use an alternate browser to the one you are currently using

Please try any of those options and let me know which one worked best for you.

 

If you need anything else let me know so I can help!

Captain777
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

You need to click 'Enable Editing' when you open the file in Excel 365. 

I saw zeros when I 'previewed' the file. I also saw zeros when I opened the file in 'protected mode' in excel. 

Once I clicked on the 'Enable Editing' box in the yellow 'Protected View' Bar at the top...all the numbers showed up. 

Adrian_A
Moderator

I get all zeroes when I export reports ?? Just started happening yestereday.

Hi there, Captain777.

 

Have you tried the solutions shared by my colleague, sberti? I'd suggest giving it a try. However, if none of those workarounds work on your end, I recommend reaching out to our Phone Support team.

 

One of our agents can pull up your account and verify what causes the zeroes on the report. Here's how:

 

  1. Click the ? Help icon.
  2. Enter Talk to a human.
  3. Select Contact a human.
  4. Click Live Chat / Call me back.

 

Also, if you want to customize the data on the report, you can check this reference: Customize reports in QuickBooks Online.

 

I'll be around if there's anything that I can help. Keep safe!

SquareTriangle
Level 2

I get all zeroes when I export reports ?? Just started happening yestereday.

Thank you @Captain777 ! This worked for me too. Could this be posted at the top of the thread as the solution? Thanks!

JenoP
Moderator

I get all zeroes when I export reports ?? Just started happening yestereday.

Glad it worked for you, SquareTriangle!

 

You can click the Accepted Solution button. This will tag the answer as "Solved" and will be shown as the first answer at the top of the thread. 

 

Check out these additional articles for more reference:

 

 

Please don't hesitate to reach out to us again if you need more help with QuickBooks. We're always here to help. 

AMAcpaPC
Level 2

I get all zeroes when I export reports ?? Just started happening yestereday.

I experienced the same issue and searched for this error. While trying to follow one of the troubleshoot step, after I opened the Excel with all Zero data, I clicked 'Enable Editing' and the amounts appeared

mikenextlevel
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

This issue is NOT resolved. The issue is that the preview of an Excel attachment in Outlook shows all dollar amounts as zeros ($0). This must be an intentional privacy feature setting implemented by QuickBooks because only the dollar values are zero but the other info (ex. financial account names) are viewable in the Outlook preview. It would be great to preview these Excel files within Outlook without having to open each file in the Excel desktop application.

 

Please pass this along to your developer team. Thanks!

Angelyn_T
QuickBooks Team

I get all zeroes when I export reports ?? Just started happening yestereday.

Hi, @mikenextlevel.

 

It's my priority to help you with exporting your reports from QuickBooks Online (QBO). At this time, you'll be able to view the dollar amounts by opening the file through Excel. I understand your point about being able to the Excel files within Outlook without opening the Excel application. I'll be taking note of your request and pass them along to our product developers. Rest assured they're working nonstop to enhance the product and developer the best experiences for all QuickBooks users.

 

You can also send your feedback through your QuickBooks account. Here's how:

 

  1. Open your QBO account.
  2. Go to the Gear icon, then click on Feedback.
  3. Enter your comments or product suggestions. Then select Next to submit feedback.

 

Your valuable feedback goes to our Product Development team to help improve your experience in QBO. You can track feature requests through the QuickBooks Online Feature Requests website.

 

While waiting for the updates, you can visit our blog to stay current with the latest QuickBooks news and feature enhancements. Here's the link: The QuickBooks Blog.

 

On the other hand, here's how you can learn more about handling reports in QBO:

 

 

Aside from your reports, you can also download your lists and other data to Excel. You can open this article as your guide: Export reports, lists, and other data from QuickBooks Online.

 

If you have any other follow-up questions about exporting your reports, let me know by adding a comment below. I'm more than happy to help. Have a good one!

Glen77
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

Enabling "Edit" worked for me as well. I am using Excel 2010.  Thank you.

megtay
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

I am getting this issue in MS Excel 365.  I tried clearing my cache and it didn't help.  I don't have an "Enable Editing" option at the top of my Excel file when I open it, so I can't use that to correct the issue.  

 

The numbers are there, and if I double click in each cell, they will show up.  However, for reports with lots of cells of information, that is not useful.  I have found that if I insert a column at the beginning or in the middle of the data, then all the numbers appear.  

 

This is not how these reports are supposed to function.  The original post was from two years ago.  Is there a long-term fix for this?  

 

SarahannC
Moderator

I get all zeroes when I export reports ?? Just started happening yestereday.

Hello,@megtay. Appreciate you for trying to troubleshoot the MS Excel 365 performance. 

 

You can correct the data from Excel by enabling editing in your document. Here's how:

 

  1. Go to FileInfo.
  2. Select Protect document.
  3. Click Enable Editing.

 

I'd recommend reaching out to MS Excel 365 Support Team for further assistance.

 

Then, I'd still suggest giving us a short call since this has been happening on your end. We'll need to look into this matter and investigate the root cause of why the numbers only appear when inserting a column at the beginning/middle of the data. Here's how:

 

  1. Log in to your QBO account and go directly to the Help icon.
  2. Click the Contact us button and enter a short description of your concern.

 

If you want to run sales or any reports soon, you can use these articles to manage them well:
 

 

Know that you can always tap me on my shoulder if you ever need anything else with QuickBooks. I'll be around to back you up. Stay safe, megtay.

Oxford_daisy
Level 1

I get all zeroes when I export reports ?? Just started happening yestereday.

I had the same issue but as soon as I clicked "enable editing" the values appeared!

RCV
QuickBooks Team
QuickBooks Team

I get all zeroes when I export reports ?? Just started happening yestereday.

Thanks for checking in with us, Oxford_daisy.

 

We can update your Excel to isolate this. Outdated Excel may have caused exported reports to show incorrect data. Let me guide you on how:

 

  1. Open the Excel file.
  2. Navigate to the File menu.
  3. Select Account.
  4. Click Update Options.
  5. Hit Update Now.

 

However, if you don't see the Update Options, this means you already have the latest version of Excel. In this case, I suggest reaching out to the Microsoft Support team. They'll be able to provide you with some steps on how to troubleshoot your Excel. Then, click the Enable Editing option at the top to see the full content of the report with the correct total.


z.PNGx.PNG

 

 

 

Check out these additional articles for more reference:

 

 

Please don't hesitate to reach out to us again if you need more help with QuickBooks. We're always here to help. You have a good one. 

Need to get in touch?

Contact us