Convert Handelsbanken Statements to Excel

Why Choose Us for Handelsbanken

What a Handelsbanken kontoutdrag looks like inside

• Dates are ISO — YYYY-MM-DD. That is unusual: most banks we handle print DD/MM or MM/DD, and a parser tuned for those misreads Swedish statements.
• Amounts use a space as the thousands separator and a comma as the decimal: 1 234,56. A converter that assumes the Anglo convention reads 1 234,56 as two numbers, or as 1.23.
• A running balance follows every transaction, which is what makes the strongest accuracy check possible here — and why this is the bank we verified first.
• Rows can carry two dates, the booking date and the transaction date, and both are kept rather than collapsed.
• When the PDF text is extracted, the fields run together with no spaces between them — a row arrives looking like 2026-01-02Prel Revolut*-500,0020 937,97. Splitting date, description, amount and balance back out of that is the specific problem the Handelsbanken parser exists to solve, and it is why a generic table extractor tends to fail on these statements.
• Swish transactions appear as ordinary rows and are included.

Things worth knowing

• Preliminary "Prel" rows are authorised but not settled. They can break balance continuity and cause a statement to be flagged — that is the check working, not failing.
• Fortnox's own bank-file import will not read a converted CSV. It expects business-banking interchange formats tied to a bank integration. If you want the transactions in Fortnox, use the voucher posting on Pro, which goes through Fortnox's API and books each reconciled row as a voucher.
• Posting is blocked outright for any statement that does not reconcile. There is no override — an unverified statement cannot be pushed into your books.