Create renewal payment records in central payments table

You have no centralized log of subscription renewals, delaying reconciliation and follow-up. Logging renewals into a payments table gives billing staff same-day visibility for reconciliation.