File formats
Every file type, column name, date and amount format the importers accept.
Transaction files
| Format | Accepted as |
|---|---|
| CSV | .csv or .txt, separated by commas, semicolons or tabs |
| Excel | .xlsx, first worksheet only |
| OFX / QFX | .ofx, .qfx or .xml |
| CAMT.053 | .xml bank-to-customer statements; pending entries are left out |
| QIF | .qif, bank account transactions (not investment QIF) |
Limits: 10 MB and 10,000 rows per file. One statement file can hold one account; export each account separately.
Columns in CSV and Excel files
The first row must be a header. Column order doesn't matter. Euporia matches
header names after ignoring capitals, accents, spaces and punctuation, so
Booking Date, booking_date and Buchungsdatum all work. You can change
any match before importing.
| Column | Required | Header names we recognise | Accepted values |
|---|---|---|---|
| Date | Yes | date, bookingdate, transactiondate, valuedate, buchungstag, buchungsdatum, datum, valuta, wertstellung, completeddate, starteddate, postingdate, datedoperation, fecha, data | 2026-06-28, 28/06/2026 or 28.06.2026 |
| Amount | Yes | amount, value, sum, betrag, betrageur, umsatz, montant, importe, importo, bedrag, amounteur | 1234.56, 1,234.56 or 1.234,56; € $ £ signs are ignored |
| Currency | No | currency, ccy, currencycode, wahrung, devise | A code from the currency list, such as EUR; empty means the account’s currency |
| Description | Yes | description, name, payee, reference, details, memo, verwendungszweck, buchungstext, umsatztext, beschreibung, libelle, narrative, transactiondescription, concepto, descrizione, omschrijving | The statement text for the transaction |
| Merchant | No | merchant, merchantname, counterparty, counterpartyname, vendor, empfanger, auftraggeberempfanger, beguenstigterzahlungspflichtiger, payeename, beneficiary | Who you paid or who paid you |
| Category | No | category, categoryslug, kategorie, categorie, categoria | A category code from the table below; anything else is categorised for you |
Dates
2026-06-28, 28/06/2026 or 28.06.2026. Day comes before month. Two-digit
years aren't recognised. Excel date cells work as they are.
US-style dates
A month-first date such as 04/05/2026 is read day-first, as 4 May, with no
warning. Only dates that can't be day-first, such as 04/25/2026, are
skipped. If your bank exports month-first dates, change the export or the date
format to 2026-04-05 before importing.
Amounts
1234.56,1,234.56and1.234,56are all read correctly.- The symbols €, $ and £ are ignored. Other text in the amount, such as
EURor brackets for negatives, makes the row fail. - Choose whether negative or positive amounts mean money out when you import. Statement files (OFX, CAMT.053, QIF) always use negative for money out.
Currencies
A currency column must use one of the supported currencies. Without one, rows use the currency of the account you import into.
Text encoding
UTF-8 is best. Euporia also reads UTF-16 files and declared encodings, and falls back to Western European (Windows-1252), telling you if it did.
Re-importing an Euporia export
The CSV from Transactions → Export imports back unchanged.
Holdings
Holdings files are CSV or Excel (.xlsx), up to 1 MB and 500
holdings. Header names are matched the same way as for transactions.
| Column | Required | Header names we recognise |
|---|---|---|
| Holding name | Name or identifier | name, holding, security, securityname, instrument, description, asset |
| Ticker or ISIN | Name or identifier | symbol, ticker, isin, identifier, securityid |
| Quantity | No | quantity, units, shares, position, pieces |
| Market value | Yes | value, marketvalue, currentvalue, positionvalue, totalvalue, valuation |
| Currency | No | currency, ccy, valuecurrency |
| Asset class | No | assetclass, assettype, type, class |
Quantities can have up to 8 decimal places. Each holding can appear only once per file.
Last updated on