Continuing the discussion from Bank statement duplicates :
Hello,
We’ve been uploading bank statements into our account but subsequently finding duplicate entries. These seem to be caused by us marking, for example, supplier payments as paid which QF posts to the bank statement and then the same payment to the supplier appearing in the statement when we subsequently upload the statements.
I looked in the community and found this post:
Duplicate entries when manually logging payments
Plus the help file:
http://help.quickfile.co.uk/main/1/tagging_your_bank_transactions.htm
However both say that the “import process will however test for pre-existing items with the same date and amount and will give you the option to commit or ignore”.
Despite us having pre-existing items with the same date and amount I saw no prompt or option to commit or ignore the duplicates before posting. It has therefore been a bit tedious to run through and check manually.
Can you advise, or have we missed something?
Thanks for the help!
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 :
When you manually log payments to invoices (using the log a payment button) the system creates an entry on the bank, if you’re then importing the bank statement those items may get duplicated. The bank import process will however test for pre-existing items with the same date and amount and will give you the option to commit or ignore.
The testing process seems not to work for me , 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.
Glenn
3 November 2015 22:31
3
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!
Glenn
4 November 2015 09:19
7
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
Glenn
4 November 2015 10:29
9
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 I have been able to hunt down all the duplicates and delete them.
Glenn
4 November 2015 12:28
11
UPDATE:
Duplicate filtering should now work fine on foreign currency accounts.
1 Like
Thank you for resolving the issue so quickly.
1 Like