Add failed subscription records for billing team before next billing run

Your failed subscription renewals arrive untracked, causing revenue leakage and missed retry windows. Keep billing and marketing managers prioritized on recoveries so follow-up happens before the next billing run.