Import QBO into Kashoo: convert QBO to OFX

Kashoo imports OFX files. Convert your QBO file to OFX first, then import it. Read the full Kashoo import guide.

load a QBO file in ProperConvert

What is a QBO file

QBO is OFX with extra fields for QuickBooks, so the date, amount, payee, memo and transaction ID all carry over. Convert it when you need another format for your app or version. Check the account type, and that credit card amounts have the signs you expect.

What is an OFX file

OFX (Open Financial Exchange) is a standard format for bank data. Many accounting apps import it. It holds the date, amount, payee, memo, check number and a transaction ID, along with the account ID and type. More about OFX.

Why convert QBO to OFX

QBO is OFX with extra fields for QuickBooks, so other apps may refuse it. OFX is the most widely accepted bank format, with named fields and a transaction ID on each row, so an app can skip rows it already has.

Before you import: check the account in Kashoo

Kashoo keeps your data online, so there is no company file to back up. Check that the bank or credit card account exists and look at what is already imported for this period.

Step by step: convert QBO to OFX

  1. Download, install and start ProperConvert. The trial is free.
  2. Open your QBO file.
  3. Review the transactions to see how the app read your file. Check that the dates are correct, and that expenses are negative and deposits (payments to the account) are positive. The "Change +/-" button reverses the signs for the whole file, for bank and credit card accounts alike.
  4. Set the OFX settings below.
  5. Click Convert, then confirm the file name and location.

Set the OFX output settings

In the QBO/QFX/OFX tab on the right sidebar, set the file type to OFX and select OFX All apps as the OFX target, then set:

See all OFX settings.

Import the OFX file into Kashoo

  1. Log in to Kashoo and click Banking.
  2. Select the bank or credit card account.
  3. Click Browse, select the OFX file, and click Upload.

Then categorize the transactions:

  1. Select Add Expense.
  2. Choose the supplier and the expense account.
  3. Click Add Statement, and continue for all transactions.

See the Kashoo import guide for more.

Kashoo OFX questions

How do I remove imported transactions?

If you don't want certain transactions, or you imported the wrong statement, click Remove Unmatched Rows. The unmatched imported transactions are removed.

Related Kashoo conversions