Import from anywhere with Generic CSV
Generic CSV takes any CSV file whose first line names its columns, from a broker, a bank or a sheet you keep. You match its columns to what the import needs once, and the next file with the same columns is matched by itself.
Pick Generic CSV
Open Import. At the end of the list, under Not in the list?, choose Generic CSV: No ready-made import for yours yet? Bring its CSV and match the columns by hand. On the All tab, pick Investments or Bank statement beside it.
Add the file
The panel reads Add your CSV file: Any CSV with a header row: you match its columns next. Drop the file, or click to choose it. It is read on your device and never uploaded.
Under the drop zone, What your file can look like shows the layouts a file can have, each with its first lines and Download this example.
Match your file's columns
The Columns step, Match your file's columns, finds most columns by their names. Check each one under What the import needs, and pick any it left for you. A column found by what it holds rather than its name says found by what it holds: check it is right, and a column with nothing in it says This column is empty in your file. With no Type column, a column of letters gets a question, such as Side holds B and S: is it the kind of line? Use it, and say what each letter means on the next screen., with Use Side. A column your file does not have can stay on Not in your file.
Under the list, the first lines are read with your choices, so a line that cannot be read says why, like Line 3 of your file. A split line says left out: splits come from market data. When the file names no broker or account, pick one for every line. With no currency column, Prices and fees are in starts on Each holding's own: each price is in its holding's currency, with fees and tax then in the broker's currency. Pick one currency there only when the whole file is in it.
For a bank statement, From and To can each take A second column, where this one is empty?, read then, where it is empty. Two columns, in and out? reads the money from a Money in and a Money out column, and One column, signed? goes back to one.
Check what it found
On Check, the import shows what the file holds and where it goes. For investments, In your file counts Trades, Dividends or Income, Holdings and Left out, such as 1 split from market data instead. The Kinds of line card shows each word your Type column uses and the kind it is read as: Buy, Sell, Dividend, Interest, Other income, Other expense, Shares moved in, Shares moved out or Split, whose lines are taken from market data instead. A word it does not know says Pick one. You can also choose Leave these lines out.
Review and import
Review before importing lists every line, with those already in your workspace marked Already here and left out. Nothing is saved until you press the button with the count, like Import 4 transactions. Next time a file with the same columns comes, they are matched as now, on this device.
Investments: the columns
| Column | Needed | What it holds |
|---|---|---|
| Date | Yes | The day of each line. |
| Type | Yes | Buy, Sell, Dividend, Interest, Split, or your file's own words. Words like Bought, Kauf or Dividende are understood. Split lines are read, then left out: splits come from market data. |
| Ticker or ISIN | One of them | The asset: its ticker, like ASML, or its ISIN, the 12-character code that names a security, like IE00B4L5Y983. |
| Shares | For trades | How many shares were bought, sold or moved. |
| Price | For trades | The price of one share. Without it, give Amount, and each trade's price is its amount over its shares. |
| Amount | For dividends and interest | What the line paid. With a Fee column and no Price, you say once whether the amount includes the fee. |
| Broker | Yes, or one for the whole file | The broker each line is at. Each name is matched to your brokers on Check. |
| Currency | No | Each line's currency. Without it, each price is in its holding's own currency, and fees and tax in the broker's, unless you pick one currency for the whole file. |
| Fee, Tax | No | What each line cost, and the tax on it. |
| Notes | No | A note on each line. |
A line your file calls Deposit, Withdrawal, Fee, Tax, Transfer, Cash in, Cash out or Top up, or the same in German, French, Spanish, Italian, Dutch or Romanian, is left out of an investments file by itself. On the Columns step it says left out unless you name it on the next screen, and on the Check its word is listed as left out under Kinds of line.
An Interest line with no ticker, such as interest on the broker's cash, is not left out: it stops the Columns step. The line says there is no ticker or ISIN, the footer says so, such as Line 7 cannot be read., and Next stays greyed. Take such lines out of the file, then add them by hand on the Broker tab of Add transaction: interest as Broker income, a fee on its own as Broker expense. Money you sent to a broker comes in through the Wallet, as money from your account to the broker, or as an Outside deposit typed by hand. A bank statement's Generic CSV with From and To columns brings many such deposits at once.
Bank statements: the columns
| Column | Needed | What it holds |
|---|---|---|
| Date | Yes | The day of each line. |
| Amount, or Money in and Money out | Yes | One column with money in above zero and money out below, or two columns, each above zero. |
| Account, or From and To | Yes, or one account for the whole file | The account each line goes into, or where each line's money left and arrived. With From and To, a line between two of your accounts is a transfer, and one to your broker is a deposit. |
| Category | No | Matched to your categories on the review's Categories card, where a category none of yours matches waits for your pick: see Import a bank statement. Without it, a line takes its payee's usual category, or you pick on the review. |
| Payee | No | Who was paid, or who paid you. A new name becomes a new payee when you import. |
| Description | No | A note on each line. |
| Tags | No | Several in one cell, split by commas. |
| Type | No | Another app's words, like Expense, Income or Transfer: a transfer's two lines become one move between your accounts. |
| Received | No | With From and To, what reached To in its own currency: the line is then an exchange. |
A bank's own export is often one account per file:
| Date | Description | Money in | Money out |
|---|---|---|---|
| 2026-10-01 | CARD 4417 LIDL | 64.20 | |
| 2026-10-02 | SALARY ACME LTD | 3280.00 |
You pick the account it goes into on the Columns step.
Dates and numbers
| Written as | Read? |
|---|---|
| 2026-10-18, with or without a time | Yes |
| 18/10/2026, 18.10.2026, 18-10-2026 (day first) | Yes |
| 10/18/2026 (month first) | Yes |
| 18/10/26 (a two-digit year), 18 Oct 2026 (a month in words), a timestamp | No |
| -64.20, 64.20- or (64.20), below zero | Yes |
| 1,234.56, 1.234,56 or 1 234,56 | Yes: the column shows which mark is the decimal one |
| €64.20, $64.20, 64,20 lei | Yes: the signs and codes are left out |
| 1,234.56 and 1.234,56 in the same column | No: the import stops and names the two lines |
When no value in a column settles whether the day or the month comes first, like 05/04/2026, your workspace's date format decides. The line about formats on the Columns step has Change, to read it the other way.
Worked example
| Date | Type | Ticker | Shares | Price | Amount | Fee | Broker |
|---|---|---|---|---|---|---|---|
| 2026-09-02 | Buy | VWRL | 10 | 110.00 | 2.00 | Trading 212 | |
| 2026-09-15 | Kauf | ASML | 2 | 650.00 | 1.00 | Trading 212 | |
| 2026-09-25 | Dividend | VWRL | 4.80 | Trading 212 | |||
| 2026-10-01 | Sell | ASML | 1 | 700.00 | 1.00 | Trading 212 | |
| 2026-10-02 | Deposit | 500.00 | Trading 212 |
With no Currency column, each price is read in its holding's own currency, euros for these two, and the fees in Trading 212's. After the import you hold 10 VWRL and 1 ASML at Trading 212.
Good to know
The next file with the same columns is matched by itself, on this device, and the screen says Matched as last time.
Lines already in your workspace are skipped, so files that overlap bring each line in once.
You do not need split lines: splits come from market data by themselves. Split lines in your file are read, then left out, and the Check counts them under Left out.
A Generic CSV takes 10,000 lines at most; a longer bank statement stops with File exceeds 10,000 row limit. Split a longer history into files of up to 10,000 lines each, and import the oldest first. Ready-made imports have no such limit.
Check Imports, broker by broker first: a source in the list needs no matching.
Generic CSV is on every plan. The review checks your plan's limits before anything is saved.