Aantar

Aantar Books

Import Invoices or Bills from Excel

Bring many invoices or bills in at once from an Excel or CSV file — one row per line, every row checked against your customers, vendors, items, accounts and tax codes before anything is posted.

Where: File ▸ Utilities ▸ Import Invoices from Excel… · File ▸ Utilities ▸ Import Bills from Excel…

Import Invoices from Excel and Import Bills from Excel post many invoices or bills at once from a spreadsheet. Every row is checked first: Aantar Books finds each customer or vendor, item, account and tax code in your lists, and shows every problem by its row number. Nothing is posted until the whole file is right, and then every invoice or bill is posted — or none, if one is refused.

Note: The customers, vendors and items must already exist; add them first (or with Add/Edit Multiple List Entries).

Opening it

  • File ▸ Utilities ▸ Import Invoices from Excel… — needs permission to create invoices.
  • File ▸ Utilities ▸ Import Bills from Excel… — needs permission to create bills.

Step by step

  1. Click Download template and save the file. It has the columns in the right order and two sample rows.
  2. Fill it in Excel: one row per line. Rows with the same number are one invoice or bill. Keep a document's rows together.
  3. Save it as .xlsx, .xls or .csv.
  4. Click Choose file… and pick it. Aantar Books reads it and lists each invoice or bill: number, customer or vendor, date, due date, how many lines and the amount before tax.
  5. Fix every problem listed in red (in the file), then Choose another file… to check it again.
  6. When it says ready to import, click Import. The window says how many were imported.

The columns

The first row must hold the headings. The order does not matter, and other columns are ignored.

Invoices

Column What to enter
Invoice No The invoice number. Rows with the same number are one invoice. Leave blank to number it automatically — a blank number with a customer starts a new invoice, a blank number with no customer continues the one above. A number already used is refused.
Customer The customer's name exactly as in the Customer Centre (or their company name). Only on the first row of each invoice.
Date The invoice date: yyyy-mm-dd, an Excel date, or your company's date format. Blank means today.
Due Date Optional. The invoice's terms are the days from the date to the due date.
Item The item's name or its SKU.
Description Optional. The line's description.
Qty The quantity. Blank means 1.
Rate The price of one, before tax.
Tax Code Blank uses the item's own tax, as picking the item on Create Invoices does. A tax code's name (for example GST) or a percentage (5%) uses that tax. Exempt, None or 0 means no tax.
Memo Optional. The customer message.

Bills

Bills have the same columns, with Bill No and Vendor, plus:

Column What to enter
Account For an expense line instead of an item: the expense account's name or number.
Amount The amount of an expense line (or of an item line, instead of Rate).

A bill number already entered for the same vendor is refused, as on Enter Bills.

What is checked

  • The customer or vendor exists, and only one has that name.
  • Each item exists by name or SKU, and only one matches. An item with variations needs its SKU.
  • Each account and tax code exists.
  • Dates can be read, the due date is not before the date, and the date is not in a closed period.
  • Quantities are more than 0 and rates are not negative.
  • The number is not already used.

Invoices are posted unpaid. Receive their payments with Receive Payments; pay bills with Pay Bills.

Messages you may see

Message What to do
Row 4: no customer named "…". Add them first, or correct the name. Add the customer, or spell the name as the Customer Centre shows it.
Row 6: no item named or with the SKU "…". Use the item's exact name or SKU.
Row 7: "…" matches 3 items or variations. Use its SKU. Put the SKU in the Item column.
Row 3: the date is not a date this company reads (use yyyy-mm-dd). Type the date as 2026-10-06, or format the cell as a date.
Row 2: invoice 1001 already exists. The invoice was imported or entered before. Remove those rows.
No heading row found. The first row needs the headings. Start from the template.
Nothing was imported: invoice … was refused — … One invoice could not be saved (the reason follows). Nothing from the file was posted; fix it and import the file again.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.