Use Google Sheets to set up a shared expense tracker with columns for date, description, category, total amount, payer, number of members, per-person share, and paid status. Share via editor permissions for club collaboration. This helps club leaders track dues, events, or trips without needing payment apps.

Start with a new Google Sheet. Add a Summary tab for balances and separate tabs for each month, like "Jan 2026" or "Feb 2026". Enter expenses row by row. Use simple formulas like =total/#members for per-person shares. Consistent category names prevent summing errors, as noted in SpreadsheetPoint's expense tracker guide.

Choose Columns for Club Shared Expenses

Tailor columns to club needs, such as dues, events, or trips. Essential ones include:

  • Date: When the expense happened (e.g., 01/15/2026).
  • Description: What was bought (e.g., "Annual dues payment" or "Pizza for meeting").
  • Category: Group like items (e.g., Dues, Events, Trips, Supplies). Use exact matches like "Events" every time.
  • Total Amount: Full cost (e.g., $200).
  • Paid By: Member name or "Treasurer".
  • # Sharers: Number splitting the cost (e.g., 20 members).
  • Per-Share Amount: Formula like =D2/G2 (total divided by sharers).
  • Status: Paid, Owed, or Reimbursed.

For equal splits, divide total by all members. For usage-based, adjust # Sharers (e.g., 10 attendees for a trip). Tradeoffs: Equal splits are simple but ignore no-shows; usage-based is fairer for optional events but needs attendance tracking.

Add a Balance column: =IF(H2="Paid",0,G2*(G2-D2)) to track owes per person. This setup works for 5-50 members.

Set Up the Basic Spreadsheet Structure

Follow these steps:

  1. Go to sheets.google.com and click Blank.
  2. Rename Sheet1 to "Summary". Add tabs: Right-click bottom tab > Insert sheet. Name them "Jan 2026", "Feb 2026".
  3. In monthly tabs, add headers in row 1: Date, Description, Category, Total Amount, Paid By, # Sharers, Per-Share Amount, Status.
  4. Enter sample data. In Per-Share (column G), enter =D2/G2 and drag down.
  5. In Summary tab, total categories with =SUMIF('Jan 2026'!C:C,"Events",'Jan 2026'!D:D). Repeat for other months and categories. Consistent category naming avoids undercounting, per SpreadsheetPoint's template guide (SpreadsheetPoint).

For overall balances, list members in column A and use =SUMIF('Jan 2026'!E:E,A2,'Jan 2026'!G:G) to sum what each owes, adjusted for payments.

Input club data like $500 venue for 25 members (=20 per person) or $100 supplies paid by one, split evenly.

Add Sharing and Permissions for Club Members

Click Share in the upper right. Add member emails and select Editor for collaborative edits, as explained in Tiller's help center (Tiller Help) and Google Workspace (Google Workspace).

Editors can add rows or update status. For protection, select key ranges (e.g., formulas in Summary): Data > Protect sheets and ranges. Set to warn or restrict edits while allowing overall access.

If someone gets View only, they click Request edit. Avoid Viewer for active clubs.

Common Mistakes and How to Avoid Them

Inconsistent categories like "Food" vs. "Groceries" break SUMIF totals, as SpreadsheetPoint notes. Fix: Create a dropdown list (Data > Data validation) with approved categories.

Unprotected sheets risk accidental deletes. Use Protected Ranges for summaries, per Tiller Help.

No update cadence leads to outdated records. Set monthly reviews at meetings.

Overcomplicating: Skip advanced formulas like INDIRECT unless switching months dynamically, which SpreadsheetPoint describes for charts.

Forgetting receipts: Add a column for links to Google Drive photos.

When a Spreadsheet Works vs. When to Add Apps

Spreadsheets suffice for tracking dues, events, or occasional trips. Pair with receipt photos in Drive and Venmo/Zelle for reimbursements. Document rules upfront: "Update within 48 hours; treasurer approves monthly."

Consider apps if payments are frequent (e.g., weekly dues). Apps handle requests and transfers; keep Sheets for records. Separate tracking (Sheets) from paying (apps). For clubs under 50, Sheets with editor access works without paid tools.

Decision tree:

  • Infrequent expenses, simple splits? Use Sheets alone.
  • Recurring payments, reminders needed? Pair with a payment app.
  • Growth to 50+? Review permissions and add a log tab.

FAQ

How do I calculate uneven splits for clubs (e.g., income-based)?
Add columns for % Share (e.g., 30% for high earner). Per-share = total * % Share. Discuss rules first.

What's the best update schedule for a club spreadsheet?
Monthly reviews at meetings; members update within a week of expenses.

Can I protect formulas while letting members add expenses?
Yes, protect Summary formulas via Data > Protect sheets and ranges; allow edits to data tabs.

How do I handle receipts and reimbursements in Sheets?
Link Drive photos in a Receipts column. Mark Status "Reimbursed" after payment proof.

Is this setup free? Any Google Sheets limits?
Free for personal Google accounts. Editor sharing works for small groups.

What if our club grows beyond 50 members?
Add member lists and SUMIF by name. Consider apps for scalability.

Next, create your sheet and test with past expenses. Set a first meeting to review rules and permissions.