Skip to main content
A
AshleyK2
July 10, 2022
Question

linking bank creates new G/L account

  • July 10, 2022
  • 3 replies
  • 0 views

I just started at a new company and they had the bank account linked but weren't matching transactions.  There were over 10,000 unmatched transactions, so I decided to unlink the account to get rid of those, and then turn linking back on with my credentials instead of the old ones.  I did this for three companies.  Two worked fine, but on one of them every time I try to link it, it creates a new bank account in QuickBooks instead of linking to the current one and posts a beginning balance entry in the new account.  I know I'm doing the steps correctly since I did it fine on the other companies.  How can I get it to link to the current account instead of creating a new one?

    3 replies

    katherinejoyceO
    katherinejoyceO
    July 10, 2022

    Hello there, @AshleyK2.

     

    Thanks for asking the Community today. I'm pleased to guide you with linking your bank account to an existing one in QuickBooks Online. 

     

    Each bank have a different ways on transmitting their transactions. Hence, when connecting bank accounts to online banking, it's best to know how your bank sends the downloaded transactions beforehand.

     

    So, if your connected bank download transactions to one account, you'll need to connect only the parent account. However, if the transactions download to the individual accounts, connect the subaccounts and not the parent account.

     

    For further insights about this process, you can check out this article: About bank or credit card subaccount setup. 

     

    Here's another article that you can guide and give you a better idea on creating subaccounts in your chart of accounts in QuickBooks Online

     

    Visit us again and post some more if you have additional concerns. I'll be there right away to guide you again. 

     

     

    A
    AshleyK2Author
    July 11, 2022

    Hi,

    It's the same bank on all three companies, and the same account setup.  There are no parent accounts.  It's just one bank account to match to one QB account.  I select the account in QB and then do the steps to link it, but instead of linking that QB account it creates a new account.

    Adrian_A
    Adrian_A
    July 11, 2022

    I appreciate you for getting back to us, AshleyK2.

     

    Let's run a few troubleshooting steps to identify what causes this issue.

     

    There are instances queries like this occur when the system encounters browser-related issues.

     

    To start with, link your account using an incognito window. It is the best way to isolate any browser-related issues. You can use these keyboard keys to open one:

     

    • For Google Chrome: Ctrl + Shift + N
    • For Mozilla Firefox: Ctrl + Shift + P
    • For Microsoft Edge: Ctrl + Shift + P
    • For Safari: ⌘+ Shift + N

     

    If the account links to the existing one, you can continue working on it on a regular browser and clear the cache. It refreshes the page so it will load faster.

     

    You also have the option to switch to a different browser like Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge.

     

    I've also added these links as your guide in categorizing the transactions:

     

     

    I'll be around when you need my help in categorizing the transactions.

    M
    M_S_F
    July 16, 2022

    I’ve been linking GL Chart of Accounts to QBO bank link for years. I just started experiencing issues similar to what you described this week. Not sure what is causing it… but when I connect bank, it shows my bank’s list of accounts, but doesn’t let me select from my GL to assign. And same error when I try connecting straight from my chart of accounts. Only lets me setup a new GL, which is not what I want. 

    R
    ReymondO
    July 16, 2022

    Good day, @M_S_F.

     

    Thanks for joining the thread and your banking concerns with us. Allow me to provide you with further help in linking your account to online banking. 

     

    Once you connect your account from the Chart of Accounts window, you should be routed to the online banking page. At times, too much cache build-up in your current browser might be the cause of the issue. This can be the reason why you're getting this kind of behavior in QuickBooks. 

     

    I'd recommend following the suggested troubleshooting steps that were shared by my colleague Adrian_A above. This will help us identify if the problem is cache-related. 

     

    In case you're still getting the same result, reach out to our QuickBooks Support Team. They can perform a further investigation and help you with the process of connecting your account to online banking. 

     

    Simply follow these steps to connect with them:

     

    1. Click the Help menu in the upper-right hand corner and click Talk to a human.
    2. Type in "Talk to a human", then press Enter.
    3. Look for I still need a human and click on it.
    4. Select Get help from a human.
    5. Choose between Chat with us, Schedule an appointment, or Have us call you.

     
    Please check out our support hours to ensure that we address your concerns on time.

     

    While working, you can also manually import your bank transactions to QuickBooks using a CSV file. This way, you can match them with the ones you've already entered into the program. Just make sure to open and review the file from your bank. Make sure it's in the correct format before you upload it.

     

    Once your transactions are in QuickBooks, it's time to match and categorize them. The transactions go into your accounts after you review them. QBO also enters certain details automatically if you set up any banking rules, or if it recognizes transaction descriptions.

     

    Please let me know if the suggestions above help fix the issue. I want to ensure that you're able to connect with your financial institution and continue with your business. Have a great rest of the week.

      M
      M_S_F
      July 18, 2022

      I tested two separate troubleshooting fixes this morning. The first one was: opening in a private browser window. By doing this I was able to select from active chart of accounts. The second troubleshooting workaround was: to clear browser cache. By doing this I was also able to select from active chart of accounts.

       

      Note on Troubleshooting QBO Bank Link: After linking two accounts successfully in private browser window, I went into Link a third and ran to the same issue where the active chart of accounts was not displaying as an option from the drop-down menu. By closing all browsers and opening a new private browser window, I was again able to see the active chart of accounts. 

       

      So I am back in business and ready to catch up on some bank reconciliations. 

        A
        AshleyK2Author
        July 16, 2022

        I ended up merging the new account it created into the old account so at least the account is linked and updating again.  Unfortunately, all of the old unmatched transactions came back when I did that, even though I told the new link to only pull transactions from today.  

        C
        Charies_M
        July 16, 2022

        Welcome back, AshleyK2.

         

        No worries! You'll just need to exclude those old and unmatched transactions from your Bank Feed in QuickBooks Online (QBO).

         

        Here's how to exclude:

         

        1. Go the Banking menu and choose the For Review tab.
        2. Select the transactions you want to exclude.
        3. Click the Batch Actions drop-down arrow and select Exclude Selected.

        This will move the transactions to the Excluded tab from the For Review tab.

         

        You may find this article handy to learn more about the process of excluding downloaded transactions in QBO.

         

        If you wish to permanently delete them, you can follow the steps below:

         

        1. Go to the Excluded tab.
        2. Select transactions to delete.
        3. Click the Batch Actions.
        4. Hit Delete.

        You know where to find me if you have follow-up questions managing your bank transactions. I'll be around in the Community and I'm always happy to assist. Have a good day ahead!

        A
        AshleyK2Author
        July 16, 2022

        Yes, but it's not that easy when there are over 10,000 transactions and you an only exclude what shows up on the screen.  It will take days to get through it at this rate, unless there's some way to exclude all at once??

        Terms & ConditionsAccessibility statement