cancel
Showing results for 
Search instead for 
Did you mean: 
Likensbooks
Level 1

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

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?

Solved
Best answer December 02, 2020

Best Answers
MadelynC
Moderator

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

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.

View solution in original post

10 Comments 10
MadelynC
Moderator

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

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.

byroncrowley-gma
Level 1

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

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?

AbegailS_
QuickBooks Team

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

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!

AngelaA13
Level 1

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

This is happening to us too. Everytime I exclude them, I click update, and they re-appear in the bank feed. At one point it duplicated them 51 times in the bank feed and they just keep re-appearing

AngelaA13
Level 1

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

This is happening to us too. At one point 51 of them duplicated in the bank feed. I clicked on all of them and excluded but every time I click update, they re-appear in teh bank feed. The transactions in the bank register are not duplicated because I am excluding them from the bank feed. Looking to see how to make them so showing up. I logged into our credit card site just to make sure they weren't happening there, and they aren't. They are dating back to 3/19, 3/26 and 4/26 which is when they actually first hit. Help!

Rubielyn_J
QuickBooks Team

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

I've got your back to get rid of duplicate transactions on your banking feeds, @AngelaA13.

 

When doing a manual update, QuickBooks will download whatever your bank will share with us. That being said, you can only clear duplicate transactions by excluding them. 

 

At times, we roll out enhancements based on our customer's requests. That being said, I suggest sending a recommendation to our product developers to ensure you can clear all duplicate transaction in the register. They'll review this idea and might consider updating it in the future.

 

Here's how:

 

  1. Go to the Gear located at the top.
  2. Under Profile, click Feedback.
  3. Enter your recommendation and select Submit.

 

You can also utilize this link to check the status and keep you in the loop on our progress of your request: Customer Feedback for QuickBooks Online.

 

I also encourage you to visit this articles that will guide you in managing your banking transactions in QuickBooks: 

 

 

As always, add a comment below if you have any other questions about handling banking concerns QuickBooks. I'm here to help always. Take care!

scolsl
Level 1

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

Are you doing this in both the checking AND the Credit Card OR Just the checking (r CC)???

ATT55
Level 1

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

I've been going insane with the same issue.  If I reconcile the credit card it messes up the checking account and vice versa.  

JamesAndrewM
Moderator

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

I know this has to be so hard on you, @ATT55. Let's work hard together to get this reconciliation error fixed.

 

You may have linked your checking and credit card accounts in QuickBooks Online. If this is the case, both accounts will have the same set of transactions posted. It also leads to duplicate entries.

 

To resolve the duplicate entries, either matches them in the bank feeds or exclude the duplicates from the Chart of Accounts. Here's how it's done:

 

  1. Find a downloaded transaction, and under the Action column select Match.
  2. Note the DateDescriptionPayee, and amount spent or received.
  3. Choose the downloaded transaction to expand the view.
  4. Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
  5. Select the link next to each match to get more details.
  6. Make sure this is the correct match. In particular, review the Deposit toPayment method, and Bank account fields on forms for the existing transaction in QuickBooks.
  7. If this is the correct match, close the open transaction.
  8. Select Match.

 

You can follow these steps to exclude the transactions:

 

  1. Go to Menu ☰ and select Transactions.
  2. Choose Review transactions.
  3. Click the transactions to exclude, then select the trash can icon.
  4. Select Confirm.

 

You may visit these links to guide you on how to categorize your transactions and reconcile your account flawlessly:

 

 

The Community always welcomes you for further inquiries about transactions. Have a great day ahead!

TwoShoes2
Level 1

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

Thank you James Andrew, but what about the case where the duplicated transactions have both been reconciled. One in the bank account and one in the credit card. Neither can be deleted without messing up the other bank reconciliation. This is for a whole year as the uncleared in one account were cleared in the other account and the QB user misunderstood "reconciled", not knowing it was not counting uncleared transactions. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us