Import from your bank
Bring in a CSV or Excel statement from any bank. How to get the file, how column matching works, what the preview checks, and how to undo an import.
Exp Planner doesn’t connect to your bank and never asks for your bank login. Instead, you download a statement from your bank and import it. It takes a minute, and nothing is saved until you say so: the file is read in your browser.
Get the file
| Bank | How |
|---|---|
| Revolut | In the Revolut app: Accounts → Statement → Excel/CSV, pick the period, choose CSV. Exp Planner recognises the file as it is. |
| Any other bank | In online banking or the bank’s app, look for Statement, Export or Download and choose CSV or Excel (xlsx). Some banks call an HTML file “Excel”; that works too. |
| A bank with no export | Copy the rows into the Exp Planner template (Download the template on the Import screen). One file can hold several accounts, and fees become their own expense. |
Files in Windows-1251 (Cyrillic) or Windows-1252, separated by commas, semicolons or tabs, with decimal commas or dots: all of these are read as they are. There’s no need to convert anything first.
On Android, you can skip the download step: in your bank’s app or your email, Share the statement file and choose Exp Planner. It opens straight on Import.
Import, step by step
-
Choose the account the statement belongs to, and drop the file on the Import screen (or choose it).
-
Match up the columns (only for a file the app hasn’t seen before): which column is the date, the description, the amount (one column, or separate ones for money out and in), and, if there are any, the currency, balance and card category code (MCC). The app remembers your answer for files with the same columns.
-
Check the preview. Every row shows what it will become:
- a category, from your rules or from the card’s merchant code;
- a clean payee name: “SQ *CAFE LUNA 1234 MADRID” becomes “Cafe Luna”, and the bank’s text stays as the description;
- already imported? Rows that look like ones you have (same account, day and amount) are unticked, but you can still see them;
- replaces a payment you marked: if you marked a bill paid by hand, the bank’s line takes its place instead of counting it twice;
- transfers between your own accounts (Revolut top-ups and exchanges, for example) are linked to their other half after the import.
Tick or untick any row, or change its category.
-
Import. Each import is kept as one batch.
After the import
- Review these N opens exactly the rows from this import that still need a look.
- Save rules turns the categories you picked into rules, so next time they’re filled in for you.
- Undo import removes the whole batch. Changes you made to those transactions afterwards are kept where possible.
Recent imports are listed on the Import screen, each with its own Undo.
Credit card statements
A card statement imports like any other, with three extras: Flip the signs for banks that write purchases as positive numbers (remembered per account), card payments that pair up into one transfer with the other account, and interest and fees that get a category of their own. See Accounts and credit cards.
Tips
- Import every week or two. On the Overview, “Time to import a statement” appears when an account on budget has had nothing new for a week.
- The first time, import three months. Insights fills in, and the app suggests the regular payments it finds as bills.
- Rules save the most time. Settings → Rules: “if the description contains REPSOL, the category is Fuel”. A rule can also look at the direction, the account and the amount, and rename the payee. See Settings.