How to Set Up Automated Backups for Your Brisbane Accounting Software to an Encrypted External Drive
Summary
This guide helps you troubleshoot and resolve: How to Set Up Automated Backups for Your Brisbane Accounting Software to an Encrypted External Drive. Follow the steps below to fix the issue.
Common Causes
Losing financial records can be devastating for a Brisbane small business. This guide walks you through setting up automated, encrypted backups of your accounting software data to an external drive, ensuring your books are protected against hardware failure, theft, or accidental deletion.
Before You Start
You will need an external hard drive or SSD with enough capacity to hold several months of accounting data. The drive should be blank or contain no critical data, as the encryption process will erase existing contents. This guide covers common Australian accounting packages including MYOB, QuickBooks, and Xero.
Quick Fix Steps
- Connect a blank external drive to your computer and encrypt it.
- Close your accounting software to prevent locked database files.
- Identify the folder where your accounting software stores its data files.
- Configure third-party backup software to schedule automatic copies of that folder to the encrypted drive.
- Verify the first backup completes successfully and test a restore.
Detailed Instructions
Step 1: Encrypt Your External Drive
Connect your blank external drive. Encrypt the drive before copying any data to it:
- Windows: Open File Explorer, right-click the external drive, and select Turn on BitLocker. Follow the prompts to set a password and save your recovery key to your Microsoft account or a printed copy.
- macOS: Open Disk Utility from Applications > Utilities. Select the external drive, click Erase, choose APFS (Encrypted) from the format menu, and enter a password.
Do not lose your encryption password or recovery key. Without it, you cannot access your backups. Store the recovery key in a secure password manager or a printed copy kept offsite.
Step 2: Locate Your Accounting Data
Most accounting software stores data in a specific folder. Close your accounting software before locating or copying these files to avoid locked database errors.
- MYOB: Data files are typically stored in
C:\Users\[YourName]\Documents\MYOBor a custom folder selected during installation. Check File > Open within MYOB to confirm the current data file path. - QuickBooks Desktop: Company files (.QBW) are often located in
C:\Users\[YourName]\Documents\Intuit\QuickBooks\Company Files. Open QuickBooks, press F2 to view the Product Information window, and note the file location. - Xero: Xero is cloud-based, but if you use Xero Practice Manager or local export files, check
C:\Users\[YourName]\Documents\Xeroor your chosen export folder.
If you are unsure, open your accounting software and check Settings or Preferences > Data Location to confirm the exact path.
Step 3: Schedule Automated Backups
Windows and macOS do not include simple built-in tools for scheduling backups of a single folder to an external drive. We recommend using third-party backup software.
On Windows: Macrium Reflect Free
- Download and install Macrium Reflect Free.
- Open Macrium Reflect and select Backup > Create an Image of the partitions required to back up and restore Windows, or choose File and Folder Backup for specific data.
- Click Add Folder and browse to your accounting data folder (for example, the MYOB or QuickBooks company file folder).
- Set the destination to your encrypted external drive.
- Click Schedule, choose Weekly, and set a time when the computer is on but accounting software is closed.
- Click Finish and save the backup definition file.
On macOS: Carbon Copy Cloner
- Download and install Carbon Copy Cloner.
- Open Carbon Copy Cloner and click New Task.
- Set the Source to your accounting data folder.
- Set the Destination to your encrypted external drive.
- Click the Scheduler button and choose Weekly. Select a day and time when your Mac is awake and accounting software is closed.
- Click OK and then click Clone to run the first backup immediately.
Backup Strategy: 3-2-1 Rule and Offsite Rotation
Follow the 3-2-1 backup principle: keep at least three copies of your data, on two different media types, with one copy offsite. Because your external drive is kept onsite, it is vulnerable to theft, fire, or flood.
We recommend rotating two encrypted external drives weekly:
- Keep Drive A connected for weekly automated backups.
- Swap Drive A with Drive B every Friday and take Drive A offsite (for example, to a director's home or a secure storage facility in Brisbane).
- Bring Drive A back the following week and swap again.
This ensures you always have a recent offsite copy of your financial records.
Retention and Versioning
Configure your backup software to keep at least three months of weekly backups. This protects against ransomware or corrupted files that may not be noticed immediately. If your software supports versioning, retain daily versions for the current month and weekly versions for the previous three months.
Verify Your Backup and Test Restores
- Wait for the first scheduled backup to finish.
- Open your external drive and confirm the accounting data folder is present.
- Copy a sample file from the backup to your desktop and open it with your accounting software to ensure it is not corrupted.
- Check the backup log for any errors.
- Once per month, perform a test restore by copying a backup file back to its original location and opening it in your accounting software.
Troubleshooting
Backup Fails Because Files Are Locked
- Close your accounting software completely before the scheduled backup window. MYOB, QuickBooks, and Xero local files lock when the application is running, which prevents backup software from copying them.
- If using QuickBooks, use the File > Backup Company option to create a local backup file first, then back up that file to your external drive.
Insufficient Permissions
- On Windows, run your backup software as an administrator.
- Ensure your user account has full control permissions for the accounting data folder. Right-click the folder, select Properties > Security, and verify your account is listed.
- On macOS, check System Settings > Privacy & Security > Full Disk Access and ensure your backup software is permitted.
Encrypted Drive Unlock Failures
- Ensure you are entering the correct encryption password.
- On Windows, if BitLocker locks the drive, use your recovery key to unlock it.
- If the drive is physically damaged or the encryption header is corrupted, the data is unrecoverable without the recovery key. Replace the drive and reconfigure encryption.
Drive Not Recognised
- Try a different USB port or cable.
- On Windows, open Disk Management to see if the drive needs a drive letter assigned.
- On macOS, open Disk Utility to verify the drive mounts correctly.
For ongoing backup monitoring or assistance with data recovery, Open a Ticket with our Brisbane support team.
Still Having Issues?
💻 Open a Ticket