Background
I used to calculate commissions for a staff of 30 sales reps.
Every month there would be hundreds of leftover transactions that should have been tied to an account, but weren't. Therefore, no sales reps got paid on them.
The transactions tended to be really small, and when I would...