What data should your transfers CSV contain

Published on · Updated on

What data should your transfers CSV contain

A clean CSV converts to SEPA XML with no friction. Here are the columns.

Mandatory

Column Notes
Beneficiary name Exactly as it appears in their account
IBAN International format, no spaces
Amount Two decimals (52.91 or 52,91)
Concept What the beneficiary will see
  • BIC: derived from the IBAN if missing.
  • Execution date: defaults to the file date.
  • Unique reference (End-to-End ID): your ERP ID, useful for reconciliation.
  • Amount in cents: alternative to decimal amount, if your ERP exports that way.

Template

Download a transfers CSV template with the correct header. Fill it in and upload.

Conclusion

Four mandatory columns and a couple of optional ones are enough. The cleaner the CSV, the less you’ll need to fix before uploading the file to your bank.


Frequently Asked Questions

What separator do you recommend?
Comma or semicolon. We detect both. Keep it consistent across the file.
What if the BIC is missing?
We derive it from the IBAN. Within SEPA it has been optional since 2016.
How do I write decimals: comma or dot?
Either, but be consistent. Don't mix `1,234.56` with `1.234,56`.

Convert your file to SEPA XML

Try it now →
Was this article helpful?

Related articles

Showing the first four on mobile.