What data should your SEPA direct debits CSV contain

Published on 2026-01-04 · Updated on 2026-05-17

What data should your SEPA direct debits CSV contain

A SEPA direct debit isn’t just about collecting: it must be backed by a mandate. The CSV for direct debits therefore needs extra fields compared with transfers.

Mandatory

Column	Notes
Debtor name	Exactly as in the mandate
Debtor IBAN	No spaces
Amount	Two decimals
Concept	What the debtor will see
Unique Mandate Reference (UMR)	Unique within your organisation
Mandate signature date	DD/MM/YYYY

Optional

Sequence type: FRST (first), RCUR (recurring), OOFF (one-off) or FNAL (final). Default: inferred from history.
Debtor BIC: derived from the IBAN.
End-to-end reference: for internal reconciliation.
Payment category: optional (SUPP, SALA, etc.).

Template

Download a ready-to-use direct debits CSV template.

Conclusion

Six columns is all you need. The key is to keep the mandates and use a consistent UMR per debtor across collections.

Frequently Asked Questions

What if I get the mandate reference wrong?: The debtor's bank will return the collection (typically MD01 'no mandate') and your bank will charge you a return fee.
When should I mark a collection as FRST?: The first collection on a new mandate is FRST. From the second onwards it is RCUR. One-off collections are OOFF.
Can the signature date be earlier than the first collection?: Yes. It is the actual date when the debtor signed, not the date of the collection.