Importing and Exporting Clients with the Government Entity Column
You can mark clients from government entities when importing clients from a file, using the Government Entity column, and this column also appears in the clients export file. This guide explains how to prepare the import file, the import and export steps, and the error messages and their solutions.
🛈
Note: The Government Entity column appears only in Saudi accounts where the KSA Electronic Invoice app is activated, and it is used with Business clients only.
Contents
Preparing the Import File
Add the following columns to the clients file for each client from government entities:
| Column | Value |
|---|---|
| Government Entity | نعم or Yes for a government entity, and لا or No for others. If you leave the cell empty, the client is considered not a government entity. |
| Type | Business or 2. A government entity can’t be set for an Individual client. |
| C.R / Unified Number | The contract / registration / license number of the government entity, up to 50 letters or digits, and it can contain / or – or . |
| VAT Number | Optional for government entities. |
🛈
Note: You can write the column name جهة حكومية or Government Entity, and the system recognizes it automatically when mapping the fields.
Steps to Import Clients
- From the main menu, click Clients, then click Import.
- Choose the file in File to Import, then click Next Step.
- In Fields Mapping, make sure the field Government Entity in the System Field column is mapped to the correct column in Corresponding Field in File.
- Click Import.
After the import, a message appears with the number of clients imported or updated, and the number of rows that failed to import.
The value is saved in the Client is a Government Entity checkbox in the client’s data.
Exporting Clients
- Open the Clients List report from Reports.
- View the report, then export it in the format you want.
The exported file contains a Government Entity column with the value Yes or No for each client, and the C.R / Unified Number column contains the contract / registration / license number for government entities.
Error Messages and Their Solutions
| Message | Cause | Solution |
|---|---|---|
| Government Entity can only be set for Business clients | The value of Government Entity is Yes, and the client type is Individual. | Change the type to Business, or set the value of Government Entity to No. |
| Contract / Reg No / License No. must be up to 50 letters, digits, / – or . | The contract / registration / license number is longer than 50 characters or contains characters that aren’t allowed. | Edit the number in the file, then import again. |
Frequently Asked Questions
Why doesn’t the Government Entity column appear when importing or in the export file?
Because the column appears only in Saudi accounts that have activated the app KSA Electronic Invoice.
What happens if I leave the Government Entity cell empty?
The client is imported without being set as a government entity. And when updating an existing client, the government entity mark is removed if it was enabled for it.
Can I import a government entity without a VAT number?
Yes; the VAT number is optional for government entities.
Can I write the client type in Arabic in the file?
No; write Business or 2 in the column Type.
How do I set existing clients as government entities by import?
In the step Fields Mapping, enable the option Update an existing Client with new data. And add to the file the column Type with the value Business next to the column Government Entity; because the system saves the Government Entity value when updating a client only if its type in the file is Business.