Create failed payment rows for billing team immediately

Failed payments land without a central ledger, delaying collections for billing staff. Log failed payment details into a payments sheet so billing can prioritize retries before the next billing run.