Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I work do bookkeeping for two separate companies. Both companies have Bank of America business credit cards. Business credit cards with Bank of America are set up so that cards that are used for purchasing each have a unique card number and then there is what I will call the CORPORATE card number (which is never used for purchasing) and the CORPORATE card is where ALL payments for ALL cards are posted on the Bank of America website; and, NO payments are posted to the card numbers that are used for purchasing. Stick with me because I think this matters for my problem here. The two Quickbooks companies I do bookeeping for both have Bank of America business credit cards and both are having the same problem. I have connected the Bank of America credit card in Quickbooks, but Quickbooks ONLY downloads the payments. NO purchases/spent items are imported into Quickbooks. One of the QB companies is connected using the "purchase" credit card. The other is connected using the "CORPORATE" credit card number. Both have the exact same problem.
Hello, Cyndi.
Thanks for the detailed information about the bank feed issue. I'm here to ensure you're able to import the credit card transactions for the two companies.
You'll want to make sure to set up your credit card accounts (both the business and the corporate cards) properly. An incorrect setup is the reason why the system would only import the payments.
You would want to set up a parent account (for reconciliation) and the subaccounts (for both the business and the corporate cards). Then, connect the credit card accounts to the subaccounts.
That way, the transactions would flow through easily and smoothly through the bank feeds.
Before doing this, disconnect the existing connections.
Then, set up the parent and subaccounts in the Chart of Accounts:
Next, create a subaccount for the business cards. Simply make another Credit Card account, then tick the Is sub-account box and connect it to the parent account. For the name, you can enter something like "Business card 1."
Do this until you've created the subaccounts for the business cards. For the corporate card, you can name it something like "Corporate payment account" or similar.
Then, connect the live credit card accounts accordingly with their respective subaccounts. If you need a bit of help, you can check this article: Connect bank and credit card accounts to QuickBooks Online.
You can also do this to the other company you're working for.
Though, you can also upload those transactions manually. If you're interested to learn about the process, check this article out: Manually upload transactions into QuickBooks Online.
For more details about handling multiple credit cards, you can read this article: About bank or credit card subaccount setup.
Do you also handle the companies' bank reconciliation? Check this article out if you need a guide: Reconcile an account in QuickBooks Online.
I'm happy to help you out again if you have more questions about the Online Bank Feeds feature. Do you need help managing the companies? Let me know and I'll lay down some guides and details.
Thank you for that detailed response. That all made perfect sense. Can you help me understand the bigger picture? Everything you explained makes perfect sense for proper recording and reconciliation. But how does that make a difference for the transaction getting imported into QB, which is the problem I'm having? Here is what happens when I connect the credit card bank feeds. This happens with both companies (both of whom have Bank of America business credit cards):
1) When I connect the "Corporate" card, ONLY the payments import into QB, NO transactions.
2) When I connect the "business" card, ONLY the payments import into QB, NO transactions.
3) When I try to manually upload the QBO file that was downloaded from the Bank of America website, QB gives me an compatibility error. I can try using the CSV file instead, but that requires some field translation so I'll do that if the bank connect doesn't work and the QBO upload doesn't work.
Hello, CyndiBlossom.
I'm glad that my colleagues were able to help you with the proper recording and reconciliation of your account. Let me share some more insight why your Corporate" card, and "business" card, ONLY the payments import into QB, with NO transactions. It could be an improper setup of your account why the system would only import the payments. For additional reference, please visit the following article about connecting a bank or card account: About bank or credit card subaccount setup.
Also, the error was getting when trying to manually upload the file. It could be the file is too big or doesn't meet the QuickBooks format requirements. Feel free to read this article to learn more about format requirements in QuickBooks Online: Format CSV files in Excel to get bank transactions into QuickBooks.
Fill me in if you have further questions by leaving a comment below. I've got your back. Take care and have a good one!
Hi, That makes sense. Thank you! After I set up the accounts and try to link the accounts to Bank of America, my new QB account numbers do not come up as a selection. My old (now unused) QB credit card accounts are in the list of accounts I can pick to link to, but not my new QB accounts. I log out and log back in, same results.
During the setup, I set up a new credit card account using your instructions. Account 22000 for the parent, account 22100 as a subaccount for payments and account 22200 as a subaccount for transactions. During the setup it asks me "When do you want to start tracking your finances from this account in QuickBooks?" so I select the beginning of this year and $0.00 as the balance and I save. I do this for all three accounts.
When QB wouldn't let me link to these accounts, I went back to check the setup on each account. I Edit each account to check to make sure it is set up correctly, but there is no balance - still asks "When do you want to start tracking your finances from this account in QuickBooks?". I tried putting a balance only in the parent account, no change. I tried putting a balance in only the subaccounts, no change. I log out and log back in, no change. No matter what I try I can't get a balance to save on any of these accounts.
What are the possible reasons QB is not showing me these accounts when I go to link them?
Hello there, @CyndiBlossom.
Let me share with you some insights about connecting a bank account to your QuickBooks Online account.
I understand you're not able to link your bank account. This issue has been raised to the banking engineer to understand why this unexpected behavior is happening. As of the moment, I'd recommend you contact our support so you will be listed as one of the affected customers and get updates about this issue.
Here's how:
Meanwhile, you can also manually upload bank transactions as a workaround.
You can also check on how to troubleshoot Online Banking Issues in Quickbooks Online to know more about common issues and how to resolve them.
Feel free to reach back out to me if I can be of more help with connecting a bank account. I'll make sure to get back to you as soon as I can.
I understand. I appreciate all of your help!! I've already tried to manually import a .QBO file from my Bank of America account into QB, but it gives me an error. I checked the file size as suggested, and the .QBO file is pretty small. I've spent quite a few hours on CHAT with QB before I started this thread, and we just kept going in circles. I haven't been on a QB Chat regarding this specific linking issue, so I'll try again.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here