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.
.QBO files are required. There are work arounds to make a .QFX file work but they are unsupported.
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)