Importing sales and purchase invoices

If you have a spreadsheet containing sales or purchase invoices, you can import them into QuickFile as a CSV file from Account Settings > Import Data. QuickFile matches the client or supplier to your existing records, or creates a new one when there is no match. You can import a maximum of 250 invoices at one time.

Prefer to watch?

Watch How to Import Sales and Purchase Invoices in QuickFile on YouTube

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

Before you start

  • Your invoices saved as a CSV file, with no more than 250 invoices in the file.
  • A value in each of the four required columns: for sales invoices, Issue date, Client name, Description and Total gross amount; for purchase invoices, Receipt date, Supplier name, Description and Total gross amount.
  • The VAT rate as a whole number, for example 20, not 20%.
  • For paid invoices, a Paid date and a bank nominal code on every paid row. See How do I find a bank nominal code? below.
  • If you include contact details on sales invoices, the first name, surname and email together on each row.
  • Special characters such as commas or hyphens removed from your description fields, as they can harm the CSV format.

Tip: Before you import sales invoices, you can add your payment terms, bank details and notes as defaults in Account Settings > Invoice customisation, so they are added to the invoices when they are created. You can change them afterwards if you need to. See Customising your invoice design.

What columns can my sales invoice CSV contain?

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

Sales invoice column Required? Notes
Issue date Required. The date of the invoice, for example 01/11/2026.
Client name Required. QuickFile matches this to an existing client, or creates a new client when there is no match.
Description Required. What the invoice is for.
Total gross amount Required. The invoice total including VAT.
Invoice number Optional. If you leave it out, QuickFile generates one. Rows that share an invoice number are combined into one invoice (see below).
Currency Optional. A three-letter code such as GBP. If you leave it out, GBP is assumed.
Exchange Rate Optional. If you leave it out for an invoice that is not in GBP, QuickFile uses the daily spot rate.
Purchase ref Optional. A purchase order or other reference for the invoice.
Sales nominal code Optional. If you leave it out, 4000 is used.
Term in days Optional. The number of days the client has to pay. If you leave it out, QuickFile uses a default.
VAT rate Optional. Enter a whole number such as 20, not 20% or 0.2. If you leave it out, the standard rate is assumed for VAT-registered accounts.
VAT amount Optional. If you leave it out, QuickFile works the VAT out from the VAT rate.
Notes Optional. Notes for the invoice.
Paid date Optional. For paid invoices. If you leave it out, the invoice is treated as unpaid. Use it together with Paid bank account nominal code.
Paid bank account nominal code Optional. The bank account the payment went into. Use it together with Paid date.
Account Reference Optional. If you map this column, QuickFile links each invoice to a client by its account reference. If no account reference is supplied, it uses the client name.
Item Quantity Optional. The number of items. For example, a total gross amount of 100.00 with a quantity of 5 gives a unit price of 20.00.
Client contact first name Optional. Supply the first name, surname and email together, or none of them.
Client contact surname Optional. Supply the first name, surname and email together, or none of them.
Client contact email Optional. Supply the first name, surname and email together, or none of them.
Client address Optional. The client’s address.

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

Issue date Invoice number Client name Description Total gross amount VAT rate
01/11/2026 INV-1001 Acorn Design Ltd Website design 120.00 20
02/11/2026 INV-1002 Brightside Cafe Menu printing 60.00 20

Please note: Enter the VAT rate as a number, not a decimal or a percentage. For example, 20.00% becomes 20.

How do I open the import page?

  1. Click Account Settings, then click Import Data.

  2. Click Import sales invoices or Import purchase invoices.

Alternatively, click Account Settings > All settings, then click Data import wizard. This opens the Data Import Options page, where you choose the sales or purchase invoice import.

How do I find a bank nominal code?

You need a bank nominal code for every paid invoice in your file. To find the code:

  1. Click Reports, then click Chart of accounts.

  2. Click Assets and Liabilities to open it.

  3. Find your bank account and note its code, for example 1200 for Current Account.

How do I upload my CSV file?

  1. Click Choose file and select your CSV file.

  2. Click Upload.

The page for purchase invoices works the same way, without the green multi-line box.

How do I map the columns?

After you upload, QuickFile shows an extract of your CSV file with a drop-down above each column. Use the drop-downs to say which field each column holds.

  1. Check that every mandatory field in the Mandatory fields list shows a green tick. Headings that match a field name are mapped for you.

  2. For any column that was not mapped, choose its field from the drop-down above it. Leave a column as – if you do not want to import it.

  3. Leave Ignore the first row in the CSV file ticked if your first row holds headings.

  4. For sales invoices only: tick Mark all unpaid invoices as sent if you do not plan to send the imported invoices from QuickFile.

  5. Click Save. Allow a few minutes for larger imports to complete.

When the import finishes, QuickFile shows how many invoices were imported, with a link to view them. You can also find them under Sales > Show all sales.

Please note: Imported unpaid sales invoices are saved with the status DRAFT. Tick Mark all unpaid invoices as sent to save them as SENT without sending them.

Tip: Use the exact field names from the column tables in this article as the headings in your CSV file. QuickFile then maps those columns for you. The match is not case-sensitive, but a heading with extra characters, such as “Supplier Ref.” with a full stop, is not matched.

How do I import multi-line invoices?

If you want to create invoices with multiple line items, include an Invoice number column and link your line items together using a common invoice number.

In the following example, 2 invoices will be created. Rows 3 and 4 will be combined into a single two-line invoice totalling £180.

Please note: The row in your CSV file with the first instance of an invoice number is used to identify the client information, dates and so on. Any further rows with a common invoice number must still include the minimum required fields, but only the amounts, quantity (if applicable) and descriptions are used to add the extra lines to the new invoice.

What columns can my purchase invoice CSV contain?

The purchase invoice import works in the same way as the sales invoice import. Your CSV file can contain any combination of the columns below. The four required columns are in bold.

Purchase invoice column Required? Notes
Receipt date Required. The date on the supplier’s invoice, for example 05/11/2026.
Supplier name Required. QuickFile matches this to an existing supplier, or creates a new supplier when there is no match.
Description Required. What the purchase is for.
Total gross amount Required. The invoice total including VAT.
Supplier ref Optional. The supplier’s invoice number or reference.
Currency Optional. A three-letter code such as GBP. If you leave it out, GBP is assumed.
Exchange Rate Optional. If you leave it out for an invoice that is not in GBP, QuickFile uses the daily spot rate.
Term in days Optional. The number of days you have to pay. If you leave it out, QuickFile uses a default.
VAT Total Optional. The VAT amount on the invoice.
VAT Rate Optional. Enter a whole number such as 20, not 20% or 0.2.
Purchase nominal code Optional. If you leave it out, 5000 (General Purchases) is used.
Paid date Optional. For paid invoices. If you leave it out, the invoice is treated as unpaid. Use it together with Paid bank account nominal.
Paid bank account nominal Optional. The bank account the payment was made from. Use it together with Paid date.

Click Save when the mandatory fields are all ticked. The purchase screen has no contact fields and no Mark all unpaid invoices as sent tick-box.

Please note: As with sales invoices, enter the VAT rate as a number, for example 20, not 20% or a decimal.

Troubleshooting

A heading in my CSV was not mapped automatically.

The heading does not match a field name exactly. The match ignores capital letters but not other characters, so “Supplier Ref.” with a full stop is not matched to Supplier ref. Choose the field from the drop-down above the column, or correct the heading in your CSV file.

A mandatory field shows a red cross instead of a green tick.

Map a column to that field using the drop-down above the column. Paid date and the paid bank account nominal code are required only as a set: if you map one, map the other.

Related topics

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