cancel
Showing results for 
Search instead for 
Did you mean: 
CyndiBlossom
Level 1

Quickbooks online credit card bank feed only importing payments

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.  

6 Comments 6
jamespaul
Moderator

Quickbooks online credit card bank feed only importing payments

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:

 

  1. Go to your Chart of Accounts.
  2. Click the New button.
  3. Set the Account and Detail Types to Credit Card
  4. Under the Name, enter something like "Parent credit card account for reconciliation." 
  5. Click Save and Close.

 

banksub1.PNG

 

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. 

CyndiBlossom
Level 1

Quickbooks online credit card bank feed only importing payments

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. 

 

AileneA
QuickBooks Team

Quickbooks online credit card bank feed only importing payments

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!

CyndiBlossom
Level 1

Quickbooks online credit card bank feed only importing payments

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? 

Ethel_A
QuickBooks Team

Quickbooks online credit card bank feed only importing payments

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:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?).
  3. Select either tab to get started:
    • Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still talk to a human.
    • Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
      • Start a chat with a support expert.
      • Get a callback from the next available expert.
      • Ask the community to get help from businesses like yours.

 

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.

CyndiBlossom
Level 1

Quickbooks online credit card bank feed only importing payments

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. 

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

Need to get in touch?

Contact us