Record failed payment rows for billing staff before reconciliation

Your failed payments sit uncaptured, causing revenue gaps and reconciliation delays. Finance and project managers get one ledger row per failure so reconciliation finishes before the next billing run.