How to back up and restore your QuickBooks, Xero, or MYOB company file to prevent accounting data loss
Summary
This guide helps you troubleshoot and resolve: How to back up and restore your QuickBooks, Xero, or MYOB company file to prevent accounting data loss. Follow the steps below to fix the issue.
Common Causes
Your accounting software company file contains every transaction, invoice, and reconciliation your business relies on. A hardware failure, ransomware attack, accidental deletion, or corrupted file can mean days of lost work and serious financial reporting problems. Setting up a reliable backup routine for QuickBooks, Xero, or MYOB is one of the most important safeguards you can put in place for your business records.
This guide walks you through backing up your company file locally and to the cloud, verifying those backups are working, and restoring them safely when needed.
Before You Begin
Before configuring backups, take a moment to identify what you need to protect:
- QuickBooks Desktop: The company file (
.qbw) and any attached files (.qbbbackup copies). - Xero: Xero is cloud-based, but you can export reports and back up the organisation's data manually or via the API.
- MYOB AccountRight: The company file (
.myob) which can be backed up to a local.ziparchive.
Quick Fix: Enable Built-In Scheduled Backups
All three platforms include a built-in backup scheduler. Enabling it is the fastest way to automate protection.
QuickBooks Desktop
Note: These instructions apply to QuickBooks Desktop only. QuickBooks Online is cloud-managed, and your data cannot be backed up locally as a company file.
- Open QuickBooks Desktop and sign in to your company file as the Admin user.
- Go to File > Back Up Company > Create Local Backup.
- Choose Local Backup and click Next.
- Tick Save backup copy automatically and select how often (we recommend Every time you close the company file or Daily).
- Choose a backup location such as an external drive or a cloud sync folder, then click OK.
MYOB AccountRight
- Open your company file in MYOB AccountRight.
- Go to File > Backup > Schedule Backups.
- Tick Schedule automatic backups and choose a frequency (Daily is recommended).
- Select a destination folder on an external drive or cloud sync folder, then click OK.
Xero
- Sign in to Xero at xero.com.
- Click the Organisation menu, then select Export.
- Choose the reports you want to export (we recommend the full Accounting Reports and Transaction List).
- Download and save the exports to a secure folder on your computer or cloud storage.
Detailed Instructions: Set Up a Reliable Backup Strategy
A single backup is not enough. Follow the 3-2-1 rule: keep three copies of your data, on two different types of media, with one copy offsite.
Step 1: Choose Your Backup Locations
Pick at least two destinations from the list below:
- External USB drive: Affordable and fast. Rotate two drives so one is always stored offsite.
- OneDrive or Google Drive: Built into Windows and macOS. Files sync automatically once placed in the sync folder.
- Backblaze, iDrive, or similar: Continuous cloud backup services designed for small business.
Step 2: Configure Your Primary Backup
Use the built-in scheduler from the Quick Fix section above as your primary backup. Confirm it is running by checking the destination folder after your next scheduled backup window.
Step 3: Add a Cloud Copy
For QuickBooks and MYOB, the simplest approach is to point your backup destination at a folder inside your OneDrive, Google Drive, or Dropbox sync folder. The file will then upload to the cloud automatically.
- Locate your OneDrive or Google Drive folder. On Windows, OneDrive is usually under
C:\Users\YourName\OneDriveand Google Drive is usually underC:\Users\YourName\Google Drive. On macOS, sync folders are typically found in Finder under your user folder. - In your accounting software's backup settings, change the destination to a subfolder such as
OneDrive\Backups\QuickBooksorGoogle Drive\Backups\MYOB. - Run a manual backup to confirm the file appears in the cloud folder.
Step 4: Verify Your Backup
A backup that has never been tested is not really a backup. Verify yours monthly:
- Check that the backup file exists and the file size is reasonable (not 0 KB).
- For QuickBooks Desktop, open the
.qbbfile and use File > Open or Restore Company > Restore a Backup Copy to confirm it opens cleanly. - For MYOB, attempt to open the backup archive in AccountRight using File > Restore to confirm it is valid.
How to Restore Your Company File
When you need to recover data, follow the steps for your software carefully. Always restore to a new file name first so you do not overwrite a recoverable original.
Restoring QuickBooks Desktop
- Open QuickBooks Desktop and go to File > Open or Restore Company.
- Select Restore a Backup Copy and click Next.
- Choose Local Backup and browse to your
.qbbfile. - When prompted, choose Save it now and give the restored file a new name (for example,
MyCompany-Restored-2024.qbw). - Open the restored file and verify your data looks correct before deleting anything.
Restoring MYOB AccountRight
- Copy the backup
.zipfile to a safe location. - Open MYOB AccountRight and go to File > Restore.
- Browse to the backup file and follow the prompts.
- Save the restored company file under a new name and open it to confirm the data is intact.
Restoring Xero
Because Xero is fully cloud-based, there is no company file to restore. If data has been deleted or changed in error:
- Go to Accounting > Advanced and review the History & Notes on affected accounts to see recent changes.
- Use the Audit Trail report (under Reports > All Reports) to identify what was modified and by whom.
- Manually re-enter or reverse the affected transactions.
- For larger recoveries, contact Xero support directly for guidance.
Troubleshooting
Scheduled Backup Fails or Does Not Run
- Confirm the software is actually being closed each day if you chose "Every time you close the company file".
- Check that the destination drive is connected and has enough free space.
- Verify the user account running the software has write permission to the backup folder.
- Ensure the software is not being run in a virtualised environment that suspends scheduled tasks.
Backup File Is 0 KB or Corrupted
- Run a manual backup and watch for any error messages.
- Disable antivirus temporarily and retry, as some security products interfere with backup writes. Add the backup folder as an exclusion in your antivirus settings.
- Check the destination drive for disk errors using Windows Error Checking or macOS Disk Utility.
- Try backing up to a different local folder to rule out a failing drive.
Restore Fails with Error
- Ensure you are restoring a
.qbbor.zipfile, not the live.qbwor.myobcompany file. - Confirm you have enough free disk space for the restored file.
- If restoring from a cloud sync folder, download the file to your local desktop first and restore from there rather than restoring directly from OneDrive or Google Drive.
- Close all other instances of the accounting software before attempting the restore.
Cloud Sync Conflicts
- Avoid opening or editing the company file directly from inside the OneDrive or Google Drive folder, as sync conflicts can corrupt the database.
- Back up to a local folder first, then allow the cloud sync service to upload the backup file separately.
- Check the OneDrive or Google Drive status icon for sync errors and resolve any "File is locked" or "Sync pending" warnings before relying on the cloud copy.
If you are still unable to complete a backup or restore, Open a Ticket and our team will assist you.
Still Having Issues?
💻 Open a Ticket