Member dues: how to set, collect and track membership dues

Member dues are the regular fee a person pays to belong to an organisation: a club, a society, a professional association, a union, a nonprofit. Dues are usually charged per year, sometimes per month or per quarter, and they pay for whatever the organisation does for its members: meetings, a venue, insurance, a newsletter, events, representation. A dues-paying member is simply a member whose dues for the current period are paid. Most bylaws treat that as the condition for voting, holding office and using member benefits, often under the phrase "member in good standing".

That is the whole definition. The work is in the three jobs that follow it: setting an amount that actually covers your costs, collecting it on a schedule members can predict, and knowing at any moment who has paid, who is late and who has lapsed. This page covers all three, with a dues tracker structure you can copy into a spreadsheet and the two formulas that matter most.

Membership and dues: the terms that get mixed up

Your bylaws or constitution should say which of these your organisation uses and who can change them. In many clubs, the board proposes the dues amount and the members approve it at the annual meeting. If your rules are silent, write it down before the next increase, because a dues change nobody had the authority to make is the fastest way to start an argument.

How to set membership dues

There are two honest ways to arrive at a number. One is to copy what similar organisations charge. The other is to cost it from your budget. Do the second, then sanity-check against the first.

Cost dues from your annual budget

The method is short:

1. List what the year will cost.
2. Subtract income that does not come from dues: sponsorship, grants, event surpluses.
3. Divide the gap by the number of members you realistically expect to pay, not the number on your list.
4. Add the payment processing fee and round to a clean figure.

Here is a worked example for a fictional community club. Every figure is illustrative; use your own.

The club had 150 members last year. Assume 85% renew (about 128) and 12 new people join: 140 expected paying members. That retention figure is the most important assumption in the whole calculation, and the one most often skipped. Dividing by everyone on last year's list builds a deficit into the budget before the year starts.

$7,000 ÷ 140 = $50 per member. If the club collects online and its payment provider takes around 3% (an illustrative rate; check your own), it needs about $51.55 per member to net $50. Round to $55, which also leaves a margin for a lower renewal rate than planned.

Flat, tiered or both

A single flat rate is easiest to explain and to collect. Most organisations eventually add tiers because members' circumstances differ. Common ones:

Tiers change the arithmetic, so re-run it with the mix you expect. Continuing the example:

After 3% fees, that nets about $7,445 against the $7,000 needed. Tiers lowered the average dues per member, so the margin is smaller than the flat $55 alone would give. Check this every time a tier is added: a discount that half the membership qualifies for is a price cut, not a concession.

Lifetime memberships deserve caution. The organisation takes one payment and owes benefits for as long as the member lives. Whatever multiple you choose (20 times the annual rate is an illustrative figure, not a standard), treat the money as something to spend slowly, not as this year's income.

Prorating for people who join mid-year

If everyone renews on the same date, someone who joins in July either pays the full year for half a year, or you prorate. Three common rules:

• Monthly proration: annual dues ÷ 12 × months remaining. At $55, joining with six months left costs $27.50.
• Half-year rate: one discounted rate for anyone joining in the second half of the year.
• Join late, get the rest free: anyone joining in the last two or three months pays the full rate and is covered until the end of the following year.

Pick one, write it in the membership policy and apply it the same way every time. Proration decided case by case is how two members who joined the same week end up paying different amounts.

How to collect member dues

Choose a renewal cycle: anniversary or calendar year

A volunteer-run club with one treasurer often prefers a calendar year: one campaign, one deadline, one list to chase. An organisation that takes members all year round, or collects online, usually does better on anniversary renewals because nobody is asked to pay for months they did not get. Either works. What does not work is a mixture nobody chose, where some members are on calendar dates and others on anniversaries because of whoever processed their first payment.

Set a grace period

A grace period is the time after a membership ends during which the member keeps their benefits while you chase the renewal. Thirty days is a common choice for annual dues; a shorter one suits monthly payments. Decide two things: how long it is, and what changes when it ends (no vote, no member pricing, removal from the mailing list, loss of access to a members' area). Then write both down.

A reminder schedule that works

Most lapses are not decisions. People forget, a card expires, an email goes to the wrong address. A fixed reminder schedule recovers most of them. An illustrative schedule for annual dues with a 30-day grace period:

Two rules make the schedule work. Every message has one obvious way to pay. And members who renew stop getting reminders immediately, which means the tracker has to know about the payment the day it arrives. Nothing annoys a paid-up member faster than a "final notice".

A member dues tracker that answers the right questions

The usual dues spreadsheet is one row per member with a "paid" column that someone ticks and then clears every year. It tells you who has paid this year and nothing else: not when they joined, not whether last year's cheque bounced, not who lapsed in 2024 and might rejoin. Keep the history instead. A dues tracker needs four tables.

Members. One row per person, kept for as long as you know them. No status column here; status is calculated.

Membership periods. One row per term of dues. A renewal adds a row; it never edits the old one.

Payments. One row per payment attempt, linked to the period it pays for. Keep failed attempts; they are why a member says "but I paid".

Reminders. One row per reminder sent, so you know who has been chased and how.

Download the tracker

Download the membership dues tracker (.xlsx)

Our free workbook already has the first three tables as Members, Periods and Payments sheets, with fictional sample records, a report date and renewal window you set, and checks for duplicate IDs, missing references and overlapping terms. Each period's balance is its agreed fee minus settled payments (refunds add it back), so a failed or pending attempt never counts as paid. It does not include a reminders sheet; add one with the columns above if you send reminders by hand. It holds 100 members, 300 periods and 500 payment attempts, and it does not send emails or collect money.

The paid-through and lapsed formulas

Two derived values answer almost every dues question: the date a member is paid through, and whether they are current, in grace or lapsed today. Add them as columns on the Members sheet. These use the workbook's table names; adjust them if you build your own. ReportDate and GraceDays are single cells you name yourself.

Paid through  = MAXIFS(PeriodsRecords[End date],
                       PeriodsRecords[Member ID], [@[Member ID]],
                       PeriodsRecords[Cancelled], "No",
                       PeriodsRecords[Balance], "<=0")

Dues status   = IF([@[Paid through]]=0, "Never paid",
                IF([@[Paid through]]>=ReportDate, "Current",
                IF([@[Paid through]]>=ReportDate-GraceDays, "In grace", "Lapsed")))

Paid through is the latest end date among uncancelled periods with nothing left to pay. MAXIFS returns 0 when a member has no fully paid period, which the status formula reports as "Never paid". A member with an unpaid future period is still "Current" on the strength of the one they have paid for, which is what you want: they are not late yet. MAXIFS works in Excel 2019 and later, Microsoft 365 and Google Sheets.

From those two columns everything else is a filter: everyone "In grace" is this week's reminder list, everyone "Lapsed" in the last year is your win-back list, and a count of "Current" is the number of dues-paying members you report at the annual meeting.

Where a dues spreadsheet breaks

A spreadsheet like this is enough for many clubs: a few hundred members, mostly annual dues, one treasurer or membership secretary. It starts to fail in predictable places.

• Reminders depend on someone remembering. The tracker can tell you who is in grace. It cannot email them. The schedule above becomes a manual job at exactly the busiest time of year.
• Payments arrive somewhere else. Online payments sit in your payment provider, cheques in the bank, cash with whoever was at the meeting. Every one has to be copied in by hand, and a missed one means a paid-up member gets chased.
• Failed card payments are invisible. If members pay by card on a recurring basis, a declined renewal is known to the provider and not to the spreadsheet until someone checks.
• Members cannot help themselves. Updating an address, renewing, downloading a receipt or switching to a family membership is an email to you every time.
• More than one person edits it. Two volunteers with two copies is how a renewal gets recorded in one and not the other.
• Access does not follow it. If dues unlock a members' area, a shared password does not stop working when someone lapses.

The membership management in Excel guide goes through each of these in detail, including plan changes and refunds.

Membership dues software: the main options

Once the spreadsheet is costing more time than it saves, there are four broad routes. We have not named products here; what matters is which kind fits you, and the questions below will separate good options from weak ones within any of them.

Our free membership software guide covers what free plans tend to hold back. Whichever route you look at, ask these before you move a single member:

1. Does it support our renewal cycle? Calendar year, anniversary, or both, and our proration rule.
2. Does it send the reminder schedule on its own, and stop as soon as a member pays?
3. What happens when a card payment fails? Retries, an email to the member, a grace period, then the membership ending. In our hand-counted inventory of 60 paid-membership products, only 4 document failed-payment retries, reminders and grace periods at all, so ask directly.
4. Can members renew, update details and get receipts themselves?
5. Can we export members, periods and payments in a form we could take elsewhere?

If you are building a members' portal with a coding agent, the Paid Membership and Access planner is the specification we use: plans, the membership lifecycle, grace periods and what happens to access when a payment fails or is refunded.

Member dues FAQ

What does "dues-paying member" mean?

A member whose dues for the current period are paid. It is often used to separate full members from people who are on a mailing list, attend events, or were members once. Organisations usually tie voting rights, eligibility for office and member pricing to being dues-paying; your bylaws say exactly which.

Are membership dues tax-deductible in the US?

It depends on who you pay and why. This is general information, not tax advice.

• Charities. IRS Publication 526 says membership fees or dues paid to a qualified organisation may be deductible, but only to the extent they exceed the value of the benefits you receive. For an annual payment of $75 or less, certain benefits, such as free or discounted admission and discounts on purchases, can be disregarded.
• Social clubs. The same publication says dues to country clubs and other social organisations are not deductible, because they are not qualified organisations.
• Trade and professional associations. Contributions to 501(c)(6) organisations, such as trade associations and chambers of commerce, are not charitable deductions, but the IRS says they may be deductible as business expenses if ordinary and necessary for your business. The part of dues an organisation spends on lobbying and political activity is not deductible, and organisations must tell members that amount or pay a proxy tax.

Checked on 19 October 2026, against the publication for 2025 returns. Ask a tax professional about your own situation.

What happens if a member doesn't pay their dues?

Whatever your bylaws or membership policy say. Typically the member moves into a grace period, gets the reminders above, and then lapses: they lose voting rights and member benefits and stop being counted as a member. Many organisations let a lapsed member rejoin by paying the current period, sometimes with the joining fee waived if they come back within a year. Some associations go further and suspend or remove members in arrears, but that should only happen under a written rule applied to everyone.

Can membership dues be refunded?

Only if your policy says so. Many organisations state that dues are non-refundable, because the costs they cover are committed for the year. Others refund the unused part if a member cancels within a set time. Either is fine. Put the policy where members pay and on the receipt, and when you do give a refund, record it as its own payment row so the tracker shows the period as unpaid again.

How do I track member dues for free?

A spreadsheet with members, membership periods and payments as separate sheets, plus the paid-through and status formulas above. The free dues tracker has the three main sheets ready to fill in.