Log high-value failed payments to centralized payments ledger

High-value failed payments aren't centralized, causing delayed collections and missed follow-ups by billing staff. Log each qualifying failed payment into a single payments sheet so billing can retry or contact customers the same day.