Home › Knowledgebase › KB-971

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.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

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.

Important: Xero does not have a native feature to automatically back up data directly to an external drive, nor does it support scheduled automated backups to local hardware. The process described below is a hybrid manual/automated workflow. You must manually export reports from Xero first; your computer's scheduler can then automatically copy those exported files to your external drive. Standard report exports do not include a complete backup of all Xero accounting data, such as every transaction, contact, or organisation setting.
ATO Compliance: Australian small businesses must generally keep financial records for at least five years. Ensure your backup retention policy meets Australian Taxation Office (ATO) requirements for your specific circumstances.

Prerequisites

Before beginning, ensure you have the following:

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.

  1. Log in to your Xero organisation at https://go.xero.com.
  2. Navigate to the Accounting menu and select Reports.
  3. Select the financial reports you wish to back up, such as the Profit and Loss or Balance Sheet.
  4. Set your desired date range and click Update.
  5. Click the Export button in the top right of the report.
  6. Select Export to Excel or Export to PDF.
  7. Save the file to a dedicated folder on your computer, for example: C:\Users\[YourName]\Documents\Xero Backups.
Tip: Remember that report exports are manual. You will need to repeat this export process periodically to capture new financial data before your scheduled copy task runs.

Step 2: Schedule Automated File Copying (Windows)

To automate moving these exports to your external drive, use the Windows Task Scheduler.

  1. Press Windows Key + R, type taskschd.msc, and press Enter.
  2. In the Task Scheduler window, click Create Basic Task in the Actions pane.
  3. Name the task Xero Backup and click Next.
  4. Select your preferred frequency (e.g., Weekly) and click Next.
  5. Set the start time and click Next.
  6. Select Start a program and click Next.
  7. In the Program/script field, enter: robocopy
  8. In the Add arguments field, enter your source and destination paths. Example: "C:\Users\[YourName]\Documents\Xero Backups" "E:\Xero Backups" /E (Replace E: with your external drive's letter).
  9. Click Finish to save the task.
Warning: Do not select Run whether user is logged on or not if your task references a mapped drive letter. Robocopy typically requires an interactive user session to access mapped drives, and the task may fail silently in a non-interactive context. Ensure your external drive letter remains consistent; Windows may assign a different letter if you reconnect the drive or connect other USB devices, which will break the scheduled 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.

  1. Open Terminal (found in Applications > Utilities).
  2. Create a backup script by typing: nano ~/xero_backup.sh
  3. Enter the following command, replacing [User] and [DriveName] with your details: rsync -av ~/Documents/Xero\ Backups/ "/Volumes/[DriveName]/Xero Backups/"
  4. Press Ctrl + O, then Enter to save, and Ctrl + X to exit.
  5. Make the script executable: chmod +x ~/xero_backup.sh
  6. Open the crontab editor: crontab -e
  7. Add a line to run the script weekly (e.g., every Sunday at 2 AM): 0 2 * * 0 /Users/[User]/xero_backup.sh
  8. Save and exit the editor.
Note: Cron jobs will not run if your Mac is asleep or powered off at the scheduled time. Ensure your computer is awake or adjust your Energy Saver settings accordingly.
Warning: On modern macOS, Terminal and cron require Full Disk Access to read and write to folders such as Documents and external volumes. Go to System Settings > Privacy & Security > Full Disk Access and ensure Terminal is enabled. Without this permission, your backup script may fail silently.

Step 4: Verify Your Backups

Automation can fail silently. It is critical to verify that your data is actually reaching the external drive.

  1. Manually run your scheduled task or script once.
  2. Open your external drive in File Explorer (Windows) or Finder (Mac).
  3. Confirm that the most recent Xero export files are present in the backup folder.
  4. 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.

  1. Enable encryption on your external drive (BitLocker on Windows or FileVault on Mac) to protect data if the drive is lost or stolen.
  2. Consider password-protecting individual Excel or PDF files before backing them up.
  3. 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

Failed or incomplete Xero exports

Corrupted or unreadable backup files

Drive disconnected during backup

If you encounter issues configuring your local copies of Xero reports, you can Open a Ticket with our Brisbane support team.

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

💻 Open a Ticket