Multiple Credit Card Accounts

Nathandh · ‎May 10, 2018

The company that I work for uses multiple American Express and multiple Chase credit cards for purchases. The thing is that some of the cards are registered in the owners name, and some of the cards are registered in the name of other employees. All the accounts in the owner's name, even from the same provider (with different account numbers) have been added (in banking). We are not able to add the other accounts from the same provider when they are registered under a different name. I need to add these accounts and get the download feed for the purchases and payments. So far, we have had no luck in adding these accounts.

Please help. I appreciate it.

ClayJ · ‎May 10, 2018

Hey there, Nathandh. I want to shed some light on this for you, so your books are right as rain. With QuickBooks and American Express, you will be able to connect one account. For more information on how American Express connects to QBO, take a look at this article: https://community.intuit.com/articles/1302337-american-express-connect-to-quickbooks#Key%20Benefits . For Chase, you will be able to connect more than just the one account. Since you have multiple cards for Chase, it is recommended you have one account as the parent/reconciliation account. Any other accounts associated with that line of credit should be sub accounts. Only the sub accounts should be connected via bank feeds. This action will allow the charges on the individual cards to funnel up to the parent account, where you will apply payments and reconcile. It should look something like this:

Parent (Reconcile) Account
>John’s Card xxxx
>Jane’s Card xxxx
>Josh’s Card xxxx

To create a sub account, follow these steps:

Click the Gear icon at the top, then select Chart of Accounts.
Choose New at the top.
In the Account Type drop-down, select the account type (Credit Card).
In the Detail Type drop-down, choose the type of account you want to create (Credit Card).
Enter a name for the account In the Name field.
Check the box for Is sub-account, and chose the parent (reconcile) account.
(Optional) In the Balance field (not available for all account types), enter an opening balance for the account. Then in the as of field, enter the date of the balance.
Click Save and Close(or Save and New if you want to enter another account right away).

Once you have entered in all of the accounts and mapped everything, you can start connecting your bank accounts. The reason for this process is to help avoid duplicate transactions and the system in general won't allow for the parent account to be connected while sub accounts are also connected. I've attached the article with additional information about this process: https://community.intuit.com/articles/1145370-setting-up-bank-or-credit-card-account-that-attaches-t... . Should you need anything else, I'm a comment away.

View solution in original post

KathyS296 · ‎May 10, 2018

Do you have the online sign in information from the account owner?

Are you trying to download into separate GL accounts?

Nathandh · ‎May 10, 2018

I followed all the steps to add the account (in banking) and signed into the CC account. When I added the account, QB even said that it was added and would show up in the banking tab. But guess what. It did not show up.

Not sure what you mean by GL accounts.

ClayJ · ‎May 10, 2018

Hey there, Nathandh. I want to shed some light on this for you, so your books are right as rain. With QuickBooks and American Express, you will be able to connect one account. For more information on how American Express connects to QBO, take a look at this article: https://community.intuit.com/articles/1302337-american-express-connect-to-quickbooks#Key%20Benefits . For Chase, you will be able to connect more than just the one account. Since you have multiple cards for Chase, it is recommended you have one account as the parent/reconciliation account. Any other accounts associated with that line of credit should be sub accounts. Only the sub accounts should be connected via bank feeds. This action will allow the charges on the individual cards to funnel up to the parent account, where you will apply payments and reconcile. It should look something like this:

Parent (Reconcile) Account
>John’s Card xxxx
>Jane’s Card xxxx
>Josh’s Card xxxx

To create a sub account, follow these steps:

Click the Gear icon at the top, then select Chart of Accounts.
Choose New at the top.
In the Account Type drop-down, select the account type (Credit Card).
In the Detail Type drop-down, choose the type of account you want to create (Credit Card).
Enter a name for the account In the Name field.
Check the box for Is sub-account, and chose the parent (reconcile) account.
(Optional) In the Balance field (not available for all account types), enter an opening balance for the account. Then in the as of field, enter the date of the balance.
Click Save and Close(or Save and New if you want to enter another account right away).

Once you have entered in all of the accounts and mapped everything, you can start connecting your bank accounts. The reason for this process is to help avoid duplicate transactions and the system in general won't allow for the parent account to be connected while sub accounts are also connected. I've attached the article with additional information about this process: https://community.intuit.com/articles/1145370-setting-up-bank-or-credit-card-account-that-attaches-t... . Should you need anything else, I'm a comment away.

Nathandh · ‎May 11, 2018

Thanks Clay. Let me first clear up American Express.

I got the below from the link:

The American Express - Connect to QuickBooks app will only support one (1) connection to one (1) QuickBooks Online company. If the user manages multiple credit cards for multiple companies under one Amex login, the user will only be able to connect the Amex account to one (1) QBO account for it to work properly.

I find the wording very unclear.

Does it allow two completely seperate American Express accounts to be added to one quickbooks account?

If not, how can I balance my books without adding the other accounts?

P.S. Quickbooks said I successfully added the American Express account, but it still does not show up!

ClayJ · ‎May 11, 2018

No worries, Nathandh. I can bring some clarity to your question about American Express. The Amex Open app allows for only one account to be connected to QBO. This means that only one American Express Open login can be connected to QBO, and it can only be connected to that one QBO account. You can think of it as One Amex Open login per QBO subscription. Once the Amex Open app is connected to QBO, you will be able to connect all business accounts associated with that login. For anything that isn't an Amex Open card (personal or corporate), you can connect through the standard method for bank feeds. I hope this helps to clear up some of the confusion. Should you have any additional questions, feel free to reach out to me.

RSS01 · ‎June 22, 2018

I am a new to QB online and trying to set up all my credit cards to our account.

I have 6 individual credit cards that are from all banks

chase

amex

Bank of America

discover

mastercard

etc

i have tried to link them to QB online. It will only show 3 cards but goes thru the “connect” process and acts like they have been added. How can I confirm they have been added if they do not show on the dash board?

MichelleT · ‎June 22, 2018

Hi there, @RSS01,

Thanks for reaching out to the Community. I want to make sure everything gets taken care of, so you can work smoothly in QuickBooks Online.

I’ve checked to see if there are any issues with the individual credit cards you listed, and so far, none are reported. We also have not received any reports about missing credit card or bank accounts on the Dashboard.

Let’s first verify if only three cards are showing in the Chart of Accounts since the same accounts should appear under Banking on the Dashboard. Simply click Accounting on the left panel.

If you can only see three cards, let’s try accessing your account in a private browser. It’s a great place to start to see if the cache is causing the issue since it does not store temp files and browsing history.

Here’s how:

•   Google Chrome: Ctrl + Shift + N
•   Mozilla Firefox: Ctrl + Shift + P
•   Internet Explorer: Ctrl + Shift + P
•   Safari: Command + Option + P

If all six cards are visible on the Dashboard, you can log out and open the regular browser. Then, clear the cache. The steps are outlined in this article: How do I clear temporary internet files and cache?

If the cards are missing while using the private browser, you can try switching to a different browser. If none of the steps work, I recommend calling our Support Team for further investigation. They have the means to communicate with the banks to check if there are any connection issues.

Let me know how the call goes. If there’s anything else you need, I’ll be here to help you out.

teammodul · ‎September 14, 2018

Good morning Clay!

I am really hoping you can help me out! I spent almost 4 hours on the phone yesterday with QBO support trying to set up our Chart of Accounts for our Business Credit Cards with Chase.

We created the "parent" account and 3 sub accounts (1 for each CC and 1 for payments) We have 2 credit cards and I am trying to confirm the auto feed is set up correctly and determine how to apply the credit card payments to the I think I am pretty close to having the set up complete, however, the balances are not matching and I believe we also have duplicate transactions listed.

I have reviewed the support pages and still seem to be encountering problems. :-(

- Chart of Accounts: how it works in QuickBooks Online

- Set up bank or credit card account that attaches to a primary account

- Add and connect your bank and credit card accounts in QuickBooks Online

I would appreciate any help and guidance you could provide on how to resolve these issues. Thank you for your help!!

Erica

beyondbookeeping · ‎March 07, 2019

I could still use some help with this if at all possible. When I first tried to hook up my credit card with multiple accounts I must have just rolled all of the accounts into one and now it will not let me separate them. This is the message I get "The account, Discover Credit Card:Nancy 6322, has a parent account that is already connected to an account at one of your banks" What can I do to correct this problem?

AldrinS · ‎March 07, 2019

Hi there, beyondbookeeping.

I'd be happy to help you correct this problem.

When you try to separate the incorrect sub-account from the parent account, did you choose a different parent account? If so, then that would be the reason why you're getting the error.

To fix this, you just need to uncheck the Is sub-account checkbox to separate the sub-account and click Save and Close. Then, if you need to transfer it to a different parent account, edit it again and select the Is sub-account checkbox, then hit Save and Close.

That should do it. Please keep in touch if you need further assistance with this, or if there's anything else I can do for you. Have a good one!

beyondbookeeping · ‎March 08, 2019

I did not quite follow what you were telling me but this is what I had done. When I connected my Discover Credit Card with three different account numbers to Quickbooks Online it rolls them all into one. I set up the sub accounts as shown and tried it again and it still rolled them all into one. Is there anyway to separate them out? When I check the CSV file from Discover Credit Card there are six columns which are Trans. Date, Post Date, Description, Amount, Category, Card Number. In Quickbooks Online it looks to me like there are the options of only 3 or 4 columns of information which are Date, Description and Amount with one column or Amount in two columns. Am I doing something wrong or is there something else I can do to correct this?

Rose-A · ‎March 08, 2019

Hello, beyondbookeeping.

Let me lend a hand in connecting your Discover Credit Card and provide you additional information about CSV file format.

Before connecting to Online Banking, you need to know how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the subaccounts and not the parent account.

You may want to check your parent and sub-accounts setup, here's how:

Select the Gear icon on the Toolbar.
Under Your Company, choose Chart of Accounts.
Select New.
In the Account Type drop-down, select the account type.
In the Detail Type drop-down, select the type of account you want to create.
If more than one choice appears in the Detail Type field, select the type of account you want to create.
In the Name field, enter a name for the account.
Select Save and Close (or Save and New if you want to enter another account right away).

To add a sub-account:

Follow the procedure in the previous section to create a parent account.
Select the Is sub-account checkbox.
Then select the Enter parent account drop-down arrow and choose the sub-account's parent account.

Also, regarding CSV file format, here's a recommended article for your reference: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/How-to-import-bank-transactions-using....

You may find these articles helpful:

Keep me posted if there's anything else I can help you with connecting multiple credit cards and CSV file. I'm always here to help you out.

olgavolk · ‎March 11, 2019

Hi!

What about the credit card payments, that would usually be booked to the master credit card?

Where would they need to be booked to, as the master account is tagged as sub account now?

Thanks,

Val V.

Charies_M · ‎March 11, 2019

Hello there, olgavolk.

Thanks for joining this thread. Let's get this sorted out.

Since you have credit card payments that is booked to the master credit card, you'll need to disconnect the sub accounts and make sure you are connecting the parent account for Online Banking.

Here's an article to know more about connecting accounts in QuickBooks Online (QBO): Connect the accounts to Online Banking.

Keep me posted on how it goes. I'm still here whenever you need help while working with Online Banking in QuickBooks.

olgavolk · ‎March 12, 2019

Hi Charies,

I have 4 Chase credit cards. One of them is a main card with 3 other ones being sub accounts (employees cards).

If I connect the master card as a parent account, than i am not able to connect the sub accounts, and vice versa.

I spoke to the qb rep yesterday and was told to add all the cards as subaccounts. Question is how do I book the payments in that case?

Thanks!

Olga

thegrubber · ‎March 12, 2019

Hi there. I have some confusion on the Amex as well. We have two company Amex cards which we linked. However each card has an additional cardmember and those transactions are not showing up. Is that what you mean by only one account can link to QBO?

If yes, how do I get all transactions in for those Amex cards?

BettyJaneB · ‎March 12, 2019

I appreciate the details you've given, @olgavolk.

I'm here to help share some clarifications on how you can book payments into the credit cards sub-accounts in QuickBooks Online.

When recording payments for credit cards with sub-accounts, if the payment is for the specific sub-account, then you can select the said account. However, if the payment is for the entire account, then you can select the parent account.

To reconcile the accounts you can just look for the account that you've used and match it with the transactions that you've created. To guide you with this process, please refer to this article: How to reconcile accounts.

To find and match the transactions, here's a helpful article that you can check out: Add and match downloaded banking transactions.

This should get you in the right track, @olgavolk.

Thanks for joining us here, @thegrubber.

In your case, you'll need to reach out to your financial institution to verify if what account is connected to QuickBooks Online. This can be the reason why your transactions are not showing up. Once verified, you can set up your other Amex account as a sub-account so you can use it with your transactions.

To guide you with this process, here are some articles that you can read through for more details:

That should do it!

Please know that you guys have me here in the Community if you have any other questions concerning bank accounts. I'm always here to help. Have a good one!

brigadetrading · ‎May 09, 2019

Hello Clay, the explanation you wrote is great! Only one question, you sent an article for amex business cards, and they are different from Amex personal cards, I have a personal amex platinum card and a secondary (sub account) amex card attached to it. I set up both accounts and the secondary downloads only it's own charges, and the main one downloads all the charges, both the main and sub, how do I get rid of the sub charges on the main account? Is there a step by step instruction how to set that up?

Anonymous · ‎May 09, 2019

Hi there, @brigadetrading,

It's nice to have you here today. I can share some information about connecting your sub-account in QuickBooks Online.

Before you start, it is best to identify the type of connection you need to establish in Quickbooks. If your transactions download to individual accounts, connect the sub-accounts and not the parent account.

At the moment, we're unable to connect both parent account and sub-accounts. If you try to connect both, you’ll get an alert that the account is already connected. To get started, follow the steps below:

Click the Accounting menu.
Choose Chart of accounts.
Locate the account you want to connect.
Tap View Register from the Action column.
Hit Connect bank.
Follow the onscreen instructions.

You can also find these steps from this article: Connect and add bank and credit card accounts to QuickBooks Online

Here are additional resources to guide you with your online banking set up:

About bank or credit card subaccount setup

How to use Online Banking, Connect Bank Accounts, and Review your Bank Feed in QuickBooks Online

That should get your work done for today. Please update me on how it goes by leaving a comment below. I'll be glad to work with you again. Have a good one!

Credit Card AMEX · ‎June 03, 2019

Has this been updated, Can you add more than one American Express Card?

MirriamM · ‎June 03, 2019

Thanks for visiting the Community, Credit Card AMEX,

I can provide information about connecting bank accounts.

Right now, you can only connect one American Express account into your QuickBooks Online company. Since connecting more than one American Express account might cause some syncing issues.

To know more about connecting American Express Business Card to QuickBooks, you may want to check this article: https://quickbooks.intuit.com/community/Help-Articles/Connect-your-American-Express-Business-Card-to....

If you have further questions concerning your QuickBooks Online account, please let me know. I'm always here to help.

MDBR · ‎July 12, 2019

I and my client are getting conflicting information on the subject of parent/sub credit card accounts. I was told by QB that we needed to connect the sub accounts, but post payments to and reconcile the parent account. The problem with that is that on the dashboard, the sub accounts show large balances which aren't correct because no payments are posted to those. And since we cannot connect both parent and sub accounts there is no easy visual to know what the credit card balance on QB actually is. I feel like I'm completely missing something here. Can you help?

Rose-A · ‎July 12, 2019

Hi, MDBR.

I can help and share with you some information about downloading transactions for main and sub-accounts in QuickBooks Online.

Before connecting to Online Banking, you need to know how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the sub-accounts and not the parent account.

When initially connecting your account, the same opening balance transaction may download to all sub-accounts. You must delete all but one of these balances when you reconcile.

Some banks may show the overall bank balance at each sub-account level. This is because the bank provides us with a static balance of the entire account, not the balance of each sub-account.

You can get more details in this article: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/About-bank-or-credit-card-subaccount-....

For account discussion, feel free to reach out to our QuickBooks Online Support. To reach us, please follow these steps:

Sign into your QuickBooks Online Company.
Click (?) Help at the upper right corner.
Select Contact US on the pop-up.
Enter a brief description of your concern then hit Continue.
Click Get a callback.
Enter your contact information.
Select Call me.

Don't hesitate to drop a reply below if you have additional questions. I'll stick around to help.

MDBR · ‎July 12, 2019

I believe I have the accounts connected correctly. The issue is that since we reconcile and post payments to the parent account, no payments show on the sub accounts. Therefore the sub accounts show balances that are a total of everything that's ever been charged, with no payments applied. Do I need to make journal entries to rectify that?

Topics

Training

Community

Resources

Multiple Credit Card Accounts