Create subscription transaction records in a central table

Your subscription updates aren't tracked centrally, creating reconciliation work for finance. Record each change to a transactions table so finance can reconcile same day.