Import bank transactions from CSV or Excel

Downloading your statement

The exact place varies by bank, but the option is usually in the account transaction view, behind a download or export button next to the date filter. Look for CSV or Excel; if it only offers PDF, that will not import.

It is worth picking a wide date range the first time — a year, if it lets you — and then downloading only what is new.

Mapping the columns

Sumant tries to recognise the columns on its own. It detects the common variants in Spanish and English: Date, Value date, Transaction date, Concept, Description, Amount, Debit, Credit, Balance, Currency.

It also handles both amount models banks use: a single column with positives and negatives, or two separate debit and credit columns. If your file has an odd header or title rows on top, it skips them.

When something is not recognised, you pick it from a dropdown. With Sumant PRO you can save that setup as a template and reuse it next month.

Review before anything is saved

Nothing is saved until you confirm. The review screen separates what is new, what you already have and what could not be read:

• New: transactions that do not exist yet. They come ticked.
• Exact duplicates: they match on account, date, amount, currency and description. They come unticked.
• Possible duplicates: same day and amount, different wording. Shown separately for you to judge.
• Errors: rows with an unreadable date or amount. They are not imported, and they do not stop the rest.

What Sumant does not do

It does not connect to your bank, read your email, use aggregators or open banking, and it does not accept PDFs or images of statements. It also does not keep the file you upload: it is processed on your device and only the transactions you confirm are stored.