Aantar

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

  1. Under List, choose Customers, Vendors, Items or Chart of Accounts.
  2. Click Choose file and pick an Excel (.xlsx) or CSV file of up to 5 MB. The first row must be the column headings.
  3. 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).
  4. 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.
  1. 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.