I think there might be a way to have this list handled via MLS, where more frequent reports and updates could be done via send/receive. And more sophisticated reports as well to help leaders get the New Era and Friend into the homes those are most needed in.
1. The report itself. A new feature in MLS would be 'Church Magazine Subscription Report' and Headquarters would send it down at a frequency TBD, whether weekly or monthly. It would have the following fields:
Member/Family head name: An adult member single or married, and if a family, would have just a line for that family by the head of household.
Three magazine fields:
Ensign
New Era
Friend
If the family had members in either or both the New Era field, there could be a way to alert the magazine rep or leaders that this would be a family to approach about a magazine subscription to those particular magazine. The field would have a check mark once the member subscribed. A field beside each magazine would be blank until the magazine was subscribed to and then would fill with the expiration date once HQ received the subscription, whether from a magazine drive or the member phoned it in, mailed it in, or purchased a sub at a Distribution Services store.
A monthly list could be generated for the magazine rep indicating which families needed to renew, and which magazines they needed renewal for.
In the case of Ensign subscriptions, Magazines has an option to get one with extra conference issues. Families with two or more adults could be noted so the magazine rep knows how many extra conference issues per conference will be needed. Useful for families where a college student is living at home, or in locations like BYU where a number of students share the same apartment or house.
There may be other ideas related to this also.