Importing data from another system

When migrating to QuickFile from another accounts package you may need to consider how you will bring across the data stored there. This guide will discuss 3 methods for importing data. You can also use our interactive questionnaire here to point you in the right direction.

Unless you have a very new company you don’t want to go back and import every single invoice and bank transaction. Importing Opening Balances is the quickest way to get started on QuickFile. Most accounting applications will allow you to produce a Trial Balance (TB) that can easily be imported to QuickFile.

In short: Method 1 enters your invoices one by one, Method 2 enters your opening balances as a single journal, and Method 3 imports your opening balances from a trial balance CSV file. Let’s take a look at the options.

Prefer to watch?

Watch QuickFile Tutorial: Importing Data from Another System on YouTube

Prefer a video walkthrough? Watch our QuickFile Tutorial: Importing Data from Another System tutorial on the QuickFile Help Guides YouTube channel.

Method 1 : Start using the system from the beginning of your financial year

This method essentially involves entering each individual sales/purchases invoice onto the system one by one, along with the relevant customer/suppliers details. Using this method will allow you to see all the transactions for each individual customer/supplier, along with their individual balances from the start of your financial year. The downside with this method is if you have any significant number of transactions, it will be a slow process.

To save time, you can bring records in from a spreadsheet or bank file instead of keying them by hand. See Importing clients and suppliers, Importing sales and purchase invoices and Importing your bank statement.

Method 2 : Manually enter your opening balances

If you don’t have a great deal of activity on your previous accounts you could just manually enter your opening balances. This goes in as a single journal with multiple lines. You can find the manual opening balance entry form in your Account Settings area.

  1. Click Account Settings on the top menu, then click All settings.

  2. Click Setup your opening balances.

  3. In Journal Name, enter a name for the journal, for example Opening Balances.

  4. In Journal Date, enter the date your opening balances are as at. This is normally the day before the date you start using QuickFile, the same date a trial balance would be taken to (see Step 1 of Method 3).

  5. Optional: click More settings and choose the Opening Balance folder, so the journal is filed with other opening balances.

  6. For each balance, choose the Nominal Code, add a Description (and Notes if you want them), then enter the amount in Debit or Credit. Click the green + to add another line.

  7. Check that the total debits and the total credits are the same.

  8. Click Save Journal Entry.

Important: The total debits and credits must always balance, and every line must have a description.

You can also open this form from the enter it manually here link at the top of the Trial Balance Import page. For more about journals, see Journals.

Method 3 : Import your Trial Balance

This method involves obtaining the Trial Balance or list of account balances from your existing accounting system and uploading the CSV or entering the figures as at the day before you want to start using QuickFile. We have provided guides for obtaining the Trial Balance from the most common accounting systems; follow the step by step guide below for the relevant link.

Step 1. Decide when you want to start using QuickFile from

Depending on whether you’re VAT registered we recommend the following start dates:

For non VAT registered

Unless you’re VAT registered, you should start using the system from the beginning of the month. For example, if you decide to use QuickFile from 1 June 2026 and enter all transactions for sales/purchases onto the system from that date, you will need to obtain your Trial Balance or list of account balances up to the day before, in this example 31 May 2026.

For VAT registered

We recommend that you start from the beginning of a VAT period for a return yet to be submitted. For example, if your VAT period ends on 31 July 2026, we would recommend that you start entering all invoices on QuickFile from 1 May 2026. To achieve that you will need to obtain your Trial Balance or list of account balances up to the day before, in this example 30 April 2026.

To check your VAT status and year end in QuickFile, go to Account Settings > Company settings and look at VAT Registered and Next Year End Date.

Step 2. Export your Trial Balance to CSV

This is a relatively simple process if you’re using accounting software. Follow the guide below for your existing accounting system:

If your system isn’t listed, run a Trial Balance report as at the day before your start date. Make sure it includes all your asset, liability, equity and nominal ledger balances, with an account code, a name, and a debit and credit amount for each line. Then export the report as a CSV file.

Step 3. Import the CSV Trial Balance into QuickFile

Now that you have your trial balance in CSV format, upload it to QuickFile.

  1. Click Account Settings on the top menu.

  2. Click Import Data, then click Import trial balance.

  3. Next to Source, leave Other selected. If your file is a Xero trial balance, choose Xero.

  4. Next to Effective Date, choose the Month Ending month and year your trial balance is up to. This is the day before you start using QuickFile. For example, for a trial balance as at 31 March 2026, choose March and 2026.

  5. Click Choose file and select your CSV file.

  6. Click Upload.

Warning: If you are VAT registered, make sure all purchases and sales invoices have been entered for a complete period. The trial balance figures are not imported into your VAT return, but you can make manual adjustments to the return if required.

You can also open the same page from Account Settings > All settings by clicking Import trial balance, or by clicking Data import wizard and then Import Trial Balance from a CSV File.

Map the columns of your file

After you upload the file, QuickFile shows an extract of it so you can say where each field is. The extract shows every row of your file, including the headings row, and no column is chosen for you.

  1. Next to Nominal Code, choose the column that holds your account codes.

  2. Next to Description, choose the column that holds your account names.

  3. Next to Debit Amount and Credit Amount, choose the columns that hold those amounts.

  4. Click Save.

Map each line to a QuickFile nominal code

On the next page, set the Effective Date (dd/mm/yyyy) to the date your trial balance is as at, for example 31/03/2026. Then map each line of your trial balance to the matching QuickFile nominal code in the Map To column. If a code in your file matches a QuickFile nominal code, it is matched for you. If your old system uses different codes, such as three-digit codes, each line needs matching.

If you want to use a new nominal code rather than the one QuickFile matches, tick New on that line and enter the 4-digit nominal code you want to use.

QuickFile nominal codes follow these ranges:

Nominal codes Type
0000-2999 Assets and Liabilities
3000-3999 Capital and Reserves
4000-4999 Sales
5000-5999 Cost of Sales
6000-6999 Direct Expenses
7000-9999 Overheads

Click Save, then confirm when asked “Are you sure you want to import this trial balance?”.

Check the result

The imported data is saved as a journal. Go to Reports > Journals and look for the journal named Trial Balance import in the Opening Balance folder. Each line has the note “Opening Balance Imported into QuickFile”, and the total debits equal the total credits. Then check your Balance Sheet or Trial Balance report to make sure the figures match your old system.

Important: If your QuickFile account already contains records, the trial balance is added as a journal alongside them. To start again with an empty account, see How do I clear my account?.

Troubleshooting

I see “Warning your trial balance is out by …” or my trial balance doesn’t import correctly.

A common mistake is leaving the totals in the CSV file. Make sure the file you import contains only the account lines, with no totals row (for example a Total line at the bottom, or subtotals for each section). If the totals are included, the file will not import correctly.

Also check that the total debits equal the total credits in your file. If they don’t, QuickFile shows a warning such as this one, with the amount it is out by:

Remove any totals rows, correct the balances in your previous system if needed, export the trial balance again and re-import it.

My bank balance in QuickFile doesn’t match my bank statement after I start.

Check that your trial balance was run as at the day before your start date. If the balance still differs, post a journal that corrects the bank account to the balance on your bank statement, then reconcile the account. See Journals.

My accounting system isn’t listed, for example Wave.

You can still use Method 3. Run a trial balance report as at the day before your start date, export it as a CSV file and import it with Other selected as the Source.

The headings row of my file appears on the mapping page.

The extract shows every row of your file, including the headings row. Choose the columns by their position (Column 1 to Column 4).

I also want my old invoices, clients and suppliers.

A trial balance only brings across account balances. To bring in individual records, see Method 1 above.

Related topics

Moving to QuickFile from another system? These articles cover the next steps.