@sherknime OK here is another try. This time there is a loop that takes every debt (positive value) and would check for a corresponding negative value at the same or a later date based on Name, City, Country and Value. This entry is then removed from the ‘pool’ (this loop and table being saved is not pretty and might be done with a recursive loop but I still like it better this way).
So this would be the result where there is a ID attached to every debt that has been paid so one can check if this does make sense. If you want further matching criteria you might have to go for some text (fuzzy) matching.
