Skip to main content
C
c-whatley-live-c
February 11, 2024
Question

Duplicate current account after reauthorising bank account

  • February 11, 2024
  • 1 reply
  • 0 views
our bank account had been disconnected from quickbooks for months and months due to no treasurer in post.  I'm the new treasurer.
When I re-authorise the bank connection to quickbooks, it needs to know what type of account to create, so I said bank current account I think.  When the connection has been made and the bank account transactions brought over, I end up with 2 bank current accounts in Quickbooks, the exisitng one with the balance from months ago and a another with the correct current balance but empty of transactions.
I can't connect to the bank without it asking for the account type which generates the new bank account in QB !!

1 reply

A
AnneMariee
February 11, 2024

Thanks for posting here in the Community.

 

Having duplicate accounts after reconnecting a bank account in QuickBooks Online (QBO) is unusual behaviour. Let's find the root cause to resolve this issue so your accounts connect seamlessly.

 

First, the bank account may have been reconnected to the incorrect account in QuickBooks. A new account may have been added instead of selecting the preexisting one. This can cause the new account to reflect the correct current balance without the transactions. To fix this, you'll need to disconnect the newly reconnected account, merge the accounts in the Chart of Accounts, and reconnect the account. I'll be here to guide you every step of the way.

 

To disconnect the account, kindly follow the steps below.

 

  1. On the left navigation panel, click Transactions.
  2. On the Bank transactions tab, tap the pencil icon of the bank account you need to disconnect.
  3. Select Edit account info.
  4. Tick Disconnect this account on save.
  5. Hit Save and Close.

 

Once you've disconnected the account, the next step is to handle the duplicate in the Chart of Accounts.

 

  1. Click the Gear icon.
  2. Select Chart of Accounts under Your company.
  3. Find the duplicate account. Click the dropdown in the Action column.
  4. Then, press Edit.
  5. Change the Name and Detail Type so the duplicate account's info matches the account you want to keep exactly.
  6. When ready, hit Save and then Yes to confirm.

 

After that, reconnect the bank account to QBO.  By performing these steps, you can streamline your bookkeeping process and avoid any confusion or errors caused by duplicate bank accounts.

 

On the other hand, if you've confirmed that you reconnected the bank account to the correct account and still got duplicates, I recommend contacting our Customer Care Team. They can review your account in a safe and secure environment and conduct further investigation as to why you're experiencing this issue.

 

Once everything looks good, you can refer to this comprehensive guide on ensuring your QuickBooks accounts correspond to your real-life bank statements: Reconcile workflow.

 

Keep me posted if you have more questions about connecting your bank accounts to QuickBooks. I'm just one post away to help you out.

C
c-whatley-live-cAuthor
February 12, 2024

Hi AnneMariee:

 

Thank you for your help.

 

I have carried out all the steps you said but still have problems.

 

I disconnected the account (disconnect this account on save) ok, Renamed the duplicate account to the same as the original account, said yes to merge accounts.  Now the bank balance is correct but there are zero transactions apart from an opening balance equity dated 16 November 2023 which looks like it might have been the QB balance back in November 2023, possibly when QB was last used by anyone.

A
AnneMariee
February 12, 2024

Hello there,

 

Thanks for getting back to this thread, and I appreciate you following the steps I've provided. Allow me to provide further guidance so your accounts connect seamlessly and your transactions appear in QuickBooks.

 

First, ensure you've successfully reconnected your bank account after merging the accounts in the Chart of Accounts. Once you've done that, I recommend looking around at the Banking menu. Your transactions may be under the For review tab. You'll need to review and categorise them into the correct categories if they are. You can either add, match, or exclude your transactions. I'll outline the differences between them below.

 

Matching links a transaction that flows into your bank feeds with one you've already entered. This ties them together, so you don't get duplicates. 

 

Here's how to match an existing transaction:

 

  1. Find a downloaded transaction with the Match option in the Action column.
  2. Note the Date, Description, Payee, and amount spent or received.
  3. Select the downloaded transaction.
  4. Review the Matching records found in QuickBooks.
  5. Click the link next to each match to get more details.
  6. Verify if this is the correct match. 
  7. If it is, close the open transaction.
  8. Select Match.

 

When QuickBooks cannot find an existing transaction that matches, adding a new transaction starts a fresh transaction for you. Moreover, excluding transactions ensures that they do not appear in your accounts or financial reports. For more detailed information on reviewing your transactions, you can refer to this article: Categorise and match bank transactions.

 

However, if you're unable to view your transactions under the Banking menu, it's possible that the transactions were downloaded previously. In this case, you'll need to contact your bank's website and request a CSV file of your transactions. After obtaining the file, you need to manually upload it into QuickBooks.

 

For future use, here's an informative guide that outlines a step-by-step process for seamlessly synchronising your QuickBooks accounts with your bank statements: Reconcile workflow.

 

Feel free to reach out if you have any further questions about banking in QuickBooks. I'm always ready to help!

Terms & ConditionsAccessibility statement