The amounts come out wrong
If post-conversion amounts are off, the usual suspects are:
TL;DR
- Mixed decimal separators (comma and dot in the same CSV).
- Amount in cents declared as euros.
- Decimals truncated by Excel (watch out for “General” or “Currency” formats).
Check the CSV
| Detail | Recommendation |
|---|---|
| Decimal separator | Always the same (dot or comma) |
| Thousand separator | If used, different from the decimal |
| Excel cell format | “Number” with 2 decimals, not “General” |
| Cents amounts | Tell us at the mapping step to multiply by 100 |
Typical error
Name,IBAN,Amount
Juan Pérez,ES7621000418450200051332,52.91
María López,ES7621000418450200051335,12,75
Row 2 uses comma as decimal: GenerateSEPA reads it as 12.75 only if the whole CSV uses comma. Mixing separators breaks the parser.
Conclusion
99% of amount errors come from separators. Normalise the CSV (all dot or all comma) and re-convert.
