Question

QB Desktop suddenly won't let me manually import bank transactions for reconciliation

Forum|Forum|2 years ago
December 26, 2023
6 replies
63 views

Using the very expensive QB Desktop Pro Plus 2024. Each month, I've been manually downloading statement transactions from the bank and importing them into QB for account reconciliation. Suddenly, QB has stopped importing the transactions. When I try to do so, I get a "Select Bank Account" popup saying that QB "does not have an online account to handle these transactions" with 2 radio buttons: "Use an existing QB account" and
"Create a new QB account." When I select "use an existing" (because these accounts have existed in QB without problems for years), no accounts show as existing. How can I fix this, please? I repeat that I'm using manual downloading, NOT bank feeds that connect directly to our bank.

I wangled a tech support phone number from a reluctant QB employee, only to spend an hour listening to a very nice lady reading all the QB fixit articles I've already read and that do no apply to my issue. So Intuit will not help me.

QuickBooks Desktop

A

Archie_B

Level 6

Hello there, gorejs.

I understand the difficulty with the inability to manually import bank transactions. Allow me to assist you and ensure that your bank transactions are successfully imported.

In QuickBooks Desktop, the option to manually import bank transactions is typically available through the Bank Feeds feature. However, it seems that you are encountering an issue where QuickBooks is not recognizing the existing accounts for transaction import.

To isolate this issue, we can check some details and perform some troubleshooting steps. First, verify that the bank accounts you're trying to import transactions for are set up correctly in QuickBooks Desktop. Double-check the account names and account types to ensure they match your actual bank accounts.

Next, make sure to update QuickBooks Desktop to the latest release. Sometimes, software updates can resolve compatibility issues or bugs that may be causing the problem.

If you're still unable to upload bank transactions, we can use the Verify and Rebuild utility tools to fix possible data issues. Here's how:

Go to Window then select Close All.
Go to File, then select Utilities.
Select Verify Data. If you see:

a. QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
b. An error message—search for it on our QuickBooks Desktop support site for how to fix it.
c. Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

You can find detailed steps on how to rebuild your data in this article: Verify and Rebuild Data in QuickBooks Desktop.

If the issue persists after trying these steps, I recommend reaching out to our Support Team directly. They have the necessary tools and resources to further investigate the issue and provide you with tailored assistance.

I've also included this link as a resource for troubleshooting Web Connect import errors: Fix Web Connect import errors.

Let me know if you need further assistance downloading your bank transactions. I'm always around to help. Have a great day!

G

gorejsAuthor

I've rebuilt my data countless times, & this allowed me to import transactions on some previously blocked accounts. But there are still 2 that won't import, so I'll try contacting QB support. I'm not excited about this possibility, because QB seems dedicated to NOT helping clients & leaving it all up to community comments. But I will try.

4

4Gal

Level 5

@gorejs

Run the Verify/Rebuild Data utility. If you didn't encounter any error message, run the Condense Data utility with any scenario. Did you encounter any error message?

G

gorejsAuthor

Thanks for this. I waited until I got our accountant's okay to condense data, & I just did that, but alas, 2 accounts still won't import. I think I'm stuck with trying QB Desktop support, but I'm not confident they'll actually help.

4

4Gal

Level 5

@gorejs

You run the Condense Data utility for testing purposes only to make sure no hidden errors. You will not use the condensed file without your accountant's approval.

B

Belleport

Same same I'm setting up a new company on QBD 2024 ($999) and have a QBO file from Bank of America for 1 of the 3 bank accounts for my clients account. I import the QBO and get the same issue you have—the account does not exist, and the second option is to create a new account, which would be duplicative. Then the second message that pops up is "Not all accounts contained in the download were set up and enabled for bank feeds. Accounts which were skipped may be set up at a later time by downloading those accounts again" What the heck? The feeds are working fine, and I got 90 days of transactions into each bank account. I cannot figure out what this message from some 'non-accountant' means and what I am supposed to do with it. Rebuilding data on a brand-new company with nothing in any register and only three accounts (banks) in the chart of accounts makes no sense. I also just spent $599 on Money Thumb to convert old PDFs to QBO files—it works incredibly easily, but I can't get the data into QBD 2024.

O

On Beta

@Belleport

Run the Verify/Rebuild Data utility. Did you encounter any error message?

F

FSC HVAC

I have been a Quickbooks user since 2010 and over the years I have seen this problem with both credit card accounts and bank accounts specifically with Capital One. I have never been able to resolve without creating another new account to apply the new transactions to which I find insane...... Unfortunately once again, this has happened to me of late and specifically to my business checking account. It's insane how it was working a week ago for months / years with this account and suddenly this problem rears its ugly head. (Quickbooks Desktop Pro Plus 2024)

I have done the verify feature as suggested and it did find a problem with the account name but don't understand what really changed. Of course, the rebuild procedure indicated that it could not "fix" the problem and pretty much let me down the "go Fish" trail..........

I too would to solve this problem and I have attached the below image so that Quickbooks technical support can help me resolve. I remember the days of no yearly subscription to own software. I am sure with this added stream of revenue, Quickbooks should be able to contact me and resolve in a quick and efficient manor since nothing has changed on my side and the way I upload bank transaction to my Quickbooks account........

I await Quickbooks quick resolution to this problem via this new indirect resolution process. I surely miss the good old days when humans used to resolve these problems quickly over the phone (there is so much lost in translation via texting.........) but we are living in a brave new world

L

LeizylM

QuickBooks Team

Let's resolve the error you received when rebuilding data in QuickBooks Desktop (QBDT), FSC HVAC.

Error 195 exists when verifying and rebuilding company files or deleting bank accounts. It is triggered by an invalid account or routing number on the accounts that have a bank feed connection.

You'll need to edit the bank feed settings for a bank in QBDT. You can change your login and other info for the bank account you use.

Once done, we can verify and rebuild to locate and fix common issues with your company file. First, let's ensure you have updated QuickBooks Desktop to the latest release to keep your software up-to-date so you always have the latest features and fixes.

If the issue persists, you can run the Quick Fix My Program and File. That way, it will repair both files and programs in the QuickBooks desktop

Quick Fix My File:

Open the Tool Hub, select Company File Issues
Then select Quick Fix My File.
Once it is complete, select OK and launch QuickBooks.

Quick Fix my Program:

Once done, open the file and select Program Problems.
Select Quick Fix My Program.
Start QuickBooks Desktop and open your data file.

For detailed instructions, see these articles:

You can always count on me if you need further assistance managing your transactions from your Capital One business checking account. I'm just a post away.

F

FSC HVAC

Dear LeizylM:

I have taken your advice and have run the update of which the program needed to reboot. Unfortunately, the problem still existed and the verify and rebuild procedure only resulted in the same answer that it could not fix the problem.

Please note that Capital One Bank does not allow an automatic updating interface, It has always been a manual process, one that I find tedious, but I cannot change that due to their security parameters on their side that disallow it.

I also ran “quick fix my file hub” which did not find any errors and consequently the problem remained the same.

The edit bank settings requires that all pending transactions are accepted before the User is allowed to edit. Since I still have some pending transactions in the que, I will not be able to try this right now. In the meantime, can you please send me more details on how this step could resolve the problem since nothing has been changed on my side and I don’t understand how Capital one has changed the routing and account number on their side of my business checking account to trigger off this issue.

Thanks

Keith.

D

daler

Bank of America has re-done their online banking and now I am not able to manually import bank transactions into QB Accountants Desktop Plus 2024. The error is "QB is unable to verify the Financial Institution information for this download. I tried the "common fixes" suggested in QB which are similar to the fixes in this thread. I also set up a new company and tried the import and received the same message. Anyone else have this issue with BoA? If so, have you been able to resolve it? Thank you.

R

rjjjbrown

I have a few clients with this issue, and nothing is working. I've tried everything (I'm a ProAdvisor - so resetting bank connections is nothing new) ... the clients affected are using QBs Desktop 2024 with ALL of the current updates installed.

For reference we've tried:

- Breaking the connection by deactivating bank feeds and renaming the account

- Creating an entirely new bank account

- Downloaded multiple QBO files - with specific date ranges and through a statement date

- Opening the .qbo file from the download folder - which NOW causes QBs to try to open another QBs instance! We get a message that we are trying to open QBs 2024 but QBs is already running. This is not true of course, double-clicking on the .qbo file is attempting to open another version of QBs now.

- Importing the .qbo file from File>Utilities>Import>Web Connect files. We get the error message about this being a temporary issue. However, this has been going on for weeks.

- Changed the bank feed modes - tried all 3 of them and circled back again.

- Confirmed ALL UPDATES have been installed

- Confirmed the file integrity - comes up clean

This is not happening (yet) with everyone – only a few clients. All are using QBs desktop 2024 and have been importing BOA .qbo files for years.

We NEED a fix for this!

K

KayePe

QuickBooks Team

Please know that we appreciate the detailed steps you and your clients have taken to troubleshoot the import concern, @rjjjbrown.

For further guidance on uploading the transactions successfully, we recommend contacting our Live Support team. They can thoroughly investigate this matter and provide the right solution for your clients.

Here's how:

In QuickBooks Desktop, click the Help menu at the top.
Select QuickBooks Desktop Help or Contact Us.
Type your question or keywords in the Search questions, keywords, or topics field.
Select Contact Us to connect with a QuickBooks expert.

For prompt assistance, please check our support hours.

Let us know if you have more questions. We're ready to help.

Z

ZuzieG

QuickBooks Team

Hi Daler,

Thank you for reaching out regarding your QuickBooks Accountant Desktop Plus 2024 (QBDT Accountant 2024) import issue. I understand that you're experiencing difficulties importing bank transactions from Bank of America following their online banking update. Despite attempts at applying the commonly suggested fixes and testing with new company files, the issue persists. I know how important it is for your business to have seamless and efficient banking integration.

With that in mind, I recommend contacting QuickBooks Desktop (QBDT) Live Support, as this issue requires further internal review of your account. This way, they will be able to determine the root cause of the issue and provide the steps to resolve it.

Here's how:

Go to Help, then select QuickBooks Desktop Help.
Hit the Contact Us button.
Enter a brief description of your concern in the "What can we help you with?" section and click Continue.
Choose a way to connect (Chat or Callback).

For more information, refer to the article Get help with QuickBooks products and services, which includes support hours and guidance for QBDT services.

When you connect with our live support team, please provide a detailed explanation of the issue you're experiencing. This will enable them to offer a targeted solution for your specific situation. Remember, we're here to assist you with any further questions or concerns you may have. Our goal is to ensure your QuickBooks experience remains smooth and efficient.

Sign up

Login with SSO

Let's get you signed in

Login with SSO