Importing customers from Excel
On this page
Downloading the template and selecting the group
Open Customers and use the Import arrow to download Example and Catalog. This guide imports two corporate customers, corrects a rejected row and checks their resulting accounting codes.
Use the template Import sheet, retain all seventeen headings, enter data from row 2 and save as xlsx. Catalog explains fields and lists Countries, Cities, Branches and Ledgers; it is not the upload file.
Name type and contact details
name is the customer name shown in the list. Use a clear name; the corporate example also uses it for the ledger name.
type selects the customer kind. Use corporate for a corporate customer or individual for an individual. Enter the English value; this example uses corporate.
email is optional customer email. phone is optional customer phone; format its cell as text to preserve a leading zero or international prefix.
ref_note is a reference note to identify the customer. Contact details and the note may be left blank when unavailable.
Identification and address fields
national_number is the national ID when needed. passport_number is the passport number. Keep identifiers as text and check them before uploading.
country is the country name from Countries, not its ID or Serial. city is the city name within that country. Check them together because city names may repeat.
region_city is free-text region or district, rather than an identifier from Regions. building_number is a whole building number. address is the street address and its supplementary details.
References branch and accounting codes
customer_id is a reference from your existing customer data. It is not the internal record ID generated by the system.
tax_number is the tax number when applicable. Enter accurate numeric text without separators or symbols and check its length. The catalogue specifies a maximum of 14 digits.
branch is a branch name from Branches, such as Main Branch. The catalogue states that a blank value uses the signed-in user branch.
code is the corporate customer accounting ledger code. ledger_code is an existing ledger code when requesting a previous account link; it differs from the Ledgers ID and customer_id. Leave both fields blank in this new-ledger example and select the group in the import window.
Submitting the file and reading the result
Correcting the rejected customer type
Before uploading again, search for B in Customers and review the accounts to confirm that it was not created. This example used a fresh catalogue download to review Ledgers.
Retrying and reviewing the customers
Checking the accounting codes
In this example, importing corporate with blank code and ledger_code created two ledgers named after the customers. Check Name and Code in Ledgers after downloading a fresh catalogue. The customer number, internal ledger ID and account code are different identifiers.
Sign in to record the lessons you have read. Sign in