Excel to MT940 converter
A spreadsheet of transactions is not something accounting software will take. Pick the sheet, map the columns and download a SWIFT MT940 with correctly formed fields.
Upload your spreadsheet →2 free conversions · no credit card required
Excel to MT940 in 3 steps
- Upload your spreadsheet. Both .xlsx and .xls are supported, including workbooks with several sheets. The first sheet is used by default; select another if your transactions live there.
- Map the columns. Date, amount and description are detected automatically. Separate debit and credit columns can be mapped together into a single amount.
- Download the MT940 file. Balances are calculated from the amounts or taken from a balance column. You confirm the opening balance before export.
Where Excel exports come from
Downloaded from the bank
Some banks offer XLSX alongside CSV. The layout differs per bank, which is what the column mapping is for.
Report exports from accounting software
An export from Exact or Twinfield with date, amount and description is treated the same as a raw bank export.
Hand-built overviews
A sheet you maintain yourself works, as long as there is a date column and an amount column.
Why not build MT940 by hand
MT940 needs exact :20:, :25:, :28C:, :60F:, :61: and :62F: fields. Hand-built files are usually rejected on import.
Frequently asked questions
Which Excel files can I convert?
Both .xlsx and .xls, including workbooks with several sheets. The first sheet is used by default; you can select a different one in step 1 if your transactions live elsewhere.
Does my spreadsheet need a specific column order?
No. Date, amount and description are detected automatically. For an unusual layout you choose which column belongs to which field in step 2.
My amounts are in two columns (debit and credit) — does that work?
Yes. In step 2, add 'Amount debit' next to 'Amount' and map both columns. They are combined into a single amount column with the correct sign in the MT940 output.
Does it work with report exports from Exact or Twinfield?
Yes. Excel exports from accounting software with date, amount and description are treated the same as a raw bank export. If the signs are the other way round, 'negate amounts' is available in step 2.
How is this different from building an MT940 by hand?
An MT940 file needs exactly formed :20:, :25:, :28C:, :60F:, :61: and :62F: fields in SWIFT syntax. Those are generated correctly here; doing it by hand is error-prone and is usually rejected on import.