Uncleared duplicate transaction(deposit) from last year that show up in reconciliation report

Hi, I am having a bit of a problem with reconciliation. 

Recently, I realized there are 2 uncleared transactions(deposits) that were overstating/understating the QB bank balance, which made my report inaccurate. The thing is these 2 uncleared transactions are from last year (2022) and are duplicates of transactions that have been reconciled. It only showed up as uncleared in the reconciliation report for the month of March 2023. I didn't realize it would be a problem until it is.

I searched many sources from the community and found that since the uncleared deposits cannot be voided, it could only be deleted from the bank registry. Since it was an uncleared transaction, I thought it was fine to delete it, however, when I delete the 2 uncleared transactions. It actually messed up with my reconciliation, stating that I had a difference of RM1620 (810 +810). This is when things get weird, when I deleted the duplicate transaction, it actually deleted the correct transaction that has been reconciled as well. Almost like it was linked. I checked the categorized banking feeds and find that there were no duplicates of the transaction that has been added. The duplicates only show up when I try to reconcile. 

Then I tried to change the amount of the duplicate (RM810) to 0, to test my theory of the duplicate being linked to the original transaction, and yes, my theory was correct. When I changed the uncleared amount, it made a difference of RM810. I honestly have no idea if the duplicate transaction is a glitch or not.

Below is a screenshot of the uncleared transaction with the reconciled one (the correct one). The duplicate one is a deposit but it is on the payment column for some reason.How do I solve this?