Skip to main content
L
Likensbooks
December 2, 2020
Solved

URGENT: How to get rid of the duplicate transactions in the register when transfering a payment to a credit card from linked accounts? my quckbooks balance is off

  • December 2, 2020
  • 1 reply
  • 0 views

I need to provide a P&L and Balance Sheet to my employer today.

I am reconciling my accounts, and I have several credit card payments and transfers between accounts that are showing up as duplicates in the registers, it is causing my accounts to be off from what the bank balance is. 

How do I fix this?

Best answer by MadelynC

I’ll help you resolve these duplicates so you can reconcile your accounts successfully, @Likensbooks.


There are several reasons for duplicates. If the linked account you’ve mentioned is a checking, this might be the reason for duplicates.


When checking and your credit card are both connected in QuickBooks Online, doubled entries usually happens. The moment you transfer funds from your checking to your credit card, both accounts will post the same set of transactions. You could have matched them in the bank feeds to settle the entries.


Otherwise, you’ll want to delete the duplicate events under Chart of Accounts to get this fix. Let me show you how:

 

  1. On the left panel, click the Accounting tab.
  2. Select Chart of Accounts.
  3. Locate the account that creates duplicate transactions, then selects the View register under the Action column to view the events.
  4. Click each transaction and then select the Delete button.


This article helps you find, review and edit transactions in the account registers. You can use it for your reference.


It would be best to reach out to an accountant also to ensure reporting remains accurate. They can guide you thoroughly with this matter and have some tips to avoid this issue moving forward.


Don’t hesitate to reach out back if you have other concerns with your register. I’ll be here anytime.

1 reply

M
MadelynCAnswer
December 2, 2020

I’ll help you resolve these duplicates so you can reconcile your accounts successfully, @Likensbooks.


There are several reasons for duplicates. If the linked account you’ve mentioned is a checking, this might be the reason for duplicates.


When checking and your credit card are both connected in QuickBooks Online, doubled entries usually happens. The moment you transfer funds from your checking to your credit card, both accounts will post the same set of transactions. You could have matched them in the bank feeds to settle the entries.


Otherwise, you’ll want to delete the duplicate events under Chart of Accounts to get this fix. Let me show you how:

 

  1. On the left panel, click the Accounting tab.
  2. Select Chart of Accounts.
  3. Locate the account that creates duplicate transactions, then selects the View register under the Action column to view the events.
  4. Click each transaction and then select the Delete button.


This article helps you find, review and edit transactions in the account registers. You can use it for your reference.


It would be best to reach out to an accountant also to ensure reporting remains accurate. They can guide you thoroughly with this matter and have some tips to avoid this issue moving forward.


Don’t hesitate to reach out back if you have other concerns with your register. I’ll be here anytime.

B
byroncrowley-gma
April 10, 2022

When you delete from chart of accounts it simply puts it back in the for review section in banking.  Any suggestion on how to completely delete dupes.  I have a similar situation where somehow QuickBooks pretty much duped every charge for the last 6 months on my credit card.  Is there some sort of merge feature like on a cell phone when you have duplicate contacts or something similar?

    A
    AbegailS_
    April 10, 2022

    I'll lend you a hand with removing duplicate transactions in QuickBooks Online (QBO),  @byroncrowley-gma.

     

    Let's first remove the duplicate transactions from your register. Once completed, we can exclude and delete it from the Banking page.

     

    Here's how:

    1. Go to the Banking menu.
    2. Select the Banking tab.
    3. Choose the account where the transactions are recorded.
    4. Pick the Reviewed tab.
    5. Search for the duplicate transactions.
    6. Mark the duplicate ones.
    7. Click on Undo. 

     

    Once done, let's mark the transactions as Excluded. From here, you can now permanently delete the duplicate transactions.

     

    Here's how:

    1. Click the Banking menu.
    2. Choose the Banking tab.
    3. Go to the For Review tab.
    4. Select all duplicate transactions.
    5. Click Batch actions, then select Exclude Selected
       

    After removing all the duplicate transactions from your bank register, you can now proceed with reconciling the account. For more guidance, feel free to check out this article: Reconcile an account in QuickBooks Online.

     

    Also, if you want to merge duplicate accounts and vendors, you can check this article: Merge duplicate accounts, customers, and vendors in QuickBooks Online.

     

    Message me again in the comment so I can check on you again. I'll be waiting for your response as I want to ensure this is resolved. Have a good one!

    Terms & ConditionsAccessibility statement