Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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.
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:
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.
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?
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:
Once done, let's mark the transactions as Excluded. From here, you can now permanently delete the duplicate transactions.
Here's how:
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!
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
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!
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:
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!
Are you doing this in both the checking AND the Credit Card OR Just the checking (r CC)???
I've been going insane with the same issue. If I reconcile the credit card it messes up the checking account and vice versa.
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:
You can follow these steps to exclude the transactions:
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here