How To Set Up Automated Backups For Month-End Financial Reporting
Summary
This guide helps you troubleshoot and resolve: How To Set Up Automated Backups For Month-End Financial Reporting. Follow the steps below to fix the issue.
Common Causes
Regular backups are essential for protecting small business data against accidental loss, hardware failure, or cyber incidents. This article explains how to configure automated backups specifically for month-end financial reporting, ensuring accounting records and client data are consistently protected without manual intervention.
Month-End Backup Schedule
Schedule your automated backup to run after month-end processing completes and before new transactions begin for the next period. This ensures the backup captures a consistent snapshot of your financial records, including reconciled accounts, finalised reports, and closed periods. Avoid running backups while accounting software is actively processing month-end entries, as open data files may be locked and excluded from the backup.
Quick Fix Steps
- Identify your business-critical financial files and folders, including accounting software company data directories.
- Choose a backup destination (external drive or cloud storage).
- Enable the built-in backup tool for your operating system.
- Schedule the backup to run automatically after month-end processing completes.
- Verify that the first backup completed successfully.
- Test a restore to confirm backups are usable.
Detailed Instructions
Windows (File History)
- Connect an external hard drive to your computer.
- Open Settings and select System (Windows 11) or Update & Security (Windows 10).
- Click Backup in the left-hand menu.
- Under Back up using File History, click Add a drive and select your external drive.
- Toggle Automatically back up my files to On.
- Click More options to configure how often backups occur and how long to keep them.
- Under Back up these folders, click Add a folder to include specific accounting or client data directories.
- Enable encryption on the backup drive to protect sensitive financial data.
Mac (Time Machine)
- Connect an external storage device to your Mac.
- Click the Apple menu and select System Settings (macOS Ventura and later) or System Preferences (earlier macOS versions).
- Select Time Machine.
- Click Select Backup Disk and choose your external drive.
- Enable Back Up Automatically.
- Click Options to exclude unnecessary folders or add specific network volumes.
- Enable encryption on the backup disk to protect sensitive financial data.
Accounting Software Data File Locations
Common Australian small business accounting software stores company files in different locations. Ensure these folders are included in your backup selection and that the software is closed before the backup window begins.
- MYOB: Company files are typically stored in the Documents folder or a custom MYOB data directory. Close MYOB AccountRight or Essentials before backup to avoid locked file errors.
- Xero: Xero is cloud-based, but local exports, PDF reports, and supporting spreadsheets should be backed up from your Documents or Downloads folders.
- QuickBooks: Company files (.QBW) are usually located in the QuickBooks company file folder under Documents or a custom path. Close QuickBooks Desktop before backup to prevent database locking.
Cloud Backup Alternative
If you prefer offsite protection, consider a cloud backup service. Install the provider's application, sign in with your business account, select the folders containing your financial records, and enable scheduled backups. This protects against physical damage or theft of local hardware. Ensure the service provides encryption for data at rest and in transit.
ATO Record-Keeping Requirements
Australian businesses must keep financial records for at least five years under ATO requirements. Configure your backup retention policy to preserve month-end financial reports, BAS records, and transaction data for this minimum period. If using File History or Time Machine, adjust the Keep backups setting to retain monthly backups for at least 60 months, or archive older month-end backups to separate storage.
Troubleshooting
Backup fails to start
- Ensure the external drive is connected and has sufficient free space.
- Check that the drive is formatted correctly for your operating system (NTFS for Windows, APFS or Mac OS Extended for Mac).
- Restart your computer and try the backup again.
Accounting software file is in use or locked
- Close the accounting software completely before the scheduled backup runs.
- Ensure no other users have the company file open on a network.
- Use a backup solution that supports Volume Shadow Copy (Windows) or a dedicated backup agent to capture open database files.
- Verify the backup completed after closing the software and run a manual backup if needed.
Files are missing from the backup
- Verify the folders are included in the backup selection settings.
- Check for file permission issues that may prevent the backup service from reading certain files.
- Ensure files are not open or locked by another application during the backup window.
Backup drive not recognised
- Try a different USB port or cable.
- Open Disk Management (Windows) or Disk Utility (Mac) to see if the drive appears but needs to be mounted or formatted.
If you continue to experience issues with your backup configuration, Open a Ticket and our Brisbane support team will assist you.
Still Having Issues?
💻 Open a Ticket