How to set up a shared expense spreadsheet for sports teams

✨ Community Finance

Published: May 4, 2026

Set up a shared expense spreadsheet in Google Sheets with columns for date, description, category, paid by, amount, and notes. Use formulas to calculate per-person balances. Share with edit permissions but protect key ranges.

This approach helps sports team organizers, coaches, or treasurers track costs like uniforms, gas for away games, tournament fees, and player dues. For informal groups under 20 people with simple, occasional expenses, a spreadsheet handles tracking and splitting without needing apps for payments or receipts.

Choose Columns and Structure for Team Expenses

Start with a clean Google Sheet. Name tabs like "Expenses" for entries, "Balances" for summaries, and "Team List" for player names.

Essential columns on the Expenses tab, tailored to sports teams:

Date: When the expense happened (format as MM/DD/YYYY).
Description: Details like "Away game gas" or "New soccer cleats".
Category: Options such as Uniforms, Travel/Gas, Tournament Fees, Dues, Equipment, Snacks/Meals.
Paid By: Player name or "Team Fund" (match names from Team List tab).
Amount: Total cost in USD.
Share Per Person: Formula like =E2/F2 (amount divided by people).
Notes: Add receipt details or vendor.
Receipt Link: Paste Google Drive or photo link for records.

To keep headers visible when scrolling, go to View > Freeze > 1 row.

On the Team List tab, list names in column A (e.g., A2: "Alex", A3: "Jordan"). On Balances tab, reference these for per-person math.

This structure supports equal splits or adjustments, like fewer people for driver gas.

Add Formulas to Calculate Balances and Shares

Formulas automate totals so the treasurer does not recalculate manually. These are examples; test them for your team size.

On Balances tab, column A lists team members (e.g., =Team List!A2). For "Amount Paid" in column B: =SUMIF(Expenses!D:D, A2, Expenses!E:E). This sums amounts where Paid By matches the player.

For "Total Share Owed" in column C: =(SUM(Expenses!E:E)/COUNTA(Team List!A:A2)). This divides all expenses by team size for equal split.

"Balance" in column D: =B2 - C2. Positive means they are owed money; negative means they owe.

For category totals on a Summary tab, use =QUERY(Expenses!A:E, "SELECT C, SUM(E) GROUP BY C LABEL SUM(E) 'Total'"), from Relayfi's Google Sheets expense tracker template editorial.

Or for specific filters like travel costs: =SUMIFS(Expenses!E:E, Expenses!C:C, "Travel"), from the same Relayfi editorial.

Copy formulas down the column. For away games in foreign currency, multiply by =GOOGLEFINANCE("CURRENCY:USDEUR") if needed, per Johnny Africa expense split spreadsheet editorial.

Set Up Sharing and Permissions in Google Sheets

Safe sharing prevents accidental deletes while allowing team input.

Click Share (top right). Add emails with "Editor" access for treasurers and players who enter expenses. Viewer access lets others open and view but not edit (Tiller Help Center).

For restrictions, use Protected Ranges or Sheets: Select a range like formulas on Balances tab, then Data > Protect sheets and ranges. Set "Restrict who can edit this range" to only you or treasurers (Tiller Help Center).

If someone has View only, they see a green button to request edit access (Tiller Help Center). Use comment-only for players who just review.

Share the link with "Anyone with the link can edit" only for trusted groups; otherwise, require sign-in.

Team Workflow: Entry, Review, and Reimbursement

Assign roles: Treasurer enters most expenses; players add rows for personal buys like snacks, with receipts.

Entry steps:

Snap receipt photo, upload to shared Drive folder, paste link.
Add row: Date, description, etc.
Formulas update balances automatically.

Weekly review: Meet or message "Check Balances tab - Alex owes $30 for dues."

For reimbursements, use equal splits for dues/tournaments. For usage-based, adjust # People column (e.g., drivers enter gas with 1 in # People, then reimburse others).

Sample message: "You owe $45 for tournament gas - Venmo @teamhandle or cash at practice."

Settle monthly: Players with negative balances pay treasurer; positives get reimbursed. Note payments in a separate "Settlements" column on Balances.

Common Mistakes and When to Use an App Instead

Avoid unprotected edits: Without Protected Ranges, players overwrite formulas (use Tiller steps above).

Other pitfalls: Skipping receipt links (keep a folder for records), ignoring currency for international tournaments (add GOOGLEFINANCE as noted), or not freezing headers so categories scroll away.

Spreadsheets work for small teams with infrequent expenses like seasonal dues. They suffice when no one needs payment reminders or scans.

Consider apps if your team grows, has frequent travel with receipts to scan, or wants built-in requests/payments. Apps separate tracking from paying; spreadsheets focus on records. For simple tracking under 20 people, start here before adding tools.