Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
December 11, 2018
Solved

Can't manually import .qbo bank transactions file

  • December 11, 2018
  • 7 replies
  • 4 views
I'm trying to maintain my business's account balance and transaction history in quickbooks by manually importing the .qbo file. I successfully imported my transactions as a .qbo file from bank of america a few months ago. So when I go to "Downloaded Transactions", I see them all, and the account dropdown at the top says "Bank of America". Great...

But now I'm trying to update these transactions by importing another .qbo file containing all transactions since the last import. I click "import file" and select the file. Then it asks me to select which account to import into.

The problem is the "Store in the quickbooks account" dropdown is empty. The only option in the dropdown is "new...". There should be an option to select the existing bank of america account which I've already imported transactions into. 

Can anyone tell me how to fix this problem?


Best answer by SkinnyRaven
Something has changed in the file and QB no longer associates it with your account. From your chart of accounts right click (control+click) on the account in question, select edit account, from the online settings tab select not enabled. From online banking your account will now show in the list.

7 replies

Level 6
December 11, 2018
Something has changed in the file and QB no longer associates it with your account. From your chart of accounts right click (control+click) on the account in question, select edit account, from the online settings tab select not enabled. From online banking your account will now show in the list.
Level 7
December 11, 2018
Thanks, that really helped. What happened when I selected not enabled was all of my bank transactions disappeared. Not good, but I just reimported all the qbo files again and it started working again.
Level 7
December 11, 2018

The original answer was not incorrect, just not the best answer. There is no need to disable the account from online access. Here is the secret way to get these transactions into Quickbooks (on Windows or Mac).
Just be sure you are bringing the downloaded transactions into the correct account. I find this issue usually occurs with credit card downloads - as in credit card accounts that have more than one credit card (eg, one master and several sub accounts) associated with them.
Here we go. First download the QBO and save the file, say, on your desktop. Right click on the file and select Open With, then choose Notepad. (on a Mac use TextEdit). Now, look thru the info listed (starting from the top) and look for <ACCTID>. It will list an account number after this. You will notice that this account # differs from what is in QB. That is what is causing the problem. In QB, from your chart of accounts right click (control+click) on the account in question, select edit account. Copy down the account number listed here. Now, type it in Notepad, after <ACCTID>, replacing what was there. Voila!! Done!. Save the file. It should save as a QBO file. Double click on the file and the transaction will flow into QB seamlessly...  Matt (former online tech support for Intuit)


Level 7
December 11, 2018
You are most welcome!
Level 6
December 11, 2018

From the online settings tab.

Level 7
December 11, 2018

Thank you!!

January 15, 2019

I'm using this utility to convert .QBO file to .IIF format and then I can import into my old version. 

Was way cheaper than upgrading.    https://www.propersoft.net/products/bank2iif

 

 

August 25, 2019

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
Level 6
August 25, 2019

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.

 

 

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.

May 31, 2020

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 

June 29, 2020

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.

February 10, 2021

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

Level 4
February 10, 2021

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.