Import a QBO file into FreeAgent

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

You could get that QBO file from your Online Banking or you could create it, using ProperSoft converter, let’s say you have a PDF file and you convert to QBO, using PDF2QBO converter. And now you want to upload it into FreeAgent, instead of typing your data. So, let’s try to do that. First, you need to login into FreeAgent. Then click on ‘Banking’.

Then we have to click ‘Upload a bank statement’.

FreeAgent supports OFX (QBO files are extended OFX files, so if FreeAgent supports OFX, it supposes to support QBO, as well), QIF, CSV formats.

Click ‘Select a file’.

Look for a sample.qbo file.

Now you have to select which account you want to upload to. In our case, we have ‘Business Checking Account’. We can click ‘Guess explanations for my bank transactions’, but we will use it next time, once we imported one of two statements and categorize some Payees.

Click ‘Upload Statement’.

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

As with any Online accounting system (for example, Quickbooks Online, FreeAgent), you have on your QBO file the Payee names in a certain way, your Bank provides this way or you have this converted from the file. Those Payee names may not match what you have in your accounting system and for sure there are no categories, provided on the OFX file or QBO file because of those transactions from your Bank (Bank doesn’t know about your accounting system, how you categorize Home Depot or whatever, that Vendor is). This is your part because only you know what was spent on. The accounting system can help you later to automate this process, but first, you have to categorize the transactions. So, look for this expense transaction. Click on the transaction. FreeAgent calls it “Explain”, Quickbooks calls it “Matched”. And different accounting systems have different names for this process of categorizing.

Select a ‘Category’.

Then change the Type and the ‘Description’ to something that means in your accounting system and click ‘Explain Transaction’.

So, now ‘Office Costs’ is an explained transaction. Continue for all transactions.

Let’s say you realize, that you did many typos or this is the incorrect imported file, so FreeAgent has a good function, as ‘Undo Last Upload’, click it.

Whatever you imported last time, click ‘Delete these transactions’.

So, four bank transactions are deleted. It is very important when you are starting or making some conversions, let’s say you are using the converter from one format to another and you realized, that imported something wrong, some fields are not as they should be and then you could do undo easily with this accounting system.

Originally published at https://www.propersoft.net.

--

--

--

www.propersoft.net — need to import transactions, but the file format is not supported? Try ProperSoft converters.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

[HTB] Buff — Writeup

Flutter and the “Where’s my ConstraintLayout?” dilemma

Tips For Beginner Maintainers of Open Source Projects

2018 — Tech Predictions: Cloud, Containers, AI, and more

Raising Productivity: Distributed Autonomous Web Development Teams

Setting Up your Metamask with Unmarshal Custom RPC

Copy API data to Azure SQL Database using Azure Data Factory

Quick guide to minikube set up on local machine

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sergiy Tytarenko

Sergiy Tytarenko

www.propersoft.net — need to import transactions, but the file format is not supported? Try ProperSoft converters.

More from Medium

Analyzing Decadal Natural Disaster Data

Using Machine Learning in field of Insurance

Data Moshing: A Gameplay(?)Journal

“My Experience with problem solving so far”