Solved

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

Forum|Forum|2 years ago
April 6, 2024
3 replies
0 views

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/1165936

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

QuickBooks Desktop

Best answer by BigRedConsulting

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.

E

Ethel_A12

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.

4

4Gal

@gnocchi

Does your bank provide data in csv format?

G

gnocchiAuthor

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

4

4Gal

@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

BigRedConsultingAnswer

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.

L

Lisa-E-CPA

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!!

4

4Gal

@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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded