☰
✕
Sign In

Why sign in to the Community?

  • Submit a question
  • Check your notifications
Sign in to the Community or Sign in to TurboTax and start working on your taxes
Returning Member
posted Jan 28, 2022 4:42:24 PM

PLEASE FORWARD TO DEVELOPERS: Major Bug with TurboTax 2021 Import of QuickBooks Files

I cannot find an email address for tech Support, this is nuts. SO, I'll post it here and hope someone at Intuit sees it. I've been using QuickBooks file import into TT Home and Business for ten years, this error hasn't happened before, but TurboTax 2021 will NOT import my QuickBooks file, just hangs endlessly. I found the error in the Windows Event Logs (I'm a programmer by day), and while it's QB throwing the errors, it's the API that seems to be failing when TurboTax connects. The issue:

 

You start a TT file (new return), important last year's TT file, no problem. TT asks about your side business and prompts you to import your QB file which I do every year, and all transactions are properly categorized. At that point my business info should import, but right there is where it hangs endlessly. I've tried it several times, created a new file, ran verification on the QB file (which is small, I do photo work, a few shoots a month, that's IT. I'm on the latest Windows 10 updates, etc etc and run a 14-core processor with 128GB of ram so it's not a PC issue. After a couple days of this I opened the Event Viewer and ran it all again to create fresh entries.  Here are the three Windows Event Viewer entries generating from inside of QuickBooks while getting triggered by TurboTax:

 

ERROR #1 - Internal credential issue

 

An unexpected error has occured in "QuickBooks Desktop Pro 2020":
Connection Error:Invalid user ID or password

(NOTE: This is not an invalid Password issue, I enter it for the import and QB accepts it, and I know my password... this error happens after the fact)

 

ERROR #2 - QuickBooks Connection String

An unexpected error has occured in "QuickBooks Desktop Pro 2020":
Connection String:CON=QBConnection[product key removed]ta_engine_30; ;DBF=j:\documents\photo business\quickbooks main files\MyBusinessFile.QBW;ENG=QB_data_engine_30;DBN=4f073293cd194b73bbb2184c5fc7c00b

 

ERROR #3: Error in connpool.cpp file

An unexpected error has occured in "QuickBooks Desktop Pro 2020":
DBConnPool::HandleConnectionError errorCode:-6069, dbCode:-103 from file:'src\connpool.cpp' at line 1042 from function:'DBMgr::DBConnPool::init'

 

FOR THE DEVELOPERS:

The three XML files for event viewer entries:

 

#1

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="QuickBooks" />
  <EventID Qualifiers="0">4</EventID>
  <Version>0</Version>
  <Level>2</Level>
  <Task>2</Task>
  <Opcode>0</Opcode>
  <Keywords>[phone number removed]0000</Keywords>
  <TimeCreated SystemTime="2022-01-28T23:48:12.1005799Z" />
  <EventRecordID>88297</EventRecordID>
  <Correlation />
  <Execution ProcessID="0" ThreadID="0" />
  <Channel>Application</Channel>
  <Computer>GenesisOneDAW</Computer>
  <Security />
  </System>
- <EventData>
  <Data>QuickBooks Desktop Pro 2020</Data>
  <Data>Connection Error:Invalid user ID or password</Data>
  </EventData>
  </Event>
 
___________________________________
#2
- <System>
  <Provider Name="QuickBooks" />
  <EventID Qualifiers="0">4</EventID>
  <Version>0</Version>
  <Level>2</Level>
  <Task>2</Task>
  <Opcode>0</Opcode>
  <Keywords>[phone number removed]0000</Keywords>
  <TimeCreated SystemTime="2022-01-28T23:48:12.1015781Z" />
  <EventRecordID>88298</EventRecordID>
  <Correlation />
  <Execution ProcessID="0" ThreadID="0" />
  <Channel>Application</Channel>
  <Computer>GenesisOneDAW</Computer>
  <Security />
  </System>
- <EventData>
  <Data>QuickBooks Desktop Pro 2020</Data>
  <Data>Connection String:CON=QBConnection[product key removed]ta_engine_30; ;DBF=j:\documents\photo business\quickbooks main files\MyBusinessFile.QBW;ENG=QB_data_engine_30;DBN=4f073293cd194b73bbb2184c5fc7c00b</Data>
  </EventData>
  </Event>
 
____________________________________________________
#3
- <System>
  <Provider Name="QuickBooks" />
  <EventID Qualifiers="0">4</EventID>
  <Version>0</Version>
  <Level>2</Level>
  <Task>2</Task>
  <Opcode>0</Opcode>
  <Keywords>[phone number removed]0000</Keywords>
  <TimeCreated SystemTime="2022-01-28T23:48:12.1015781Z" />
  <EventRecordID>88298</EventRecordID>
  <Correlation />
  <Execution ProcessID="0" ThreadID="0" />
  <Channel>Application</Channel>
  <Computer>GenesisOneDAW</Computer>
  <Security />
  </System>
- <EventData>
  <Data>QuickBooks Desktop Pro 2020</Data>
  <Data>Connection String:CON=QBConnection[product key removed]ta_engine_30; ;DBF=j:\documents\photo business\quickbooks main files\Express Image Media LLC.QBW;ENG=QB_data_engine_30;DBN=4f073293cd194b73bbb2184c5fc7c00b</Data>
  </EventData>
  </Event>

0 1 283
1 Replies
Returning Member
Feb 2, 2022 9:05:47 AM

I got it to work but it takes a few tries (this is the Windows version, not Mac):

  • Start TurboTax as Admin on Windows
  • Do NOT start QuickBooks
  • Get to the spot where you import the QB file in TurboTax and execute that
  • Enter your password into QuickBooks
  • If the next screen asks about Cash or Accrual, you made it through. If it hangs on "verifying...", then kill the processes and start over, it will never complete by letting it sit.
  • If you DO get it to succeed, save your TurboTax file right there so you don't have to deal with it again.