Use a 2026 Google Sheets calendar for due dates, then keep the actual money in an Expenses tab. A Team List tab shows what each player paid and what that player still owes or should receive. The setup fits coaches, treasurers, and parent volunteers who need a clear record without adding a payment service.
The calendar is the reminder. The expense rows are the record. Start with equal splits for roster-wide charges. Gas, meals, and partial attendance need the actual participants, not a full-roster guess. Who should pay, and when? A neat formula can still make an unfair split.
Pick a 2026 calendar format
Choose a monthly layout with enough room for a due date, amount, and short note. Large cells help with league fees, equipment orders, tournament deposits, and travel reminders.
Two reasonable starting points are Smartsheet's free Google calendar templates, which includes monthly options, and CalendarLabs' 2026 Google Docs calendars, which lists monthly and yearly layouts. Treat these as starting files, not financial systems.
| Layout | Best use | What to enter |
|---|---|---|
| Year at a glance | Season planning | Expense ID, due date, and total |
| Monthly calendar with large cells | Regular bills and equipment orders | Description, amount, and payer |
| Weekly calendar | Tournament or travel weeks | Departure times, deposits, and reminders |
Some versions show holidays. Verify the labels and dates before planning around them.
A Google Docs calendar can handle the visual schedule, but formulas belong in Google Sheets. Keep the calendar easy to scan. Put receipt details in the tracker.
Put bill due dates on the calendar
Make a copy of the template and name it something clear, such as 2026 Team Bills. Keep the calendar, Expenses, and Team List tabs in the same file.
Use this setup:
- Give every expense a simple ID, such as
EXP-001. - Add the ID to the calendar note and the matching Expenses row.
- Write entries in a consistent format, such as
League fees - $200 total - due Mar 15. - Add planned bills to Expenses with a
Plannedstatus. - Keep the original due date even after the bill is paid. Record the paid date separately.
That last step matters. A due date answers when money was expected. A paid date answers when it actually left someone's account.
Build the Expenses tab
Use one row for each bill or purchase. Enter amounts as numbers, then format the Amount column as currency. Do not create separate expense rows for reimbursements.
| Column | Header | What to enter |
|---|---|---|
| A | Expense ID | A unique ID that matches the calendar |
| B | Due date | The date the bill is expected |
| C | Paid date | The date someone actually paid |
| D | Description | Tournament entry, uniforms, or field rental |
| E | Category | League fees, Equipment, Travel, Meals, or Uniforms |
| F | Cost type | Fixed or Variable |
| G | Payer | The roster name of the person who paid |
| H | Amount | The total bill or purchase amount |
| I | People sharing | Number of people in an equal split |
| J | Status | Planned, Paid, or Voided |
| K | Receipt or notes | Receipt file name, folder note, or exception |
Use Fixed for predictable charges such as registration or insurance. Use Variable for costs that change by event, such as gas or tournament meals.
On purchase day, photograph the receipt and add the row. Store the file in a shared folder named with the expense ID. The same expense ID, amount, and payer should appear in both places.
Review new rows weekly. A missing payer or status is easy to fix early.
Add the Team List formulas
Create a Team List tab with one player per row. Put names in column A, beginning at A2. Use the same spelling in Expenses and Team List.
Add these headers:
| Column | Header | Formula or entry |
|---|---|---|
| A | Player | Enter names beginning in A2 |
| B | Amount paid | =SUMIFS(Expenses!$H$2:$H$500,Expenses!$G$2:$G$500,A2,Expenses!$J$2:$J$500,"Paid") |
| C | Share owed | =SUMPRODUCT((Expenses!$J$2:$J$500="Paid")*IFERROR(Expenses!$H$2:$H$500/Expenses!$I$2:$I$500,0)) |
| D | Net owed (+) | =C2-B2 |
| E | Settlement note | Enter Settled, a date, or a payment method |
Enter the formulas in row 2 and fill them down. Freeze the first row so the headers stay visible while you review names.
The basic Share owed formula assumes every paid expense applies to every player listed. For a team-wide bill, People sharing should equal the number of active players included in that bill. A planned bill doesn't change the balances because the formulas only read rows marked Paid.
The Net owed formula uses a clear sign convention. A positive number means the player owes the team. A negative number means the team owes that player. For example, a player who paid the full team bill will usually show a negative balance.
Handle partial participation fairly
Turns out, the hard part isn't the formula. It's deciding who was included.
The two-tab model works for roster-wide costs. It becomes unreliable when only some players used the gas, shared a room, or attended a meal.
| Situation | Useful rule | Record |
|---|---|---|
| League fee for the active roster | Equal split | Full participant count |
| Gas for a known group of riders | Usage-based split | Actual riders and their shares |
| One person fronts a purchase | Reimburse after proof | Receipt, payer, and settlement note |
| Players have different charges | Explicit allocation | Dollar amount owed by each player |
For mixed expenses, add an optional Allocations tab with three columns: Expense ID, Player, and Share owed. Add one row for each participant after the expense is paid. Then replace the basic C2 formula with =SUMIF(Allocations!$B$2:$B$500,A2,Allocations!$C$2:$C$500).
Use the allocation formula for every paid expense in that model, not just unusual ones. The allocation rows for each Expense ID should add up to the Amount on the Expenses tab. If they do not, pause before requesting reimbursement.
Run a simple review and reimbursement workflow
A short routine keeps the file current without turning it into another job.
- At the start of the season, enter known dues, fees, deposits, and deadlines on the calendar.
- When someone pays, fill in Paid date, Payer, Amount, receipt details, and
Paidstatus. - During the weekly review, check the receipt, payer spelling, split rule, and allocation total.
- Before a monthly team review, scan Team List for positive and negative balances.
- After the group agrees, send a reimbursement request and add the settlement note after payment.
Try wording such as: Alex, the sheet shows $45 due for tournament gas. Please review the receipt and participant list, then reply if anything looks wrong.
To be honest, a short message works better when the receipt and math are already visible. Don't ask someone to settle a balance that still has a missing payer or unclear split.
Share the file without opening every cell to edits
Give access according to the person's job.
| Person | Suggested access | Main task |
|---|---|---|
| Treasurer | Editor | Enter expenses, receipts, and settlements |
| Coach or captain | Commenter or reviewer | Check unusual charges and approvals |
| Players or parents | Viewer | Review their row and supporting notes |
Use the Share control in Google Sheets to provide a view-only link when people only need to check balances. Protect formula ranges if your spreadsheet permissions support it. Keep editing limited to the people who reconcile the records.
Avoid storing full bank details, card numbers, or unnecessary contact information in the file. A shared sheet can show money owed without becoming a repository for sensitive data.
At the end of each month, save a dated copy or export the Team List tab to PDF. Keep the receipt folder, sheet, and calendar entry tied together by Expense ID. The system won't send payments or reminders by itself, so assign one person to review it on a regular day.
Check the sheet before asking for money
Thing is, most disputes begin with a small recordkeeping error. A due date gets mistaken for a paid date, or a payer's name is spelled two different ways.
| Check | Fix |
|---|---|
| Planned bill appears in balances | Leave it as Planned until someone pays |
| Payer is missing | Add the exact Team List name |
| Receipt cannot be found | Add the Expense ID to the receipt file name |
| Allocation total differs from the bill | Correct the participant shares before sending a request |
| Reimbursement is entered as a new expense | Keep the original expense and document settlement separately |
FAQ
Can I use a Google Docs calendar instead of Google Sheets?
Yes, for the visual calendar. Use Google Sheets for Expenses, Team List, and formulas. A Docs calendar won't replace the transaction table.
Why does every player show the same share owed?
The basic two-tab formula uses an equal split. It assumes every paid expense applies to every player listed. Use an Allocations tab when only some players participated.
Should an unpaid bill appear in the balance?
Not in the paid balance. Add it to the calendar and Expenses as Planned, then change the status after payment. This keeps forecasts separate from reimbursements that are actually due.
How should I record a reimbursement?
Leave the original expense in place. Add the settlement date, method, or confirmation in the Team List note. Do not count the reimbursement as a second team expense.
How often should the treasurer review the tracker?
Review new receipts weekly. Review balances before the monthly team meeting or before sending a reimbursement request. A small, regular check is easier than rebuilding the record later.
Can parents and players see the sheet?
They can receive viewer access if the team is comfortable sharing the listed information. Remove unnecessary personal details and restrict editing to the treasurer or another designated reviewer.
Create the file, enter one paid test expense, and confirm the formulas before sharing the tracker with the team.