Why is it When I try to export the profit and loss report to excel, all I get is 0s and not the actual numbers?

Let's ensure that we have enabled the option to edit the report, terry@edgexdc.co.

When exporting reports to Excel, it will give you the file in a protected view. You can check this guide for more information: What is Protected View?.

To get the correct values in your financial statement, we'll need to click the Enable Editing button in the upper part of the Excel file. 

I've also share these articles for additional reference: 

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

Don't hesitate to tag my name if you have other concerns. Keep safe!