cancel
Showing results for 
Search instead for 
Did you mean: 
gnocchi
Level 3

Importing a local QBO file that does not require connecting to financial institution

Hello!

 

Happy Tax Season everyone, unless you get into a QB issue ;-). I've got an issue similar to what is posted here, but more concerning.

https://quickbooks.intuit.com/learn-support/en-us/banking/problem-with-webconnect-qbo-file/00/116593...

 

All my QBOs have all my banking data locally -no need to connect to my financial institution - and when I try to import through Utilities > Import > Web Connect Files, I get the window in the attachment. I'm running Quickbooks Desktop Pro 2020.

 

Can I be wrong in assuming that everyone is being pushed toward an online version? I will really appreciate it if you can help me as I'm going to have to ask for an extension. Kudos though to the support community including Intuit as they've always been fast and helpful in responding.

Cheers, 

Marty

 

 

 

Solved
Best answer April 07, 2024

Best Answers
BigRedConsulting
Community Champion

Importing a local QBO file that does not require connecting to financial institution

Intuit has been doing this for about 20 years, has been shutting off connected features and services when the version-year of QuickBooks is about three years old.

 

One solution for the bank feeds feature is to download OFX files from your bank or credit card provider and then convert them to IIF files and then import the IIF files (which Intuit doesn't shut off).

 

The files are in completely different format. Our OFX/QFX/QBO to IIF Converter, an Excel add-in, can convert them for you. It includes a free trial mode so you can see if it works for you.

 

It handles all three 'flavors' of OFX files, and so it even works when your financial institution doesn't support QuickBooks special 'QBO' OFX file variant.

View solution in original post

13 Comments 13
Ethel_A
QuickBooks Team

Importing a local QBO file that does not require connecting to financial institution

Hello there, @gnocchi.

 

After May 31, 2023, access to add-on services for QBDT for Windows 2020, including payroll services, will be discontinued. Once effective, your connected bank accounts can no longer pull up your latest transactions.

 

That said, I'd suggest upgrading your QBDT to a compatible version so you can continue importing your bank transactions.

 

Moreover, you may want to know about the QuickBooks Desktop service discontinuation policy and how it affects your service. Read this article for more information: QuickBooks Desktop Service Discontinuation Policy.

 

Furthermore, I'll share this article to learn about the features included in the QBDT 2023 release and how you can utilize them to your company's benefit: What’s new in QuickBooks Desktop 2024.

 

Feel free to get back to us if you have any other questions about the upgrade. We're always right here to help you.

4Gal
Level 11

Importing a local QBO file that does not require connecting to financial institution

@gnocchi 

Does your bank provide data in csv format?

gnocchi
Level 3

Importing a local QBO file that does not require connecting to financial institution

Hi,

 

Indeed, the bank already lets me download all transactions in QBO format (and CSV).

I don't need to connect to the financial institution at all as I'm just locally importing into QB desktop.

 

Thank you,

 

Marty

4Gal
Level 11

Importing a local QBO file that does not require connecting to financial institution

@gnocchi 

You can use an importer tool as a workaround. It's a $199 one time license. You can purchase it thru a partner and get $100 cashback.

https://get.transactionpro.com/qbd

 

BigRedConsulting
Community Champion

Importing a local QBO file that does not require connecting to financial institution

Intuit has been doing this for about 20 years, has been shutting off connected features and services when the version-year of QuickBooks is about three years old.

 

One solution for the bank feeds feature is to download OFX files from your bank or credit card provider and then convert them to IIF files and then import the IIF files (which Intuit doesn't shut off).

 

The files are in completely different format. Our OFX/QFX/QBO to IIF Converter, an Excel add-in, can convert them for you. It includes a free trial mode so you can see if it works for you.

 

It handles all three 'flavors' of OFX files, and so it even works when your financial institution doesn't support QuickBooks special 'QBO' OFX file variant.

Lisa-E-CPA
Level 1

Importing a local QBO file that does not require connecting to financial institution

Are you guys legit? I'm completely frustrated with Intuit & QuickBooks. I have QuickBooks Accountant Desktop 2021 that I use for 5, count 'em, 5 clients, including my own business. For exactly ONE of those clients, I download bank and credit card transactions monthly. I am totally pissed off that Intuit is forcing us long-time users to QuickBooks Online--or we can choose to stay with the QuickBooks Enterprise edition, for which a one-seat license is more than $1,000 per year for a subscription! I already get raped on my tax software, about which I have no choice, but I'm not sitting still for this. I'm going to continue to use my Accountant Desktop 2021 until it dies. Will your workaround software work with QuickBooks Accountant Desktop 2021, and Excel for Microsoft 365? If so, I have no problem paying the $99 first year subscription fee/$79 each year thereafter. I'm running Windows 11 Pro. I've been considering retiring--and this latest ridiculousness from Intuit is the last straw. Unless I can find a legitimate, reliable workaround. Thanks so much!!

4Gal
Level 11

Importing a local QBO file that does not require connecting to financial institution

@Lisa-E-CPA 

You can still use your QB Desktop 2021 for good or upgrade to QB Desktop 2024 Accountant Plus for 5 users. Intuit will support it until 2027 as long as you pay the renewal fee annually to keep your license active.

 

Another option, use an importer tool with your QB Desktop 2021. It's a $199 one time license and you can get $100 cashback to purchase it via a partner.

https://get.transactionpro.com/bank_feed_alternative

 

Lisa-E-CPA
Level 1

Importing a local QBO file that does not require connecting to financial institution

@4GalWhat's the fee for the upgrade to QB Desktop 2024 Accountant Plus? And if you read anything at all in my previous post, I don't NEED 5 users. I'm a one-person practice. I have been searching for an answer for a few months, and frankly, I'm worn out by all the layers of advertising and propaganda. My last upgrade to 2021 cost me about $800, and I thought that was too much.

BigRedConsulting
Community Champion

Importing a local QBO file that does not require connecting to financial institution

@Lisa-E-CPA  Re: Are you guys legit?

 

Yes, we are!

4Gal
Level 11

Importing a local QBO file that does not require connecting to financial institution

@Lisa-E-CPA 

You can purchase QB Desktop 2024 Accountant Plus for single user = $950 via @Fiat Lux - ASIA + you can get $100 cashback.

Lisa-E-CPA
Level 1

Importing a local QBO file that does not require connecting to financial institution

Fantastic! I've bookmarked your website & am going to download the free trial to test it out.

Thanks for getting back to me!

4Gal
Level 11

Importing a local QBO file that does not require connecting to financial institution

Correction, QB Desktop 2024 Accountant Plus for single user = $1,000

gnocchi
Level 3

Importing a local QBO file that does not require connecting to financial institution

Thank you for your feedback. I've used your products in the past and I've been very happy with them.

I appreciate your input!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us