Recommendations for CSV\Excel Statement Importing to QB Desktop Pro 2020?

DrMcLane · ‎June 05, 2023

TLDR: Do you have suggestions for third-party software to import bank statement transactions into Quickbooks Desktop Pro 2020?

I've used Quickbooks Desktop Pro for bookkeeping for over 15 years now. I would typically buy the current version every 3 years or so to maintain Online Bank Feeds functionality. I understand this was already basically "a subscription", but the new subscription-only Quickbooks is nearly three times the cost, and subscriptions tend to disable your access to the software entirely if you don't keep subscribing, so I'm not wiling to sign up for that.

They've now discontinued the Bank Feeds online feature for Desktop Pro 2020 (frustrating, but whatever) but ALSO the ability to import qbo files at all, which feels tantamount to extortion, since the format of the files hasn't changed since 2018.

It appears that QB does not have a native functionality for importing bank transactions from csv or xls files (which seems like an intentional decision to limit function), so I'm looking for third-party software to import transactions. (Alternatively, a "buy it and own it" alternative to Quickbooks entirely.)

All I use Quickbooks for is bookkeeping, writing checks, and generation of records like Profit-Loss, Balance Sheets, etc.

A quick Google Search turned up Transaction Pro, which has a 7-day free trial, but I'm curious if anyone has positive experience with importer software.

Fiat Lux - ASIA · ‎June 05, 2023

If you prefer a one time license, pick TP

https://get.transactionpro.com/qbd

If you don't mind the annual subscription, pick Saasant

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

View solution in original post

Fiat Lux - ASIA · ‎June 05, 2023

If you prefer a one time license, pick TP

https://get.transactionpro.com/qbd

If you don't mind the annual subscription, pick Saasant

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

AlcaeusF · ‎June 05, 2023

Hello,

I know the importance of choosing the right accounting product which provides the functionalities you need at a lesser cost. Allow me to chime in and share information about importing data to QuickBooks Desktop.

We're unable to suggest specific third-party applications which you can use to import bank transactions into QuickBooks Desktop. Since you need to bring over data, I can route you to our website to help you find an app.

Here's how:

Go to: https://desktop.apps.com/home.
Find applications using the search field.
Hit Search.
View the results.

We also have a link with complete information about the QuickBooks Desktop 2020 service discontinuation. This article serves as your additional guidance for the affected products to the disco and some information about the frequently asked questions: QuickBooks Desktop 2020 service discontinuation policy.

Feel free to hit that Reply button if you have additional questions about syncing apps or importing bank data. We'll be sure to get back to you. Keep safe.

AlcaeusF · ‎June 13, 2023

Hello Fiat Lux - ASIA,

I have reviewed the workaround you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

We love to see members supporting one another! Have a great day.

BigRedConsulting · ‎June 23, 2023

One way to continue importing transactions into QuickBooks 2020 and older versions that have been 'sunset' is to download OFX files from your bank and convert them to IIF files for import. Use our OFX/QFX/QBO to IIF Converter to do this.

As the name suggests, it can also be used to import QFX (Quicken OFX) files and OFX (standard OFX files) that no version of QuickBooks, even current versions, will import. Many banks and credit card companies that don't support QBO files, do offer QFX and QBO files for download.

Topics

Training

Community

Resources

Recommendations for CSV\Excel Statement Importing to QB Desktop Pro 2020?