Import a CSV file into FreeAgent - ProperSoft

Import a CSV file into FreeAgent

This tutorial shows how to import a CSV file with transactions into Online Accounting system - FreeAgent.

You could get that CSV file, created manually, let's say in Excel and then save as CSV, or you could download from your Bank, or you could use ProperSoft converter and you would convert PDF file, let's say you have a PDF file and you convert to CSV, using PDF2CSV. And now you want to upload it into FreeAgent, for example. So, let's try to do that. First, click on 'Banking'.

Import CSV into FreeAgent Step 1: click Banking

Then we have to click 'Upload a bank statement'.

Import CSV into FreeAgent Step 2: click Upload a bank statement

FreeAgent supports OFX, QIF, CSV formats. CSV is called as free form format, you can edit it as you like, as a table, open in Excel, you could have as many columns, as you like, as many rolls, as you like, you could enter the date, as you like. OFX or QIF format is called determined format, it means everything is determined: where the date is, how you supply date, how you supply the description, how you supply the amount and which format is. So, for the accounting system to import that, OFX format is much easier, because it doesn't have to guess where is your data is (because it is a determined format). But the CSV free form format will see how they handle it, let's say Quickbooks Online says that you can import the CSV file, it is the straight table, but allow you to choose which columns for which you want to use, if you have more than one, or three columns, or you have two dates columns.

Import CSV into FreeAgent Step 3: freeagent supports

Click 'Select a file'.

Import CSV into FreeAgent Step 4: select a file

Look for a sample.csv file.

Import CSV into FreeAgent Step 5: sample csv

Now you have to select which account you want to upload to. In our case, we have 'Business Checking Account'.

Import CSV into FreeAgent Step 6: select account

We can check 'Guess explanations for my bank transactions'. Don't check it for now, until we have a couple of statements imported.

Import CSV into FreeAgent Step 7: Guess explanations for my bank transactions

Then we click 'Upload Statement', but there is a problem with our file upload. Let's learn more about it.

Import CSV into FreeAgent Step 8: Upload Statement

If you have the CSV file, that was created by the certain way, but is not supported by the accounting system, use ProperSoft converter, let's say CSV2QFX or Bank2QFX to convert from free form format to determined format.

Import CSV into FreeAgent Step 9: supported formats

Let's say, that you don't want to do that and you still want to import that CSV file. FreeAgent says, that you have to have three columns: column A - date must be in a certain way only, column B - must be the Amount, column C - must be the Description.

Import CSV into FreeAgent Step 10: columns

This is our CSV file. We do have the first roll, as column names. And our dates are in different formats. Let's fix this. This is not a big file. You could have the mistakes here by editing, by typing. You have to get a technique here.

Import CSV into FreeAgent Step 11: csv file

For this simple file - it's fine. You can also use a CSV2CSV converter, that converts CSV or Excel file in free form format into the specific target CSV file, like Quickbooks Online or FreeAgent, or another one. Or you could use CSV2OFX converter and just make it determined format.

Import CSV into FreeAgent Step 12: edited csv file

We fixed dates and layout, so save the changes and go back. Select a CSV file and click 'Upload Statement'.

Import CSV into FreeAgent Step 13: upload a statement second step

Because we follow what they ask for, this is the only way they can do this, that's why a CSV file is imported. Click 'Review your transactions'.

Import CSV into FreeAgent Step 14: click Review your transactions

We have four successfully uploaded transactions. The date 2016-01-21 was typed incorrectly, it is the editional moment, when you edit manually transaction files. So, anyway, we have to explain each transaction in the accounting system.

Import CSV into FreeAgent Step 15: statement with 4 new transactions

Select a 'Category', change the 'Description', if needed and click 'Explain Transaction'.

Import CSV into FreeAgent Step 16: explain transaction

Let's say you realize, that you did many typos, so FreeAgent has a good function, as 'Undo Last Upload', click it.

Import CSV into FreeAgent Step 17: Undo Last Upload

Whatever you imported last time, click 'Delete these transactions'.

Import CSV into FreeAgent Step 18: Delete these transactions

So, four bank transactions are deleted. You would say that it is no good, so let's go back, let's take ProperSoft converter, let's take our transaction file, let's convert to determined format OFX or QIF and then create that OFX or QIF file. Check another tutorial, where you can find how to import an OFX file and FreeAgent doesn't ask anything, it just imports an OFX file quietly and just shows you only that you have to explain the transactions.

Import CSV into FreeAgent Step 19: 4 Deleted transactions

Related articles