Getting started

Switching expense tracker apps without losing history

How to switch expense tracker apps and keep history: export a CSV from the old app, check dates and columns, import, spot-check a month, or re-import statements.

Editorial illustration for Switching expense tracker apps without losing history

To switch expense tracker apps without losing history, export your data from the old app as a CSV or Excel file, check the columns and date format, import it into the new one by account, and spot-check one month against your records. If the old app cannot export, re-import your bank and card statements instead, which usually rebuilds the history just as well. Do not delete the old app until you have checked the new one.

Step 1: can the old app export anything?

Look in the old app's settings or menu for an export, download or backup option. Common choices are a CSV or an Excel file. Some apps export only a backup file that only that same app can read, which is no use for moving. Do this before you cancel anything, since some apps limit exports once a subscription ends.

Step 2: what should I check in the file?

  • Dates. Is it day, month, year or month, day, year? A date like 03/04 is a different day in each.
  • Amount signs. Are expenses positive or negative? Are refunds shown as negatives?
  • Accounts. Does the file mix accounts in one list? If so, split it so each account imports on its own.
  • Currency. If any rows were in another currency, note which.
  • Categories. They will not match yours exactly, and that is fine.

Open the file in Excel or Google Sheets and look at the first twenty rows. If the dates are stored as text, or the amounts include commas inside quotes, tidy those before importing.

Step 3: how do I import it?

SpendixAI accepts bank and card statements as PDF, CSV or Excel, and you review the rows before they are saved. An export from another app is not a bank statement, so treat the first import as a trial: upload a small slice, say one month, and see whether the dates, amounts and merchants come through sensibly. Pick the right account before uploading, and choose your base currency first, because it cannot be changed once transactions exist. Do not promise yourself that every layout will parse perfectly. If it does not, you will see it in the review.

Step 4: how do I spot-check?

  1. Pick one closed month that you know well.
  2. Compare the total spend and the three largest categories with the old app.
  3. Compare the ten largest transactions.
  4. Check the transaction count roughly.
  5. Look for duplicates, since overlapping exports can double rows. SpendixAI flags possible duplicate imports, but read the import history too.

What if the old app has no export?

Then your statements are the better source anyway. Download the last few months of bank and card statements, import each into its own account, and your history rebuilds from the documents themselves. Cash entries are the only thing you will need to retype, and they will be fewer than you fear. Keep a screenshot or a manual note of anything you want to remember, such as a savings goal total.

A worked example with invented numbers

Say your old app exports 1,840 rows for the past year across a savings account and a card. You split the file in two, giving 1,100 and 740 rows. Check: 1,100 + 740 = 1,840. You import one month from each, compare the monthly spend (₹48,200 in the old app, ₹48,950 in the new one), and find a ₹750 refund that the old app counted as a negative expense and the new import treated as a credit. After fixing that, you import the rest.

What to keep, what to let go

  • Keep the original export file in a dated folder, as your own backup.
  • Let go of old category trees you never used.
  • Do not delete the old account until a full month of the new tool has matched your bank balance.
  • Cancel any paid subscription on the old app from the place you bought it, such as the App Store, and check the renewal date.
SPENDIXAI JOURNAL

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

Explore your reports