When you create a Mapping for a certain Bank, then you include Account ID and Account Type as part of Mapping. You can also put Account ID (number) as part of Mapping: Output Account ID. For multiple accounts, use a different Account ID for each account. Set the Account ID (number) and the Account Type to create QFX for the right account. You have to leave it empty if your bank is not listed, so the default - Wells Fargo Bank Label will be used. You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. Click the 'Charges/Withdrawals' are positive if expenses are positive on the CSV file.įor Quicken, set INTU.BID to match your bank or keep the default value. The INTU.BID value defines the bank label shown during import. Your credit card file may have expenses positive on your Source file. Select the QFX target to match your Quicken version or your accounting software: Regular QFX, Quicken 2018+, Quicken 2017, Quicken 2016, Quicken 2015, YNAB.Įxpenses must be negative and payments to the account must be positive. Reassign columns to QFX fields if needed.
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 you are using the latest version of. Step by step instructions for Windowsįollow the steps below for the Windows version, followed by the Mac version.
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. Step by Step Tutorial for CSV2QFX Convert CSV/Excel to QFX (Web Connect) and import into Quicken