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

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. 

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

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 Date, date format, Description, 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!

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

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.

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

CAN U GUIDE STEP BY STEP THIS MUMBO JUMBO

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

This solution worked well. Thank you.

I was able to import the qbo output file (stmi1.qbo) without any 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.  

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.

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. 

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.

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.

@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

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.

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.

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.

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