SEPA XML file generator (pain.001) from Excel / CSV

How it works

  1. Export your payment list from Excel or Google Sheets (columns: Name, IBAN, BIC (optional), Amount, Reference).
  2. Drop the file in PayBatchKit. Every IBAN is checked (country length + mod-97 checksum), amounts are summed in cents, and special characters (ä, é, &) are converted to the EPC SEPA character set.
  3. Download a pain.001.001.03 (accepted by most EU banks) or pain.001.001.09 XML file and upload it to online banking.

What gets checked

Collecting money instead of paying? Use the SEPA direct debit (pain.008) generator.

FAQ

Is my data uploaded? No. The page runs entirely in your browser.

Which version should I pick? pain.001.001.03 unless your bank asks for .09 (the newer ISO 20022 2019 version).

Free? Files with up to 5 payments are free; Pro removes the limit.

Guides: How to create a SEPA XML payment file from Excel · SEPA structured addresses: the November 2026 deadline was postponed · How to create a SEPA direct debit file (pain.008) from Excel · FRST vs RCUR: SEPA direct debit sequence types · SEPA XML file rejected: what the error codes mean and how to fix them
← Karuna Labs tools · Privacy · Terms · Refunds · Contact