Thursday, January 29, 2015

How to Convert Quicken QFX files to QuickBooks QBO files for Import via Web Connect

The files actually have identical structure. There are only three things preventing the import:
  1. Download the file as "Quicken 2004 or Newer (QFX)"
  2. Replace file extension from .qfx to .qbo
  3. In the file, replace <INTU.BID> number with 10308 for BofA. See the link below for other banks.
  4. (This may not be necessary) In the file header replace <FID> number with the same number
  5. Import the file into QuickBooks
QuickBooks tries to validate the financial intitution ID for web connect import and if it is QIF file it fails saying "QuickBooks is unable to verify the Financial Institution information for this download." If you use a valid ID, most likely from a different financial institution, the import will succeed and the only annoyance is that QuickBooks will think the data came from The Bank of America, if you use 10308, or <FID>10898 <INTU.BID>2430 for Chase. You might not have to change FID. Find INTU.BID for you bank here: https://ofx-prod-filist.intuit.com/qb2800/data/fidir.txt
Posted by at

1 comment:

  1. QuickBooks Error Support NumberFebruary 14, 2022 at 9:06 AM

    The blog you present is too knowledgeable. Through QuickBooks, the retail business has become somewhat easier to handle. No more complex pricing, more integrated eCommerce, and managed inventory. But if you get stuck in any of these tasks, our experts are available to solve them for you. Learn the added features of data level permissions, industry-specific report bundles, gross margin by inventory items, vendor returns detail from us.QuickBooks Online Banking Error Code 102

    ReplyDelete

Subscribe to: Post Comments (Atom)