Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 10, 2018
Solved

Multiple Credit Card Accounts

  • May 10, 2018
  • 4 replies
  • 83 views

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.

    Best answer by ClayJ

    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-to-a-primary-account . Should you need anything else, I'm a comment away. 

     

    4 replies

    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?

    NathandhAuthor
    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
    ClayJAnswer
    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-to-a-primary-account . Should you need anything else, I'm a comment away. 

     

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

    June 3, 2019

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

    QuickBooks Team
    June 4, 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-QuickBooks/m-p/188065.

     

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

    Rose-A
    Level 10
    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-setup/m-p/186230.

     

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

     

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

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

    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?
    July 12, 2019

    I'm here to help, @MDBR.

     

    In your case, you'll have to reconcile first before creating a journal entry. If you do it the other way around, this will confuse the reconciliation process and will show duplicates.

     

    When posting moving forward, you'll need to ensure these are allocated to the correct accounts so you can reconcile all the transactions easily.

     

    Should you need other references for banking transactions, feel free to visit our site: Banking and Bank Feeds for QuickBooks Online.

     

    Please let me know if you have further questions about your sub-accounts. I'll be more than happy to help out.