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

Опубликовано: 21 Октябрь 2024
на канале: ProperSoft Inc.
2,166
4

Access ProperSoft at https://www.propersoft.net/

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

00:00​​ - Download PDF2QFX
00:21 - Start PDF2QFX and select a file with transactions
00:29​​ - Review the transactions before converting
00:40​​ - Set the QFX Target
00:50 - Set the Account ID and Account Type
01:02​​ - Set the Bank INTU.BID
01:53 - Set the Currency
02:17​​ - Convert to QFX file
02:29​​ - Switch to Quicken
02:36 - Backup your data before importing
03:01 - Disconnect from online services before importing
03:43 - Import a QFX file
03:57 - Select the account to import data into
04:33​​ - Review the transactions

Step by step instructions for Windows:

Use ProperSoft PDF2QFX to convert PDF bank and credit card statement files to QFX (Web Connect) format and import into Quicken. Download it and make sure you are using the latest version of the PDF2QFX.

Start PDF2QFX and 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.

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

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

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

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.

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

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

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

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

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

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.

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.

Then click the 'Import' button and click the 'Close' button.

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

You can review transactions. They are now inside Quicken.