SEPA direct debit CSV template
Ready-to-use CSV template you upload to GenerateSEPA to produce a pain.008 without touching Excel.
TL;DR
- File type:
CSV - Download: sepa-direct-debit-template.csv
- Usage: upload it to GenerateSEPA or adapt it to your ERP.
What it’s for
The template saves you the headache of figuring out which columns a SEPA file needs. We built it following EPC requirements (Pain.001/Pain.008) and Spanish banks’ real-world habits.
Column structure
| Column | Description | Example |
|---|---|---|
debtor_name |
Debtor name | Acme S.L. |
debtor_iban |
Debtor IBAN | ES7100817281530001234567 |
debtor_bic |
BIC (optional) | BSABESBB |
amount |
Amount in euros | 120.50 |
concept |
Collection concept | Cuota enero 2026 |
mandate_id |
Unique Mandate Reference (UMR) | MANDATE-001 |
mandate_date |
Mandate signature date (YYYY-MM-DD) | 2025-12-15 |
end_to_end_id |
End-to-end ID (optional) | INV-2026-0001 |
How to use it
- Download the template.
- Fill it with your operations (paste from your CRM or ERP).
- Upload the file to GenerateSEPA to obtain your SEPA XML.
- Validate the XML with our SEPA XML Validator.
- Send it to your bank.
Best practices
- Don’t include empty rows at the end.
- Use
YYYY-MM-DDfor every date. - Double-check IBANs before uploading (typos cause AC01 returns).
Conclusion
With this template you go from messy Excel collections to a SEPA batch generated in 2 minutes. Try it now with GenerateSEPA.
