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

I have duplicate bank transactions and I can't exclude one of them since they both say they are apart of another transaction. What do I need to do?

 
Solved
Best answer November 30, 2020

Best Answers
BettyJaneB
QuickBooks Team

I have duplicate bank transactions and I can't exclude one of them since they both say they are apart of another transaction. What do I need to do?

I'm here to ensure that you'll be able to exclude your duplicate transactions in QuickBooks Online, @GFWS.

 

Being unable to exclude one of the duplicate bank transactions in QuickBooks Online can be caused by a partially matched entry. To get this issue sorted out, I recommend unmatching the transaction from the entry that you have in QBO.

 

To do that:

  1. Go to the Banking menu.
  2. Refer to the Banking tab.
  3. Select tile for the bank or credit card account you downloaded the transaction from.
  4. Select the Categorized tab.
  5. Find the transaction you want to unmatch.
  6. Select the blue transaction link in the Added or Matched column to see the matched transaction.
  7. Press the Undo from the Action column. 

For additional information about unmatching bank transactions in QBO, please check out this link: Learn how to undo or unmatch transactions downloaded into QuickBooks Online.

 

Once done, you can proceed with excluding the bank entries. 

 

Here's how:

  1. Go to Banking menu on the left panel.
  2. Choose Banking tab.
  3. Check the box for beside the transactions you want to exclude.
  4. Click the Batch actions drop-down and choose Exclude Selected.

 

I've got here a reference that you can bookmark to guide you in excluding bank transactions: Exclude a bank transaction from your expenses in QuickBooks Online.

 

Drop me a reply if you have any follow-up questions about excluding transactions. I'm always happy to help.

View solution in original post

3 Comments 3
BettyJaneB
QuickBooks Team

I have duplicate bank transactions and I can't exclude one of them since they both say they are apart of another transaction. What do I need to do?

I'm here to ensure that you'll be able to exclude your duplicate transactions in QuickBooks Online, @GFWS.

 

Being unable to exclude one of the duplicate bank transactions in QuickBooks Online can be caused by a partially matched entry. To get this issue sorted out, I recommend unmatching the transaction from the entry that you have in QBO.

 

To do that:

  1. Go to the Banking menu.
  2. Refer to the Banking tab.
  3. Select tile for the bank or credit card account you downloaded the transaction from.
  4. Select the Categorized tab.
  5. Find the transaction you want to unmatch.
  6. Select the blue transaction link in the Added or Matched column to see the matched transaction.
  7. Press the Undo from the Action column. 

For additional information about unmatching bank transactions in QBO, please check out this link: Learn how to undo or unmatch transactions downloaded into QuickBooks Online.

 

Once done, you can proceed with excluding the bank entries. 

 

Here's how:

  1. Go to Banking menu on the left panel.
  2. Choose Banking tab.
  3. Check the box for beside the transactions you want to exclude.
  4. Click the Batch actions drop-down and choose Exclude Selected.

 

I've got here a reference that you can bookmark to guide you in excluding bank transactions: Exclude a bank transaction from your expenses in QuickBooks Online.

 

Drop me a reply if you have any follow-up questions about excluding transactions. I'm always happy to help.

SondraB
Level 1

I have duplicate bank transactions and I can't exclude one of them since they both say they are apart of another transaction. What do I need to do?

Good morning, I have a common situation in which I want to exclude only a part of a transaction. I'm receiving Neon One payouts through my bank, but they contain multiple transactions within the single instance. I need to itemize each of them, and some are duplicates with other transactions (the reason is too complicated to explain here). Each time I categorize these I use "split" to assign to the correct account. I want to be able exclude a part of this split (or just somehow take away this value). How can I do this? Thanks in advance!

ChristineJoieR
QuickBooks Team

I have duplicate bank transactions and I can't exclude one of them since they both say they are apart of another transaction. What do I need to do?

I understand what you were trying to say, @SondraB.

 

I can provide you with additional information about dealing with duplicate transactions in QuickBooks Online.

 

What you're doing is right about splitting with identical transactions and putting them into the correct accounts. Aside from breaking them, the workaround is to Find other matches.

 

If you need to remove the portion of the transaction, the only way to do it is to exclude them from the For Review tab, then re-enter the transaction manually. 

 

Here's how:

 

  1. Go to Settings ⚙ and select Chart of accounts.
  2. Find the account register you want to review.
  3. Click the View register from the Actions column.
  4. At the top of the list, select the Add journal entryAdd check, or Add deposit dropdown menu.
  5. Select the type of transaction you want to add.
  6. Fill out the fields to complete the transaction.
  7. Lastly, select Save.

 

You can also review the topics from this link for extra resources while working with your bank transactions in the future: Find help with bank feeds and reconciling accounts.

 

Do you need a guide for reconciling accounts in QuickBooks? Could you get back to us? I'll make sure you get the answer that you require. 

Need to get in touch?

Contact us