Spreadsheets

Back up your expense spreadsheet: a simple three-copy routine

A simple three-copy routine for your expense spreadsheet: a cloud copy, a dated monthly download and an offline copy, plus version history for bad edits.

Editorial illustration for Back up your expense spreadsheet: a simple three-copy routine

Keep three copies of your expense spreadsheet: the live one in the cloud, a dated download once a month, and one copy on a device or drive that is not your usual laptop or phone. Add version history for fixing a bad edit. This takes about five minutes a month and covers most ways of losing a year of records.

What are the three copies?

CopyWhereHow oftenProtects against
1. Live fileGoogle Drive or OneDriveEvery edit, automaticallyA broken phone or laptop
2. Dated downloadA Backups folder in the same cloudFirst of each monthA wrong edit nobody noticed for weeks
3. Offline copyPen drive or external disk kept at home or with a relativeEvery three monthsLosing access to the account

The idea is that no single accident, such as a deleted file, a locked account or a dead laptop, can take out all three.

How do I make the monthly dated copy?

  1. In Google Sheets choose File, Download, Microsoft Excel (.xlsx). In Excel choose File, Save a Copy and keep the cloud location, or use Save As to a different folder.
  2. Name it with the year and month first, for example Expenses-2026-11.xlsx, so the folder sorts itself in order.
  3. Move it into a folder called Backups.
  4. Set a repeating calendar reminder for the first of the month. Habits that depend on remembering usually fail.

Do this after you have closed the previous month, so the copy is a clean snapshot of the finished month.

Add one line to a Notes tab each time you make a copy, with the date and what changed that month, such as a new category or a corrected opening balance. When something looks wrong a year later, that short log tells you which dated copy to open first.

Can I undo a bad edit without a backup?

Often yes. In Google Sheets open File, Version history, See version history. Pick an older entry, check it, and choose Restore this version. You can also name important versions, such as Year end March, so they are easy to find. In Excel, if the file lives on OneDrive, look under File, Info, Version History. A file saved only on your own computer may offer AutoRecover for unsaved work but is much less forgiving, which is another reason to keep the working file in the cloud.

What if the file was deleted or the account is lost?

Deleted cloud files normally land in the Bin or Recycle bin first, where you can restore them. How long they stay depends on the service and your plan, so check the help page for yours rather than assuming. If you cannot sign in to the account at all, your third copy is what saves you, which is why it must not sit in that same account. Keep recovery options for the account itself up to date, and do not store the sign-in details inside the spreadsheet.

What belongs in the backup besides the sheet?

  • The statement PDFs or CSV files you pasted from, because they are the source of the numbers.
  • Receipts you photographed for big purchases.
  • A small notes tab explaining what each sheet and formula does, so you or a family member can rebuild it.
  • The Settings tab values, since those drive every total.

If you import your statements into SpendixAI, the original files stay available to import again, and transactions you delete go to a recycle bin for 30 days. That is a useful safety net, but it does not replace a copy of your own sheet.

Your first-time checklist

  1. Move the sheet into cloud storage if it is on one device only.
  2. Create the Backups folder and save this month's dated copy today.
  3. Copy the file to a pen drive or disk and store it somewhere separate.
  4. Add the first-of-month reminder.
  5. Try restoring an older version once, on a copy.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports