Euporia Help
Reference

Δεν έχει μεταφραστεί ακόμη

Αυτή η σελίδα υπάρχει προς το παρόν μόνο στα αγγλικά.

File formats

Every file type, column name, date and amount format the importers accept.

Transaction files

FormatAccepted 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.

ColumnRequiredHeader names we recogniseAccepted values
DateYesdate, bookingdate, transactiondate, valuedate, buchungstag, buchungsdatum, datum, valuta, wertstellung, completeddate, starteddate, postingdate, datedoperation, fecha, data2026-06-28, 28/06/2026 or 28.06.2026
AmountYesamount, value, sum, betrag, betrageur, umsatz, montant, importe, importo, bedrag, amounteur1234.56, 1,234.56 or 1.234,56; € $ £ signs are ignored
CurrencyNocurrency, ccy, currencycode, wahrung, deviseA code from the currency list, such as EUR; empty means the account’s currency
DescriptionYesdescription, name, payee, reference, details, memo, verwendungszweck, buchungstext, umsatztext, beschreibung, libelle, narrative, transactiondescription, concepto, descrizione, omschrijvingThe statement text for the transaction
MerchantNomerchant, merchantname, counterparty, counterpartyname, vendor, empfanger, auftraggeberempfanger, beguenstigterzahlungspflichtiger, payeename, beneficiaryWho you paid or who paid you
CategoryNocategory, categoryslug, kategorie, categorie, categoriaA category code from the table below; anything else is categorised for you

Dates

2026-06-28 (a time after it, such as 2026-06-28 10:15:32, is ignored), 28/06/2026 or 28.06.2026. Two-digit years aren't recognised. Excel date cells work as they are.

US-style dates

Slash dates are read month-first when the file proves it: some date such as 04/25/2026 can only be month-first, and none can only be day-first. Otherwise they are read day-first, so a file with only 04/05/2026-style dates becomes 4 May. If your bank exports month-first dates, change the export to 2026-04-05 to be sure.

Amounts

  • 1234.56, 1,234.56 and 1.234,56 are all read correctly.
  • 1.500 with no decimals could be 1.5 or 1500, so the row fails. Write 1500 or 1.500,00.
  • The symbols €, $ and £ are ignored. Other text in the amount, such as EUR or 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. Rows in another currency are skipped: import them into an account in that currency.

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.

ColumnRequiredHeader names we recognise
Holding nameName or identifiername, holding, security, securityname, instrument, description, asset
Ticker or ISINName or identifiersymbol, ticker, isin, identifier, securityid
QuantityNoquantity, units, shares, position, pieces
Market valueYesvalue, marketvalue, currentvalue, positionvalue, totalvalue, valuation
CurrencyNocurrency, ccy, valuecurrency
Asset classNoassetclass, assettype, type, class

Quantities can have up to 8 decimal places. Each holding can appear only once per file.

Τελευταία ενημέρωση

Σε αυτή τη σελίδα