How to Set Up Automated Backups for Xero Accounting Data to an External Drive for Brisbane Small Businesses
Summary
This guide helps you troubleshoot and resolve: How to Set Up Automated Backups for Xero Accounting Data to an External Drive for Brisbane Small Businesses. Follow the steps below to fix the issue.
Common Causes
How to Manually Export and Schedule Local Copies of Xero Reports for Brisbane Small Businesses
Xero is cloud-based accounting software, but relying solely on cloud storage can leave your Brisbane small business vulnerable during internet outages or accidental data deletion. This guide explains how to manually export Xero reports and schedule your operating system to copy those exported files to an external drive.
Prerequisites
Before beginning, ensure you have the following:
- An active Xero subscription with administrator access.
- A Windows PC or Mac with a stable internet connection.
- An external USB drive with sufficient storage space.
- The external drive formatted to
NTFS(Windows) orAPFS/Mac OS Extended(Mac).
Step 1: Export Your Xero Reports
Because Xero cannot automate exports directly to a local drive, you must first export your reports to a dedicated folder on your computer.
- Log in to your Xero organisation at
https://go.xero.com. - Navigate to the Accounting menu and select Reports.
- Select the financial reports you wish to back up, such as the Profit and Loss or Balance Sheet.
- Set your desired date range and click Update.
- Click the Export button in the top right of the report.
- Select Export to Excel or Export to PDF.
- Save the file to a dedicated folder on your computer, for example:
C:\Users\[YourName]\Documents\Xero Backups.
Step 2: Schedule Automated File Copying (Windows)
To automate moving these exports to your external drive, use the Windows Task Scheduler.
- Press
Windows Key + R, typetaskschd.msc, and pressEnter. - In the Task Scheduler window, click Create Basic Task in the Actions pane.
- Name the task Xero Backup and click Next.
- Select your preferred frequency (e.g., Weekly) and click Next.
- Set the start time and click Next.
- Select Start a program and click Next.
- In the Program/script field, enter:
robocopy - In the Add arguments field, enter your source and destination paths. Example:
"C:\Users\[YourName]\Documents\Xero Backups" "E:\Xero Backups" /E(ReplaceE:with your external drive's letter). - Click Finish to save the task.
Step 3: Schedule Automated File Copying (Mac)
Mac users can use a simple shell script and the cron scheduler to automate copying exported files.
- Open Terminal (found in Applications > Utilities).
- Create a backup script by typing:
nano ~/xero_backup.sh - Enter the following command, replacing
[User]and[DriveName]with your details:rsync -av ~/Documents/Xero\ Backups/ "/Volumes/[DriveName]/Xero Backups/" - Press
Ctrl + O, thenEnterto save, andCtrl + Xto exit. - Make the script executable:
chmod +x ~/xero_backup.sh - Open the crontab editor:
crontab -e - Add a line to run the script weekly (e.g., every Sunday at 2 AM):
0 2 * * 0 /Users/[User]/xero_backup.sh - Save and exit the editor.
Step 4: Verify Your Backups
Automation can fail silently. It is critical to verify that your data is actually reaching the external drive.
- Manually run your scheduled task or script once.
- Open your external drive in File Explorer (Windows) or Finder (Mac).
- Confirm that the most recent Xero export files are present in the backup folder.
- Open one of the files to ensure it is not corrupted.
Step 5: Secure and Manage Your Backup Files
Because Xero exports contain sensitive financial data, take steps to protect your local backups.
- Enable encryption on your external drive (BitLocker on Windows or FileVault on Mac) to protect data if the drive is lost or stolen.
- Consider password-protecting individual Excel or PDF files before backing them up.
- Set a retention policy (for example, keep monthly backups for one year) and manually delete old files to prevent the external drive from filling up.
Alternative: Third-Party Xero Backup Solutions
If you require a more reliable or complete backup of your Xero organisation's data, consider third-party backup solutions designed for Xero. These services can automate cloud-to-cloud backups and may include data not captured by standard report exports, such as detailed transaction history and contacts. Evaluate any third-party provider against your security and compliance requirements before granting access to your Xero organisation.
Troubleshooting
Backup task not running
- Check that the computer is awake and not in sleep mode at the scheduled time.
- Ensure the external drive is plugged in and recognised by the operating system.
- Verify the file paths in your script or task match your current folder structure.
- On Windows, confirm the external drive letter has not changed. If it has, update the Task Scheduler arguments to match the new letter.
- On Mac, ensure Terminal has Full Disk Access in System Settings > Privacy & Security.
Failed or incomplete Xero exports
- Ensure you have administrator access to the Xero organisation.
- Verify your internet connection is stable during the export process.
- Try exporting a different report or a smaller date range to isolate the issue.
- Confirm you are selecting a supported export format (Excel or PDF).
Corrupted or unreadable backup files
- Re-export the affected report directly from Xero and replace the corrupted file.
- Open the file in the appropriate application (Excel or PDF reader) to confirm readability.
- Check the external drive for errors using your operating system's disk utility.
Drive disconnected during backup
- Ensure the external drive remains connected for the duration of the scheduled task.
- Check Task Scheduler history (Windows) or system logs (Mac) for failed run entries.
- Re-run the backup task manually once the drive is reconnected.
If you encounter issues configuring your local copies of Xero reports, you can Open a Ticket with our Brisbane support team.
Still Having Issues?
💻 Open a Ticket