Import bank transactions from CSV, Excel or Norma 43

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 (.xlsx). If you receive .xls, save a copy as .xlsx or CSV in a spreadsheet first: renaming it does not convert it. A PDF cannot be imported directly.

Start with a small period to check the format and result. Then extend the history and download only new transactions, keeping the original files.

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.

If you have a photo, screenshot or PDF

The file importer accepts CSV, Excel (.xlsx) and Norma 43. It does not load PDFs or images. For a receipt photo or a screenshot of transactions, use Scan: it accepts PNG, JPEG and WebP and proposes transactions for you to check and correct before saving.

Reading an image needs a connection and sends the chosen image to the reading service. Plan limits and service availability apply. It does not send your history or categories. If you only have a PDF, look for an Excel download first; for a few rows, you can use a readable screenshot without treating it as a complete document import.