To back up an expense workbook automatically, keep it in a synced cloud folder so every change is saved and versioned, then add one scheduled copy to a different place so a deletion or a sync mistake cannot take everything with it. Finish by restoring a file once a month, because a backup you have never opened is only a hope.
Is cloud autosave enough?
Cloud autosave answers "what if my laptop dies". It does not fully answer "what if I delete the wrong thing". A synced folder mirrors your actions, so a deleted or overwritten file is deleted or overwritten everywhere. That is why you want two layers: continuous saving plus version history, and a separate copy that does not mirror.
| Layer | Protects against | Does not protect against |
|---|---|---|
| Cloud autosave | Laptop loss, crashes, forgetting to save | Deleting or corrupting the file in place |
| Version history | Bad edits, overwritten formulas | Losing the whole account or folder |
| Scheduled copy to another drive or cloud | Deletion, sync errors, ransomware-type surprises | Nothing, if it is tested and stored separately |
How do I turn on autosave and version history?
In Excel with Microsoft 365, save the file to OneDrive and switch on AutoSave at the top left. Version history is under File, Info, Version History. In Google Sheets there is no save button: changes are written continuously, and File, Version history, See version history lists earlier states with timestamps. You can name an important version, for example "March closed".
Check the actual option names on your screen, as menus and plan features change. If you work offline, remember that the cloud copy only catches up when you reconnect.
If you work in Google Sheets, add a small monthly routine: use File, Make a copy and put the month in the name, and once a quarter use File, Download, Microsoft Excel and keep that file in your separate backup folder. A download gives you a file that lives outside the cloud account, which matters if the account is ever locked or compromised.
How do I schedule an automatic copy?
Make a folder such as Expense-backup on a different drive, or in a different cloud account. Then on a Windows PC, use Task Scheduler to run a copy once a week. A simple command is:
robocopy "C:\Expenses" "D:\Expense-backup" /E
This copies the Expenses folder to the backup drive, including subfolders. If you are not comfortable with commands, the built-in File History or your phone and laptop brand's backup tool does the same job with a menu. On a Mac, Time Machine plays this role.
How many versions should I keep?
Keep more history for recent weeks and less for old ones. A workable pattern is: the last seven daily autosaves in version history, four weekly copies, and one copy at each month end for the full financial year. Say your workbook is 2 MB: twelve month-end copies plus four weekly copies is sixteen files, about 32 MB, which is small. Name them with the date in front, such as 2026-04-30-expenses.xlsx, so they sort in order.
What should I back up besides the workbook?
- The original statement PDFs or CSVs the workbook was built from, since the sheet can be rebuilt from them.
- Receipts and invoices you keep as scans or photos.
- A note of your category list and any lookup tables, in case a tab is damaged.
If you ever move to SpendixAI, remember it keeps your transactions in your own workspace and lets owners export data, so your statements and receipts are the files that matter most to keep safe outside it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


