Convert PDF files to QFX and import into Quicken (PDF2QFX)

This tutorial shows how to convert a PDF file from your bank or credit card statement to QFX (Web Connect) and import into Quicken.

Use the ProperConvert app to convert PDF to QFX. Other formats are supported as well.

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 PDF2QFX. Download it from the PDF2QFX download page. Start PDF2QFX and select a PDF file.

PDF2QFX Windows Step 1: select a PDF file

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

PDF2QFX Windows Step 2: review transactions before converting

Make sure to select the QFX Target to match your accounting software: Regular QFX, Quicken 2018+, Quicken 2017, Quicken 2016, YNAB.

PDF2QFX Windows Step 3: QIF Target

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

PDF2QFX Windows Step 4: Account ID and Account Type

Make sure to set INTU.BID number to match your bank or use a default value. The INTU.BID value defines the 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 the default value if your bank is not listed (3000-Wells Fargo or any allowed bank).

PDF2QFX Windows Step 5: INTU.BID

Currency should be USD even for non-USD accounts for the Quicken US edition. For the Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. If you have another currency, you have to use another converter, for example, a PDF2QIF converter. IMPORTANT: PDF2QIF is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.

PDF2QFX Windows Step 6: currency

Click the 'Convert' button to create a QFX file.

PDF2QFX Windows Step 7: click Convert

Confirm the file name and location.

PDF2QFX 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. Before importing a QFX file make sure to backup your data. You can easily roll back or restore your data to the previous state if the transactions are imported incorrectly.

PDF2QFX Windows Step 9: backup and restore in Quicken

Before importing the QFX file make sure that the account is not connected to online services.

PDF2QFX Windows Step 10: tools, account list in Quicken

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

PDF2QFX Windows Step 11: edit Account in Quicken

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

PDF2QFX Windows Step 12: deactivate online services in Quicken

After disconnecting the account from online services, you can import a QFX file. To import a QFX file, select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX file.

PDF2QFX Windows Step 13: file, import, web connect in Quicken

You can select 'Create a new account' or you can select 'Link to an existing account to import transactions'. If you are disconnected from online services, that account will be shown on the list. You may choose to keep online services connected and import into a new account if you have something temporary to import. You can import in that account, and then move transactions from that account to another account. So this way you will keep the existing account connected to online services and you don't have to connect it back later.

PDF2QFX Windows Step 14: link to an existing account in Quicken

Then click the 'Import' button.

PDF2QFX Windows Step 15: click import in Quicken

Then click the 'Close' button.

PDF2QFX Windows Step 16: one step update summary in Quicken

Now your data is imported. You can accept all transactions.

PDF2QFX Windows Step 17: accept all transactions in Quicken

You can review transactions. They are now inside Quicken.

PDF2QFX Windows Step 18: review transactions in Quicken

See this windows tutorial as a video:

Step by step instructions for macOS

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

PDF2QFX Mac Step 1: select a PDF file

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

PDF2QFX Mac Step 2: review transactions before converting

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).

PDF2QFX Mac Step 3: Account ID and Account Type

Currency should be USD even for non-USD accounts for the Quicken US edition. For the Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. If you need to import for non-USD dollars account to use another converter, for example, PDF2CSV converter, that creates CSV Mint file and imports it into Quicken and then moves transactions from that account into non-USD dollars account. IMPORTANT: PDF2CSV is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.

PDF2QFX Mac Step 4: currency

You have to set INTU.BID number to match your bank or use a default value. The INTU.BID value defines the 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 the default value if your bank is not listed (3000-Wells Fargo or any allowed bank).

PDF2QFX Mac Step 5: INTU.BID

Click the 'Convert' button to create a QFX file.

PDF2QFX Mac Step 6: click Convert

Confirm the file name and location.

PDF2QFX Mac Step 7: confirm 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 a QFX file backup your Quicken data file. You can easily roll back or restore your data to the previous state if the transactions are imported incorrectly.

PDF2QFX Mac Step 8: save a backup in Quicken

Before importing the QFX file make sure that the account is not connected to online services. Right-click - 'Edit' account.

PDF2QFX Mac Step 9: edit checking settings 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'.

PDF2QFX Mac Step 10: click set up transactions download in Quicken

Then click the 'Options' button.

PDF2QFX Mac Step 11: click Options in Quicken

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

PDF2QFX Mac Step 12: click enter transactions manually in Quicken

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

PDF2QFX Mac Step 13: account added, finish in Quicken

To import a QFX file, select 'File' - 'Import' - 'Bank or Brokerage File (OFX, QFX)', select created QFX file.

PDF2QFX Mac Step 14: file, import in Quicken

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

PDF2QFX Mac Step 15: select an existing account in Quicken

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

PDF2QFX Mac Step 16: data imported in Quicken

See this tutorial as a video:

Related articles