Bank2QFX: Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to QFX

Easy to use secure solution to review/convert your transactions and import into your accounting software. Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to QFX and import into Quicken 2019, 2018, 2017, (Win/Mac)



What can I do with Bank2QFX (CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to QFX Converter)?

Why should I trust Bank2QFX?

If I need any help with conversion, can you help me?

Can I try before purchasing?

Convert CSV, Excel, PDF, QFX, QBO, OFX, QIF to QFX and import into Quicken 2019, 2018, 2017, 2016, (Win/Mac)

This tutorial shows how to convert a transactions file to QFX format. We will use Bank2QFX utility.

Step by step instructions for Windows

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

Make sure you are using the latest version of Bank2QFX. Download it from the Bank2QFX download page. Start Bank2QFX and select a transactions file (it could be QBO file, OFX file, QFX file, QIF file or PDF file).

Bank2QFX Windows Step 1: select a pdf file

Review transactions before converting, check that dates are correct, have correct year, deposits and withdrawals are in correct places.

Bank2QFX Windows Step 2: Review transactions before converting

Before converting select the QFX target to match your Quicken version or your accounting software: Regular QFX, Quicken 2018+, Quicken 2017, Quicken 2016, YNAB.

Bank2QFX Windows Step 3: QFX target

Set the Account ID (number) and the Account Type to create QFX for the right account. For multiple accounts, use a different account ID for each account.

Bank2QFX Windows Step 4: Account ID and Account Type

For Quicken, set INTU.BID to match your bank or keep the default value. INTU.BID defines bank label shown during import. It has to be from the allowed bank. You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. You have to leave it empty if your bank is not listed, so default Wells Fargo Bank Label will be used.

Bank2QFX Windows Step 5: INTU.BID

Currency should be USD even for non-USD accounts for Quicken US edition. For Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set.

Bank2QFX Windows Step 6: currency

Click 'Convert' button to create a QFX file.

Bank2QFX Windows Step 7: click Convert

Confirm the file name and location.

Bank2QFX Windows Step 8: file name and location, save

Import created QFX file into Quicken

Now the QFX file is created, let's switch to Quicken and import created QFX file. file. Before importing QFX file make sure that account is not connected to online services. Click 'Tools' - 'Account List'.

Bank2QFX Windows Step 9: tools, account list in Quicken

We have to disconnect from online services first. Click 'Edit'.

Bank2QFX Windows Step 10: disconnect from online services in Quicken

Then click 'Online Services' and click on 'Deactivate' button. Then click 'Yes' and 'Ok'.

Bank2QFX Windows Step 11: click deactivate in Quicken

Before importing a QFX file make sure to backup your data. To import a QFX file, select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX.

Bank2QFX Windows Step 12: file import in Quicken

Import into a new account or existing account. Then click 'Import' button.

Bank2QFX Windows Step 13: click import in Quicken

Then click 'Close' button.

Bank2QFX Windows Step 14: one step update summary in Quicken

All transactions are imported here, they showed in the bottom part. You can review transactions and use Renaming Rules if you like. Then click 'Accept All transactions'.

Bank2QFX Windows Step 15: accept all transactions in Quicken

They accepted and listed in Quicken.

Bank2QFX Windows Step 16: review transactions in Quicken

Step by step instructions for macOS

Make sure you are using the latest version of Bank2QFX. Download it from the Bank2QFX download page. Start Bank2QFX and select a transactions file (it could be QBO file, OFX file, QFX file, QIF file or PDF file).

Bank2QFX Mac Step 1: select pdf file

Review transactions before converting. Check that dates are correct, have a correct year (Date), amount, withdrawals and deposits are shown in corresponding columns, check number (Doc/Check#) is assigned.

Bank2QFX Mac Step 2:Review transactions before converting

Before converting the QFX file make sure to set the Account ID (number) to be digits only. If you convert for one account you can leave the default value. If you convert for multiple accounts, use a different account id for each account. Make sure to set the Account Type (if you converting for Credit Card - set CREDITCARD, if you converting for Checking - set CHECKING).

Bank2QFX Mac Step 3: Account ID, Account Type

Currency should be USD even for non-USD accounts for Quicken US edition. For Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set.

Bank2QFX Mac Step 4: Currency

You have to set INTU.BID number to match your bank or use a default value. INTU.BID defines bank label shown during import. It has to be from the allowed bank. You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. Keep default value if your bank is not listed (3000-Wells Fargo or any allowed bank).

Bank2QFX Mac Step 5: INTU.BID

Click 'Convert' button to create a QFX file.

Bank2QFX Mac Step 6: convert

Confirm the file name and location.

Bank2QFX Mac Step 7: Confirm the file name and location

Import created QFX file into Quicken

Now the QFX file is created, let's switch to Quicken and import created QFX file. Before importing QFX file make sure that account is not connected to online services. Right-click - 'Edit' account.

Bank2QFX Mac Step 8: edit an account in Quicken

If you see, for example, Connection Type (Web Connect), it means that it is connected. We have to disconnect from online services first. Click on 'Set up transaction download'.

Bank2QFX Mac Step 9: Set up transaction download in Quicken

Then click 'Options' button.

Bank2QFX Mac Step 10: Options button in Quicken

Select 'Enter transactions manually' and click 'Continue' button.

Bank2QFX Mac Step 11: Enter transactions manually in Quicken

Click 'Finish' button. This way you disconnect from direct online download and now you can import a QFX file into this account.

Bank2QFX Mac Step 12: click finish, disconnect in Quicken

Before importing a QFX file go to settings, clicking 'Preferences'.

Bank2QFX Mac Step 13: click preferences in Quicken

Then click 'Connected Services'.

Bank2QFX Mac Step 14: connected services in Quicken

And uncheck 'Automatically improve the quality of downloaded payee names and categories'. Because it could change your Payee names and assign categories, that are not applicable.

Bank2QFX Mac Step 15: automatically improve the quality in Quicken

In Quicken, backup your data file before importing. To import a QFX file, select 'File' - 'Import' - 'Bank or Brokerage File (OFX, QFX)', select created QFX file.

Bank2QFX Mac Step 16: file, import in Quicken

And select an existing account to import transactions instead 'Add a new Quicken account'. Click 'Continue' button.

Bank2QFX Mac Step 17: select an existing account in Quicken

Now your transactions are imported. You can categorize, review, delete them. They are already inside Quicken.

Bank2QFX Mac Step 18: transactions are imported in Quicken