Why move at all
A household spreadsheet often starts as a simple list and grows into a sprawling workbook with tabs, formulas and colours. It served its purpose. But it also depends on one person’s skill, breaks when a formula is overwritten, makes mobile entry awkward and offers limited reporting. Moving to an app can bring faster entry, automatic categories and ready-made reports.
The move succeeds when it is planned, not rushed.
Decide what to bring
Not everything in the old workbook is worth migrating. Consider three groups.
**Essential.** Recent history, typically the last twelve to twenty-four months of transactions, which provides the baseline for budgets and year-on-year comparisons.
**Useful.** Older years in summary form: annual totals by category. These support long-term comparisons without cluttering the app with old detail.
**Leave behind.** Scratch calculations, outdated plans, tabs that no longer reflect the household’s life.
Clean before you move
Spend time tidying the data in the spreadsheet first. This is easier there than in the app. Check the following.
- Dates are in a consistent format.
- Amounts are plain numbers, without text or symbols.
- Each row is one transaction.
- Categories use consistent names.
- Duplicate rows are removed.
- Income and spending are distinguishable, by sign or column.
A clean sheet imports smoothly. A messy one produces errors that take longer to fix afterward.
Map the categories
List the old categories alongside the new ones. Decide how each maps. Some will map one-to-one. Others will merge or split. Create a simple mapping table.
| Old category | New category |
|---|---|
| Veg and fruit | Groceries |
| Milk | Groceries |
| Cleaning | Household supplies |
| Auto | Transport |
| Doctor | Health and pharmacy |
Apply the mapping in the spreadsheet by adding a new column, then use that column for the import.
Import a sample first
Before moving the whole history, import one month. Check that dates, amounts and categories came through correctly. Look for sign errors, doubled entries and garbled text. Fix the problems in the spreadsheet or the mapping, and try again.
Once a month imports cleanly, proceed with the rest, in batches of a few months so errors are easier to trace.
Reconcile totals
After each batch, compare totals. The sum of spending for each month in the app should match the spreadsheet. If it does not, find the difference. Common causes are rows skipped for format reasons, income imported as spending and rounding.
Reconciliation is dull but essential. It gives confidence that the history is accurate.
Handle accounts and balances
Set up accounts in the app and enter opening balances as of the earliest imported date, so balances flow correctly. If the spreadsheet did not track accounts, assign transactions to a best-fit account or an “imported history” account, and accept the limits.
Run both in parallel briefly
For one month after the move, keep recording in both systems. At the end, compare. If they agree, retire the spreadsheet for new entries. If they differ, find out why. The overlap catches mistakes before the old record is abandoned.
Keep the original
Do not delete the spreadsheet. Save a copy, dated, in a safe place. It is the source of truth if something in the app seems off, and it holds details you chose not to migrate.
After the move
Spend a few weeks refining categories and budgets in the app, using the imported history as the basis. Retrain the household in the new routine: where to enter spending, who reviews what. Celebrate the end of the spreadsheet era, and the start of fewer broken formulas.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

