Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesNonprofit & CommunityClubs, Churches & Community GroupsMembership Dues Tracker

SpreadsheetClubs, Churches & Community GroupsFree

Membership Dues Tracker

Track members, dues by membership type, renewal dates and who is paid, due soon, overdue or lapsed.

Shown with sample data

Colour

Membership Dues Tracker

Track members, dues by membership type, renewal dates and who is paid, due soon, overdue or lapsed.

Members
10
Paid up
70%
Paid, lifetime or not yet due
Renewals due in 30 days
2
Overdue or unpaid
1
Balances owed
$65
Expected dues per year
$470
Members by membership type
  • Individual440%
  • Family330%
  • Senior or student220%
  • Lifetime110%

How to use it

  1. 1Set your membership types and annual dues on the Rates sheet.
  2. 2List each member with their type, join date and the date and amount of their last payment.
  3. 3Each month, filter Status for Due soon and send renewal reminders; chase Overdue members personally.
  4. 4Update Last paid and Amount paid as renewals arrive.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A treasurer-friendly membership list that knows when everyone renews. Set dues for each membership type once; for each member enter the last payment date and amount, and the sheet works out the renewal date, days left, any balance owed and a status of Paid, Partly paid, Due soon, Overdue or Lapsed. The Rates sheet totals expected and collected dues by type.

Who it’s for

  • Clubs, societies and associations with annual dues
  • Sending renewal reminders 30 days ahead
  • Treasurer reports at committee meetings

What’s included

  • Members sheet: One row per member or household.
  • Rates sheet: Dues for each membership type.

How to use it

  1. 1Set your membership types and annual dues on the Rates sheet.
  2. 2List each member with their type, join date and the date and amount of their last payment.
  3. 3Each month, filter Status for Due soon and send renewal reminders; chase Overdue members personally.
  4. 4Update Last paid and Amount paid as renewals arrive.

Tips

  • Send the first renewal reminder 30 days before the renewal date and a second on the day; most lapses are forgetfulness, not intent.
  • A grace period of 60 days before marking someone Lapsed keeps members who are simply late.
  • If you use a single renewal date for everyone (for example January 1), set every Last paid date to the start of the membership year.

Questions

How do I track membership renewals?

Record the date each member last paid. The renewal date is 12 months later; the tracker counts down the days and flags members due within 30 days or overdue.

What is the difference between Overdue and Lapsed?

Overdue means the renewal date has passed within the last 60 days: worth a friendly reminder. Lapsed means more than 60 days have passed; treat them as a former member to win back.

Can I use it for monthly dues?

Yes. Change EDATE([lastPaid],12) to EDATE([lastPaid],1) in the Renewal date column and set the monthly amount on the Rates sheet.

Related searchesmembership dues trackerclub dues spreadsheetmembership renewal trackermember payment tracker excelassociation membership listannual dues template

Details

Format
Spreadsheet
Category
Clubs, Churches & Community Groups
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetClubs, Churches & Community GroupsFree

Membership Dues Tracker

Track members, dues by membership type, renewal dates and who is paid, due soon, overdue or lapsed.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Clubs, Churches & Community Groups
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More clubs, churches & community groups templates

View all
Church Tithes and Offerings Tracker4 sheets

Total given

$4,585

Tithes

$3,080

Designated funds

$675

ABCD
1DateFamily or memberEnvelope no.Fund
2Jan 4The Johnson Family101Tithe
3Jan 4Maria & Luis Hernandez102Tithe
4Jan 4Loose plate offering General offering
5Jan 11Grace Okonkwo103Tithe
Giving
SpreadsheetClubs, Churches & Community Groups

Church Tithes and Offerings Tracker

Record tithes and offerings by family and fund, see each family’s giving by month and produce annual giving statement totals.

15 min setupPreview
Food Pantry Inventory and Distribution Log3 sheets

Items low or out

5

Lots expiring in 30 days

2

Units on hand

664

ABCD
1ItemCategoryUnitOpening count
2Green beansCanned vegetablescan180
3Black beansCanned proteincan140
4TunaCanned proteincan90
5Peanut butterCanned proteinjar60
Inventory
SpreadsheetClubs, Churches & Community Groups

Food Pantry Inventory and Distribution Log

Track stock in and out by item, reorder levels and best-by dates, and log households and people served each distribution.

15 min setupPreview

Membership Application Form

Welcome! Complete this form to join [Club or association name]. Membership runs for 12 months from the date we receive your payment.

Full name *

Email *

Phone *

Apply for membership
FormClubs, Churches & Community Groups

Membership Application Form

Join form for clubs, associations and community groups: contact details, membership type, household, interests, payment and consent.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ