How do I correct duplicated bank transactions in my bank register from transactions added that were already in the register?

It's good to hear you've converted from QuickBooks Desktop to QuickBooks Online (QBO), btsaccounting. The easiest way to deal with duplicated transactions is by matching them to your bank feed. Let me provide you with the steps below.
 

The system will detect if there's a possible match transaction in your bank feed. When they do, you can match them by clicking it and selecting Match.

Here's how:

1. Go to Transactions, then select Bank feed.
2. Select the Tile where the duplicate transaction is associated.
3. Click the transaction that has matches found. 
4. In the Match section, confirm if the details are the same.
5. Once confirmed, click Match.
   

Kindly refer to this article for guidance in categorizing your transactions in QBO.

Additionally, if there are transactions you no longer need, you can exclude them. All excluded transactions will be stored in the Excluded tab.

Feel free to enhance your financial trajectory by working with our QuickBooks Live Expert Assisted team. These financial maestros streamline your processes and provide bespoke advice to meet your business's unique needs. Click now to embark on a new era of financial clarity and success.

Furthermore, feel free to refer to these articles in managing your bank transactions in QBO:

• Set up bank rules to categorize online banking transactions in QBO
• Reconcile an account in QBO

You can always reach out to us if you have any questions or any other concerns about managing your transactions. The Community is here to provide the target solution to your needs. Take care.

Nope. You're misunderstanding me. This is AFTER the bank transactions have already been added to the register. Now we have a ton of duplicate transactions in our bank register. Is there a way to correct this easily, such as deleting them all and re-downloading bank transactions?

Hi there, btsaccounting.

Yes, we can remove transactions that have already been recorded in the bank register,  however, they need to be managed manually. It's essential to ensure that you back up your data before conducting extensive deletions to prevent the risk of data loss. Below, I'll detail the procedures involved.

For transactions already in the register that are duplicated, here's how:

1. Go to the Bank transactions menu.
2. Click Go to bank register on the right corner.
3. Find the relevant bank account and click on it.
4. Look for duplicate transactions. You can sort transactions by date or amount to make this easier.
5. Then, choose Delete.

I've added a screenshot for your reference.

If you need to remove all recently downloaded transactions to start fresh, you would typically need to exclude them all and then manually delete recorded duplicates.

Here's how to exclude transactions:

1. Go to Transactions, then select Bank transactions.
2. Select the For Review tab.
3. Select the checkbox of the transactions to exclude.
4. Select Exclude.

Here's how delete them:

1. Go to Transactions, then select Bank transactions.
2. Select the Excluded tab to see a list of transactions that have been excluded from the bank feed.
3. Select the checkbox of the transactions to delete.
4. Select Delete.

For complete guidance about this topic, we can check out this resource: Exclude a bank transaction you downloaded into QuickBooks Online.

Moreover, we can check out his resource for future reference on how to reconcile your accounts, so they always match your bank and credit card statement: Reconcile an account in QuickBooks Online.

Before we wrap up, I suggest you explore QuickBooks Live Bookkeeping to streamline your accounting, maintain precise financial records, and access professional support. This could free up valuable time, allowing you to concentrate on expanding your business.

If you have further questions about duplicate transactions in QBO, feel free to return here in the Community. We'll provide continuous assistance. Have a great one.