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.
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.
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.
This is a completely worthless response. The question is not about how to download web connect supported files. It IS about how to import transactions from financial institutions that ONLY support obsolete QuickBooks formats like IIF and QFX or Excel CSV files . These same institutions usually offer a paid monthly version that does work with QuickBooks.
Please answer the real question. How can users import transactions into QuickBooks from no longer supported by QuickBooks file formats or from csv files?
Nice to see you here, @KenV.
Thanks for adding a reply on this thread and for clarifying the concern. I'm here to provide additional information on how to download bank transactions into QuickBooks.
While my colleague@BettyJaneB provided you with one of the supported file to upload bank transactions, the CSV files is also a great idea if you're using QuickBooks Online.
To avoid receiving an error when uploading this file, your CSV file must be formatted correctly. You can look into the following article for the steps: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/How-to-import-bank-transactions-using....
Please note that each bank formats its CSV files differently, so importing a CSV file may not be possible for every financial institution.
If your bank doesn't support CSV files but offers Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX), you can try to import your data and then upload more than 90 days of bank transactions through Web Connect. You may refer to the above detailed steps provided by my colleague.
On the other hand, if you're using QuickBooks Desktop for Mac, you may import transactions through WebConnect and DirectConnect only. I'll leave you with this article for the steps: https://qblittlesquare.com/2012/04/online-banking-updating-your-register-2/.
You've got this. This information should help you with the importing. Let me know how things go and if you have questions about this info or anything else in QuickBooks. Enjoy your day.
Was there ever a response given for this question because I am having the same problem. How do you get a QFX file into Quickbooks Desktop?
Thanks for looping in, NickPace.
I'm here to help you get the QFX file into QuickBooks Desktop. Let's get started.
The QFX file is also known as a WebConnect file. However, this format is only supported in QuickBooks Online. While in QuickBooks Desktop, the supported format is the .qbo file.
You will first need to convert the QFX file into .qbo file to import the transactions into the desktop version.
To download web connect files:
You can get more details in this article: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/Import-web-connect-qbo-files/m-p/1858....
If you need more help with importing bank transactions in QuickBooks Desktop, please let me know. Have a great rest of your day.
I had the issue with one of my banks where it offers a quicken (.QFX) file and not quick books (.QBO). I opened both files with Notepad and saw they used similar tags. So I just saved the file as a .QBO file and gave it a shot to import. Seemed to work fine for me. I think that is also what RoseMarjorieA is saying too.
I would suggest making a back up prior to experimenting with this technique.
Hello there, @DJC.
Appreciate you for posting your experience here in the Community. It will surely help other users who encounter the same issue. Please know that you're always welcome to post if you have any other concerns about your QuickBooks service. The Community team will always here to help you out.
Wishing you and you business continued success. Have a good one.
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!
I used the info in this link and i was able to download my US bank transactions to QB (which only allow quicken downloads or a monthly service fee to connect to QB directly)
I used the information in the following link to download my US Bank transactions to QB for free. ( which only allow for quicken downloads or pay a monthly fee to connect directly to QB)
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.
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.
It's great to hear you found the answers you were looking for here in the Community, dianachismar. You're always welcome if you ever need a helping hand again in the future. Take care.
I get annoyed at your answers (Quickbooks support) and your fake interest in solving this extremely easy to fix issue on your end that I,and many others, have been asking for for more than 10 years. The conversion site that I listed above adds one single line tot he qfx file and renamed the file extension. So your devs can fix this in their sleep. You will never fix it, though, because for some reason it does not help your business in any way.
Thanks for following up on this thread. The Development Team views each case and tries to resolve them as quickly as possible. That's one reason why the Community is so great; for helpful posts like yours that can resolve this type of issue through a different route.
I'm genuinely glad this worked for the customer and that this space is used to communicate problem-solving resources.
If there's anything you need, please feel free to comment below.
RE: I get annoyed at your answers (Quickbooks support) and your fake interest in solving this extremely easy to fix issue on your end that I,and many others, have been asking for for more than 10 years.
Intuit doesn't see this as an issue to fix. They set it up this way on purpose, and they charge banks for the right to create files for QB and Quicken, independently. Except that QB Online breaks that rule. For some reason that is OK.
For a quick and easy solution to convert OFX and QFX files to QBO files, and one that will also clean up the payees in the OFX file for an easier import into QB, see our BRC OFX Cleaner
RE: Please answer the real question. How can users import transactions into QuickBooks from no longer supported by QuickBooks file formats or from csv files?
To import transactions using older QuickBooks, you can import them using an IIF file. If your bank offers Excel or CSV download files, you can likely use them with the BRC IIF Transaction Creator .
I tried this but it didn't work. It tells me that QB can't do it and I should contact my financial institution (that is clueless)...any more ideas?