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.
