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
- Click Download template and save the file. It has the columns in the right order and two sample rows.
- Fill it in Excel: one row per line. Rows with the same number are one invoice or bill. Keep a document's rows together.
- Save it as .xlsx, .xls or .csv.
- 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.
- Fix every problem listed in red (in the file), then Choose another file… to check it again.
- 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
- Create Invoices
- Enter Bills
- Add/Edit Multiple List Entries
- Closing date and year-end
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.