Create failed payment rows for renewal tracking

Failed recurring payments aren't logged, leaving recovery campaigns blind to at-risk customers. Log each failure to a sheet so campaign managers can trigger outreach before the next billing run.