02Home & Garden · Updated
How to Backup QuickBooks: Full Guide
Short answer
How to Backup QuickBooks: Full Guide
Backing up your QuickBooks company file protects your financial data from hardware failures, accidental deletions, and corruption. This guide walks you through creating a manual backup, setting up automatic backups, and verifying your backup is usable. Before you start, make sure you have a destination for the backup—either an external drive, a network folder, or a cloud storage service—and that you know your QuickBooks admin username and password.
What You’ll Need
- A QuickBooks Desktop or QuickBooks Online account with admin access
- A storage location: external hard drive, USB drive, network folder, or cloud service (like Dropbox, Google Drive, or OneDrive)
- For QuickBooks Desktop: the company file (.qbw) and the accountant’s copy if applicable
- For QuickBooks Online: no special tools needed—backups are automatic, but you can export a backup copy
Step-by-Step
- Close all company files and windows. In QuickBooks Desktop, go to File > Close Company/Log Off. In QuickBooks Online, you don’t need to close anything—just ensure you’re signed in.
- Open the backup wizard. In QuickBooks Desktop, go to File > Backup Company > Create Local Backup. In QuickBooks Online, go to Settings (gear icon) > Tools > Export Company File to QuickBooks Desktop. Choose the option to create a backup.
- Choose the backup location. For local backup, select “Local backup” and click Options to choose where to save. For online, select “Online backup” if you have the service, or choose a local/cloud folder manually.
- Set backup options. In the Options window, you can choose to verify the backup integrity, limit the number of backups, and schedule automatic backups. For local backups, you can also select “Add the date and time to the backup file name” to keep multiple versions.
- Start the backup. Click OK and then Next. If prompted, enter your admin password. QuickBooks will create a .QBB file (for backups) or a .QBW file (for portable copies). Wait for the process to finish—it may take a few minutes.
- Verify the backup. After the backup completes, QuickBooks will ask if you want to verify the backup. Always choose Yes. This tests the file to ensure it’s not corrupt.
- For QuickBooks Online, export a backup. If you want a local copy of your online data, go to Settings > Tools > Export Company File to QuickBooks Desktop. Choose “Backup” and follow the prompts. This creates a .QBB file you can store anywhere.
- Store the backup securely. If you backed up locally, copy the .QBB file to a second location (e.g., an external drive and cloud storage). For online backups, ensure you have the cloud service credentials saved.
- Test restoring a backup. Periodically, open the backup file in a test environment to ensure it works. This confirms your backup is valid.
Common Mistakes
- Saving the backup on the same drive as the original file. If the drive fails, you lose both. Always use a separate physical drive or cloud.
- Not verifying the backup. Skipping verification can leave you with a corrupt file that won’t restore.
- Forgetting to close the company file. QuickBooks Desktop won’t back up if the file is in use by another user.
- Using a portable file instead of a backup. A portable file (.QBM) is compressed but not a true backup—it doesn’t include all settings and transactions.
- Ignoring automatic backup schedules. Manual backups are easy to forget. Set up automatic backups to run daily or weekly.
Tips
- Use the “Verify” option every time. It takes a few extra seconds but can save you from discovering a bad backup later.
- Keep multiple backup versions. QuickBooks lets you keep up to 99 backups. Retain at least the last three so you can restore to an earlier point if needed.
- Store backups offsite. Use cloud storage or a safe deposit box for critical backups. This protects against fire, theft, or natural disasters.
- Schedule automatic backups. In QuickBooks Desktop, go to File > Backup Company > Create Local Backup > Options > Schedule Backup. Choose a time when no one is using the file.
- Consider QuickBooks Online Auto Backup. If you use QuickBooks Online, the service automatically backs up your data, but you can still export a local copy periodically.
Troubleshooting
- Backup fails with an error message. Common errors include “The backup could not be created” or “The file is in use.” First, ensure all users are logged out. Then try running the backup as the admin. If the error persists, use the QuickBooks File Doctor tool (available from Intuit) to repair the company file.
- Backup is too large. QuickBooks has a file size limit of 2GB for backups. If your file exceeds this, condense the company file (File > Utilities > Condense Data) to remove old transactions, then back up again.
- Cannot find the backup file. Check the default backup location (usually C:\Users\[YourName]\Documents\Intuit\QuickBooks\Company Files). If you chose a custom location, search for the .QBB file.
- Restore fails. If restoring a backup gives an error, try restoring a different backup version. If none work, the backup file may be corrupt—you’ll need to use your last known good backup or contact Intuit support.
- QuickBooks Online export fails. Ensure you have a stable internet connection and sufficient disk space. If the export is too large, try exporting during off-peak hours.
Frequently Asked Questions
How often should I back up QuickBooks?
At least once a day if you use it daily, or weekly for occasional use. Automatic backups are best to ensure consistency.
What’s the difference between a backup and a portable file?
A backup (.QBB) is a complete snapshot of your company file, including all transactions and settings. A portable file (.QBM) is compressed and smaller but may not include all data, and it’s meant for transferring between computers, not for backup.
Can I back up QuickBooks to a USB drive?
Yes, you can back up to any writable drive, including USB. Just make sure the drive has enough space and is reliable.
Does QuickBooks Online automatically back up my data?
Yes, QuickBooks Online automatically backs up your data to Intuit’s servers. However, you can also export a backup file for your own records.
How do I restore a backup?
In QuickBooks Desktop, go to File > Open or Restore Company > Restore a backup copy. Then select the .QBB file and follow the prompts. In QuickBooks Online, you can import a backup file by going to Settings > Tools > Import.
Why is my backup file so large?
Large backups are often due to many transactions, attachments, or a long history. You can condense data to reduce file size, but keep in mind this removes old transactions.
Related
- How Long Do Life Alert Batteries Last?
- How to Store an EpiPen: Temperature, Light & Expiry
- How to Plant Zoysia Seed: Step-by-Step Guide
Further reading: Intuit QuickBooks Support. Details can change, so check the official page for anything that matters to you. Spotted a mistake? Tell us. How we write an answer.