Update subscription ledger rows automatically when payments fail

Unrecorded subscription payment failures leave billing blind to churn. Update a single subscription sheet so finance can start collections before the next billing run.