Log new active subscriptions to payments sheet for billing

Subscription status changes aren't logged centrally, leaving billing and reporting incomplete. Add active subscriptions to a payments sheet so billing reconciles before close.