I tried exporting data from QBO as a backup, but some of the resulting Excel files such as the balance sheet and P

Hi there, @NotAnAccountantHere. 

There are a few ways to get your data out of QuickBooks. Many reports and forms, lists, and reports have a download button. You can save copies of these onto your computer's hard drive.

If you need to export more data, you have a few options.

• Looking to export data for anything including audit purposes to sharing it out to stakeholders? We have a new streamlined feature to simply download some of the most needed lists and reports to make this even easier.
• Looking for a continuous backup of your data? There are apps in the QuickBooks App store that provide this continuous backup.

Just in case you want to save a report or list, you can open this article for the steps: Export reports, lists, and more.

You can also look for a backup application that has similar features in the App Center. Go to https://apps.intuit.com/app/apps/home or click the Apps tab located in the left navigation menu.

Should you have other questions or concerns, please let us know. Have a good day!