Convert QBO files to QIF and import into Quicken

This tutorial shows how to convert a QBO file from your bank or credit card statement to QIF and import into Quicken 2019. We will use QBO2QIF utility.

Step by step instructions for Windows

Follow the steps below for the Windows version, followed by the Mac version.

Make sure you are using the latest version of QBO2QIF. Download it from the QBO2QIF download page. Start QBO2QIF and select a QBO file.

Review transactions before converting, check that dates are correct, have the correct year, deposits and withdrawals are assigned correctly.

Select the QIF Target to match your Quicken version or your accounting software: Quicken 2018+, Quicken 2017, Quicken 2015–2016, Quicken 2014 or earlier, Banktivity, Microsoft Money, NetSuite, MYOB, Reckon, YNAB, Quicken UK, AccountEdge, old Microsoft Money non-US, Quicken 4, Quicken French 2015.

Set the Account Name (must be matched as you have in Quicken) and the Account Type (must be matched as you have in Quicken) to create a QIF file for the right account. Set ‘Output dates’ if applicable.

Click the ‘Convert’ button to create a QIF file.

Confirm the file name and location.

Import created QIF file into Quicken 2019

Now the QIF file is created, let’s switch to Quicken and import created QIF file. Before importing a QIF file make sure to backup your data. To import a QIF file, select ‘File’ — ‘File Import’ — ‘QIF File’, select created QIF file.

For Quicken 2017 or earlier, it is important to select ‘’All Accounts’’. For Quicken 2018 or later, you have to select the actual account.

Then click the ‘Import’ button.

Then click the ‘Done’ button.

Now your data is imported. Review transactions after import.

Step by step instructions for macOS

Make sure you are using the latest version of QBO2QIF. Download it from the QBO2QIF download page. Start QBO2QIF and select a QBO file.

Review transactions before converting, check that dates are correct, have the correct year, deposits and withdrawals are assigned correctly.

Make sure to set the Account Name and the Account Type to create a QIF file for the right account. Set the Date format if applicable.

Select the QIF Target to match your Quicken version or your accounting software: Quicken 2018+, Quicken 2017, Quicken 2015–2016, Quicken 2014 or earlier, Banktivity, Microsoft Money, NetSuite, MYOB, Reckon, YNAB, Quicken 2007 for Mac, Quicken UK, AccountEdge.

Click the ‘Convert’ button to create a QIF file.

Confirm the file name and location.

Import created QIF file into Banktivity

Now the QIF file is created, let’s switch to Banktivity and import created QIF file. Before importing a QIF file make sure to backup your data. To import a QIF file, select ‘File’ — ‘Import transactions’. Then click ‘Import File’ and select created QIF file.

Select a Quicken account to import.

Then click the ‘Continue’ button.

Now your data is imported. Review transactions after import.

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

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