Log failed customer payments for billing team before next run

Failed payments land unseen, causing missed collections and slow reconciliation. Billing staff get rows with payment ID, date, amount and customer so reconciliation completes before next billing run.