cancel
Showing results for 
Search instead for 
Did you mean: 
PreciousB
Moderator

Can't manually import .qbo bank transactions file

Thanks for your quick response, ProGaitWays.

 

I know how important the bank feeds for you, and I'm here to help get this working.

 

Creating a new test bank account is one of our troubleshooting when we have issues with importing WebConnect files. You can merge it to your original account to avoid duplicate.

 

This process helps us determine if the account is corrupted or not.

 

Here's how:

  1. Go to Lists at the top menu bar and select Chart of Accounts from the drop-down.
  2. Right-click on the pop-up window and select New.
  3. Tick the radio button for Bank and click Continue.
  4. Enter the correct bank's name in the Account Name field and hit Save and Close.
  5. Right-click the old account and rename it to the correct bank's name.
  6. Hit Save and Close
  7. Tick Yes when you get the prompt to merge the accounts.

Another solution that I'd recommend is to import the .QBO file in a new test company. This way, we'll be able to determine if the issue lies in the original company or with the formatting of the .QBO file.

 

Here's how:

  1. From the QuickBooks File menu, select New Company.
  2. Choose Express Start.
  3. On the newly created test company, add your bank account to the Chart of Accounts.
  4. Set up the account for Bank Feeds.
  5. Download or import the .qbo file.

If you've ever successfully imported transactions from the problem bank account to this company data file (.QBW):

  1. Reset the problem account in QuickBooks by deactivating the online connection.
  2. Re-establish the connection to the bank by importing the Webconnect file.

Lastly, performing the verify and rebuild process usually resolves the issue. You can always refer to the article shared by my colleague JuVielL for the complete troubleshooting of bank feeds.

 

The Community is always here, so please let me know if you have any questions or concerns. I'm wishing you continued success.

richjacy
Level 1

Can't manually import .qbo bank transactions file

That solution worked! I am using the latest QB update (version 2017) and it is bizarre to have to deactivate the bank feed for the account in order to be able to import the QBO file. I tried everything, including deactivating and reactivating several times and nothing worked. There needs to be a patch to this offered to allow you to work around it so you don't lose hours of time scratching your head trying to reestablish a link to an existing account just because some linkage aspect has changed.

Thanks for the suggestion.

PreciousB
Moderator

Can't manually import .qbo bank transactions file

Thanks for trying the recommended steps, richjacy.

 

I'm happy to know that you've successfully imported the bank transactions in QuickBooks Desktop.

 

As long the Desktop product is still supported (QuickBooks 2017, 2018 and 2019), you should receive a notification about the latest improvements. The release notes with the highest number (R 14 for Desktop 2017) includes all changes including the bank feeds updates. It's great that you're currently using the newest one.

 

We keep improving our product and to keep you in the loop, visit this article for the recent changes in QuickBooks Desktop 2017: Recent changes, improvements, and fixes in QuickBooks Desktop 2017.

 

You can also check the Product Information screen to see your release version. Just open QuickBooks Desktop, press F2 and look at the topmost part of the window to get the details.

 

image.png

 

Here's an additional article to learn more about the fixes in the other versions of Desktop: 

QuickBooks Desktop Release Notes.

 

If you have any questions or clarifications about QuickBooks, please leave a comment below. I'm always here for you. Have a successful day of business.

Stephbrown1
Level 1

Can't manually import .qbo bank transactions file

 Save the file. It should save as a QBO file - Thats where you lost me, I tried to save it, click save as and i cannot get it to save as a QBO file.  Any suggestions? I had to change my CC # because someone stole it, will i have to do this everytime or can i just switch my CC # in QB going forward?  Thanks

katherinejoyceO
QuickBooks Team

Can't manually import .qbo bank transactions file

Thanks for joining this thread, @Stephbrown1. I can't imagine what you've been through when you lost your credit card. I'm glad you're able to change the number right away.
 
Since you got a new one now, you can edit the bank feed settings for your credit card account in QuickBooks so you won't have to download your transactions every time. First off, you'll need to deactivate the bank feeds for the old credit card. Then re-setup the new account. Here's how: 

 

Deactivate bank feeds in QuickBooks Desktop for Windows

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Right-click the credit card account you want to deactivate. Then, select Edit Account.
  3. Click the Bank Settings tab.
  4. Select Deactivate all online services, then click OK to confirm.
  5. Click Save & Close.

 

Deactivate bank feeds in QuickBooks for Mac

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Highlight the credit card account, then select the Pencil icon to edit.
  3. Click the Online Settings.
  4. In the Download Transactions drop-down, choose Not enabled.
  5. Click OK to confirm.

 

For more information, check out our help article: Edit Bank Feed settings for bank or credit card accounts and follow Step 3 to re-setup the account for Bank Feeds.

 

With regard to your saving file concern, if you're unable to save your bank data as .QBO file on your end, I'd suggest you contact your bank and verify if they can provide you a .QB file. If this isn't possible, contact an IT guy to help you convert data. Then, follow the steps provided by @matts on the 1st page of this thread. 

 

Let me know how it goes, @Stephbrown1. I'd like to make sure that everything works perfectly on your end. We're always around here to help you if you need assistance. 


 

Tink1
Level 1

Can't manually import .qbo bank transactions file

Awesome Matts!!! Thanks so much, I have been having this problem forever :)

LW60
Level 2

Can't manually import .qbo bank transactions file

I've tried the solution opening the file in notepad and also setting up a new company file to do a test. Both did not work. The issue is with my Target Card which uses TD Bank USA N.A. QuickBooks still returns the error "QuickBooks is unable to verify the Financial Institution information for this download. Please try again later." I have QuickBooks Desktop Pro 2018 R14P on a Dell and have been using QuickBooks for years because of the bank download feature and have never had this issue with any bank accounts on a Mac or PC. Frustrating as hell.

Adrian_A
Moderator

Can't manually import .qbo bank transactions file

 I appreciate you for trying the steps shared by my colleagues, LW60.

 

Since you still get the same error, it's best to reach out to our Customer Support team. This way, an agent will take a look at your company file and investigate this further. I'll also bring this issue up to our Engineering team so they can determine the main cause of this one. 

 

Here's how you can contact them:

 

  1. From the Help menu, select QuickBooks Desktop Help.
  2. Scroll down and click Contact Us.
  3. Enter QuickBooks is unable to verify the Financial Institution information for this download. Please try again later as your keyword.
  4. Click Continue.
  5. Select either you'll want to Start messaging or Get a callback from us.

 

In the meantime, we can manually download the transactions from your bank provider. I've added this article for the detailed steps of the process: Download Bank Feed transactions.

 

You always have me in case you still need my help in downloading the transactions.

nscny-com
Level 2

Can't manually import .qbo bank transactions file

I have been having the same problem with QBO automatically pulling transactions from BoA since early March. I used to also be able to upload a QBO file downloaded from BoA; that has also ceased to work.

 

I happened to have an old QBO file from September, 2019 and compared it to the more recent ones. The only difference is that now, for each transaction, BoA is inserting additional fields, like this:

<MERCHCAT>

<EXPCAT>
 <CARDNUM>
 <CARDNAME>
 <MCC>

 

I removed those fields manually from the QBO file using Notepad, saved it, uploaded it, and VOILA ...joy

 

Now to figure out how to get BoA to stop including those fields at the source.

 

In the meantime I'm using the 'findstr' command from a command prompt window and it removes all the offending lines from a QBO file in one fell swoop; Then just upload the modified file, "stmt1.qbo" instead - yeeha :)

 

findstr /v /i /c:"<MERCHCAT>" /c:"<EXPCAT>" /c:"<CARDNUM>" /c:"<CARDNAME>" /c:"<MCC>" stmt.qbo >stmt1.qbo

 

Plug that line into a batch file, keep it in the same folder as the bad QBO file, and just double click the batch file to avoid the futile QBO and BoA support $hit $how 

nscny-com
Level 2

Can't manually import .qbo bank transactions file

These extra fields look like credit card info related to each transaction so I’m sure these fields are only inserted into a credit card type of account, and not say a checking account QBO file.

Foamroof
Level 1

Can't manually import .qbo bank transactions file

I have 2 company files running on 2 different versions of QB, so that I can keep both companies open. When I attempt to download my transactions from Capital One it keeps trying to open the 2nd company, which does not have a Capital One credit card associated with it. To confuse matters, I also have 2 Cap One accounts in a single company. Can anyone help

Nick_M
QuickBooks Team

Can't manually import .qbo bank transactions file

HI there, Foamroof.

 

Thanks for dropping by the Community, I'm happy to help you out. Can you clarify a little further so I can understand fully, when you say you have 2 different company files in 2 different versions of QuickBooks. What versions are you referring too? I ask because if you mean you have one with QuickBooks Desktop and one with QuickBooks Online, the login page would be different which would cause the issue you're referring too. If you'd like, you can reach out to our support team in the meantime and they can guide you through the set up of both company files so you can achieve exactly what you want. Otherwise I look forward to your response down below. Thanks for your time and I hope you have a lovely day. 

Foamroof
Level 1

Can't manually import .qbo bank transactions file

Hi Nick, both companies run on QB Desktop, one is 2019 and one is 2021. The company running 2021 is the one I am having problems with. As I stated I have 2 Cap one credit cards and it will download one of them just fine, but it appears the second card has NEVER been downloaded, since 2016...I have renamed the card in chart of accounts to match exactly, I have stop/started the download function in the chart of accounts and I just don't know why this second Capital One card always wants to go to the 2019 version which is not the company that has the card.

Thanks Cheryl 

Ryan_M
Moderator

Can't manually import .qbo bank transactions file

Hi @Foamroof,

 

Thank you for your prompt reply, as well as for sharing an update on your situation. I'll point you in the right direction for support with your query. 

 

As my peer @Nick_M stated above, it's best to contact our Technical Support team for your issue. They can pull up your account, and investigate as to why the download goes to your other QuickBooks Desktop (QBDT) company when it isn't synced there. 

 

You can keep this article for reference: Contact QuickBooks Desktop support. It includes their hours of operation so you know when they're available.

 

I'll leave this article with you as well: Edit Bank Feed settings for bank or credit card accounts. It has the necessary links for articles that you can follow in case you need to change your bank or credit card information. 

 

Feel free to post another reply below if you have other questions about online banking in QBDT. I'll be around to help you out. 

MiroX
Level 1

Can't manually import .qbo bank transactions file

Matt, Yours is the best answer. You just saved my day!
It's important to clarify that, in my case, this <ACCTID> was several times on my QBO file (so I had to change all of them)

gnc422
Level 1

Can't manually import .qbo bank transactions file

I had a similar issue, but different lines of code were in my file.

I was downloading my transactions from my credit union and they would not import. I compared the recent file to last months and noticed a couple of lines of code that had been added, so I removed them. The <INTU.BID> had blanks after it, so I added the BID from the previous month.

Ran the file and it worked like a charm.

Not sure why the new file is formatted different. 


Need to get in touch?

Contact us