Convert CSV/Excel to QFX - Import into Quicken 2018 Starter Ed. for PC
Download ProperConvert at https://www.propersoft.net/
This tutorial shows how to convert a CSV file from your bank or credit card statement to QFX (Web Connect) and import into Quicken 2019 Starter Edition. We will use the CSV2QFX utility.
00:00 - Download CSV2QFX
00:36 - Start CSV2QFX and select a file with transactions
01:10 - 'Charges/Withdrawals' option
02:28 - Set the Date Format
04:27 - Set the Bank INTU.BID
07:30 - Set the Account Type and Account # (number)
08:50 - Convert to QFX file
08:59 - Switch to Quicken and import a QFX file
09:19 - Select the account to import data into
10:15 - Review and accept all transactions
10:42 - Move the transactions to the 'Checking' account
12:10 - Create a 'Credit Card' account and import a QFX file (with the same Account ID)
13:33 - Move the transactions to the 'Credit Card' account
Step by step instructions for Windows:
ProperSoft CSV2QFX converts CSV to QFX ready to import into Quicken 2018 for PC. Download it and make sure you are using the latest version of the CSV2QFX.
Start CSV2QFX and select a CSV 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. Reassign columns to QFX fields if needed. Select the QFX target to match your Quicken version or your accounting software: Regular QFX, Quicken 2018+, Quicken 2017, Quicken 2016, Quicken 2015, YNAB.
Expenses must be negative and payments to the account must be positive. Your credit card file may have expenses positive on your Source file. Adjust CSV Mapping if needed. Click the 'Charges/Withdrawals' are positive if expenses are positive on the CSV file.
Set the date format if applicable.
For Quicken, set INTU.BID to match your bank or keep the default value. The INTU.BID value defines the bank label shown during import. It has to be from the allowed bank.
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.
You can also put Account ID (number) as part of Mapping: Output Account ID.
When you create a Mapping for a certain Bank, then you include Account ID and Account Type as part of Mapping. So when you change Mapping, your CSV file will have to be mapped this way, and Account Type and Account ID have to be used as well.
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. To import a QFX file, select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX file.
Import into a new account or existing account (disconnect the account before importing).
Then click the 'Import' button.
Then click the 'Close' button.
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'.
They accepted and listed in Quicken.
You need to disconnect the account before importing from direct download to import QFX files into that account. For example, let's say you have another account. Click 'Tools' - 'Add Account'.
Let's say you have a Checking account. Click 'Advanced Setup'.
And you don't want to mess up your existing setup and connection. Click on 'I want to enter my transactions manually'.
You can review transactions here, like your special separate place and then you select the transactions, click first one - hold Shift Button - click the last one.
Then right-click - 'Move transactions'.
Move transactions to the 'Checking' account and click 'Ok'. For example, let's say you have another one 'Credit Card' account. Click 'Tools' - 'Add Account' - select 'Credit Card' - 'Add Manual Account' - click 'Next' - 'Finish'.
Convert again: click the 'Convert' button - create a new QFX file - import sample.qfx file.
Select 'File' - 'File Import' - 'Web Connect (.QFX) File', select created QFX file. We didn't change the Account Name. You can select transactions, move them to one of two accounts or your existing account. Click the first one - hold Shift Button - click the last one. Then right-click - 'Move transactions'.
Just move your transactions to another account. This way you keep all those things unchanged and you have all your transactions. Select the account and click 'Ok'.
Now transactions under the 'Credit Card' account.