Bank reconciliation duplicates

Accounting
1

Hi, so I thought it was a good idea to start reconciling my bank statements. I started by uploading a csv file and ignoring the conflicts.
I then saw that I had lots of untagged transactions i.e. payment to supplier for £100 on 09.jan.2014
I had already logged that payment in the system but it won’t find it, I guess because it is already tagged?

If in bank reconciliation, I add the transaction as new supplier then it shows up as duplicate.

Do I have to delete one? which one? Can I just join them together in anyway?

Thanks in advance

2

I should probably add my (probably very stupid) solution so far is the following.

  1. find the duplicates in my bank account
  2. going into the original logged payment that has the receipt attached
  3. saving the receipt to desktop
  4. tagging the actual payment that was brought in via cvs
  5. manually attaching the receipt that I just saved to my desktop
  6. deleting the original payment.

I’m pretty sure I’m doing this completely wrong. Simple solution would be great :slight_smile:

3

Yes just delete the untagged one that was brought in on the CSV, as long as the dates and amounts match you will be fine and your bank will reconcile.