Use a Google Sheets template with columns for date, description, payer, amount, category, and split method to track club expenses like dues, events, and trips. Add formulas for summaries, share via link with controlled permissions, and export to PDF for a printable version. This works for club treasurers or organizers managing shared costs without apps or accounts.

Club groups often handle dues, venue fees, snacks, travel, and reimbursements informally. A printable tracker keeps records clear for meetings or audits, with digital formulas updating balances automatically before printing.

Recommended Columns for Club Expense Tracking

Set up columns tailored to clubs for tracking dues, events, and group reimbursements. Start with these in row 1 of a "Transactions" sheet:

  • A: Date (format as MM/DD/YYYY)
  • B: Description (e.g., "Annual dues payment", "Pizza for game night", "Bus rental for field trip")
  • C: Payer (member name or "Club Cash")
  • D: Amount (positive for expenses/outflows, negative for income/reimbursements)
  • E: Category (e.g., Dues, Venue, Snacks, Travel, Equipment; adapt from No More Debts suggestions like Transportation for trip gas or memberships for club fees)
  • F: # People (for per-person splits)
  • G: Split Type (Equal, Per-Person, Usage-Based)
  • H: Paid? (Y/N or date paid)
  • I: Running Balance (formula: =SUM($D$2:D2) for cumulative total)

For reimbursements, add a J: Reimbursed To column. This setup tracks who paid upfront and who owes what. Example row: 01/15/2026, "Venue deposit", "Alex", -150, "Venue", 1, "Club Cash", Y, =SUM($D$2:D2), "Alex".

Adapt categories to your club: PTAs might use "Fundraiser Supplies"; sports teams "Uniforms" or "Ref Fees".

Setup Steps in Google Sheets

Create the template from scratch or a blank sheet.

  1. Open Google Sheets and start a new spreadsheet named "Club Expense Tracker 2026".
  2. Add tabs: "Transactions" for entries, "Summary" for totals, "Members" for dues lists.
  3. In Transactions, enter headers in row 1 and sample data in rows 2-5.
  4. Add running balance in I2: =SUM($D$2:D2). Drag down.
  5. In Summary tab, use =QUERY(Transactions!A:D, "SELECT Transactions!E, SUM(Transactions!D) GROUP BY Transactions!E LABEL SUM(Transactions!D) 'Total'") for category totals like Venue: $200 (Relay Financial).
  6. For high expenses, add =FILTER(Transactions!A:D, Transactions!D>100) to list items over $100 (Relay Financial).
  7. Category totals with conditions: =SUMIFS(Transactions!D:D, Transactions!E:E, "Travel", Transactions!H:H, "Y") (Relay Financial).
  8. Conditional formatting for warnings: Select budget column, format > conditional > custom formula =AND(C2>=B2*0.8, C2<=B2) to highlight 80-100% budget use (Relay Financial).
  9. Protect formulas: Data > Protect sheets and ranges (Tiller Help Center). Set ranges like Summary tab to "Warn before editing".

Update weekly or per event. Version history (File > Version history) tracks changes for audits.

Sharing and Permissions for Group Access

Share securely for club members to view, comment, or edit.

From Tiller Help Center, permission levels include:

  • Viewer: Open and view only.
  • Commenter: View and add comments, no edits.
  • Editor: Full access to modify, add, delete data (except ownership changes).

Steps:

  1. Click Share button (top right).
  2. Add emails or change to "Anyone with the link".
  3. Set to Editor for active clubs where members add transactions; Viewer for read-only. Per Spreadsheet Point, "Anyone with the link" lets non-Google users access. For edits, request access if view-only (click "Request edit access", Tiller Help Center).

Protect key areas: Use Protected ranges/sheets to allow transaction edits but lock Summary (Tiller Help Center). Treasurer sets as owner.

For print distribution, share PDF link instead.

Printing Your Template as a PDF Tracker

Export for meetings, sign-offs, or offline use where formulas won't update.

  1. Finalize digital sheet with current data.
  2. File > Download > PDF document (.pdf).
  3. In PDF settings: Landscape orientation, fit to width, include gridlines.
  4. Print or save; add instructions like "Manual updates only - check digital for balances".

Printed version suits quarterly reviews or low-tech groups. Limits: No auto-calculations; re-enter for updates. Use for signatures on reimbursements.

Common Mistakes and When to Use Apps Instead

Avoid these pitfalls:

  • Unprotected sheets: Members overwrite formulas (protect ranges, Tiller Help Center).
  • No receipts: Always note or attach photos; ignore for audits.
  • Forgetting version history: Use for disputes.
  • Over-customizing: Stick to core columns.

Spreadsheets suffice for small clubs (<10 members, quarterly events) with simple dues or reimbursements - free, no accounts, printable. Use when group agrees on rules like equal splits.

Switch to apps for frequent reimbursements, receipt scans, or automated payouts (separate tracking from payments). Consider if >20 transactions/month or multi-location access needed. Apps add automation but require accounts; spreadsheets stay lightweight.

FAQ

How do I add a running balance for club dues?
In column I2: =SUM($D$2:D2). Drag down; treats income as negative.

What formulas sum expenses by category like travel or events?
=QUERY(Transactions!A:E, "SELECT E, SUM(D) GROUP BY E LABEL SUM(D) 'Total'") (Relay Financial). Or =SUMIFS(D:D, E:E, "Travel").

Can non-Google users view or print the tracker?
Yes, share "Anyone with the link" as Viewer; they open/export PDF (Spreadsheet Point).

How do I protect the summary sheet but allow transaction edits?
Data > Protect sheets and ranges; protect Summary tab, warn on edits (Tiller Help Center).

Is this template good for tax records or reimbursements?
Tracks reimbursements with dates/payers; keep receipts. For U.S. taxes, consult IRS guidance as rules vary; not formal advice.

When should a club switch from printable sheets to an app?
If handling frequent payouts, scans, or >10 members; sheets work for simple, infrequent tracking.

Next, test with sample club data, share a draft link, and print for your next meeting. Adjust columns as your group agrees on split rules like equal vs. usage-based.