Payments for an account that isn't in the account master are orphans. Don't drop them silently with an inner join: report them as exceptions so the source can be fixed and totals still reconcile.
- Lesson: Quarantine with reasons, in rule order
- Practise: Referential integrity with explicit exceptions
Related: Referential integrity, Quarantine