Collect buyer details from your customers

Email each UAE customer a form that holds the details you already have, let them confirm and complete it, then move the confirmed records to your Buyers master. You need a customer export from your ERP with a customer code and a contact email for every customer.

A UAE e-invoice needs details about the buyer that an ERP often does not hold, such as a Peppol ID (the buyer’s address for receiving e-invoices), a registration number or an emirate. Buyer data collection gets those details from the customers themselves:

  1. You upload your customer list.
  2. Each customer gets a link to a form. What is in your file is already filled in, so they check it and add what is missing.
  3. Answers that only fill a gap are accepted for you. You decide on the ones that replace a key detail from your file.
  4. You move the confirmed customers to the Buyers master, the Buyers catalog in Masters, where document forms reuse them.

Upload your customer export

In the Invoice Portal, expand Masters and choose Buyer data collection. Drop your file on the page, or choose Choose file.

Your file needs:

RequirementDetail
A header rowColumn names somewhere in the first 10 rows, then one row per customer.
A customer code columnYour ERP’s ID for the customer. Each Entity and customer code pair can appear only once.
A contact email columnRequired on every row. The customer’s form link goes to this address. Rows without a valid email are not imported.
One sheet or severalFor example, one sheet per legal entity.

When the file is read, the page shows its name with the number of sheets and rows, for example 1 sheet · 8 rows read. Choose Replace file if it is the wrong one. Nothing is saved yet. Choose Next.

The Buyer data collection page on the Upload step. A drop area asks for an Excel or CSV customer export up to 25 MB, and a What your file needs panel lists a header row, a Customer code column, a Contact email column and one sheet or several. A Download template button is at the top right.
Step 1 of 4. The page also lists your earlier uploads below this panel.
The Buyer data collection page on the Upload step. A drop area asks for an Excel or CSV customer export up to 25 MB, and a What your file needs panel lists a header row, a Customer code column, a Contact email column and one sheet or several. A Download template button is at the top right.

Match your columns

Match your columns lists each field next to the column it found in your file, with an example value. Check the suggestions. To change one, open the list under Column in your file and choose another column, or Not in my file.

  • Customer code and Contact email must be matched before you can continue.
  • Entity says which of your companies sells to the customer. When the file has several sheets, you can choose Use the sheet name.
  • Customer type and Annual revenue decide which fields a customer must fill. The customer confirms both on the form, or chooses them if your file does not have them.
  • A field you leave as Not in my file has nothing to pre-fill. If the form asks for it, the customer fills it in.

Customers who have it shows how complete each column is. On the customer form shows what the form will do with the field, such as Customers just confirm it or 4 customers must fill it in.

The footer says how many customers will be imported. Choose Next to import them. A message confirms the count and how many rows were skipped.

The Match columns step. A table lists Customer code, Contact email, Entity, Customer type, Annual revenue, Legal name and Peppol ID, each with the matched column from the file, an example value, how many customers have it and what the customer form will ask. The footer says 8 customers from 1 sheet will be imported.
Each field next to the column from your file. Your matches are suggested again on your next upload.
The Match columns step. A table lists Customer code, Contact email, Entity, Customer type, Annual revenue, Legal name and Peppol ID, each with the matched column from the file, an example value, how many customers have it and what the customer form will ask. The footer says 8 customers from 1 sheet will be imported.

Choose what the form asks

Form fields lists every field the customer form can ask, in three groups.

GroupFieldsSettings
MandatoryLegal name, Peppol ID, Peppol ID scheme, Registration type, Registration number, Country, Address line 1, City, EmirateAlways Required. Every UAE e-invoice needs these, so they cannot be turned off.
Conditionally mandatoryTRN, Issuing authority, Passport countryIf it applies, Everyone or Don’t ask
Optional47 more fields, such as Trading name, Postal code and Contact personDon’t ask, Optional or Required

With If it applies, the form asks for the field only when its rule holds:

  • TRN (the UAE tax registration number): VAT-registered customers and VAT-group members.
  • Issuing authority: the registration type is a trade licence.
  • Passport country: the registration type is a passport.

A Peppol ID and its scheme become optional for a customer whose annual revenue is below AED 50 million.

The Form fields step. Mandatory fields such as Country, City and Emirate show a locked Required setting. TRN, Issuing authority and Passport country are set to If it applies. Trading name is set to Optional and Business activity to Don't ask. The footer reads: On the form: 9 required, 3 if they apply, 1 optional, 46 not asked.
The footer counts what the form will ask.
The Form fields step. Mandatory fields such as Country, City and Emirate show a locked Required setting. TRN, Issuing authority and Passport country are set to If it applies. Trading name is set to Optional and Business activity to Don't ask. The footer reads: On the form: 9 required, 3 if they apply, 1 optional, 46 not asked.

Under Custom fields, choose Add field to ask something that is not a buyer field, such as a cost centre or a copy of the trade licence. Enter the Question, choose an Answer type and say whether it is Required.

Answer typeThe customer enters
TextAny text
NumberA number
Letters and numbersLetters and digits only, with no spaces or symbols
DateA date
Choice listOne of the choices you list
File uploadOne PDF, JPG or PNG file, up to 10 MB
The Custom fields section with two fields: Trade licence copy, a File upload, and Cost centre, a Text field. Both are Optional. An Add field button is at the top right.
Custom fields are asked on every form, after the buyer fields.
The Custom fields section with two fields: Trade licence copy, a File upload, and Cost centre, a Text field. Both are Optional. An Add field button is at the top right.

Field settings and custom fields are locked once you send. Check them now, then choose Next. Back returns to column matching and keeps your form fields.

Choose who gets the form

Who should we email? shows how many customers will be emailed, how many you will confirm yourself, and how many details your customers will add.

In the list, choose what to do for each customer:

  • Email them the form: the customer checks their details and adds what is missing.
  • I’ll confirm myself: no email is sent. You accept the details as they are in your file.

Already in your file shows how much of the form your file covers. Choose See details to list what is there and what the customer will add. If you confirm a customer whose details are incomplete, the missing ones stay empty.

To change several customers at once, select their rows and choose I’ll confirm them myself.

Three cards above the list set how the emails go out:

  • Outlook: where emails are sent from. See Send from your Outlook mailbox.
  • Logo and email: choose Edit to add your logo and change the Subject and Message. The dialog previews what your customer gets. The logo also appears on the form. Reset to standard restores the original wording.
  • Reminders: turn on Send reminders to email customers who have not filled in the form. Set Remind every and Stop after. Reminders stop as soon as a customer submits.
The Choose customers step. Logo and email and Reminders cards sit above a customer list. One customer is expanded to show eight details already in the file and four the customer will add. Desert Rose Interiors LLC is set to I'll confirm myself and the others to Email them the form. The footer reads: We email 7 customers, you confirm 1.
Rows that did not import are listed on this step with the reason.
The Choose customers step. Logo and email and Reminders cards sit above a customer list. One customer is expanded to show eight details already in the file and four the customer will add. Desert Rose Interiors LLC is set to I'll confirm myself and the others to Email them the form. The footer reads: We email 7 customers, you confirm 1.

Choose Send form links. The button shows how many links it will send. In Send the form links, choose how customers get their link:

  • Email them for me: Complyance emails each customer their link.
  • I’ll send them myself: nothing is emailed. Each customer’s link appears in the list for you to copy or open in your own email. Download all links gives you an Excel file for a mail merge.

Under Link works for, choose 1, 3, 7, 14 or 30 days, or Custom… for any number of days from 1 to 30.

Choose Send emails or Create links. Customers you chose to confirm yourself are confirmed at the same moment.

The Send the form links dialog. Email them for me is selected and I'll send them myself is the other option. Link works for is set to 1 day. A note says field settings are locked after this step. The buttons are Cancel and Send emails.
The delivery method and link length you choose here also apply to links you create later in this collection.
The Send the form links dialog. Email them for me is selected and I'll send them myself is the other option. Link works for is set to 1 day. A note says field settings are locked after this step. The buttons are Cancel and Send emails.

Emails go out one after another. A customer shows Sending email until theirs is out.

Follow the replies

The collection now opens as a dashboard. Each tile is a list:

TileWho is in it
Needs reviewCustomers who replaced a key detail from your file. They wait for your decision.
Changed by customerConfirmed customers whose answers differ from your file. There is nothing to decide.
Confirmed, no changesConfirmed with nothing changed, by the customer or by you.
Waiting on customerLink sent or created, no reply yet.
No emailCustomers with no valid contact email. An upload skips rows without one, so this is normally 0.
Email not deliveredThe email bounced or could not be sent.
All customersEveryone in this collection.
A collection dashboard with tiles for Needs review, Changed by customer, Confirmed no changes, Waiting on customer, No email, Email not delivered and All customers. The All customers list shows eight customers with statuses such as Needs review, Confirmed by customer, Confirmed by you and Sent, not opened yet. Waiting customers have copy and email buttons for their form link.
A collection whose links you send yourself. The Form link column has each customer's link.
A collection dashboard with tiles for Needs review, Changed by customer, Confirmed no changes, Waiting on customer, No email, Email not delivered and All customers. The All customers list shows eight customers with statuses such as Needs review, Confirmed by customer, Confirmed by you and Sent, not opened yet. Waiting customers have copy and email buttons for their form link.

Choose a customer to open their record. It shows their answers, the declaration, an Audit trail of everything that happened, and any documents they uploaded. For a customer who has not replied, Email a new link or Get a link to send myself creates a new link. A new link replaces the previous one.

To come back to a collection later, open Buyer data collection and choose it under Previous uploads.

Review the answers that need a decision

Most answers need no review. A customer who fills a gap in your file, or changes a field that is not a key field, is confirmed automatically.

A customer goes to Needs review when they replace a value that was valid in your file for one of these: Legal name, TRN, Country, Customer type or Annual revenue. The list shows the value in your file next to the customer’s answer, with the difference highlighted.

The Needs review list with one customer. The Legal name in the file is Falcon Building Materials LLC and the customer's answer is Falcon Building Materials Trading LLC, with the word Trading highlighted. An Accept button and a more menu are at the end of the row.
The changed part of the answer is highlighted.
The Needs review list with one customer. The Legal name in the file is Falcon Building Materials LLC and the customer's answer is Falcon Building Materials Trading LLC, with the word Trading highlighted. An Accept button and a more menu are at the end of the row.

Decide for each customer:

DecisionWhat happens
AcceptThe customer’s answers replace the values from your file. You are recorded as the verifier.
RejectThe value from your file is kept. The customer shows Rejected · upload kept and is not moved to the Buyers master.
Send backThe customer gets a new form link and answers again.

Open a customer to decide from their record. Press A, R or S, and use the arrow keys to move between customers. The next customer opens after you decide.

A customer record for Falcon Building Materials LLC with the status Needs review. Needs your decision shows the Legal name in the file and the customer's answer. Below are the declaration by Layla Mansour, Accounts Lead, and an audit trail from import to flagged for review. Accept, Reject and Send back buttons are at the bottom.
The record shows who declared the answers and when.
A customer record for Falcon Building Materials LLC with the status Needs review. Needs your decision shows the Legal name in the file and the customer's answer. Below are the declaration by Layla Mansour, Accounts Lead, and an audit trail from import to flagged for review. Accept, Reject and Send back buttons are at the bottom.

To decide for several customers at once, select them in the list. Under What changed, choose a field to narrow the list first. One decision can cover up to 1,000 customers.

Move confirmed customers to the Buyers master

Choose Move to Buyers master. The dialog lists who moves now and who stays in the collection. Check the counts, then choose the Move button, which shows the number of customers.

The Move 2 confirmed customers to the Buyers master dialog. Moves now lists one customer confirmed with no changes and one changed by customer. Stays in this collection lists one that needs review, with a Review first link, and five waiting on the customer. The buttons are Cancel and Move 2 customers.
Only confirmed customers move. You can move the rest later.
The Move 2 confirmed customers to the Buyers master dialog. Moves now lists one customer confirmed with no changes and one changed by customer. Stays in this collection lists one that needs review, with a Review first link, and five waiting on the customer. The buttons are Cancel and Move 2 customers.

Each moved customer becomes a buyer record in Masters, for the country and environment you are working in. The customer code becomes the buyer’s ID. A customer confirmed with no changes is saved as in your file. One who changed their details is saved with their answers.

Know these limits before you move:

  • Moving never changes a buyer that is already in the Buyers master, and moving twice changes nothing.
  • Moving does not look for an existing buyer with the same ID. If you already added that buyer by hand, you get a second record. Check the Buyers catalog for duplicates afterwards.
  • These answers are not saved to the Buyers master: Customer type, Annual revenue, Peppol ID scheme, Issuing authority, Passport country, custom field answers and uploaded documents. They stay in the collection and its export.

To keep everything, choose Download Excel. If the form had a File upload question, Download with documents prepares a ZIP with the Excel file and every uploaded document. Large collections can take several minutes, and you can leave the page while it is prepared. The ZIP stays available for 24 hours.

What your customer sees

The link opens a form that needs no sign-in. It shows your workspace name as the requester, the customer’s name, their customer code and when the link expires. If you added a logo, it replaces the Complyance logo at the top.

The top of the customer form, titled Confirm your details. It says the details are collected on behalf of Acme Trading LLC and lists the customer Gulf Horizon Logistics LLC, customer code C-1002, who requested it and when the link expires. Below, Your customer type offers VAT-registered, VAT-group member, Not VAT-registered and Foreign business.
The form on a phone.
The top of the customer form, titled Confirm your details. It says the details are collected on behalf of Acme Trading LLC and lists the customer Gulf Horizon Logistics LLC, customer code C-1002, who requested it and when the link expires. Below, Your customer type offers VAT-registered, VAT-group member, Not VAT-registered and Foreign business.

The customer chooses their customer type and annual revenue, then works through the sections: Tax identity, Legal registration, Business, Address, Contact person and Additional information, which holds your custom fields. Values from your file are filled in. A field you need and do not have is marked We need this.

The Tax identity section of the customer form with 2 to fill. Legal name and TRN are filled in from the file. Peppol ID and Peppol ID scheme are empty and marked We need this. TIN is filled in from the first 10 digits of the TRN.
Filled-in values come from your file. The customer can correct them.
The Tax identity section of the customer form with 2 to fill. Legal name and TRN are filled in from the file. Peppol ID and Peppol ID scheme are empty and marked We need this. TIN is filled in from the first 10 digits of the TRN.

To finish, the customer enters their full name and job title, confirms that the details are accurate and that they are authorised to provide them, and chooses Submit.

A customer can submit once. After that, the link stops working. To let them change an answer, send the customer back or create a new link from their record.

Customer statuses

StatusMeaning
Sending emailThe form email is waiting to be sent.
Sent, not opened yetThe link was emailed or created. The customer has not opened it.
OpenedThe customer opened the form and has not submitted it.
Confirmed by customerThe customer submitted and nothing needs your review.
Confirmed by youYou chose I’ll confirm myself. The details from your file are accepted as they are.
Needs reviewThe customer replaced a key detail. Decide whether to accept it.
Rejected · upload keptYou rejected the customer’s change. The value from your file is kept.
Email bouncedThe email was sent and came back as undeliverable.
Email not sentThe email could not be sent. Choose Send form links again to retry.
No emailThere is no valid contact email, so no link was created.

Send from your Outlook mailbox

By default, form emails and reminders come from Complyance. To send them from your company’s mailbox, choose Settings on the Outlook card, then Connect Outlook, and sign in with Microsoft.

  • Emails are sent from the connected mailbox at about 30 a minute.
  • An email that bounces is shown on the customer as Email bounced.
  • When you send, you can still choose Email them from Complyance for one collection.
  • If the card says Emails are not being sent. Connect Outlook again in Settings., choose Reconnect. Reminders also wait until you do.

Choose Disconnect to go back to sending from Complyance.

Limits

WhatLimit
CountryUnited Arab Emirates only
File type and size.xlsx or .csv, up to 25 MB
Customers in one file50,000 rows
Header rowWithin the first 10 rows
DuplicatesEach Entity and customer code pair once per file
UploadsEach upload is its own collection. Uploads are not merged, so a customer in two uploads is asked twice.
Custom fields10 per collection. A question can have up to 100 characters.
Choice listUp to 30 choices of up to 100 characters each. The customer picks one.
Customer file uploadOne PDF, JPG or PNG per question, up to 10 MB
LogoPNG or JPG, up to 500 KB
Email wordingSubject up to 150 characters, message up to 2,000 characters
Link length1 to 30 days. The default is 1 day.
RemindersEvery 1 to 30 days, up to 10 reminders per customer. Off until you turn them on. Not sent when you send the links yourself.
Form submissionsOne per link
Changes after sendingField settings and custom fields cannot be changed
Decisions at onceUp to 1,000 customers
ZIP with documentsAvailable for 24 hours

If something goes wrong

Buyer data collection is available for the UAE only.

Select United Arab Emirates in the country switcher, then open the page again.

You are not authorized to view buyer data collection.

Your role cannot create master records. You need the Owner, Admin or User role. See roles.

Upload an .xlsx or .csv file.

Older .xls files are not accepted. Save the file as .xlsx or CSV and upload it again.

The file has more than 50000 customer rows

Split the export into smaller files and upload each one. Each becomes its own collection.

No sheet with a header row and customer rows was found

Make sure the column names are in the first 10 rows and that at least one customer row follows them.

Rows were not imported

The Choose customers step shows how many rows were skipped, and the reason for the first 20.

ReasonWhat to do
Customer code is missingAdd the customer’s code to the row.
Duplicate Entity + Customer codeThe message names the row where the pair first appears. Remove or correct one of the two.
Contact email is missingAdd an email address for the customer.
Contact email is not a valid email addressCorrect the address.

Fix the rows in your export. While the collection is not sent, choose Back until you are on Upload, choose the corrected file and import it again. It replaces the customers in the same collection. After sending, upload the missing customers as a new collection.

The upload was blocked

If the message says the file was blocked by upload checks, contact support and share the reference shown in the message.

An email was not delivered

Open the customer from Email not delivered to see why. Then choose Email a new link to try again, or Get a link to send myself and send it another way. If the address in your file is wrong, send the link to the right address yourself, or correct it in your ERP and upload the customer again.

  • This link is no longer available: the link expired or the form was already submitted.
  • This link is not valid: part of the link is missing, or a newer link replaced it. Each reminder carries a new link.

Open the customer’s record and create a new link.

Next, create or fix a document with the buyers you moved.

Last updated