Upload bank transactions

Here's how to record all your bank transactions accurately in FreeAgent by uploading statements from your online banking.

The quickest and easiest way to do this is to export your bank statement from online banking, upload it into FreeAgent, and then explain all the transactions. You can also upload bank transactions manually.

1 Export a statement from online banking

Firstly, you'll need to go into your online banking account and export a statement – FreeAgent supports a range of bank statement formats. If you get stuck with exporting the data then you need to speak directly to your bank.

When you're exporting, make sure that you've included the correct dates for your statement. If you've already input any transactions into FreeAgent make sure that you start from the day after the last transaction's date, if you haven't then you might want to go back as far as your FreeAgent start date. FreeAgent will aim to spot any duplicate transactions and ignore them.

Information required in FreeAgent

You need to have your bank account and sort code entered into FreeAgent for the account for which you're going to upload transactions.

2 Import a statement into FreeAgent

Select Banking, and then the bank account for which you're going to upload a statement - select 'Upload Statement'.

banking screen - select upload statement

Alternatively, choose 'Upload a Statement' from the Quick Links menu on the Overview screen. If you use this option, FreeAgent will ask you to choose which bank account to upload to.

FreeAgent overview screen - choosing upload a statement from the quick links menu

Once you've exported your statement from your online banking system and saved it to your computer in the correct format, use the Browse here option to select the file you've just saved and 'Upload Statement'.

3 Guessing transactions

If you want FreeAgent to guess which transactions belong in which category, by looking at transactions you've previously uploaded, then check the Guess box.

upload a bank statement - check the box for FreeAgent to guess which transactions belong in which category

You've uploaded your statement - What next?

Unexplained transactions

FreeAgent uploads the file and gives you a message to say how many unexplained transactions there are.

If this is a business bank account, you'll see the number of unexplained transactions on the list of bank accounts under the graph.

bank accounts summary - drop-down menu of accounts

You'll also see warnings in various places throughout the software, such as here on the profit and loss account, if you have unexplained transactions on a business bank account.

profit and loss account - banking data warning

If the account is set as personal then FreeAgent will not monitor unexplained transactions.

Once you've uploaded your transactions, the next step is to explain them.

If your upload doesn't work successfully, then please contact us for help, by emailing support@freeagent.com

What if I've uploaded the wrong statement?

You can undo the last upload.

Did you find this article useful?

We're glad to hear that!

...and thanks for taking the time to feed back, it's appreciated.

We’re sorry to hear that. Would you like to...

Contact our support team

Our friendly, experienced support team are on hand to help - just email us at support@freeagent.com

Send us some feedback...

We'd love to hear your feedback about this article - please email details to support@freeagent.com