Question

How to get a QFX file from my bank into quickbooks?

Forum|Forum|7 years ago
December 11, 2018
9 replies
0 views

My bank is no longer providing QBO files, instead when I download my bank transaction data it is a QFX file. How do I get this information into my Quickbooks? I tried an online converter and when I try to import the new QBO file it just crashes Quickbooks.

QuickBooks Desktop

I

IntuitBrooks

.QBO files are required. There are work arounds to make a .QFX file work but they are unsupported.

P

pc22

What are those workarounds?

BettyJaneB

Hi there, @pc22.

Welcome to the Community. Allow me to provide you the workaround in importing a QFX file into QuickBooks Online.

You can use the WebConnect feature. This allows you to download bank transactions from your financial institution and upload them into your QuickBooks. You must download first the transactions from your bank's website and upload it afterwards.

Here's how:

Sign in to your bank's website.
Follow your bank's online process to download your transactions to your computer.
Depending on your bank's available features, choose transactions from specific or multiple accounts, or select a date range for transactions.
Choose a supported file type for the download file.
Make sure that the name of the file you downloaded, and the location you downloaded it to so you can easily find it to upload.

For detailed instruction about this process, please check out this article: How to upload more than 90 days of bank transactions.

I'm confident that these resources will assist you with getting your bank transactions imported into QuickBooks.

Please feel free to let me know how it goes, as I want to make sure that these transactions are imported. Have a most pleasant day.

M

mhawash

Try https://qbo-transformer.herokuapp.com/

D

DaveJT

Awesome thanks. Works well. Not sure about running bank data through an online convertor. :/ @ Intuit. Could you PLEASE update your flagship program to import simple accounting data from my bank downloads? Please??? After how many... decades? Boneheaded. Quickbooks MAC, Desktop version. and NO I don't want to store may data in your online version, with the funky web based feature set, online latency and cloud security issues it entails. GEEZ.

JasroV

Thanks for your sharing your thoughts @DaveJT.

I know how important it is convert your bank data file to QuickBooks. Please know our developers are always working to make our product best for our customers. You can always visit our QuickBooks Product Update page to get the latest news and updates about QuickBooks.

Also, if you want to learn some "How do I" steps in QuickBooks Desktop, you can visit our Help articles page for reference.

As always, please let me know if you have other concerns, I'm always here to help. Have a great day and more success in your business!

F

FJC1

I had the same problem with CapOne no longer downloading QBO files. My work around was to rename the file removing the .qfx and adding .qbo. It worked perfectly.

Adrian_A

I appreciate you for sharing the workaround you used, FJC1.

It's good to know that renaming the file works perfectly on your end.

Rest assured, the idea shared by all of you was forwarded to our development team. They'll review it and may be added to our future updates.

If you have other concerns, please don't hesitate to post here.

E

enter a property tax payment

Renaming .qfx file to .qbo file did "not" work for me.

W

WeOrganize

I have been using Big Red Consulting's CSV to Excel to Web Connect File converter and it has worked wonderfully. I actually have a client that uses Excel to record checks and deposits. I use BRC to upload their data as well. Best $ I've spent for correcting QB's hangup in this area. Thanks BRC!

C

CZ8

This worked for me, and I didn't need to upload files to the web: https://collaboration133.com/converting-qfx-files-to-qbo-files-for-import-to-quickbooks-via-web-connect/887/

Thanks to whomever posted it!

J

Jeremy8

Norton blocks this link as a "known dangerous website".

B

B-radley

You can simply change the file extension from .qfx to .qbo

HOWEVER…as I understand it, banks have to pay a fee to provide a .qbo file for download so if a .qbo is not one of the options available to download either your bank doesn’t offer it at all or not with the type of account you have.

In the .qxf file about 24 lines down there is a bank ID number <INTU.BID>#### where the # represents the bank number, i.e. <INTU.BID>64161 if your bank is not on the list you will get an error when trying to import but it’s an easy fix by just changing the number to one that does work. You can try 64161 and or do a search for “List of INTU.BID”.

Once you have a good number, change the .qfx file extension to .txt and open in a text editor. Scroll down the the <INTU.BID>, change the number and save the file. Change the extension from .txt to .qbo and your good to go. You can double click on that file or go into Quickbook Desktop and follow the directions for importing bank transactions.

Banking>Bank Feeds>Import Web Connect File select your .qbo file and bada bing bada boom!

J

Jeremy8

Tried this and it almost worked. So i saved the qfx file as a text file, changed the <FID> tag from 1412 to 3000 (US Bank to Wells Fargo) and then saved the file as a .qbo file, opened it and it was going to import the transactions but I could not import them into the correct US Bank account. It wanted me to create a new account to import the transactions. I guess I could have done this and then changed the origin bank after the fact but dont want to muck up the books for other bookkeepers in the company by creating a new Wells Fargo account that doesnt actually exist. :( May try again another time.

Fiat Lux - ASIA

@Jeremy8 wrote:
Tried this and it almost worked. So i saved the qfx file as a text file, changed the <FID> tag from 1412 to 3000 (US Bank to Wells Fargo) and then saved the file as a .qbo file, opened it and it was going to import the transactions but I could not import them into the correct US Bank account. It wanted me to create a new account to import the transactions. I guess I could have done this and then changed the origin bank after the fact but dont want to muck up the books for other bookkeepers in the company by creating a new Wells Fargo account that doesnt actually exist. :( May try again another time.

@Jeremy8

Did you try the converter app?

https://www.moneythumb.com/?ref=110

D

dragonflyspring

Solution for desktop version found

Download QFX file as usual for Quicken or else.

Simple change the file extension from .qfx to .QBO works like magic.

- Rename the file

- go to File-> Utilities -> Import -> Web Connect

find newly created .QBO file.

DONE