Hello, lupinecase.
I understand the importance of reconciling an account to ensure that the balance in QuickBooks matches your bank and credit card statement balance. I'm here to assist you in eliminating duplicates during reconciliation.
First and foremost, could you tell me the name of your bank linked to your QuickBooks account? This will assist me in determining whether or not there has been a reported issue with duplicate transactions.
When you connect your bank account, QuickBooks downloads transactions depend on the information shared by your financial institution. One of the possible reasons for a duplicate is that you've recorded the transactions within QuickBooks and added the uploaded transactions from the Banking page instead of matching them.
Let's check your Audit log report so we can determine the proper action to take to remove the duplicates. Here we'll know if someone added transactions or if they were downloaded from your bank account.
Here's how:
- Sign in to your QuickBooks Online (QBO) account.
- Navigate to the Gear icon.
- Select Audit log.
- Click the Filter drop-down menu.
- Personalize it to All users, select Show all events, or thick the Transactions box.
- Then hit Apply
- Select the duplicate transactions and delete them.
Additionally, you can consider undoing and excluding the duplicates if they're coming from downloaded transactions. I'll show you how.
- Go to the Banking menu.
- Select the appropriate bank account.
- Go to the Categorized tab, then find the duplicate transactions.
- Click Undo under the Action column.
After that, the transactions will be back to the For Review tab. Then, you can exclude them.
Once everything is in order, you can now proceed with reconciling your account. I've also included this article if you need to fix issues from the past reconciliation period: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
Don't hesitate to reply if you need further assistance with reconciliation. I'll be delighted to work with you again.
