A student club bill calendar is a shared Google Sheet that puts dues, event deposits, supply runs, and reimbursements on dates everyone can see. You don't need paid software for that.
Want a year-long money map without another app? Duplicate a free 2026 calendar template, park bill names and amounts next to the dates, and give members view access so dues aren't a surprise. Treasurers still have to type.
The sheet only works if someone updates after money moves.
Give the calendar an owner first
Thing is, shared club money falls apart when three officers edit the same due date and nobody confirms payment. Give the treasurer the calendar. Event leads can paste receipt links in Notes, and members stay view-only through the next quarterly review you already run in meetings.
2026 Google Sheets calendars clubs can copy
Spreadsheet Class's year-at-a-glance file puts 2026 and 2027 on separate tabs of one workbook, which helps if you're booking a fall retreat while still collecting spring dues. Week start lives in cell L3.
Smartsheet's free Google calendar set includes a 2026 yearly sheet plus monthly calendars in landscape and portrait. Keep one tab for the year and another for busy event months. Room to write matters.
CalendarLabs has a 2026 monthly calendar in Google Docs. Large note boxes are the draw. Some clubs copy it into Sheets.
Make your own copy first and leave the public file alone.
Build the tracker from the calendar
Work in this order.
- Open the template in Google Sheets, choose File, then Make a copy, and keep the 2026 and 2027 tabs if you started from Spreadsheet Class.
- Add the money columns from the table below.
- Enter recurring items first, such as monthly dues around the 15th and semester supplies in September and January.
- Add extra rows when two bills share a day.
- Test one sample row: Spring Formal Deposit, $200, due March 1.
- Share officers as editors and members as viewers, then update status after each payment.
A yearly view is easier for a few repeating charges. Use monthly when event weekends need writing room.
Columns that keep dues readable
Keep calendar dates as the visual spine. Put money fields next to them, or on a second tab if the grid gets cramped.
| Field | What to type | Why it helps |
|---|---|---|
| Bill name | Club Dues or Pizza for Meeting | People can find the charge later |
| Amount | $50 total or $10/person | Equal and per-person splits stay visible |
| Due date | Match the calendar cell | Sorting and highlighting still work |
| Paid by | Name plus method, such as Venmo | Shows who actually sent money |
| Status | Pending, Paid, Overdue, Reimbursed | Officer meetings go faster |
| Assignee | Event chair | One person owns the follow-up |
| Notes | Receipt link or invoice number | Proof sits with the bill |
Venmo is only an example.
Receipts, Drive folders, and campus rules
Members photograph receipts, drop them in a shared Drive folder, and paste the file link into Notes. The treasurer logs the date and amount.
Turns out school rules often matter more than your sheet design, and UC San Diego's student-org reimbursement page is one campus example of how tight the process can get: file within 14 days of the purchase date or the event date, whichever is sooner, skip reimbursements under $10, and combine several members' receipts into a single packet completed by a principal member, which is a lot of constraints to keep in a Notes cell if you haven't read the handbook first.
Don't copy UCSD's window. Read your own student-org rules, including who may submit, how receipts must look, and any tax handling.
Keep the calendar as the schedule. Who-owes-whom math belongs on a separate club reimbursement tracker in Google Sheets or Excel, not inside date cells. Date cells are already crowded.
Sharing and permission levels
Google Drive's sharing controls let you invite people by email or send a link. Officers need Editor. Members usually only need Viewer.
Too many editors will sort the wrong column or wipe a tab. Protect ranges you don't want touched, and remove former officers when terms end, which sounds obvious until you find last year's senior still changing dues.
Checklist before you post the link:
- Treasurer plus one backup: Editor
- Event leads who submit expenses: Editor or comment access
- Everyone else: Viewer
- Confirm former officers are off the file
Overdue highlighting and status dropdowns
Sheets can color dates with built-in rules or a custom formula. A typical custom rule uses =A2=TODAY() to mark today. Add another rule that treats a due date before today as overdue.
Lock Status with data validation dropdowns so people pick Pending, Paid, Overdue, or Reimbursed. Spelling stays consistent and reviews get quicker.
Mistakes that stall a treasurer
You'll miss a payment if nobody opens the file between meetings. Put a repeating reminder on the treasurer's own calendar.
Holiday-blind dates are another trap, because a due date can land on a day campus offices are closed.
Too many columns slow people down. History also disappears if you type over the public template instead of making a copy.
When a sheet stops being enough
To be honest, a calendar sheet is a record, not a bank. It won't autopay dues or chase people.
High-volume reimbursements and automated reminders belong in a dedicated tracker or a payment app you already use, with the sheet still exported for the archive. Save a quarterly copy. The next treasurer should inherit history, not a blank grid.
Duplicate a 2026 template today, type one real dues row, share it with the other officers, and walk through next month at your next meeting. Then adjust columns if they feel noisy.