Skip to main content
B
btsaccounting
April 5, 2025
Question

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

  • April 5, 2025
  • 1 reply
  • 0 views

Just converted from Desktop to QBO and downloaded Bank Transactions. Many of them were duplicated when added, so now we have a ton of duplicate transactions. What's the easiest way to rectify this such as deleting them all from the register and re-downloading?

1 reply

R
RhoiceW
April 5, 2025

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:

 

 

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.

B
btsaccountingAuthor
April 6, 2025

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?

J
JeveeAdvin__la
April 6, 2025

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.

Terms & ConditionsAccessibility statement