Duplicate Transaction After Reconciliation

Is this your first time reconciling or your first time using Bank Feed?

The transactions with the C are the ones Bank Feed matched to when you downloaded your bank info.  The ones with the R are the ones you Reconciled.

Is it possible that when you downloaded the Bank Feed you manually accepted all of the transactions vs. matching them to existing ones?  The Bank Feed can miss existing transactions when the bank has a different name than what you have entered in QBO.  (That's where the Renaming Rule comes into play.) 

Let us know if this is NOT the issue.  But if it is, here is one workaround. 

 I'm going to assume that many of your entries were through Bill Pay or Customer payments.  So deleting those transactions would change multiple things withing QBO.  Keeping that in mind, start at the bottom of your register (today's date) and slowly go up the list of Non-Reconciled transactions and look for duplicates.  NOTE: The entries from the bank may be on a later date than what you entered.  The Bank shows when the transaction hit them, you show when you initially entered it.  Feel free to change the Bank's date.

You want to keep the entry that is tied to the Bill Pay, Customer Payment, etc.  The incorrect entry may still be tied to what appears to be a correct Account, but just make sure which one is correct so that you do not delete and entry tied to other QBO entries.  When you're sure, Delete the duplicate you do not need.

Once you're done with the UnReconciled entries, now look at the Reconciled items you just finished.  Hopefully the items you Reconciled are the correct ones and all the Cleared (C) items will be the duplicates.  But again, be very certain.  Once all the extras are deleted you balance should be back to normal.

Going forward, you want to make sure you Match to transactions every time you do a Bank Feed do not just Accept items that do not match. 

When I get one that does not match I go do the transaction correctly, even if it's an ATM withdrawal I just hadn't put in yet or maybe a Dividend Direct Deposit.  Then I go back to the Bank Feed window and the item(s) should now show as Matched.  Often the Bank will also have a different name and QBO just misses the existing entry.  

Remember that the Bank Feed is just a quicker way to let you MATCH to transactions and look for any errors or unexpected activity in your Bank Account.  It is not meant to be an Auto Entry tool.

Hope this helps.  Let us know if the above was a waste and you have a different issue.

Hi there, minie123. 

I've answered a similar question with regards to your concern. Please click here to open the thread. 

The Community is always around to help you if you have other questions.