Aantar Books
Import Lists from Excel
Bring customers, vendors, items or accounts in from a spreadsheet, match its columns, look over the preview, and import without creating anything twice.
Where: Accountant ▸ Import Lists from Excel…
Import Lists from Excel loads a list from a spreadsheet: customers, vendors, items or the chart of accounts. You see what would be created before anything is, and you can run the same file again safely, because names already in the list are skipped.
Opening it
Accountant ▸ Import Lists from Excel…
Import a list
- Under List, choose Customers, Vendors, Items or Chart of Accounts.
- Click Choose file and pick an Excel (
.xlsx) or CSV file of up to 5 MB. The first row must be the column headings. - Under Match the columns, check how Aantar Books has matched your headings to its fields. It finds them by name, and accepts the usual alternatives (for example Customer, Customer Name or Display Name for Name). Change any that are wrong, or set a column to (none).
- Look over the preview. Each row is one of:
| Status | Meaning |
|---|---|
| New | Will be created. |
| Exists | Already in the list (the same name, or for items the same SKU, or for accounts the same number). It is skipped. |
| Duplicate | Appears twice in your file. Only the first is used. |
| Error | Cannot be imported; the reason is shown, such as no name, an unknown account type, or a name that clashes with another list. |
- Click Import. The new rows are created one at a time. A row that fails is reported and the rest carry on.
The preview heading counts the new rows, for example New 24.
The fields
| List | Fields (bold is required) |
|---|---|
| Customers and vendors | Name, Company, First name, Last name, Email, Phone, Address, Address 2, City, Province or state, Postal code, Country, Tax number |
| Items | Item name, SKU, Description, Sales price, Cost, Tax |
| Chart of Accounts | Account name, Number, Type, Description |
If a required field has no column, Aantar Books says Match a column to that field and does not import.
For accounts, the Type column takes the usual names: Bank, Accounts Receivable, Other Current Asset, Fixed Asset, Other Asset, Accounts Payable, Credit Card, Other Current Liability, Long Term Liability, Equity, Income, Other Income, Cost of Goods Sold, Expense and Other Expense. An item takes the named tax from the Tax column, or the zero-rate tax when the column is empty.
Updating what is already there
For customers and vendors, tick Update the ones already there. Rows that already exist then take the non-empty values from your file instead of being skipped. Empty cells never blank out what is on file.
Running a file twice
Each import carries its own batch id. If the same import is sent twice, the second returns the first result. A second import of the same file after refreshing the preview finds every row existing and creates nothing.
Note: Items are created without stock tracking. Set up inventory quantities with opening stock or an inventory adjustment afterwards.
For invoices and bills, use Import Invoices and Bills from Excel.
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.