Question

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

Forum|Forum|2 years ago
December 26, 2023
4 replies
0 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

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

@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

@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

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded