Import a QIF file into FreeAgent

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

Let's say you have a QIF file, downloaded from your Online Banking, it's called Quicken Interchange Format. Let's say, your Bank provides this QIF file (some Bank provide, some don't) and you select which account, what is the transaction range since the last download. And you download this batch of transactions, it comes as a QIF file. And you can import it into FreeAgent or let's say you exported from Quicken, you want to move from Quicken to FreeAgent. Then you would export from Quicken (better to export each account separately into a QIF file and export just transactions, nothing else). So, FreeAgent is not confused about all this stuff, it is just specifically transactions for the specific account.

Let's say you have a PDF file and you have a ProperSoft PDF2QIF converter. Then you would use the converter and you would get the QIF file from a PDF file. And now you want to upload it into FreeAgent. So, let's try to do that. IMPORTANT: PDF2QIF is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.

First, you need to login into FreeAgent. Then click on 'Banking'.

Import QIF into FreeAgent Step 1: click Banking

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

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

FreeAgent supports OFX, QIF, CSV formats. If you have the format, which FreeAgent doesn't support, let's say PDF format, then you would use ProperSoft converter to convert to QIF and then import here.

Import QIF into FreeAgent Step 3: freeagent supports

Click 'Select a file'.

Import QIF into FreeAgent Step 4: select a file

Look for a sample.qif file.

Import QIF into FreeAgent Step 5: sample qif

Now you have to select which account you want to upload to. In our case, we have a 'Business Checking Account'. We can click 'Guess explanations for my bank transactions', but better to use it later after a few statements, once you categorize or explain few transactions. So it knows how to guess.

Import QIF into FreeAgent Step 6: select account

Click 'Upload Statement'.

Import QIF into FreeAgent Step 7: Upload Statement

The statement with 4 new and 0 existing transactions was uploaded successfully. Click 'Review your transactions'.

Import QIF into FreeAgent Step 8: click Review your transactions

We see 4 unexplained transactions, they are red. In Quickbooks, they call the process "Matching" transactions to Vendor records and expense/income accounts. In FreeAgent, they call "Explaining". So you have some explaining to do after your statement was imported. Click on the transaction.

Import QIF into FreeAgent Step 9: statement with 4 new transactions

Select a 'Category'.

Import QIF into FreeAgent Step 10: select category

Then change the 'Description', if needed and click 'Explain Transaction'.

Import QIF into FreeAgent Step 11: explain transaction

So, now 'Office Costs' is an explained transaction. Continue for all transactions. That is how you avoid data entry, instead of typing and entering the transactions. If you have a file with transactions, you will speed up the process with this import function.

Import QIF into FreeAgent Step 12: categorized transaction

Let's say you realize, that this QIF file was not imported correctly or something wrong with this file, so FreeAgent has a useful function, as 'Undo Last Upload', click it.

Import QIF into FreeAgent Step 13: Undo Last Upload

Whatever you uploaded this time, you can just delete it. Click 'Delete these transactions'.

Import QIF into FreeAgent Step 14: Delete these transactions

So, four bank transactions are deleted. Now you can go back to the converter or go back to your file, how you created and correct the file and then import it, as a new file.

Import QIF into FreeAgent Step 15: 4 Deleted transactions

See this tutorial as a video:

Related articles