Club dues tracker template (printable)

How to use this template

Pick the layout that matches how members pay their club dues: once a year, once a term or every month. Each layout prints on one page and copies into an Excel or Google Sheets file. Fill in the rules grid before the first payment is due, then keep one row per member.

1. Write the rules down. Due date, grace period, accepted payment methods and who may waive dues go in the rules grid.
2. Add a row for each member with the amount due. For 12 members at $60, the expected total is $720.
3. Log each payment in the member’s row the day it arrives, with its date and method (cash, check, bank transfer). A row can hold several payments.
4. Work out the balance. Balance is the amount due minus the sum of that member’s payments. On paper, add the payments up by hand. In a spreadsheet, give each payment its own amount cell, and the balance cell is the due cell minus a SUM of those cells.
5. Set the status. Paid when the balance is $0 and the amount due is above $0. Unpaid when nothing has been paid and the grace date has not passed. Partial when some has been paid and the grace date has not passed. Late when a balance is still open after the grace date. Waived when an officer sets the amount due to $0.
6. Reconcile once a month. Collected is the sum of every payment, outstanding is the sum of the balances, and the two together must equal the expected total.

Say 8 members have paid $60, one has paid $30 and three have paid nothing. Collected is $510 and outstanding is $30 plus $180, or $210. Then $510 plus $210 is $720, which matches 12 members at $60. If the check is off, a payment was logged twice, in the wrong row, or a due amount was changed. When it comes out to $0, the same three totals go into the treasurer’s report.

For the term and monthly layouts, count only what has been billed so far. After the winter term in the second layout, 12 members owe $55 each, so the expected total to date is $660.

The template

Rules

Rule	Your club’s answer
Due date
Grace period (days after the due date)
Accepted payment methods
Who may waive dues

Layout 1: annual flat dues

Filled rows show $60 a member for 12 members.

Member	Amount due	Paid (date, method)	Balance	Status
Priya N. (example)	$60	Sep 8, cash	$0	Paid
Marcus T. (example)	$60	Sep 15, check	$0	Paid
Dana K. (example)	$60	Sep 20, cash $30	$30	Partial

Layout 2: three terms

Filled rows show $30 for fall, $25 for winter and $25 for spring, with winter already billed. A term cell holds the payment date and method, or the word Late.

Member	Fall ($30)	Winter ($25)	Spring ($25)	Balance
Priya N. (example)	Aug 30, cash	Jan 12, cash		$0
Marcus T. (example)	Sep 2, check	Late		$25
Dana K. (example)	Late	Late		$55

Layout 3: monthly installments

Filled rows show $15 a month billed from September to November, so $45 is due in total, and they are read as of Nov 15. Balance is $45 minus that member’s payments. Dana has an agreed extension to Nov 30, so her row is Partial and not Late.

Member	Paid (month, method)	Balance	Grace until	Status
Priya N. (example)	Sep cash, Oct cash, Nov cash	$0	Nov 10	Paid
Marcus T. (example)	Sep cash, Oct card	$15	Nov 10	Late
Dana K. (example)	Sep cash	$30	Nov 30	Partial

Reconciliation

Line	How to get it	Amount
Expected total	Sum of the Amount due column (or members times what is billed to date)
Collected	Sum of every payment
Outstanding	Sum of the Balance column
Check	Collected plus outstanding, minus expected total	Must be $0

What to agree on

Due date and grace period

A grace period, say 7 or 14 days applied to everyone, keeps a payment that is a few days behind from being marked Late. Without one, every unpaid row looks the same and the treasurer decides case by case. The due date plus the grace period is the date a status flips to Late.

Waivers and payment methods

A waiver changes what one member owes, so name the person or the two officers who can approve it and write the reason in that member’s row. Log the method on every payment too, so the treasurer can match deposits to rows later.

If you would rather not keep a sheet

You can track the same thing as an EvenOut group. Add one “Club dues” expense paid by the treasurer and split equally among the members, tapping anyone whose dues are waived to mark them “Not in”. Each member then shows as owing the treasurer, and “Settle up” records their payment. EvenOut only records payments and does not move money, so members still pay the treasurer the usual way. For monthly dues, the expense can repeat monthly. The club budget template shows how to work out what the dues should be in the first place, and how to collect club dues covers collecting online, with the limits and fees of each app.