FreeAgent comes free with a NatWest, Royal Bank of Scotland, Ulster Bank or Mettle business account, which is one reason people move to it from QuickBooks Online. There is no one-click way to bring your QuickBooks history with you today. FreeAgent's own imports cover contacts, opening balances and bank transactions. Past invoices and bills are the hard part. This guide shows the manual way, with FreeAgent's and Intuit's own help pages quoted. Checked 21 Nov 2026.
If you have an accountant, involve them early. FreeAgent's support team "can't help you with this as we're not authorised by HMRC to provide accounting advice."
1. Pick your FreeAgent start date
This is the day you start keeping your books in FreeAgent. Everything before it comes in as opening balances. FreeAgent: "you should only import bank transactions, invoices and bills that are dated on or after your FreeAgent start date."
Pick the first day of an accounting year or a VAT quarter if you can, so QuickBooks closes a whole period.
2. Export everything from QuickBooks Online
QuickBooks has an Export data tool: Settings, then Export data, then Export to Excel. Intuit lists what it covers: "Profit and Loss report, Balance Sheet report, Trial Balance report, General Ledger report, Customer List, Supplier List, and Employee List" (QuickBooks UK help, "Export your data from QuickBooks").
Set the date range so the trial balance is dated the day before your FreeAgent start date. That one report holds every opening balance you need. Also keep the General Ledger for the years you are leaving behind.
3. Import your customers and suppliers
FreeAgent calls both "contacts". Import them before the opening balances, so you can assign money owed to each one.
FreeAgent imports a CSV file with these 14 headers, in this order: First Name, Last Name, Company, E-mail Address, E-mail 2 Address, Business Street, Business Street 2, Business Street 3, Business City, Business State, Business Postal Code, Business Country, Business Phone, Mobile Phone. "The only compulsory fields are either First Name and Last Name, or Company." You can import "a maximum of 1,000 contacts at a time."
QuickBooks gives you the Customer List and the Supplier List separately, each with its own column names (customer name, company, email, phone and billing address). Put both into one sheet, rename and reorder the columns to match FreeAgent's headers, delete any title rows above the headers, and save as CSV. Split the file if you have more than 1,000 contacts.
In FreeAgent: Contacts, then Import Contacts.
4. Import your opening balances
In FreeAgent: Accounting, then Journal Entries, then Opening Balances, then Import Opening Balances. The template has three columns: the FreeAgent category (nominal code), the debit amount and the credit amount.
- QuickBooks account names and numbers are not FreeAgent's category codes. Download FreeAgent's chart of accounts from the same screen and match each line of your QuickBooks trial balance to a FreeAgent category. Add a custom category where nothing fits.
- "Importing a set of opening balances will overwrite any existing opening balances in your account", and you need full (level 8) access.
Unpaid customer invoices and unpaid supplier bills at the start date go in against each contact, so FreeAgent knows who owes what.
5. Bring in bank transactions
Connect a bank feed if your bank has one. FreeAgent: it "enables your bank transactions from the last two years to be imported into FreeAgent automatically overnight each night."
For transactions more than two years old, or a bank without a feed, upload statements from your online banking (OFX, QIF or CSV). A CSV needs three columns in this order and no header row: the date as dd/mm/yyyy, the amount with a minus sign for money paid out, and a description.
Your QuickBooks bank rules and matches do not come across. You explain each transaction again in FreeAgent. Once you have explained some, its Guess feature tries to explain new ones for you.
6. Past invoices and bills
FreeAgent's imports do not cover these. FreeAgent says you can enter "historical sales invoices or bills (supplier invoices) using a third-party integration such as AutoEntry, Dext, Fabio or Zapier." AutoEntry and Dext read invoice and bill documents. Fabio uploads records in bulk from a CSV file you build, and it is pay as you go with a free trial. None of them connects to QuickBooks and copies your records across.
Your choices:
- Keep the history in QuickBooks exports and start fresh in FreeAgent from the start date. The opening balances carry the totals. This is the simplest route.
- Bulk-upload them with Fabio: export invoices and bills from QuickBooks, reshape them into the CSV layout Fabio asks for, and upload it.
- Re-enter open invoices and bills by hand, so you can mark them paid in FreeAgent later.
- For income only, "upload the relevant bank transactions and explain them as 'Sales'" instead of creating invoices.
7. Check the numbers match
FreeAgent: "compare the figures on your trial balance in FreeAgent with the trial balance or report of all your accounts in your previous system. If they match, you've entered all the relevant data."
What does not move with this method
- Invoice and bill history line by line (only through re-entry or a third-party tool)
- Attachments and receipts stored in QuickBooks
- Payroll history
- Bank rules and reconciliations
We are building a tool for step 6
We are building a self-serve tool that copies customers, suppliers, invoices, bills, bank transactions and opening balances from QuickBooks Online into FreeAgent. It does not exist yet. If you want it, join the list and we will email you when it is ready to try.
Sources (read 21 Nov 2026)
- FreeAgent, "A guide to switching to FreeAgent": support.freeagent.com/hc/en-gb/articles/360019910020
- FreeAgent, "Get started with FreeAgent": support.freeagent.com/hc/en-us/articles/4405955565842
- FreeAgent, "Import your contacts" and "CSV file formats for importing contacts": support.freeagent.com/hc/en-us/articles/115001222904 and 115001222864
- FreeAgent, "Import your opening balances": support.freeagent.com/hc/en-us/articles/4411292032018
- FreeAgent, "Format a CSV file to upload a bank statement": support.freeagent.com/hc/en-us/articles/115001222564
- FreeAgent integrations, "Fabio": freeagent.com/integrations/fabio/
- QuickBooks UK help, "Export your data from QuickBooks": quickbooks.intuit.com/learn-support/en-uk/help-article/list-management/export-data-reports-lists-quickbooks-online/L1xleDrLp_GB_en_GB
- QuickBooks help, "Export customer data to Excel in QuickBooks": quickbooks.intuit.com/learn-support/en-global/help-article/import-export-files/export-customer-data-excel/L0ZerVWiO_ROW_en
SKILLMERC is not affiliated with FreeAgent or Intuit.