Importing clients and suppliers

The Data Import Wizard lets you bring all your clients or suppliers into QuickFile in one go, by uploading a CSV spreadsheet instead of entering them one at a time.

It imports contact details only. To bring in invoices, see Importing sales and purchase invoices.

Prefer to watch?

Watch How to Import Clients and Suppliers in QuickFile on YouTube

Prefer a video walkthrough? Watch our How to Import Clients and Suppliers in QuickFile tutorial on the QuickFile Help Guides YouTube channel.

Before you start

  • A CSV spreadsheet with one client or supplier on each row and a headings row at the top.
  • A Company Name for every row.

How do I prepare my CSV file?

Your CSV file can contain any combination of the columns below. Include only the columns you have data for, in any order.

Client column Notes
Company Name Required.
Address Line 1, 2 and 3
Town/City
Postcode
Country ISO Code For example GB.
VAT Number
Account Number Your own reference for the client. See the note below.
Contact First Name If you include contact details, supply all three together.
Contact Surname If you include contact details, supply all three together.
Contact Email If you include contact details, supply all three together.
Contact Telephone
Trading Style ID

Here is an example of a CSV file for clients, shown as a table. The first row holds the headings:

Company Name Address Line 1 Town/City Postcode Account Number Contact First Name Contact Surname Contact Email Contact Telephone
Acme Plumbing Ltd 1 High Street Leeds LS1 1AA ACC-001 Jo Smith jo@example.com 0113 496 0000
Brightside Cafe 22 Mill Lane York YO1 7AB ACC-002

Tip: Use the same names as the drop-downs for your headings, for example Town/City rather than Town. QuickFile then maps those columns for you. Columns that do not match are left for you to set on the mapping screen.

Important: Avoid commas in your spreadsheet values to prevent problems.

Please note: If you map the Account Number column for clients, QuickFile links your invoices to a client by its account reference. If no account reference is supplied, it uses the client name instead.

Where do I find the import page?

  1. Click Account Settings on the top menu.

  2. Click Import Data, then click Import clients.

Alternatively, you can go to Account Settings > All settings and click Data import wizard. This opens the Data Import Options page, where you can choose Import Clients or Import Suppliers.

How do I upload my CSV file?

  1. On the Import Client Records page, click Choose file and select the CSV file on your computer.

  2. Click Upload.

How do I map the columns?

After the upload, QuickFile shows a short preview of your file with a drop-down above each column. Use the drop-downs to match each column of your spreadsheet to a QuickFile field.

  1. Check the Mandatory fields shown at the top. A green tick means that field is mapped. Fields with a dashed outline are required only as a set.

  2. Leave Ignore the first row in the CSV file ticked if your file has a headings row. It is ticked by default.

  3. For each column that contains data, choose the matching field from the drop-down above it. Leave other columns as –.

  4. Click Save to import your clients.

Please note: Only map the columns that contain data.

After you click Save, QuickFile shows a confirmation of how many clients were imported.

Will I create duplicate clients or suppliers?

You do not need to worry about creating duplicate client or supplier profiles. QuickFile includes built-in duplicate prevention for imports.

How do I import suppliers?

The steps are the same, but choose Import suppliers from the Import Data menu. Only Company Name is mandatory on the supplier mapping screen.

The supplier drop-downs offer: Company Name, Address Line 1, 2 and 3, Town/City, Postcode, Country ISO Code, VAT Number, Contact First Name, Contact Surname, Contact Email, Telephone and Web Address. There is no Account Number column for suppliers.

Troubleshooting

I see “There is a problem with your mappings. Please note that all the optional mandatory fields (dashed outline) must be supplied collectively.”

The contact fields work as a set. Make sure Contact First Name, Contact Surname and Contact Email are each mapped to a column, then click Save again.

I see “There is a problem with your mappings. Please map all the mandatory fields.”

Map one of your columns to Company Name, then click Save again.

A heading in my CSV was not mapped automatically.

Choose the matching field from the drop-down above that column. Headings that match the field names exactly, such as Town/City, are mapped for you.

My clients’ addresses are missing after I import invoices.

Importing invoices uses the client name only. Import your clients first, with their addresses, then import the invoices. See Importing sales and purchase invoices.

The supplier reference is not what I expected.

The supplier mapping screen has no Account Number column, so a supplier reference cannot be imported.

Related topics

Moving to QuickFile from another system? Start with Importing data from another system for the whole picture.