A backup only counts once you have seen it come back. To test a restore, open the backup file on a different device from the one that made it, compare the row count and a few totals against the original, load it into a fresh sheet or a new account, and note the date and result. The whole drill takes about fifteen minutes and is worth doing once or twice a year.
Why do untested backups fail?
Most backup failures are boring. The export ran but only covered the current month. The file was saved to a folder that syncs only half the time. The spreadsheet opens on your laptop but the rupee amounts turn into text on another machine. Dates flip between day-first and month-first. A zipped file was protected with a passphrase nobody wrote down.
None of these show up until the day you need the file, which is usually the worst day: a lost phone, a dead laptop, a CA asking for last year's records the night before a deadline. A restore test moves that discovery to a calm afternoon.
What do you need before you start?
- The backup itself: an export file (CSV or Excel), a copy of the workbook, or the zipped folder of statements and receipts.
- A second device or a second login. A friend's laptop, a phone, or a fresh browser profile all work. The point is that nothing on it is already set up for you.
- The original numbers to compare against. Note them down first, from the live app or sheet.
- A blank sheet or a spare account to import into. Never test by importing over your working data.
How do you run the fifteen-minute drill?
- Note three figures from the live data: the number of transactions, the total spent in the last full month, and the total for one category such as groceries.
- Move the backup to the second device the way you would in a real emergency, by download from cloud storage or from an email to yourself, not by copying a file across from the first machine.
- Open it. If it asks for a passphrase, use the one in your password manager, not the one in your head. If you cannot, you have found your first problem.
- Count the rows. Compare against the number you noted. A mismatch usually means a filter was on during export.
- Add up the same month and the same category. Compare to the figures you noted.
- Import or paste it into a blank sheet or a fresh account and check that dates, amounts and categories still look right.
- Write the date, the device and pass or fail on a note kept with the backup.
What does a worked example look like?
Say your live tracker shows 412 transactions, ₹38,640 spent in October, and ₹9,450 on groceries. You open the backup on a friend's laptop and the sheet shows 389 rows. That is 23 short, so the export probably stopped early or skipped a date range.
Now the totals. October in the backup adds to ₹38,640, which matches. Groceries come to ₹9,450, which matches. The 23 missing rows must therefore sit in other months. Check the date range on the export, re-export the full period, and run the drill again.
| Check | What you noted | What the backup shows | Result |
|---|---|---|---|
| Transaction count | 412 | 389 | Fail: 23 rows missing |
| October total | ₹38,640 | ₹38,640 | Pass |
| Groceries in October | ₹9,450 | ₹9,450 | Pass |
| Dates readable | Day-first | Day-first | Pass |
One failed line means the whole backup is untrusted until it is fixed. Do not tick it off because two out of three matched.
What should you look for when it opens?
- Amounts stored as text, which show left-aligned and refuse to add up.
- Dates that changed meaning, such as 04/05 turning from 4 May into 5 April.
- Missing receipts or attachments. A spreadsheet export carries rows, not the photos behind them, so check that your receipts folder is backed up on its own.
- Odd characters in merchant names, which point to an encoding problem when saving the CSV.
How often should you repeat it?
Twice a year is enough for most households. Pick the dates that already mean something, such as the first weekend after the financial year closes in March and once around Diwali, when you are likely to be tidying records anyway. Repeat it sooner if you change phones, switch email accounts or move your backup to a new place.
Keep the log short. Three lines will do: date, device used, pass or fail with what you fixed. Next time you will know what broke last time, and so will anyone helping you.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


