We have a new solution for this now.
The bank import tool is a bit smarter in the way it deals with duplicates. It will check whether the new statement imported has any payments or receipts which have the same amount,date and description (all three have to match) and delete these automatically.
So for example I have imported a statement for the 30th Oct as shown below:
I have then fully explained the statement (although this will work if the statement was left unexplained too).
I now import a statement with the same transactions for the 30th Oct plus a few more on this day and some from the 31st Oct too.
If I try to import this statement the system will tell me that some duplicates have been found and have been deleted already.
You can view the transactions that have been deleted by clicking on the See them here button:
Hope that all makes sense! If you have any questions just let me know.