Problem

The fee that posted twice

Identical referral or processing fees posted twice. Verified loss when both settled.

Detection

Group by source, order, fee kind and amount. Count > 1 with distinct external ids and no reversal is verified loss — the cash left twice.