Skip to content

Import Wizard ​

The Import Wizard creates many records in one go, for example your 300 items or 80 customers from a spreadsheet. You fill in a CSV file, load it, check the rows on screen, and import.

Before you start

  • Only a Books Manager or System Manager can use the Import Wizard.
  • It works on a computer, not on a phone.
  • It only creates new records. It does not update records that already exist.

What you can import ​

Open Setup > Import Wizard and pick an Import Type:

Always availableWhen inventory is turned on
Sales Invoice, Purchase Invoice, Payment, Journal Entry, Party, Item, Tax Template, Account, Address, Number SeriesStock Movement, Shipment, Purchase Receipt, Location

A good order for a new company is: accounts, tax templates, items, parties, then transactions. A record can only point to another record that already exists, for example an item's tax template.

1. Fill in a template ​

  1. Click Setup > Import Wizard.
  2. Choose the Import Type, for example Item.
  3. Click Save template. Your browser downloads a CSV file such as Item Template.csv, with one column per field.
  4. Open the file in a spreadsheet program, fill in one row per record under the header row, and save it as CSV.

To leave fields out of the template, click More (the ... button in the page header) and then Pick import columns. Required fields cannot be left out.

2. Load and check the rows ​

  1. Click Select file and choose your CSV file.
  2. The rows appear in a grid. Check them before you import.

In the grid you can:

  • click a cell to change its value;
  • click Add row to add a row by hand (you can also build a whole import this way, without a file);
  • click the x at the start of a row to remove it.

Each column has a field selector at the top. If your file did not start from the template, choose the right field for each column, or None to skip the column. The import is blocked while two columns use the same field (Duplicate columns found) or a required field has no column (Required fields not selected).

A cell that cannot be read, such as text in a number column, gets a red border. Point at it to see the problem.

Import Wizard with Import Type Sales Invoice and a file loaded: five rows making two invoices, grouped by the Invoice No values A and B

3. Import ​

  1. Click Import data.
  2. For records that can be submitted, such as invoices and payments, the Submit entries? dialog asks whether to submit them. Click Yes to submit, or No to keep them as drafts you can check first.
  3. Wait while the records are created. A message shows the progress.

If the Cannot import dialog opens, it lists the cells or values to fix. Fix them and click Import data again.

When the import ends, the Import complete dialog shows how many records were created and, for each failed row, why it failed.

ButtonWhat it does
Show meOpens the list of the new records. Shown only when nothing failed.
Fix failedKeeps only the failed rows in the grid, so you can correct them and import again.
DoneClears the Import Wizard for the next import.

To start over before importing, click More and then Cancel. Change file in the same menu loads a different file.

Records with several lines ​

An invoice has an Items table with one line per item. In the CSV file, each line goes on its own row, and rows that belong to the same invoice share the same value in the name column, Invoice No for invoices.

Columns that belong to a table show the table name in brackets, for example Item (Items) and Quantity (Items).

Invoice NoCustomerItem (Items)Quantity (Items)
ACV Maju BersamaSemen 40 kg20
ACV Maju BersamaPasir Beton3
BPelanggan UmumCat Tembok 5 kg2
BPelanggan UmumKuas 3 inch4
BPelanggan UmumPaku 2 inch1

This makes two invoices: A with two items and B with three. Values that belong to the whole invoice, such as the customer, can be on every row or on just one of them.

  • The name column only groups rows. The new invoices are numbered from your number series, for example SINV-1001.
  • A row with an empty name column is skipped.