Cleaning customer master data for e-invoicing: a practical method

Export every customer record with name, TRN, address, emirate, contact email and last invoice date. Mark customers as business, government or individual. Then count how many business customers you invoiced in the last 18 months, because those are the records that matter first.

Example: an Abu Dhabi catering supplier has 2,300 customer records. Only 840 were invoiced in the last 18 months, and 610 of those are businesses. The clean-up starts with 610 records, not 2,300.

Duplicates are common: the same restaurant group entered as 'Al Fanar', 'Al Fanar Restaurant LLC' and 'Al-Fanar Rest.'. Sort by TRN first, since a shared TRN usually means a duplicate. Then sort by name and phone number to catch duplicates without a TRN.

Merge into one record, keeping the transaction history. Decide which branch or delivery addresses to keep as separate delivery locations rather than separate customers.

Every business customer record should carry the legal name as it appears on the trade licence and the VAT certificate, not the shop sign. Collect the TRN for every VAT-registered customer and check it against the customer's VAT certificate. The FTA offers a TRN verification service you can use for doubtful cases.

Arabic and English names deserve care. Where the licence is in both languages, store the English legal name consistently, and keep the Arabic name in a separate field if your systems allow.

• Legal name exactly as on the trade licence
• TRN checked against the VAT certificate
• Full address with emirate
• Customer type: business, government or individual
• Electronic address and identifier, once your provider explains how to obtain them

A clean list decays within months if new customers are still created carelessly. Decide who can create a customer, which fields are mandatory, and what documents are needed: a licence copy and VAT certificate for businesses.

Put a check in the sales process: no credit account without a complete customer record. Cash and card customers who are individuals can stay simple, since B2C sales are excluded from e-invoicing for now.

Track a few numbers each month: business customers with a TRN, records with a full address, duplicates found. The catering supplier starts at 71% of active business customers with a verified TRN and reaches 98% in eight weeks, with the remaining 2% confirmed as not VAT registered.

Once live, track rejections by cause. If customer data errors keep appearing, the creation process needs tightening.

The slowest part of any clean-up is waiting for customers. A short, specific request works best: one email or WhatsApp message asking for a copy of the trade licence and VAT certificate, explaining that UAE e-invoicing requires accurate details on invoices. Avoid sending a long form.

Have sales staff ask in person when they next visit, and make the request part of every credit account renewal. For the last few stragglers, check public sources and the FTA's TRN verification, and record which details you confirmed and how.

HelloBooks stores customer legal names, TRNs, addresses and customer type, and the AI agent helps with the dull parts. Ask 'list active business customers without a TRN' or 'find customers that look like duplicates' and it returns working lists. It can read a customer's licence or VAT certificate from a photo or PDF, in Arabic or English, and suggest the fields to update for a person to confirm.

Clean records then flow into every invoice the agent drafts. HelloBooks does not transmit e-invoices; your accredited provider does. If you want mandatory customer fields or an approval rule for new customers, request it at hello@hellobooks.ai.