Tracking Who Is Due and Who Is Overdue

Why this matters

A membership plan is a promise with a due date attached to it, and a promise nobody is tracking becomes a promise that quietly gets broken. The member who never got their visit scheduled does not usually complain right away. They notice at renewal time that they paid for a service they never received, and that is the moment a loyal customer turns into a churned one, or worse, a public review. Tracking due and overdue members is not an administrative nicety, it is the mechanism that keeps the whole program honest.

What "due" actually means for a membership plan

Before you can track it, define it precisely, because vague due dates are the root of most tracking failures.

• Anniversary-based: due a fixed interval after enrollment or after the last completed visit (every six months from last service, for example).
• Season-based: due within a defined calendar window regardless of enrollment date (a spring visit, a fall visit).
• Count-based: due for the Nth visit of the term, independent of a specific date, common on plans that promise a number of visits per year rather than dated ones.

Mixing these definitions across your member base without labeling which rule applies to which plan is how members fall through the cracks. Every plan type should have one clear, written rule for what "due" means.

The three states worth tracking

Do not just track "done" and "not done." Three states give you enough lead time to act:

• Upcoming - due within the next scheduling window (a few weeks out). This is your outreach queue.
• Due - inside the promised window right now, not yet scheduled or completed.
• Overdue - past the promised window with no completed visit. This is the state that damages trust and should trigger the most active response.

A member sitting in "overdue" for more than a short grace period needs a phone call, not another automated reminder. By the time a plan is meaningfully overdue, the member has likely stopped expecting the reminder to mean anything.

Building the tracking view

However you track it, whether a spreadsheet, a report, or a dedicated view in your scheduling system, the useful version has a few things in common:

• One row per member per obligation, not one row per member. A member with two visits owed this term needs two trackable lines, or the second one gets missed once the first is checked off.
• Sorted or filterable by due date, oldest first, so overdue members surface at the top instead of getting buried in a long alphabetical list.
• A visible owner, whether that is the office scheduler or a specific dispatcher, so "who was supposed to catch this" has an answer.
• A completion timestamp tied back to the actual visit, not a manual checkbox someone forgets to update. A tracking view that drifts from reality within a few weeks is worse than no tracking view, because it creates false confidence.

Working the list on a fixed cadence

Tracking only pays off if someone reviews it on a schedule, not when someone happens to remember.

• Weekly, scan for anything that moved into the overdue state and assign it for outreach or scheduling that week.
• Monthly, review the overall pattern: is a particular plan type consistently running behind, is a particular crew or region falling short, is the overdue count trending up or holding steady. A rising overdue count over several months is an early capacity-planning signal, not just a scheduling annoyance.

What overdue actually costs if it is ignored

An unscheduled, overdue membership visit is a liability sitting on the books in more than one way. The member is owed a service you are contracted to deliver. Any issue that visit would have caught (a failing part, a code violation, an early warning sign) goes uncaught, which increases the odds of an emergency call, a warranty dispute, or a safety issue down the line. And at renewal, an overdue member has direct evidence the plan was not delivered, which is the single easiest churn decision a member can make: they are not weighing the plan's value against its price, they are pointing at a broken promise.

The recap

Define what "due" means precisely for each plan type, track upcoming, due, and overdue as distinct states, keep the tracking view sorted with a clear owner, and review it on a fixed weekly and monthly cadence. An overdue member is not a scheduling footnote, it is the leading indicator of a churn you can still prevent if you catch it early enough.

References

• See related: Scheduling Membership Visits Without Overloading the Calendar
• See related: The Member Who Never Gets Scheduled Decision Tree
• Trade-standard practice for recurring-service compliance tracking