To create a basic CSV file to upload to FreeAgent, you’ll need to include three columns in the following order and format them as described below:
Column A - date: use the date format dd/mm/yyyy
Column B - amount: formatted as 'number' to 2 decimal places. This column includes all bank transactions, money paid in and out of the business bank account. Transactions for money paid out should have minus signs (-) in front of them.
Column C - description: include the invoice reference or a brief description.
Check your CSV file
Once you’ve created a CSV file in the format outlined above, check:
you haven’t included a header row
the date format is dd/mm/yyyy
you've used a single column for the transaction amounts (column B) that contains both money paid out and money paid in
there are no commas in your amounts columns
you haven't included any quote marks (")
each description is on a single line with no carriage returns
the file is saved with the extension .csv (not .xls or .xlsx)
FreeAgent is registered with the Financial Conduct Authority under the Payment Services Regulations 2017 (register no. 799763) for the provision of account information services.
Registered in sunny Scotland No. SC316774 - One Edinburgh Quay, 133 Fountainbridge, Edinburgh, Scotland, UK EH3 9QG