Create failed payment records for finance team visibility

Untracked failed payments leave billing blind to recoveries and reconciliation status. Log failed-payment records so finance can act and reconcile before the next billing run.