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.
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.
