Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 5, 2023
Solved

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

  • June 5, 2023
  • 2 replies
  • 31 views

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.

Best answer by Fiat Lux - ASIA

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

 

2 replies

Fiat Lux - ASIA
Level 14
June 5, 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
Level 14
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
Level 15
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.