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 a video walkthrough? Watch our How to Import Sales and Purchase Invoices in QuickFile tutorial on the QuickFile Help Guides YouTube channel.
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.
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.
Click Account Settings, then click Import Data.
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.
You need a bank nominal code for every paid invoice in your file. To find the code:
Click Reports, then click Chart of accounts.
Click Assets and Liabilities to open it.
Find your bank account and note its code, for example 1200 for Current Account.
Click Choose file and select your CSV file.
Click Upload.
The page for purchase invoices works the same way, without the green multi-line box.
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.
Check that every mandatory field in the Mandatory fields list shows a green tick. Headings that match a field name are mapped for you.
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.
Leave Ignore the first row in the CSV file ticked if your first row holds headings.
For sales invoices only: tick Mark all unpaid invoices as sent if you do not plan to send the imported invoices from QuickFile.
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.
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.
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.
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.
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.
Moving to QuickFile from another system? Start with Importing data from another system for the whole picture.