When running Profit and Loss Report and attempting to export to excel, the downloaded file just shows zeroes, how do I fix this?

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

I want to ensure that your Profit and Loss report will be exported to Excel with no issues.

When exporting reports in QuickBooks Online make sure that you're using the 64-bit version of Excel. This can help you open the exported reports smoothly.

If the same thing happens, I'd recommend accessing your account on a private window. It isolates the cache, which is the common cause of unusual behaviors in browsers. 

Here's how to open a private window:

• 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. 

If the issues persists, I suggest contacting our Customer Care Team. They have the tools to check on 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. Select 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.

In addition, you can always check these links attached to guide you in exporting reports in QuickBooks Online:

• Export Your Reports To Excel From QuickBooks Online
• Common Custom Reports In QuickBooks Online

If you need anything else with reports or with QuickBooks, let me know so I can help. Have a lovely day!

I am having the same problem. The report shows actual data and teh PDF version also shows numbers when I run P&L report but when I export it to excel it shows all the fields with zeros in it.

I have tried the in private mode window on my browser and I am using the lates version of office365 excel.

Please help.

Thanks

I appreciate you following up on this thread, nasar.

It's good you've performed some troubleshooting steps beforehand. Let me help further and get this sorted out.

To ensure we can export the Profit and Loss report into Excel, you might want to update the Office 365 Protected View settings. This can be done by following the outlined steps in Microsoft's What is Protected View? article. I'd recommend visiting their page and being guided from there.

If you continue encountering a zero balance on reports after updating the protected view settings, you'll want to get in touch with our Customer Care Team to have this investigated.

Please be reminded that our Support Team is available from 6:00 AM until 6:00 PM on weekdays, and 6:00 AM till 3:00 PM PT on Saturdays. Here's how to contact us:

1. Click the Help (?) icon.

2. Choose Contact Us.

3. Enter a brief description of your situation in the What can we help you with? area, then click Let's talk.

4. You'll be presented with a few options for connecting with Intuit. Select Get a call.

I'll be sharing with you the following links. These will provide us with steps on how to customize a report as well as save its customization for future use. On the same write-up, we can find details on what other reports we can export into Excel:

Customize reports in QuickBooks Online.

Export reports, lists, and other data from QuickBooks Online.

Let me know if there's else you need aside from exporting reports in QuickBooks Online, nasar. I'll be around to keep helping.

Sharing in case anyone can benefit from my experience. We used to manually export reports to Excel and, as reporting and data analysis became more prominent in the company, we decided to automate this process. Since we don’t have an Advanced license, we couldn’t leverage the built-in spreadsheet sync by QBO and ended up using a 3rd party solution to help automate reports extraction to Excel and G-sheets, including P&L. While there are a few on the market, we really liked what Coupler.io has to offer and stuck with it. Hope this helps.