Workflow template for customer success and account management

Membership renewal and lapse list

Once a month the membership coordinator gets one list from the member export: who is due to renew, who is in the grace period, who has lapsed since the last run and which records need fixing, with a renewal reminder and a lapsed-member note drafted for each level. A person checks and sends everything.

View this template on GitHub

Put this on your planBuild this in a sprint

Add it to a workflow in the FullyPowered Planner, beside the teams and roles that will run it. Book a fit call

The outcome

Renewals stop slipping through the gaps between a spreadsheet and a busy month. On the day the coordinator sits down to do renewals, the whole membership is sorted on one page: the people whose renewal date falls inside your reminder window, with those on automatic renewal shown apart, the people past their renewal date but still inside your grace period, and the people who have lapsed since the list was last made. The size of every group is shown, and a totals line ties them to the rows you exported, so nobody falls off the page unnoticed.

The records that would cause a wrong message are caught first: a renewal date that is blank or could not exist, a payment recorded after the renewal date that never moved, a member marked lapsed whose renewal is still ahead. Those come out as a short list to fix, with no draft attached.

For each membership level there is a renewal reminder and a lapsed-member note, ready to merge, written only from the facts your organization has approved: the fee, what membership includes, how to renew or rejoin and where to ask. Every member at a level gets the same wording. Nobody is ranked, singled out or judged on what they might pay or give.

The coordinator stays in charge. The workflow template sends nothing, takes no payment, changes no status and cancels nobody. It honors each member's contact preference and never drafts for anyone marked do not contact.

Who starts the work, and when

The membership coordinator or membership administrator starts it once a month, on the day renewals are done, after taking a fresh export from the membership system. The coordinator reads the list, fixes the records it flags in the system, edits the drafts and sends them to the right people. Where your rules name someone else to sign a level's notes, such as a chair, that person approves those notes. The membership lead owns the approved facts the drafts are built from.

What they supply

  • The member export from your membership management system, with these columns: member_id, name, membership_level, joined_at, renewal_date, status (active, lapsed or cancelled), auto_renew (yes or no), last_payment_at, contact_preference (email, post or phone) and do_not_contact (yes or no). If your system names a column differently, the workflow template stops and asks which column is which.
  • Your renewal rules: how many days ahead a reminder goes, how long the grace period runs before a member counts as lapsed, who signs reminders and lapsed notes at each level, the subject line each carries, your organization's name and the date the list was last made.
  • Your approved facts for each level: the fee for the year, what membership includes, how to renew, how to rejoin, where to ask questions and any welcome-back line, each written as the sentence you want members to read.
  • Today's date.

What comes out

One list in a fixed order. A totals line that proves every row of the export is in exactly one group. Then the groups: due to renew with a reminder, due to renew on automatic renewal, in the grace period with the date each membership stays open until, lapsed since the last run, and records to check with the field and the problem named. A section on who was left out and why: anyone marked do not contact, cancelled members, and members who lapsed before the last run and were listed then. Then the draft renewal reminders and lapsed-member notes, one per level, each with the members it is for and who signs it. Where a group is empty, the list says "None."

An example

Illustrative example with sample data. The organization, its members, its staff and every figure below are illustrative. Arts Society A is an illustrative community arts association with three membership levels. First come the inputs the membership coordinator supplied, in full: the member export from the membership management system, the society's renewal rules, its approved facts for each level and today's date. Then the list the workflow template returned.

The inputs

MEMBER EXPORT (from the membership management system, taken Monday 2 November 2026)
member_id | name               | membership_level | joined_at  | renewal_date | status    | auto_renew | last_payment_at | contact_preference | do_not_contact
M-1001    | Odile Fenwick      | Individual       | 2021-03-14 | 2026-11-20   | active    | no         | 2025-11-18      | email              | no
M-1002    | Tomas Arkwright    | Household        | 2019-11-25 | 2026-11-25   | active    | yes        | 2025-11-25      | email              | no
M-1003    | Bea Okonkwo-Lind   | Supporter        | 2023-12-01 | 2026-12-01   | active    | no         | 2025-12-01      | post               | no
M-1004    | Halvard Pereira    | Individual       | 2024-10-15 | 2026-10-15   | active    | no         | 2025-10-15      | phone              | no
M-1005    | Signe Ballantyne   | Household        | 2022-10-20 | 2026-10-20   | active    | yes        | 2025-10-20      | email              | no
M-1006    | Ravi Castellano    | Individual       | 2025-09-12 | 2026-09-12   | lapsed    | no         | 2025-09-12      | email              | no
M-1007    | Juno Whitcombe     | Supporter        | 2020-09-05 | 2026-09-05   | active    | no         | 2025-09-05      | post               | no
M-1008    | Esme Tolliver      | Individual       | 2023-08-10 | 2026-08-10   | lapsed    | no         | 2025-08-10      | email              | no
M-1009    | Caspar Lindqvist   | Household        | 2018-11-28 | 2026-11-28   | active    | no         | 2025-11-28      | email              | yes
M-1010    | Wanda Achterberg   | Individual       | 2025-05-03 | 2027-05-03   | active    | no         | 2026-05-03      | email              | no
M-1011    | Nils Okafor        | Supporter        | 2021-02-17 | 2027-02-17   | active    | yes        | 2026-02-17      | email              | no
M-1012    | Ida Marchetti      | Individual       | 2024-06-30 |              | active    | no         | 2025-06-30      | email              | no
M-1013    | Felix Durand-Shaw  | Household        | 2025-11-30 | 2026-11-31   | active    | no         | 2025-11-30      | email              | no
M-1014    | Greta Holm         | Individual       | 2022-07-01 | 2026-07-01   | cancelled | no         | 2025-07-01      | email              | no
M-1015    | Ottilie Brandvold  | Supporter        | 2024-10-28 | 2026-10-28   | active    | no         | 2026-10-29      | email              | no

RENEWAL RULES
Reminder window: 30 days before the renewal date
Grace period: 30 days after the renewal date
Last run: 2026-10-01
Organization name: Arts Society A
Subject line, reminders: Your Arts Society A membership renewal
Subject line, lapsed notes: Your Arts Society A membership
Reminders, all levels: signed by Rosalind Kerr, Membership coordinator
Lapsed notes, Individual and Household: signed by Rosalind Kerr, Membership coordinator
Lapsed notes, Supporter: signed by Mateo Ferris, Chair

APPROVED FACTS (owner: membership lead; reviewed 1 October 2026; each line is used unchanged)
All levels
  How to renew: Renew on the members' page of our website, by cheque to the society office, or in person at the front desk.
  How to rejoin: Rejoin on the members' page of our website, by cheque to the society office, or in person at the front desk.
  Questions: membership@example.org or 555-0142, weekdays 10am to 4pm.
  Welcome-back line: You are welcome back at any time, and rejoining costs the same as renewing.
Individual
  Fee: Individual membership is $60 for the year.
  Includes: It includes the members' rate on every class, the quarterly newsletter and a vote at the annual meeting.
Household
  Fee: Household membership is $95 for the year, for up to two adults and their children at one address.
  Includes: It includes the members' rate on every class for each of them, the quarterly newsletter and two votes at the annual meeting.
Supporter
  Fee: Supporter membership is $150 for the year.
  Includes: It includes everything in Individual membership and two guest passes to the spring exhibition.

TODAY'S DATE
2026-11-02

The output

MEMBERSHIP RENEWAL AND LAPSE LIST: Arts Society A, November 2026
Status: Draft for Rosalind Kerr, Membership coordinator. Nothing has been sent, no payment taken and no record changed.
Run: today 2026-11-02. Last run 2026-10-01 (supplied). Reminder window 30 days (renewal dates 2026-11-02 to 2026-12-02). Grace period 30 days.

TOTALS
Export rows 15 = Due, reminder 3 + Due, auto-renew on 1 + In the grace period 2 + Lapsed since the last run 2 + Lapsed before the last run 1 + Not yet due 2 + Cancelled 1 + Records to check 3.

1. DUE TO RENEW, REMINDER (3)
- M-1001, Odile Fenwick, Individual. Renews 2026-11-20, in 18 days. Email.
- M-1003, Bea Okonkwo-Lind, Supporter. Renews 2026-12-01, in 29 days. Post.
- M-1009, Caspar Lindqvist, Household. Renews 2026-11-28, in 26 days. Do not contact: no message.

2. DUE TO RENEW, AUTO-RENEW ON (1). No reminder drafted.
- M-1002, Tomas Arkwright, Household. Renews 2026-11-25, in 23 days.

3. IN THE GRACE PERIOD (2)
- M-1004, Halvard Pereira, Individual. Was due 2026-10-15, 18 days ago. Open until 2026-11-14. Phone: use the draft as call notes.
- M-1005, Signe Ballantyne, Household. Was due 2026-10-20, 13 days ago. Open until 2026-11-19. Email. Auto-renew is on but the renewal date has passed; check why before any reminder is used.

4. LAPSED SINCE THE LAST RUN (2)
- M-1006, Ravi Castellano, Individual. Was due 2026-09-12. Lapsed 2026-10-13. Status in the system: lapsed. Email.
- M-1007, Juno Whitcombe, Supporter. Was due 2026-09-05. Lapsed 2026-10-06. Status in the system: active. Post. Still marked active in the system.

5. RECORDS TO CHECK (3). Nothing drafted.
- M-1012, Ida Marchetti. renewal_date: blank.
- M-1013, Felix Durand-Shaw. renewal_date: 2026-11-31 is not a real date.
- M-1015, Ottilie Brandvold. last_payment_at: 2026-10-29 is after the renewal date of 2026-10-28, and the renewal date has not moved; the member may already have renewed.

6. LEFT OUT, AND WHY
- Do not contact: M-1009, Caspar Lindqvist, Due, reminder.
- Cancelled: M-1014, Greta Holm.
- Lapsed before the last run, already listed: M-1008, Esme Tolliver, lapsed 2026-09-10.
- Records to check: see section 5.
- Not yet due: 2, counted only.

7. DRAFT RENEWAL REMINDERS
Individual. For: M-1001 (due), M-1004 (grace). Signed by: Rosalind Kerr, Membership coordinator.
Subject: Your Arts Society A membership renewal
Dear [name],
[Due: Your Individual membership renews on [renewal date].]
[Grace: Your Individual membership was due for renewal on [renewal date]. It stays open until [open until].]
Individual membership is $60 for the year. It includes the members' rate on every class, the quarterly newsletter and a vote at the annual meeting.
Renew on the members' page of our website, by cheque to the society office, or in person at the front desk.
Questions: membership@example.org or 555-0142, weekdays 10am to 4pm.
Rosalind Kerr, Membership coordinator

Household. For: M-1005 (grace; check the auto-renew note first). Signed by: Rosalind Kerr, Membership coordinator.
Subject: Your Arts Society A membership renewal
Dear [name],
[Grace: Your Household membership was due for renewal on [renewal date]. It stays open until [open until].]
Household membership is $95 for the year, for up to two adults and their children at one address. It includes the members' rate on every class for each of them, the quarterly newsletter and two votes at the annual meeting.
Renew on the members' page of our website, by cheque to the society office, or in person at the front desk.
Questions: membership@example.org or 555-0142, weekdays 10am to 4pm.
Rosalind Kerr, Membership coordinator

Supporter. For: M-1003 (due). Signed by: Rosalind Kerr, Membership coordinator.
Subject: Your Arts Society A membership renewal
Dear [name],
[Due: Your Supporter membership renews on [renewal date].]
Supporter membership is $150 for the year. It includes everything in Individual membership and two guest passes to the spring exhibition.
Renew on the members' page of our website, by cheque to the society office, or in person at the front desk.
Questions: membership@example.org or 555-0142, weekdays 10am to 4pm.
Rosalind Kerr, Membership coordinator

8. DRAFT LAPSED-MEMBER NOTES
Individual. For: M-1006. Signed by: Rosalind Kerr, Membership coordinator.
Subject: Your Arts Society A membership
Dear [name],
Your Individual membership was due for renewal on [renewal date], and its grace period has now passed.
You are welcome back at any time, and rejoining costs the same as renewing.
Individual membership is $60 for the year. It includes the members' rate on every class, the quarterly newsletter and a vote at the annual meeting.
Rejoin on the members' page of our website, by cheque to the society office, or in person at the front desk.
Questions: membership@example.org or 555-0142, weekdays 10am to 4pm.
Rosalind Kerr, Membership coordinator

Household. No lapsed member this month; no note drafted.

Supporter. For: M-1007. Signed by: Mateo Ferris, Chair.
Subject: Your Arts Society A membership
Dear [name],
Your Supporter membership was due for renewal on [renewal date], and its grace period has now passed.
You are welcome back at any time, and rejoining costs the same as renewing.
Supporter membership is $150 for the year. It includes everything in Individual membership and two guest passes to the spring exhibition.
Rejoin on the members' page of our website, by cheque to the society office, or in person at the front desk.
Questions: membership@example.org or 555-0142, weekdays 10am to 4pm.
Mateo Ferris, Chair

CHECK
Every fact in the drafts is from the approved facts: yes. Drafts are the same for every member of a level apart from the merge fields. No draft goes to a member marked do not contact.
Prepared for Rosalind Kerr, Membership coordinator. The assistant has sent nothing, taken no payment and changed no record.

How the dates were placed: today is 2026-11-02, so the reminder window runs to 2026-12-02 and a renewal date between 2026-10-03 and 2026-11-01 is inside the 30-day grace period. A member lapses on the renewal date plus 31 days; Ravi Castellano and Juno Whitcombe lapsed after the last run on 2026-10-01, and Esme Tolliver lapsed before it. Greta Holm is left out because her membership was cancelled. Wanda Achterberg and Nils Okafor renew in 2027 and are counted as not yet due. Every figure traces to the export, the renewal rules and the approved facts above.

Where it fits

  • Customer success and account management, because keeping members is keeping the people who already chose you.
  • Nonprofits, where associations and member-funded organizations depend on renewals arriving every year.
  • Education, for alumni associations, parent groups and learned societies that run on annual membership.
  • Hospitality, for clubs whose members renew each season and expect a word before their membership runs out.
  • Established businesses, for organizations with a long member list and a renewal routine that lives in one person's head.
  • Growth & scaling, when the member list grows faster than one coordinator can check by hand.

It is not donor thank-you drafts, which thanks a gift, and it is not renewal risk review, which looks at a business's customer accounts coming up for renewal. Lapsed customer win-back works with customers who have stopped buying; this one works with members and your own renewal rules.

What has to change for your company

Set your reminder window and grace period, and the day of the month you make the list. Match the column names to your membership system's export. Write the approved sentences for each level, with someone who owns them and keeps them current. Decide who signs reminders and lapsed notes at each level. Decide whether members on automatic renewal should hear from you in advance; by default they get no reminder. Agree who fixes the records the list flags. The workflow template reads the export you supply and needs no connection to your membership system, so it runs in ChatGPT, Claude, Copilot or Gemini.

What has been checked

FullyPowered AI wrote this workflow template. It was editorially reviewed on 19 November 2026. It was tried on its example on 19 November 2026, and the record is published with it. It has not yet been tested in a client environment. It has not yet been tested as a packaged version in ChatGPT, Claude, Copilot or Gemini.

Testing in your environment means running it on a past month whose renewals you already know, with cases written in advance: a renewal date that could not exist, a payment after a renewal date that did not move, a member marked do not contact, a member on automatic renewal whose date has passed, and a renamed column. The coordinator checks the totals line and three rows by hand before anything is sent.

Who decides

People decide

Your people keep

  • Which drafts are sent
  • How each flagged record is fixed in the membership system
  • Who signs each level's reminders and lapsed notes
  • The approved facts the drafts are built from
By design

It does not

  • Sends nothing
  • Takes no payment
  • Changes no status and cancels nobody
  • Never drafts for anyone marked do not contact
  • Ranks or judges no member

Questions people ask

Who is this for?

The membership coordinator or membership administrator starts it once a month, on the day renewals are done, after taking a fresh export from the membership system.

What do I need to supply?

The member export from your membership management system, your renewal rules, your approved facts for each level and today's date.

Does it send reminders or change member records?

No. It sends nothing, takes no payment, changes no status and cancels nobody. The coordinator edits the drafts and sends them.

What about members who asked not to be contacted?

They stay counted in their group but get no draft, and they are named in the section on who was left out and why.

What has been checked?

It was editorially reviewed and tried on its example. It has not yet been tested in a client environment.

What it connects to

The business systems this workflow template works with, what it reads from each and what it writes to it, from a reviewed reading of its own text.

Writes to it: nothing.

What it connects to
How it works with the systemReads from it
Works from an export from a membership or community platform.Reads from itEach member with level, renewal date, status and last payment.

The full workflow template

Everything above is the outline. The complete workflow template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in FullyPowered’s public repository.

View the full template

Free with an account. Sign in by email: no password and no card.

Next step

Put this workflow template to work for your team: on your plan, or built with you in a sprint.

  1. 01

    The full workflow template

    Free with an account. Sign in by email: no password and no card.

  2. 02

    FullyPowered Planner

    Add it to a workflow in the FullyPowered Planner, beside the teams and roles that will run it.

  3. 03

    Build this in a sprint

    In a sprint, FullyPowered adapts this workflow template to your rules, proves it on your own work and puts it in the hands of the roles that own it.

These workflow templates are examples and a starting point, not a complete list. We can build any workflow for your company, including one that runs several steps, in a Workflow Sprint or a scoped implementation.

Rather talk it through first? Book a fit callDiscuss adapting this

FullyPowered Planner. A card to start, everything unlocked, nothing charged for seven days.Security & your informationPlanner termsRefunds