Knowledge Base Getting Started Frequently Asked Questions

How to import accounting data into FreeAgent

This article explains how to import accounting data into FreeAgent if you’ve been using another software package.

Please note that the information in this article applies only to customers whose businesses are already trading and who have been recording their accounts in another software package.

For advice on extracting data from other software packages, please refer to your software provider.

Before you start

If you haven’t already done so, sign up for FreeAgent and set up your account.

Choose a FreeAgent start date

Your FreeAgent start date is the date from which you're going to start keeping your books in FreeAgent. Your choice of date will depend on how long your business has been trading. If you’ve been trading for less than a year, you might decide to start keeping your books in FreeAgent from the start date of your business. If you’ve been trading for longer, you might choose the start of the most recent accounting year.

Screenshot_2021-02-24_at_16.20.53.png

You will enter your FreeAgent start date when you sign up but if you need to change it you can do so within FreeAgent. Navigate to the drop-down menu in the top-right corner of the screen, select ‘Settings’ and then select ‘Accounting Dates’.

Record your opening balances

You will need to record your opening balances as at your FreeAgent start date. Be sure to include:

  • The balance of all your bank accounts
  • Balances due to the business by your customers
  • Balances owed by the business to suppliers

Screenshot_2021-02-24_at_16.41.32.png

Importing your data into FreeAgent

Bank transactions

You can import your bank transactions into FreeAgent automatically by setting up a bank feed.

If the bank feed is connected via Open Banking then you can import transactions dating back two years. This means that if your FreeAgent start date is within the past two years, you can import all the transactions from this date onwards.

If your bank account is with a challenger bank such as Monzo, Starling or Revolut then you can set up an integration, which will function in a similar way to a bank feed. You may be able to import historic transactions, depending on which challenger bank you use. Please refer to the specific instructions for each integration for details.

If a bank feed isn't available for your bank, or you need to import historic transactions that are outside the scope of your bank feed, you will need to either upload bank statements or enter transactions manually.

After your bank transactions have been imported or uploaded, you will be able to view them in the ‘Banking’ area of FreeAgent, where you can explain them

Screenshot_2021-02-24_at_16.11.41.png

Once you’ve started explaining transactions, FreeAgent’s Guess feature will attempt to explain your transactions automatically. Guess is enabled by default for Open Banking bank feeds, but you will need to enable it manually for challenger bank feed integrations.

Contacts

There are several ways to import your contacts into FreeAgent, depending on the software you’re currently using to maintain your contacts. For full details, see the instructions in the following articles:

Your imported contacts will appear in the ‘Contacts’ area of FreeAgent, which you can access by selecting ‘Contacts’ at the top of the screen.

Screenshot_2020-12-28_at_11.13.15.png

Projects

If you’ve been using Basecamp to manage your projects, you can import your Basecamp project data into FreeAgent.

Your imported projects will appear in the ‘Projects’ area, which you can access by selecting the ‘Work’ drop-down menu at the top of the screen and selecting ‘Projects’.

Screenshot_2020-12-31_at_17.02.36.png

Historic expenses and mileage

Before importing this data, it’s a good idea to familiarise yourself with the difference between an expense, a bill and a bank payment in FreeAgent.

If you have lots of historic expenses or mileage to import into FreeAgent, you can upload them in bulk by using a template. For full details on how to do this, see the instructions in the following articles:

After your expenses and mileage have been imported, you’ll be able to review them in the ‘Expenses’ area of FreeAgent, which you can access by selecting the ‘My Money’ drop-down menu at the top of the screen and selecting ‘Expenses’.

Screenshot_2020-12-30_at_08.57.38.png

Sole traders with no staff can access the ‘Expenses’ area by selecting the dedicated ‘Expenses’ option at the top of the screen:

Screenshot_2020-12-30_at_07.34.16.png

Historic sales invoices and bills

If you have historic sales invoices or bills to import into FreeAgent, you can use a third-party integration such as AutoEntry or Fabio to import the data. Alternatively, you can import the relevant bank transactions and explain them as ‘Sales’.

If you use a third-party integration to import bills, the data will appear in the ‘Bills’ area of FreeAgent, which you can access by selecting ‘Bills’ at the top of the screen.

Screenshot_2020-12-04_at_16.13.09.png

Imported invoices will appear in the ‘Invoices’ area, which you can access by selecting the ‘Work’ drop-down menu at the top of the screen and then choosing ‘Invoicing’.

Screenshot_2021-02-24_at_16.17.03.png

Did you find this article useful?