cancel
Showing results for 
Search instead for 
Did you mean: 
PSound
Level 3

Bank of America - QBO Import Issues


I have had support cases open with Bank of America and Intuit for more than a month.

 

When exporting a QBO file from Bank of America and trying to upload it to Quickbooks Online, I get an error:  "Something’s not quite right

The uploaded file isn't a valid Web Connect file."

 

Bank of America says they have not made any changes and it must be an issue with Intuit.  Intuit states they are working on it, but how can it take more than a month to fix a file formatting issue?

 

Intuit noted that they were aware of the issue even BEFORE I reported my issue more than a month ago.  

Solved
Best answer April 18, 2022

Best Answers
PSound
Level 3

Bank of America - QBO Import Issues

It is ridiculously frustrating.  I will try and do a step by step so the solution is a bit more clear.

NOTE:  This will only work with the QBO files, not the CSV files.  

 

IMPORTANT: You will need to download a QBO file for each individual card.  

 

INITIAL SETUP:  Create a directory/folder.  This can be anywhere on your computer, but you are going to want a dedicated one to make it easier to track.  NOTE:  I also have a subfolder under this dedicated folder called "Complete" where I move each uploaded QBO file after it is done.

 

Next, open Notepad (or your equivalent text editor)

Copy this text into Notepad:

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

 

From within notepad, save the text file with the extension .bat   You can name it anything you want, as long as it has the extension .bat    

 

REPEAT THESE STEPS FOR EACH CARD.

That initial setup only needs to be done once.  After that, you will need to complete these steps for each card on the account every month (or how ever often you download transactions).

 

Visit Bank of America's website.  On the Corp Account page, select to Download (small blue text with an arrow next to it).  Select one of the cardholders. Select the desired time period.  Select "WEB Connect for Quickbooks 2018 and above" for the file type.

 

Save this file in the folder you created during setup.  You should have a file named stmt.qbo   DO NOT RENAME THIS.  The next step will only work if the file is named stmt.qbo

 

From File Explorer, double click the .bat file you saved/created during setup.  You should now see another file named stmt1.qbo in the folder.  The stmt1.qbo file is ready for upload.

 

Go to Quickbooks Online and upload the stmt1.qbo file under Transactions, Banking.  From the banking transactions page, select the down arrow next to "Link Account".  Choose "Upload File".  Make sure to use the stmt1.qbo file and NOT the stmt.qbo file.  Choose to Manually upload your transactions.  Select the correct Quickbooks account on the next page.

 

When the upload is complete, you should see the transactions for that particular credit card and time range ready for review.

 

Move or delete the stmt.qbo and stmt1.qbo files from the folder/directory.

 

Return to the section of this post titled "REPEAT THESE STEPS FOR EACH CARD" and repeat for each card and time period you wish to reconcile. 

 

NOTE:  There is an option to download the CORP account.  This only includes payment and interest information.  Interestingly enough, you can configure Quickbooks Online to automatically sync the payment and interest (and ONLY the payment and interest) info.

View solution in original post

21 Comments 21
Fiat Lux - ASIA
Level 15

Bank of America - QBO Import Issues

For the time being, explore and utilize the starter plan of this connector for free.

https://www. integromat.com/?pc=quickbooks

 

taborlake
Level 3

Bank of America - QBO Import Issues

Hello,

 

I have been hoping this would be fixed since back in February. We are five months in and still not working. Come on Quickbooks, this is beyond ridiculous. 

 

 

DeSwanson
Level 1

Bank of America - QBO Import Issues

Have you heard anything more about this?  I've been trying to find a work around as well.

Adrian_A
Moderator

Bank of America - QBO Import Issues

I have a workaround that you may want to consider, DeSwanson.

 

As of now, our engineering team is still investigating the error when importing a .QBO file from Bank of America. 

 

As a workaround, you can use a .CSV file to import the transactions into your QuickBooks Online account. Here's how you can do it:

 

  1. From the Transactions tab, select Banking.
  2. Select File upload.
  3. Click Browse and then choose the .CSV file.
  4. Click Open
  5. Hit Next.
  6. Select a Datedate formatDescription, and Account.
  7. Click Next and then select the transactions to import.
  8. Hit Next again and then Yes.
  9. Click  Let's go!

 

Once imported, you can now categorize and then reconcile the transactions.

 

Also, I'd recommend reaching out to our Phone Support team so you'll be added as one of the affected users.

 

You can contact them by clicking the ? Help icon and then selecting Contact Us. Enter, Something’s not quite right

The uploaded file isn't a valid Web Connect file as your keyword. Then, hit Let's talk. From there, select either Start a chat, Schedule a call, or Get a callback.

 

We appreciate your patience while we are working to fix this issue as soon as possible. Take care always!

PSound
Level 3

Bank of America - QBO Import Issues

There is a workaround.  It is so simple it really illustrates how incredibly useless both Intuit and BofA software developers are.  I really don't know how any of them still have a job since the fix is so simple.  They are all morons.  I mean, it has been 8 months impacting their entire customer base and they cannot resolve it.   Adrian_A should be terminated immediately for his inaction.


THE FIX:
The issue is that there are a few extra fields in the QBO file that cause issues with the import.  A simple batch file will fix things.  See below for the the text to put in your batch file.

If you use Notepad and save the text below in a file called "SimpleFixFortheMoronicEngineersatIntuit.bat", you can run it to fix your files.   It will take the stmt.qbo that you get from BofA and create a file called stmt1.qbo that can be imported into Quickbooks.  I also attached the .bat here.

Put it in the same directory as where you download the stmt.qbo   Double click it to create the working stmt1.qbo file.


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

PSound
Level 3

Bank of America - QBO Import Issues

I posted a fix, but the moderators may not approve it.  It is so simple that they might censor it to avoid looking like the blathering, uneducated and uncaring morons they are.

If they do not post my previous solution, let me know or post your email address so I can get it to you.

PSound
Level 3

Bank of America - QBO Import Issues

There is a workaround.  It is so simple it really illustrates how incredibly useless both Intuit and BofA software developers are.  I really don't know how any of them still have a job since the fix is so simple.  They are all morons.  I mean, it has been 8 months impacting their entire customer base and they cannot resolve it.   Adrian_A should be terminated immediately for his inaction.


THE FIX:
The issue is that there are a few extra fields in the QBO file that cause issues with the import.  A simple batch file will fix things.  See below for the the text to put in your batch file.

If you use Notepad and save the text below in a file called "SimpleFixFortheMoronicEngineersatIntuit.bat", you can run it to fix your files.   It will take the stmt.qbo that you get from BofA and create a file called stmt1.qbo that can be imported into Quickbooks. 

Put it in the same directory as where you download the stmt.qbo   Double click it to create the working stmt1.qbo file.


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

205-287-2241
Level 1

Bank of America - QBO Import Issues

CAN U GUIDE STEP BY STEP THIS MUMBO JUMBO

Dudesworth
Level 1

Bank of America - QBO Import Issues

Psound can you help see if my files have extra fields? I have some form Citi and Bellco, wierd kissue I think fields maybe, can you contact me though https://www.linkedin.com/in/mikeshawmortgage/ or http://mikeshaw.proiwebsites.com/contact_me  THX

vasu2409
Level 1

Bank of America - QBO Import Issues

This solution worked well. Thank you.

 

I was able to import the qbo output file (stmi1.qbo) without any issues.

SBR415
Level 2

Bank of America - QBO Import Issues

I'm sorry but this is the most frustrating thing to deal with. The QBO files I download aren't recognized by QBO at all so I am forced to download a CSV file. QBO doesn't even recognize the # of columns that are in the CSV file so I don't have the right options for the column #s for description, amount, etc. Even after I delete a few unnecessary columns from the CSV file, they all download as CREDIT CARD CREDITS. I'm going to enter each transaction manually because of how much time I have spent trying to figure this out.

 

Another major issue is the fact that bank of america has one account # for our credit cards, but every employee card that's added with new card #s, transactions do not get imported for all of them once 2 or more employee cards are present under the main credit card account. I am forced to download each credit card's activities individually which, as mentioned above, doesn't work anyway. This is absurd and infuriating. This worked just fine until we added a new card to the account and everything went haywire. Still, doesn't excuse why a QBO file isn't being uploaded. I don't care whose fault it is, someone should be working to fix this.  

fUuuuuckoff
Level 1

Bank of America - QBO Import Issues

what does this even mean? put it in a notepad? what? 

 

a. trying to directly import older transactions gets me this error "something unexpected has happened QB can not connect with your bank try back in a few hours."  (I have received that error for the past few days)...

 

b. so I try the CSV work around..

 

BOA > XCEL > CSV > QBO and then the error...

"Error Importing Uh-oh, looks like we ran into some trouble importing this file at line Http failure response for https://selfemployed.intuit.com/secure/txImportData/csvImport/1402362: 422 OK~ Logged- in- A pi Service .handle Error~. Look for a date or an amount that shows odd formatting. Correct it and try again."

 

c. I have used this card for 28 years- this product QB for nearly that long- and this is the first year that all of my BOA data has been scrubbed - and I can not manually enter these transactions. 

 

d. I am losing my cool over here.

jamespaul
Moderator

Bank of America - QBO Import Issues

Hello.

 

I'd also lose my cool if I'm stuck with a couple of issues after doing all the workarounds available. I have one more solution before we dive deeper into the Bank of America transaction file issues. 

 

Regarding the CSV file, I take it that you're referring to PSound's solution. It's for a different solution regarding the invalid file error message in QuickBooks Online. 

 

Looking at your error message for the CSV file, I see that you're using the Self-Employed version. If you haven't done it yet, let's open your file with Excel then check the formatting.

 

Look for odd or special characters on the amount or date fields (except for the (/) symbol and the (-) minus sign for expenses in a three-column format). 

 

If you've already checked the formatting, then we'll want to contact a support agent. They'll take a look at your file and the system and check what's causing the import error message.

 

They'll also investigate what's causing the "Something went wrong..." message that you've been getting for the past few days. 

 

Here's how to contact them: 

 

  1. In QuickBooks Self-Employed, click the Help icon.
  2. On the pop-up window, proceed with the Contact Us button. 
  3. Enter the error messages in the box, then hit Continue.
  4. Select either Chat with us or Have us call you

 

After resolving the error messages, do you need help managing your estimated taxes? Take a look at this article for a guide: Pay federal estimated quarterly taxes in QuickBooks Self-Employed.

 

If you have any other concerns regarding your transactions, let me know. I'll also hear you out if you have questions about reports or your taxes in QuickBooks. 

PSound
Level 3

Bank of America - QBO Import Issues

It is ridiculously frustrating.  I will try and do a step by step so the solution is a bit more clear.

NOTE:  This will only work with the QBO files, not the CSV files.  

 

IMPORTANT: You will need to download a QBO file for each individual card.  

 

INITIAL SETUP:  Create a directory/folder.  This can be anywhere on your computer, but you are going to want a dedicated one to make it easier to track.  NOTE:  I also have a subfolder under this dedicated folder called "Complete" where I move each uploaded QBO file after it is done.

 

Next, open Notepad (or your equivalent text editor)

Copy this text into Notepad:

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

 

From within notepad, save the text file with the extension .bat   You can name it anything you want, as long as it has the extension .bat    

 

REPEAT THESE STEPS FOR EACH CARD.

That initial setup only needs to be done once.  After that, you will need to complete these steps for each card on the account every month (or how ever often you download transactions).

 

Visit Bank of America's website.  On the Corp Account page, select to Download (small blue text with an arrow next to it).  Select one of the cardholders. Select the desired time period.  Select "WEB Connect for Quickbooks 2018 and above" for the file type.

 

Save this file in the folder you created during setup.  You should have a file named stmt.qbo   DO NOT RENAME THIS.  The next step will only work if the file is named stmt.qbo

 

From File Explorer, double click the .bat file you saved/created during setup.  You should now see another file named stmt1.qbo in the folder.  The stmt1.qbo file is ready for upload.

 

Go to Quickbooks Online and upload the stmt1.qbo file under Transactions, Banking.  From the banking transactions page, select the down arrow next to "Link Account".  Choose "Upload File".  Make sure to use the stmt1.qbo file and NOT the stmt.qbo file.  Choose to Manually upload your transactions.  Select the correct Quickbooks account on the next page.

 

When the upload is complete, you should see the transactions for that particular credit card and time range ready for review.

 

Move or delete the stmt.qbo and stmt1.qbo files from the folder/directory.

 

Return to the section of this post titled "REPEAT THESE STEPS FOR EACH CARD" and repeat for each card and time period you wish to reconcile. 

 

NOTE:  There is an option to download the CORP account.  This only includes payment and interest information.  Interestingly enough, you can configure Quickbooks Online to automatically sync the payment and interest (and ONLY the payment and interest) info.

Tam22
Level 2

Bank of America - QBO Import Issues

We are in the process of trying out BofA visas for our business (still have Capital One), but after our bookkeepers alerted us to a problem with downloading the qbo files I decided to look here for any solutions. I have the feeling we will reconsider having BofA CC's. Sounds extremely laborious if you have more than one card.

PSound
Level 3

Bank of America - QBO Import Issues

It is a total PITA. 

 

Considering that both BofA and Intuit have been aware of the problem for 3 years and the solution for at least 2 1/2 years (via the workaround I posted), your expectation should be that you will have to deal with this for as long as you have a BofA business account with multiple cards.

Fiat Lux - ASIA
Level 15

Bank of America - QBO Import Issues

@Tam22 

As another option, you can utilize MT Online as a workaround. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed. 

https://www.moneythumb.com/?ref=110

 

Tam22
Level 2

Bank of America - QBO Import Issues

Thank you. We use QB Desktop via a remote server. Bookkeepers were on the phone for several hours with Intuit a few days ago with no luck. They're hoping to conference call with their IT person and Intuit for one last try.

SBR415
Level 2

Bank of America - QBO Import Issues

The resolution I found for this last week was to download the .CSV files, remove several additional columns from said .CSV file, remove the first 3 rows before the actual spreadsheet header row, then I had to go through and basically add a (-) minus to every credit card charge in the AMOUNT column, then removed the (-) from any transactions that were credited to the card also located down that same AMOUNT column, and then I finally was able import the transactions correctly. It is a complete PITA and must be done separately for every single cardholder once your statement becomes available.

If you're only planning on having 1 or 2 B of A business cards, the above solution I just shared isn't too bad HOWEVER, small business and cash flow go hand in hand and it absolutely makes no sense when such a huge liability account isn't showing up in live time amounts at any given moment. Your Financial Reports and projections won't be accurate or helpful until you've gone through these steps at statement closing date leaving you a month off every month. Not useful or helpful and trying to download transactions in between statements only leaves you open for duplicate transactions because unfortunately QBO does not catch those for you either. BofA has a long way to go before I'd personally every utilize or bank with them for personal or for business reasons. Their tech is simply not there and calling them for help leaves you aggravated or on hold for an hour at a time. It's unfortunate.

Chase also has a similar issue but at least their QBO files actually import to QBO and you don't have to go through all these crazy extra steps like with BofA. However, you still have to download individual activity statements for every card holder that's grouped under the primary account holder so your balance sheet will always be off.

Tam22
Level 2

Bank of America - QBO Import Issues

Thank you for the detailed information. Yikes- reformatting transactions, columns, and rows for multiple cards with such precision sounds like a grand hassle! Capital One is much easier to manage. If by some chance I learn of anything from their meeting I will post about it.

NeedSomeone84
Level 1

Bank of America - QBO Import Issues

PSound - How would one do this on a mac OS? Thanks

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us