Clean a customer file for Pennylane, Sage or EBP (SIRET & IBAN)

French accounting and ERP tools — Pennylane, Sage, EBP — are picky about third-party (customer/supplier) imports. Beyond the usual name and address cleanup, they expect SIRET/SIREN and IBAN in a specific, valid shape. Get one wrong and the import is rejected or, worse, creates messy records.

What's specific to French B2B files

• SIRET / SIREN pasted with spaces, dots or mixed lengths ("814 207 234 00012" vs "81420723400012").
• IBAN with inconsistent spacing or lower case.
• Amounts and dates in French format (1 234,56, 31/12/2025) that the target tool may or may not expect.
• The usual: column names in French, duplicate rows, empty lines.

The fast way with Importly

1. Upload your customer / third-party export (.xlsx or .csv).
2. Pick your accounting profile — "Pennylane — Third parties", "Sage 50 — Customers", "EBP — Customers", and others. Importly maps your columns to that tool's import fields and cleans the values.
3. Download the import-ready file and load it into your accounting tool.

What gets cleaned

• SIRET / SIREN stripped to clean digits and validated length.
• IBAN normalized and grouped the standard way.
• Names, cities, postal codes, countries tidied.
• Dates and amounts kept in the French convention your tool expects.

Unlike a generic cleaner, these profiles are built specifically for French B2B imports — the SIRET/IBAN handling is the part that usually costs you the most time.

Clean your customer file free →