How to import a client’s opening balances

This article explains how to import a client’s opening balances into FreeAgent as part of the onboarding process.

Please note that you won't be able to import opening balances into a client's account if they have an unincorporated landlord account.

Before you get started

You can download our opening balances template and then fill in the required columns for each opening balance that you'd like to import for your client. Alternatively, you can create your own .CSV file to import into your client’s account.

You can also download a chart of accounts to view a list of all the available categories in FreeAgent and create custom categories if you need to.

Please note that importing a set of opening balances will overwrite any existing opening balances in your client’s account.

1. Switch to the client’s account

Log in to your Practice Dashboard and select the ‘My Clients’ tab in the ‘Clients’ area. Select ‘Switch to’ beside the relevant client to access their account.

Switch to client.png

2. Navigate to the client’s ‘Opening Balances’

Navigate to the ‘Accounting’ tab at top of the screen and select ‘Journal Entries’ from the drop-down menu.

Screenshot showing the 'Accounting' menu with 'Journal Entries' highlighted

From the 'Journal Entries' screen, choose 'Opening Balances' from the drop-down menu.

Screenshot 2023-03-31 at 16.26.23.png

3. Import the client’s opening balances

Select ‘Import Opening Balances’.

Screenshot 2023-03-31 at 16.29.53 copy.png

You'll be prompted to download our opening balances template.


You can also download a chart of accounts to obtain the category reference numbers in FreeAgent that you’ll need for the opening balances template.


Choose 'Select a file' and select the file you wish to upload from your computer.

Screenshot 2023-04-27 at 11.12.47 copy.png

Once you’ve selected the relevant file, select ‘Upload and review’.

4. Review the opening balances

FreeAgent will attempt to match the imported categories on the .CSV file with the relevant categories in FreeAgent. Please note that the names of the imported categories will need to match the names of the available categories in FreeAgent for them to be guessed. You can download a chart of accounts to view a list of all the available categories in FreeAgent.

You can change the ‘FreeAgent Category’ for each imported category by selecting the arrow next to the entry and choosing the appropriate option from the drop-down menu.

Screenshot 2023-04-27 at 11.27.10.png

To add additional opening balances, select ‘Add Another’ and enter the relevant information.

Screenshot 2023-04-27 at 11.28.24.png

To remove any of the opening balances, select the cross to the right of the relevant imported categories.

Screenshot 2023-04-27 at 11.29.19.png

5. Import the opening balances into the client’s account

Select ‘Import Opening Balances’ to complete the process. Alternatively, you can select ‘Cancel without importing’ to abandon the process without importing the opening balances.

Screenshot 2023-04-27 at 11.30.23.png

If you need to edit your client’s opening balances in FreeAgent, you can do so by switching to their account and following the instructions in this article.

Did you find this article useful?