Bank statement duplicates on PLN account

Continuing the discussion from Bank statement duplicates:

I seem to have the same problem. I did two CSV imports using ‘Other’ in Please Select Your Bank pulldown. Imported transaction dates were slightly overlapping and I got duplicate entries.

Also, when researching the topic, I’ve found this post by @Glenn:

The testing process seems not to work for me :cry:, which is a hassle.

If you look under Account Settings → Advanced features, you will find an option to widen the window where it looks for duplicate transactions - by default the dates must match exactly, but you can relax this to up to seven days each way.

I managed to replicate the issue here, but it only affects non-GBP bank accounts for some reason?

I’ve escalated it for further review.

1 Like

Probably the original and “duplicate” transactions using different exchange rates and the GBP values don’t match.

1 Like

Seems to be a likely cause!

Thank you for getting on the issue so quickly!

We’ve fixed this on development and it should be deployed later today.

The problem was the duplicate checker looking at the GBP value rather than the amount in currency. This looks to have appeared a few weeks ago and has effectively broken duplicate checking on foreign accounts.

1 Like

Thank you so much! This problem has caused me several hours of reconciliation effort :smile:

I apologise, I may be able to rollback a CSV import to the bank if this is still required?

No need for such a drastic measure :smile: I have been able to hunt down all the duplicates and delete them.

UPDATE:

Duplicate filtering should now work fine on foreign currency accounts.

1 Like

Thank you for resolving the issue so quickly.

1 Like