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

Rethinking the notion of API non-functional requirements.

PreSaga: 09/11/21 Progress Report

RMI (Remote Method Invocation) Java

Billy: how VictoriaMetrics deals with more than 500 billion rows

Dodging the danger with thrusters

Here’s why I converted my blog site to become a PWA (Progressive Web App)

Top 10 Must-Know SQL Queries For Data Analysis

Long Live MySQL: Good Old MySQL Should Be Rejuvenated

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

The differences between static and dynamic libraries

LOOP CONTROL STATEMENT IN PYTHON

Why Linux still isn’t the Default Gaming OS

Character Encoding