Skip to content

How do I import business data from a file?

The Business data import workflow posts sales, expenses or transaction lists from a CSV or Excel (.xlsx) export, such as a POS terminal report or another system's export. You set up the columns and accounts once. After that, each new file is checked and grouped, ready for you to review and post.

Create an import

Step 1. Go to Workflows and open the Business data import card.

Step 2. Select the business. Each business shows how many imports it has, or None yet — start your first import. A business whose plan doesn't include workflows is greyed out with the reason shown.

Step 3. On Imports for this company, select Add new.

Step 4. Type a Workflow name you'll recognise — usually the POS terminal or data source, for example "Front-counter POS". Select Create workflow.

A business can have several imports. Each has its own columns, accounts and GST setting, so create one for each source of data.

Set up the import

The setup page opens straight after you create the import. It has three sections.

Basic settings

If the business is registered for GST, choose the GST mode:

Option Use it when
GST inclusive (1/11) The amount in your file includes GST. GST is split out.
GST exclusive (+10%) The amount in your file excludes GST. GST is added on top.
No GST These transactions have no GST.

Unless you chose No GST, choose the GST Payable account that collected GST is posted to. If the business isn't registered for GST, there is no GST choice and nothing is posted as GST.

File format

Step 1. Select Click to upload your data file and choose a CSV or XLSX file. For an Excel file, only the first worksheet is read. The first rows are shown so you can map them.

Step 2. Under Assign columns, select each column heading you need and choose its role: Date, Amount, Description, Reference or Classifier. Date and Amount are required. Use Unassign to clear a column. When both required columns are done, you'll see Required columns assigned.

Step 3. For a CSV file, check the date format:

What you see What to do
Detected: and a format, in green Nothing — the dates were read. Any row that doesn't match is skipped on import.
Could be two formats — please confirm the format below. Choose the right one in Date format.
Couldn't parse the date column. Check the Date column is the right one, or choose the format yourself in Date format. You can't save until you do.

A Classifier is any column that sorts your rows, such as a payment method or register. Assign one only if you want those rows settled to different accounts.

Routing

Choose where the rows post:

  • Default income account — rows with a positive amount post as income here.
  • Default expense account — rows with a negative amount post as expenses here.
  • Default settlement account — the clearing or bank account the transactions settle through.
  • Per-classifier settlement overrides — shown when you've assigned a Classifier column. Choose a different settlement account for any value in it. Leave a value as Use default to use the account above.

Save

Select Save and import. Your settings are saved and the file you uploaded becomes your first import, which opens ready to review. If you didn't upload a file, the button reads Save configuration and you go to the import's history instead.

You can't save until Date and Amount are assigned, all three default accounts are chosen and, unless you chose No GST, the GST Payable account is chosen.

Import your next file

Step 1. On Imports for this company, select the import's name.

Step 2. Drop your file onto Drop a file here, or click to pick one, or select it to choose a file. CSV or XLSX files up to 5 MB are accepted.

Step 3. The import opens for you to check. See How do I review and post a business data import?

What you see What it means What to do
Only .csv and .xlsx files are supported. The file is another type. Export the data as CSV or Excel (.xlsx) and try again.
File is over the 5 MB limit. Try splitting it across two imports. The file is too big. Split it into smaller files, for example by month.
This file's columns don't match the saved mapping. Review the mapping to continue. The file's column headings have changed since you set the import up. See below.

If your file's columns have changed

When a file's column headings don't match the ones you mapped, the setup page opens with that file already loaded. It says This file's columns don't match the saved mapping. Check each column below before saving.

Step 1. Under Assign columns, check each role is on the right column. Reassign any that moved.

Step 2. Check the Date format.

Step 3. Select Save and import. The new mapping is saved and the file is imported.

Change the setup

To change the GST mode, columns or accounts without a new file, select Edit setup on the import's history page, or Setup next to the import on Imports for this company. Make your changes and select Save configuration. The new settings apply to files you import from then on.

Delete an import

On Imports for this company, select the bin icon next to the import, then Delete. If no files were ever imported, it is removed completely. Otherwise it is made inactive and its history is kept. You can't delete it while any of its imports are posted or still need action — the message offers View them so you can unpost, post, reject or delete them first.

Share X LinkedIn Email

Did this answer your question?