How to Set Up Automatic Backups for QuickBooks and MYOB Data to an External Drive to Prevent Financial Loss
Summary
This guide helps you troubleshoot and resolve: How to Set Up Automatic Backups for QuickBooks and MYOB Data to an External Drive to Prevent Financial Loss. Follow the steps below to fix the issue.
Common Causes
How to Set Up Automatic Backups for QuickBooks and MYOB Data to an External Drive
Protecting your financial records is critical for any Australian small business. QuickBooks Desktop and MYOB AccountRight store essential data such as invoices, payroll, and tax information. Setting up automatic backups to an external drive ensures you can recover your financial data quickly in the event of hardware failure, accidental deletion, or cybersecurity incidents.
Before You Begin
- Connect a reliable external USB drive to your computer.
- Ensure the drive has sufficient free space for your accounting files and multiple backup versions.
- Close QuickBooks or MYOB before starting if the software prompts you to do so.
- Note the location of your company file. QuickBooks company files typically use the
.qbwextension, while backup files use.qbb. MYOB AccountRight company files use.myo.
QuickBooks Desktop Automatic Backups
Schedule Automatic Backups
- Open QuickBooks Desktop and open your company file.
- From the top menu, select File, then hover over Back Up Company.
- Select Create Local Backup.
- In the Save Copy or Backup window, choose Local Backup and click Options.
- Click Browse and select your external drive as the backup destination.
- Check the box Remind me to back up when I close my company file or Automatically back up when closing, depending on your QuickBooks version.
- Set the number of backup copies to retain.
- Click OK, then click Next and choose Save it now and schedule future backups.
- Follow the prompts to set a backup schedule (for example, daily or weekly).
- Enter your Windows administrator credentials if prompted to confirm the scheduled task.
- Click Finish.
Verify the Backup Location
- Open File Explorer (
Win + E). - Navigate to your external drive.
- Confirm the QuickBooks backup folder exists and contains recent
.qbbfiles.
MYOB AccountRight Backups
Automatic Backup Workaround Using Windows Task Scheduler
Because MYOB AccountRight lacks a built-in automatic local backup scheduler, you can use Windows Task Scheduler to remind you to perform the backup or to launch a third-party backup utility that monitors your company file folder.
- Press
Win + R, typetaskschd.msc, and pressEnter. - In the right-hand Actions pane, click Create Basic Task.
- Enter a name such as MYOB Financial Backup Reminder and click Next.
- Select a trigger (for example, Weekly) and set your preferred day and time. Click Next.
- Select Start a program as the action and click Next.
- Browse to your preferred backup software or select a script that copies your
.myofiles to your external drive. - Click Finish to save the task.
Manual Backup Steps for MYOB AccountRight
- Open MYOB AccountRight and open your company file.
- Go to the File menu and select Backup.
- Choose Back up company file.
- Select your external drive as the destination.
- Save the backup file.
Important: Do not attempt to back up your company file while it is open in multi-user mode, as this can cause backup failures or data corruption.
MYOB Essentials Cloud Backup Verification
MYOB Essentials is a cloud-based product and does not support local backups to an external drive. Your data is stored on MYOB's secure cloud servers. To ensure your data is protected:
- Log in to your MYOB Essentials account regularly.
- Review your account settings to confirm that cloud backups are active.
- Export critical reports (such as profit and loss, balance sheet, and GST reports) to your local computer or external drive on a regular basis as an additional safeguard.
- Contact MYOB support if you need to restore data from a cloud backup.
Verify and Test Your Backups
Automatic backups are only useful if they actually work. Test your setup at least once per quarter:
- Copy a backup file from your external drive to a test computer or a separate folder.
- Open QuickBooks or MYOB and restore the file using the software's restore function.
- Confirm that recent transactions and data are present.
Troubleshooting
External Drive Not Detected
- Disconnect and reconnect the USB cable.
- Try a different USB port on your computer.
- Open Disk Management (
Win + X, then select Disk Management) to see if the drive appears but lacks a drive letter. - Restart your computer and check File Explorer again.
Scheduled Task Failures
- Ensure you entered your Windows administrator credentials when setting up the QuickBooks scheduled backup.
- Open Task Scheduler and check the task history for error codes.
- Verify that the external drive is connected at the time the scheduled task is set to run.
- Ensure the user account running the task has permission to write to the external drive.
Backup Fails When Company File Is Open
- Close the company file in QuickBooks or MYOB before running a backup.
- If you operate in multi-user mode, ensure all users have logged out of the company file before the scheduled backup begins.
- Check that no other application has the company file open.
Insufficient Drive Space
- Open File Explorer and check the free space on your external drive.
- Delete older backup versions if you no longer need them.
- Reduce the number of backup copies QuickBooks is set to retain.
- Connect a larger external drive if your financial data has grown significantly.
Encryption Guidance
If your external drive contains sensitive financial or payroll data, you should encrypt it to protect against theft or loss.
Enable BitLocker on Your External Drive
- Connect the external drive to your Windows PC.
- Open File Explorer (
Win + E). - Right-click the external drive and select Turn on BitLocker.
- Choose Use a password to unlock the drive and enter a strong password.
- Save your recovery key to your Microsoft account or print it and store it securely.
- Click Next and choose Encrypt used disk space only for a new drive, or Encrypt entire drive for a drive already in use.
- Click Start encrypting and wait for the process to complete.
Maintenance Best Practices
- Rotate external drives periodically and keep one offsite for disaster recovery.
- Label drives clearly with dates and contents.
- Check backup logs in QuickBooks or MYOB regularly for errors.
- Ensure your external drive is encrypted if it contains sensitive financial or payroll data.
- If you use cloud accounting versions of QuickBooks Online or MYOB Essentials, confirm your cloud backup settings in addition to local external drive backups.
For more guidance on protecting your data, see How to back up files to an external drive.
If you need assistance configuring backups or restoring your accounting data, Open a Ticket with 220 Internet Services support.
Still Having Issues?
💻 Open a Ticket