Have you ever tried collecting tournament dues after three or four parents paid for jerseys, snacks, and gear on separate credit cards? It turns into a giant headache. Someone loses a physical receipt, someone else forgets tax, and within a week nobody agrees on who owes what.
A simple Google Sheets setup handles the math without locking your club into a paid app subscription. You get a transparent record everyone can open from their phones.
Structure the Expenses Tab
Start with two tabs in a fresh file: name one "Expenses" and the other "Balances".
The Expenses tab logs every single charge as it happens. Keep this sheet simple. Teammates will update it on tiny phone screens between drills, and cluttered layouts lead straight to bad input.
| Column | Header | Purpose | Example |
|---|---|---|---|
| A | Date | When the transaction happened | 10/12/2026 |
| B | Description | What was purchased | Practice jerseys |
| C | Category | Grouping for year-end review | Equipment |
| D | Amount | Total cost in dollars | 240.00 |
| E | Paid By | Name of the person who paid | Marcus |
| F | Split Type | How the cost is divided | Equal |
| G | Receipt Link | Link to a photo in Google Drive | drive.google.com/... |
| H | Notes | Extra details or exceptions | Paid at the store |
Format column A as Date and column D as Currency. To prevent typos, add a dropdown menu to column F by clicking Data, then Data validation, and listing options like Equal, Per-person, and Direct Reimbursement.
Automate Balances with Simple Formulas
Turns out, basic spreadsheet math tracks debts better than fancy custom scripts.
Move to your "Balances" tab to build the roster summary. Column A holds member names starting at row 2. Column B calculates what each person paid out of pocket, column C shows what they owe toward shared costs, and column D displays their current balance.
To sum everything Marcus paid, drop this formula into B2:
=SUMIF(Expenses!E:E, A2, Expenses!D:D)
Next comes Marcus's share of team expenses. If your roster has twelve players sharing total season costs equally, calculate his portion in C2:
=SUM(Expenses!D:D) / 12
Finally, subtract his owed share from his paid total in D2:
=B2 - C2
A positive number means the team owes him money. A negative number means he owes the group. Once row 2 calculates properly, copy those formulas down through the rest of your roster.
Lock Down Formulas and Headers
Shared spreadsheets break in the exact same messy way every single season, usually because someone opens the sheet on a phone in a grocery checkout line and accidentally fat-fingers a formula cell or types a number directly over your column title. That silent error sits there for weeks until audit night.
You can prevent this by locking the sensitive cells before anyone gets the invite. Follow standard instructions for protecting ranges in Google Sheets to lock the entire Balances tab. Select the tab, head to Data, pick Protect sheets and ranges, choose Sheet, and limit edit permissions strictly to yourself or a designated treasurer.
Apply that same lock to row 1 on the Expenses tab. That keeps your header text intact while leaving rows 2 and below completely open for new receipts.
Handling Reimbursements Without Double Counting
Thing is, tracking repayments between members ruins sheets if you log them like normal purchases.
Say Coach Lee pays a $300 tournament registration fee directly to the league. That is a collective group expense. Every member owes a slice of that $300. But if Marcus sends Coach Lee $25 on Venmo the next day, you cannot list that $25 on your Expenses tab. If you log Marcus's payment there, the spreadsheet tallies $325 in team spending. Suddenly the balance sheet overstates total costs and messes up everybody's math.
Treat direct member repayments as settlement transfers outside your main expense list. You can track them on a separate settlements log or simply let the Balances tab reflect updated totals once Coach Lee confirms receipt.
Proper documentation protects the team if you manage funds for a formal club, PTA, or 501(c)(3) sports program. Under IRS requirements for accountable plans, expense reimbursements stay tax-free only when members verify actual costs with real receipts and return excess reimbursements in a reasonable timeframe, generally 60 days. Paste those Drive photo links into column G immediately. If league officials or auditors ask to review the season books, you will have every single payout tied to an itemized receipt.
Team Rules That Keep the Sheet Usable
Spreadsheets only work when people actually follow a routine. Share three simple expectations with the group before sending out the link:
- Log expenses within 48 hours so paper receipts do not get lost in gym bags.
- Snap and upload photos directly to a shared Google Drive folder instead of texting them.
- Clear all net balances on the first Sunday of the month.
Keep permissions clean, too. Give view-only access to parents and players who just need to see where their money went. Restrict editor access to the few people authorized to spend team funds.
Open your sheet, set up the two tabs, and enter this week's roster.