Enterprise Number Batch Cleaner

What the cleaner does

Customer and supplier lists collect enterprise numbers in every possible form: with or without BE, with dots, spaces or dashes, sometimes with a typo. Paste the list, one number per line, and each line is normalised and checked:

• the 10 digits of a Belgian enterprise number starting with 0 or 1 are extracted;
• the modulo-97 check is applied: the last two digits must equal 97 minus the first 8 digits modulo 97;
• the number is written in KBO form 0417.497.106 and VAT form BE 0417.497.106;
• repeated numbers are flagged as duplicates but kept, so the row count of your list does not change.

Sample input and output

Input              KBO            VAT                Status
BE 0417.497.106    0417.497.106   BE 0417.497.106    valid
0753124628         0753.124.628   BE 0753.124.628    valid
BE0417497107       0417.497.107   BE 0417.497.107    invalid checksum
0123.456.749       0123.456.749   BE 0123.456.749    valid
417497106          –              –                  no 10-digit number found
bE0417497106       0417.497.106   BE 0417.497.106    valid, duplicate

Export the result as CSV with input, KBO form, VAT form, status and error, and join it back to your original file on the row order.

Edge cases

• Old 9-digit numbers from before 2007 need a leading 0. The batch cleaner reports them rather than guessing; the VAT number checker adds the 0 automatically.
• Valid is not active. A correct checksum proves the number is well formed, not that the company exists or is VAT-registered. Use the company lookup for a VIES check.
• Establishment units (starting with 2 to 8) are not enterprise numbers and are rejected here.
• Foreign VAT numbers such as NL... or FR... are out of scope.

Who uses it

Finance teams preparing customer lists for Peppol, CRM administrators merging duplicate company records, and data analysts joining their own files to KBO Open Data use the cleaner first. A clean, validated enterprise number is the key that makes those joins work; a single typo silently drops a company from the result. Cleaning first, and keeping the duplicates visible, makes every later step more reliable.

Turn clean numbers into Peppol IDs with the Peppol ID checker, and read the company identifiers guide for the difference between enterprise, VAT and establishment numbers.