Jsonpage · SIREN and SIRET API
RESOURCES · INVOICING

Customer file: the errors that get an e-invoice rejected

Customer file errors are few and easy to recognise: an 8-digit number, a SIRET in the SIREN column, a closed company, a duplicate. This article goes through them; the full method to fix them is on the page Clean a customer file for e-invoicing.

By Devintech · Published · Updated · 5 min read

01 / ERRORS

The seven most frequent errors

Since the reform, the customer's SIREN is a mandatory mention (see France e-invoicing: why your customers' SIREN becomes mandatory). A file built up over the years almost always contains the same anomalies:

  1. The SIREN is missing. The customer was created from its name only, or the column is empty.
  2. A leading zero has disappeared. A spreadsheet treats the number as a numeric value: 012345678 becomes 12345678, 8 digits instead of 9.
  3. The SIRET became scientific notation. A 14-digit number can display as 1.23457E+13 and loses its last digits.
  4. A SIRET is entered instead of the SIREN, or the reverse. The first 9 digits of a SIRET are the SIREN; see SIREN vs SIRET vs NIC: what is the difference?.
  5. A typing mistake. A missing, added or swapped digit makes the check digit wrong.
  6. The company is closed, absorbed or restructured: the number is correct but no longer designates an active customer.
  7. A duplicate or a namesake. The same customer exists under two spellings, or the number belongs to another company with the same name or in the same group.
Free diagnosis of your customer fileDrop a CSV, TXT or Excel export on the Customer file page: the diagnosis appears without an account, and you only pay to download the corrected file, from €29 excl. VAT.
02 / METHOD

How to spot them, in order

Errors 2, 3 and 4 show in the length of the number: 9 digits for a SIREN, 14 for a SIRET. A typing mistake is caught by the check digit. The other three (missing number, closed company, namesake) require looking up the company itself: a correct number does not tell you it is active.

Five successive checks on a customer fileExportnames and numbersFormat9 or 14 digitsvalid check digitExistenceactive companymatching numbersDuplicatesone rowper companyFollow-upalert if thestatus changes
The five checks to apply, in this order, to every row of the customer file.
03 / FIX

What to do with each anomaly

  • Missing number: search the company by name and postcode, then have the customer confirm the number if several candidates exist.
  • Lost zero or scientific notation: restore the zeros, then save the column as text before reopening the file.
  • Closed company: check with the customer whether it changed structure before invoicing. See Struck-off, closed or dormant French company: how to find out.
  • Duplicate: keep a single record per company, linked to the right number, then merge the history.

The scope and application dates of the new mentions are set out on the official page Electronic invoicing: new mentions on invoices of Service-Public (in French): they apply from 1 September 2026 to large companies and mid-sized companies (ETI), and from 1 September 2027 to SMEs and micro-businesses.

04 / WITH JSONPAGE

With Jsonpage: spot the anomalies in one pass

The customer file diagnosis applies these checks to every row and reports valid, unknown or malformed identifiers, closed companies, insolvency proceedings and duplicates, with no account to create. The corrected file downloads after payment.

To check a record at entry, a call to GET /v2/validate verifies the format, the existence and the status:

curl "https://api.jsonpage.com/v2/validate?id=FR-552032534" \
  -H "X-API-Key: $JSONPAGE_API_KEY"

For the example FR-552032534, the response shows that the number is valid and that the company is active (active).

05 / FREQUENTLY ASKED QUESTIONS

Frequently asked questions

Why does a SIREN lose its zero in a spreadsheet?+

The spreadsheet reads the number as a numeric value and drops leading zeros. Save the column as text, then restore the zeros to get 9 digits.

Can a SIRET replace the SIREN in the column?+

No, they are two different numbers. The first 9 digits of a SIRET are the SIREN: just extract them.

Does a correct check digit guarantee that the company exists?+

No. The check digit catches a typing mistake, but not a closed company or a number assigned to another company.

How long does it take to clean a file?+

The diagnosis appears as soon as the file is dropped. The correction time depends mostly on missing numbers, which sometimes have to be confirmed by the customer.

06 / RELATED RESOURCES

Keep reading

TRY IT

Try it on your own numbers

The free account gives access to the company record, validation and name search: 100 requests per minute, no credit card.