Bring history in from any bank export using the guided column mapper.
When a bank cannot be connected, or when you want to load years of history at once, import a CSV export. The importer works from the file itself rather than from a list of supported banks: it auto-detects the separator (comma, semicolon, tab, or pipe), handles quoted fields, and reads dates and amounts in either European or US style.
Every column it guessed can be reassigned by hand, in three groups. Required is the date and the amount. Money holds the columns that decide the sign and size of a row, separate debit and credit columns, a direction column saying in or out, a currency, and a running balance. Details covers the merchant, the note, a category or MCC printed in the file, the payment method, and a booking date to fall back on. Anything you do not want imported can be set to Skip, and the reading of dates, day first, month first, or year first, is a separate control just above them.
A live preview updates as you remap, so you can verify the data before anything is saved. Amounts in either 1.234,56 or 1,234.56 style are parsed correctly, and duplicate rows are detected, so re-importing the same file does not double up your transactions.
When your export carries a running balance column, Centmond checks the file against it before importing: every row's balance change has to equal that row's amount. A file that fails that check is not blocked, but it does have to be answered. You are told how many checks failed and which row broke first, and the Import button stays switched off until you tick a box confirming you have looked at the preview and want to go ahead. Centmond recognises the common false alarm on its own: when every row is out by a small, consistent amount, that is a fee the balance includes and the amount column does not, and it is reported as such rather than blocking you. What you are being asked about is the other kind, a wrong separator or a flipped sign, far easier to catch here than weeks later in your totals.
- 1Open Settings, then Data, and choose your CSV.
- 2Correct any column it read wrongly, using the live preview to verify.
- 3Confirm the date order, and answer the balance warning if one appears.
- 4Run the import: new transactions are added to the ledger and duplicates are skipped.