Skip to main content
All CollectionsFinancial Accounts and Connections
How to download QIF or QFX files from my bank
How to download QIF or QFX files from my bank

Learn about the steps to download QIF or QFX from specific banking institutions.

Yzza avatar
Written by Yzza
Updated over a week ago

Every bank and credit card site is different. Below is a compilation of some of the most popular banks that allow you to export your data if you prefer to do it manually, or if your bank does not allow for transactions to be imported into accounting softwares.

If your bank isn't listed but you know how to download a QIF or QFX, please email support@lessaccounting.com with the steps so we can add them to this list. You will be a hero to all your fellow bank customers!

American Express Credit Cards

  1. Select “Download to Quicken/Quickbooks” from the  the “Statements & Activity” tab

  2. Click either Quicken (for a QFX file) or QIF (for QIF file) by “VIEW/DOWNLOAD”

  3. Select the date range you’d like to download, then click the “Download” button to save to your computer.

Bank of America

  1. Go to the Bank of America online statement that you want to download and import.

  2. Click the Download link at the top of your screen.

  3. On the Statement Download screen choose the statement period you wish to download and select the appropriate QIF file type.

  4. Click "Create Download File."

  5. You will get a message window from your browser. Click the "Save File" button.

  6. This brings up a "Save As" box (similar to the "save as" function in MS Word and Excel). Choose the directory where you want to save the file (e.g. c:\download).

  7. Choose a file name. Any file name will work, but make sure that the extension is ".qif". For example you could use: statement.qif or account.qif. (This is similar to saving a MS Word file as ".doc" or an MS Excel file as ".xls")

Bank of Hawaii

  1. From the Accounts menu, click Download banking transactions.

  2. Select the account for which you want to download information from the Account list.

  3. Click the calendar icon by the To and From date fields to select the dates you want to include from the calendar window. You can also enter the date directly in the field MM/DD/YY format. Please note that you can only download 45 days or 500 transactions at a time.

  4. Click the QIF option to begin download of your file.

Bank of Oklahoma

  1. Click the Accounts tab, then Download from the top navigation bar within Online Banking.

  2. Select an account, date range, and download type. Please see instructions on the download page to avoid downloading duplicate transactions.

  3. Click "Download" to begin the download process. This will allow you to use Web Connect technology to download information to your PC.

  4. Depending on your browser, you will be asked what you want to do with the download file. Select to just save the file (either as a QIF or QFX).

BBVA Compass

  1. Navigate to Account Details, then Advanced Search

  2. Filter by the dates you want to download

  3. Scroll to the bottom and select "Comma Delimited." This will download a CSV.

Capital One

  1. Log in on a laptop or desktop

  2. Click on View Account

  3. Click on Download Transactions

  4. Choose either QIF or QFX for File Type

  5. Choose the date range you wish to import

Capital One 360

  1. Sign in to capitalone360.com with your Customer Number or Saver ID and PIN

  2. Select the account you would like to download

  3. Click the ‘Download’ button on the 'Transactions' tab

  4. A ‘File Download’ dialog box will appear. Choose where to save the file on your computer to begin download.

Chase Bank

  1. Click the “My Accounts” tab

  2. On the left, click on “See more choices” under “I’d like to...”

  3. Click “Download account activity”

  4. Select “Download Now (no charge)”  then the “Continue” button

  5. Select the account, date range then Quicken QIF or Intuit Quicken Web Connect QFX for the software format

  6. Click the “Download Activity” button to begin download.

CitiBank

  1. Go to the "Account Activity"

  2. Click on the link to "View/Download" your statement.

  3. Choose QFX or QIF for the file format.

Comerica Web Banking

  1. Select the Export option from the menu.

  2. Select the QIF or QFX option from the drop-down list of available options.  Click here to see the what that screen looks like. (You can also export to CSV and then convert into QIF by following these instructions.)

  3. Use the calendars to select the Start Date and End Date for your export.

  4. Select one or more Locations you wish to export.

  5. Select one or more Accounts you wish to export.

  6. Click the Begin Export button.

  7. Select whether you would like to Open the file, Save it locally to your PC, or Cancel the export.

Discover Credit Cards

  1. Select the "Account Activity" tab.

  2. Select the statement you want to download from the "Activity Period" drop-down list.

  3. On the upper-right side of your statement, click on "Download."

  4. Download the .QFX file

  5. Save it to Desktop.

First National Bank

  1. With your bank account open, click on Transaction History Menu on the left side of the screen

  2. Click on Search > Custom

  3. Activate debit and credit

  4. Update From Date and To Date with desired date range, click Search

  5. Click on Download and download in QIF format.

  6. If format downloaded is CSV, convert your CSV to QIF here

PayPal

  1. Go to Reports, and then Activity Download

  2. Select your custom date range

  3. Select "Quicken - $USD Only (.qif)" under Format

  4. Click Create Report

PNC Bank

  1. Navigate to "My Account" then "Account Activity"

  2. Select the account you want to view

  3. In the "Posted Transactions" table header you'll see the option to select the file type to export. Choose .QIF or .QFX.

Regions Bank

  1. In the main navigation select "Accounts"

  2. Then select "Download to Desktop Software"

  3. Select a format (.QFX) and select the account you want to export

  4. Select time frame

  5. Click "Submit"

Southwest Airlines Visa Card

  1. On the right column, select "Manage Accounts" it's at the bottom.

  2. Find "Download Activity"

  3. Follow the next steps, be sure to select "all accounts" if you have multiple cardholders.

  4. Select "QIF" or "QFX" as your file format.

TD Bank (Business Direct)

  1. Navigate to the specific account. Be sure the "Account History" tab is selected.

  2. Filter transactions, scroll to the bottom, look for the Download drop-down selection below the table of transactions.

  3. Select "QIF" or "QFX" as your file format.

US Bank

  1. From the U.S. Bank Internet Banking "Download Transaction Data" page, select the start and end date for the transactions you wish to download. (If you arrive at the "Download Transaction Data" screen from an account page, the Start Date will automatically be the End Date of your last download request. You can override the Start Date by entering a new date. To avoid duplicate or missing transactions, ensure that you are not skipping or repeating dates from previous downloads.)

  2. Select the "Quicken for Macintosh" option from the "For this Software" drop-down menu.

  3. Click the "Download" button.

  4. You will get a dialog box that gives you several options, including save to disk or open file from its current location. Select the "Save this file to disk" option.

USAA Bank

  1. Go to your Account Summary page in USAA Money Manager.

  2. Click the "I Want To" drop-down menu and select "Export."

  3. Select the transactions you want to download.

  4. Click "Export."

Did this answer your question?