If you do not have access to Quicken accounting software, your only option to convert (export) Quicken QFX files to PDF format, i.e. Qfx to pdf conversion, would be to get some 3rd party converter utility that supports this particular conversion, for example QFX2PDF. Updated: September 23, 2020. To associate QFX files with this program: 1) Right click a QFX file and select 'Open With' and then 'Choose Default Program' (If 'Open WIth' is not an option, choose 'Open') 2) Select browse,.
This tutorial shows how to convert QFX to CSV/Excel. We will use [QFX2CSV] utility.
We will use a sample QFX file.
This file has four transactions.
You can see how the file looks like, what transactions it has and how the Parser transforms that QFX file to one transaction per line spreadsheet, you can see all these details.
Before converting, you can select which flavor of CSV you would like: Regular CSV will be copied to CSV or Excel file. Or if you have a specific software CSV format, like CSV Quickbooks Online, then fewer columns will be saved, but the file will be compatible with Quickbooks Online. So, Quickbooks Online imports that file without any issues. Or you would import it without selecting columns during import because it will say only columns, that Quickbooks Online needs. Or CSV Xero, which will save an additional reference column, that this software imports.
You can decide, which Date format will be in your CSV file. Like typically Quickbooks Online imports as MM/DD/YYYY or DD/MM/YYYY.
You can set 'Duplicate Payee as Memo when missing' in your QFX file if you like.
Set 'Open after conversion' if you want to open a CSV file after a conversion, using your default application in the system, like Excel.
To complete conversion you just click the 'Convert' button.
Choose a name for your CSV file, you can also change the folder, where the file is saved. And then click 'Save'.
The software tells you to open Xero and import the CSV file.
It shows you how a CSV file looks like: Date, Amount, Payee, Description, Reference, Check Number and how Xero can import those columns in a CSV file.
How To Download Qfx File
If you choose Target, for example, CSV Quickbooks Online, it imports fewer columns. In this case, it will be just Date, Amount and Description.
Related articles
Import created QFX file into Quicken for Windows
When the QFX file is created, switch to Quicken and import created QFX file. file. Make sure that the account is not connected to online services. Click 'Tools' - 'Account List'.
We have to disconnect from online services first. Click 'Edit'.
Then click 'Online Services' and click on the 'Deactivate' button. Then click 'Yes' and 'Ok'.
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. 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.
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. Click the 'Import' button.
Then click the 'Close' button.
All transactions are imported here, they are shown in the bottom part. You can review transactions and use Renaming Rules if you like. Then click 'Accept All transactions'.
They are accepted and listed in Quicken.
Import created QFX file into Quicken for macOS
When the QFX file is created, switch to Quicken and import created QFX file. Make sure that the account is not connected to online services. Right-click - 'Edit' account.
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'.
Then click the 'Options' button.
Select 'Enter transactions manually' and click the 'Continue' button.
Open Qfx File In Pdf
Click the 'Finish' button. This way you disconnect from direct online download and now you can import a QFX file into this account.
Before importing a QFX file go to settings, clicking 'Preferences'.
Then click 'Connected Services'.
And uncheck 'Automatically improve the quality of downloaded payee names and categories'. Because it could change your Payee names and assign categories, that are not applicable.
In Quicken, backup your data file before importing. You can easily roll back or restore your data to the previous state if the transactions are imported incorrectly. To import a QFX file, select 'File' - 'Import' - 'Bank or Brokerage File (OFX, QFX)', select created QFX file.
And select an existing account to import transactions instead 'Add a new Quicken account'. Click the 'Continue' button.
Now your transactions are imported. You can categorize, review, delete them. They are already inside Quicken. There is no category. This category is assigned by Quicken. This is not from the CSV file. QFX files do not have categories. You can change the category. And Quicken will use that choice next time you import.
Related articles