Importing Your Data
Import & Backup
Importing Your Data
Import transaction history from bank exports, spreadsheets, statements, and popular finance apps.
If you’re switching from another app or have a bank export, Lode can import your transaction history automatically — along with accounts, categories, tags, bills, goals and debts when the file has them.
Supported formats
CSV— most banks and finance apps can export to CSV (.tsvand.txttables work too)Excel (.xlsx)— spreadsheets with transaction dataPDF— bank statementsJSON— exports from other finance appsXML— structured exports from other appsDatabase files— SQLite exports such as.db,.sqlite,.mmbak, and.fydb
Files can be up to 50 MB. A Lode backup file doesn’t go here — use Restore from Backup instead (see Backup & Restore).
How to import
- Go to
Settings → Backup & Syncand tapImport - Tap
Select File, choose your file, and tapNext - Lode analyzes the file and shows what it found — transactions, accounts, categories and so on. Tap
Next - Review the preview, then tap
Nextto import andDonewhen it finishes
A table with recognizable column headers — date, amount, category, account and similar, in many languages — is mapped directly. Other layouts, and every PDF statement, are read with Lode AI, so those need Lode AI to be allowed to process your data. There is no manual column mapping: if the preview doesn’t look right, try another export format from your bank or app.
On the free plan, if the file has more accounts, categories, tags, goals or debts than the free plan allows, the review step asks you to choose which ones to bring in.
After importing
All imported transactions will appear in your transaction list. Check the dates, amounts, and categories to make sure everything looks right. Records Lode already has aren’t added again.
Made a mistake? You can undo the whole import in one tap. Go to Settings → Backup & Sync, find the Last Import section, and tap Undo Last Import. This removes all items created by that import without affecting anything else.
Tips for a clean import
- If your CSV has a header row, leave it in — Lode uses it to identify columns
- Make sure amounts use a consistent format, for example
1234.56or1 234,56 - If your file has both income and expenses, check that the sign or type column is included
Importing from another app?
Lode’s importer handles exports from many popular finance apps automatically. It detects the source format and maps the columns for you, so in most cases you can simply export your data, pick the file, and import. If the result isn’t right, undo the import and try a different export from that app.
Questions? Reach out — we’re happy to help.
From the Journal
- A Budget App With No Bank Login: How to Track Money Privately
Why many people won't give a budgeting app their bank password, what you lose without bank sync, and how to keep a complete budget privately on iPhone.
- How to Find Every Subscription You Pay For (and Cancel the Ones You Forgot)
Subscriptions hide in five places, and your iPhone only shows one of them. Here's how to find them all in 20 minutes, cancel safely, and keep the list current.