A shared Google Sheet or Excel workbook can keep a club's bills visible without turning the treasurer into a full-time bookkeeper. Give each expense its own row, assign responsibility, record the due date and amount, and update the status when payment or reimbursement happens.

This works for dues, venue rentals, subscriptions, team supplies, and one-off event costs. The sheet is a coordination record and paper trail. It doesn't move money or replace formal accounting.

Before choosing a layout, ask one question: will more than one person need to check or update the list? If yes, a shared spreadsheet is usually worth trying. If not, a printable tracker may be enough.

Pick a format that matches the club

For five or more members with monthly or recurring bills, a shared sheet is a sensible starting point. Smaller groups can still use one, but a printable tracker may be less work for mostly one-time events.

Club situation Practical starting point
Five or more members with monthly or recurring bills Shared Google Sheet or Excel workbook
Fewer than five members or mostly one-off costs Basic tracker or printable form
Nobody wants to maintain a spreadsheet Printable calendar first, then reassess after a month

Turns out, update frequency matters more than the exact member count. Test the format for a month. If rows stay stale, simplify the process.

Use one row per bill or expense

One row should represent one charge or payment obligation. Don't overwrite last month's amount when a subscription renews; add a new row so the club keeps a usable history.

Column What to record Example
Month/Year, optional A grouping label, not the main sorting field January 2026
Bill or expense The charge being tracked Annual dues
Category, optional The type of cost Venue
Due date A real date in U.S. format 01/15/2026
Amount The total bill before reimbursements $150
Responsible person The person expected to arrange payment Treasurer
Paid by The member who actually paid Jordan
Status A dropdown such as Pending, Partly paid, Paid, or Reimbursed Paid
Reimbursement due The amount still owed back to the payer $50
Receipt link A link to a shared receipt photo or scan Shared folder link
Notes Payment method, exception, or split rule Paid via check #123

The lean version can be smaller: Bill, Due date, Amount, Paid by, Status, Receipt link, and Notes. Add Category and Reimbursement due when the club handles varied costs.

Keep the actual due date as the field you sort. Month/Year is useful for grouping, but a text label alone can put months out of order.

Set up the file in Google Sheets or Excel

Create a new workbook named Club Bill Calendar. Then use this setup sequence:

  1. Put the headers in row 1 and enter one sample expense below them.
  2. Format Due date as a date and Amount as currency. Use MM/DD/YYYY, such as 01/15/2026.
  3. In Google Sheets, freeze the header with View > Freeze > 1 row. Excel has the equivalent Freeze Panes command.
  4. Add a data-validation dropdown to Status. Keep the options consistent so one person doesn't enter Complete while another uses Paid.
  5. Sort the full data range by Due date. Sorting only one column can separate a bill from its amount and receipt.
  6. Give the treasurer edit access. Members can have view or comment access, with more editors added only if the club has agreed who owns corrections.

Keep it boring. A clean row is more useful than a clever dashboard.

Add reminders without overbuilding

To be honest, most clubs don't need elaborate formulas. Conditional formatting can make the next deadline visible without adding another tool.

For an overdue row, use a rule like this:

=AND($C2<>"",$C2<TODAY(),$F2<>"Paid",$F2<>"Reimbursed")

For a bill due within seven days, use:

=AND($C2<>"",$C2>=TODAY(),$C2<=TODAY()+7,$F2<>"Paid",$F2<>"Reimbursed")

These examples assume Due date is column C and Status is column F. Select the full data range if you want the entire row highlighted. Select a date-only range such as C2:C500 if you want only the date cell highlighted.

Leave blank due dates uncolored. A missing date needs follow-up, not a false overdue warning.

Assign ownership and set a review rhythm

The treasurer enters new bills, checks due dates, updates statuses, and keeps receipt links in place. The member who pays confirms the payer and submits the evidence. Everyone else reviews open rows before meetings.

One person can hold all three jobs. Thing is, write that down anyway. Confusion starts when everyone assumes somebody else updated the row.

Each week, the treasurer scans for bills due within seven days. At the monthly meeting, review Pending and Partly paid rows first, then confirm any reimbursements still open.

Use a direct reminder:

Please confirm the status of the bill due on {date}, and add the receipt link if you've paid it.

For in-person meetings, project the sheet or share the relevant rows beforehand. The review should produce updates, not guesses.

Record payments and reimbursements

A receipt folder and a few consistent status changes are enough for many informal clubs.

Moment Update in the calendar
Before payment Keep Status as Pending and identify the responsible person
When a member pays Enter Paid by, add the payment method in Notes, link the receipt, and set Status to Paid
When the payer needs money back Enter the amount under Reimbursement due and note who owes it
After repayment Set Status to Reimbursed and add the repayment date
When the amount field tracks open money Change the reimbursement amount to $0 after settlement

If the club tracks percentage shares, one simple convention is to record the payer's reimbursable share as 100% until repayment, then 0% after settlement. Keep the payment date and receipt link so the history isn't lost.

A clear request might say: "I paid $50 for field rental on 01/15/2026. Please send your share using the method we agreed on. Receipt: shared-folder link."

Don't mark a request as Reimbursed just because it was sent. Mark it after the money has actually been settled.

Choose a fair split before the bill arrives

Equal shares are easy. They aren't always appropriate. Decide whether the cost follows membership, attendance, usage, or an advance by one person.

Expense Reasonable starting rule
Annual club dues Equal amount per member
Event meals or supplies Per-person or attendance-based split
A venue or field used by members for different amounts of time Usage-based split
A cost advanced by one member Reimbursement after receipt proof
Income-based contribution Only with explicit group agreement and private handling

Write exceptions in Notes before payment. For example: Even split; VP pays 2x. A vague "split later" note creates work.

Keep the record private and readable

Records should still make sense six months later. Use this small maintenance table:

Problem Practical fix
Members can't open the file Check sharing settings and have one member test access
Someone overwrites a header or formula Limit edit access and protect formula cells
The club loses older history Export the sheet monthly as PDF or CSV
The active tab becomes crowded Move closed months to an Archive tab once it grows beyond about 50 rows
Sensitive information gets added Do not store full bank or card account numbers, passwords, or unrelated personal data

A shared sheet may be enough for an informal club's day-to-day tracking. It may not be enough for formal reporting. The IRS guidance for social clubs says organizations should distinguish the types and sources of income and expenses; failing to do so can create a presumption that income is unrelated and subject to unrelated business income tax in the situations described by the IRS.

That is a tax-specific issue, not a reason to add endless columns. If the club is tax-exempt or has formal filing duties, confirm the recordkeeping requirements with a qualified tax professional.

A few common edge cases

Can the calendar handle one-time event bills?

Yes. Add a row for expenses such as Spring Picnic Supplies alongside recurring dues and subscriptions. Use the event's payment or due date, then archive the row after the reimbursement is settled.

What if a member forgets to update the status?

Leave the row as Pending until someone confirms the payment. The treasurer can follow up by email or text rather than guessing from a bank notification or conversation.

When should the club use another system?

Consider a more structured bookkeeping process when several people edit constantly, disputes are frequent, or the club needs reports beyond bills, payments, receipts, and reimbursements. The right choice depends on the club's records and reporting needs.

Create the workbook before the next bill cycle. Add one real upcoming bill, then temporary rows for an overdue item, an item due within seven days, a paid row, and a blank due date. Test the permissions and highlights with one member, delete the temporary rows, and use the first monthly review to decide whether you need another column or less clutter.