Solutions
Hold a career-length membership record.
Individual members, credentials, and a renewal cycle that repeats for decades.
Keep twenty years of history readable
Members join early and stay a long time. Every join, renewal, lapse and return is a dated state on one record, in the order it happened.
Make the annual cycle the easy part
Most of the revenue and most of the staff work sit in one renewal cycle. Notices, grace periods and reinstatement run on rules you set once.