How to Create a QFX File
QFX is an Intuit Quicken proprietary file format for exchanging financial data with banks and other Intuit applications. The QFX specification is similar to the OFX file format used by financial institutions for exporting data. Banks and financial institutions can create QFX files for their customers if the institution pays a fee to Intuit. However, you can create QFX files by converting Intuit Quicken or QuickBooks QIF files, text files and spreadsheets into the QFX format using a special Excel add-in software tool.
Open Microsoft Excel.
Click “File” and “Import.” Click the “OFX Writer” option to open the add-in. The OFX Writer dialog box opens.
Click the radio button next to the “QIF Format” option in the Data Format section to import a QIF file. Otherwise, click the radio button next to the “Other” option, then click the drop-down box and select the file type for the import. Click the “CSV” option to import a comma separated value text file, or click the “XLS” option to import an Excel spreadsheet into the QFX Writer program.
Click the “Browse” button. A file navigation window opens.
Navigate to and click on the QIF or other data file to import. Click the “Import” button. The file loads. Click “OK.” A second dialog box opens.
Click the radio button next to the application you intend to import the data file to. For example, click the radio button next to “Quicken” to import the resulting QFX file into Quicken.
Click the radio button next to your location. Click “USA” for a USA locale, or click “Canada” or the “UK" if appropriate.
Click the “Use Default BID” check box.
Click the “Account Name” drop-down box and click the name of the financial institution for the file. If the Account Name does not appear in the list, click the “Reset” button, then type the name of the account into the input box.
Click the “Account Type” drop-down box and click on the type of account. For example, click “Checking” to designate a checking account.
Click the “Currency” drop-down box and click on the currency type. Click “USD - US Dollar” for the U.S. Dollar.
Type the “Routing Number" into the Routing Number input box.
Type the “Account Number" into the Account Number input box.
Click the radio button next to “All Available Rows" in the Rows to Export section, to export the entire file.
Click “Continue." The selected file is converted to the QFX format.
Import the QFX file into Intuit Quicken or QuickBooks, or use the file with Microsoft Money.
Tips & Warnings
- The QFX Writer add-in is only available on newer Excel versions.