Free team payment tracker spreadsheet
What it is
A free spreadsheet for whoever collects the team’s money. List your families and each payment once, type in what comes in, and it shows who has paid, who owes and how much is past due today. It opens in Excel, Google Sheets and Numbers, and there is nothing to sign up for.
Excel file, 19 KB. No sign-up and no email.
Last updated November 14, 2026.
What it looks like
Riverside United 12U
- Total due
- $22,250
- Collected
- $12,550
- Still owed
- $9,700
- Past due today
- $1,900
- Families paid in full
- 3 of 16
| Family | DepositSep 15, $200 | Second paymentNov 1, $600 | Final paymentJan 15, $600 | Balance | Status |
|---|---|---|---|---|---|
| Garcia family | $200 | $600 | $600 | $0 | Paid in full |
| Chen family | $200 | $600 | Nothing yet | $600 | On track |
| Peterson family | $200 | Nothing yet | Nothing yet | $1,200 | Late |
| Smith family | $200 | $600 | Nothing yet | $600 | On track |
| Johnson family | $200 | $300 | Nothing yet | $900 | Late |
| Patel family | $200 | $600 | $600 | $0 | Paid in full |
How to use it
- Type your team and season at the top of the Tracker tab.
- Name each payment, then give it a due date and the amount each family owes. There is room for six payments.
- List your families, one to a row. Type over the example row first.
- When money comes in, type the amount under that payment, in that family’s row.
- Read the right side. Total due, Paid so far, Balance, Past due today and Status fill themselves in.
The file has three tabs. Tracker is the one you fill in, Example shows a full team part way through a season, and How to use repeats these steps.
What it works out for you
| Total due, Collected and Still owed | For the whole team, across the top. |
|---|---|
| Families paid | How many families have paid each payment in full, like 11 of 16. |
| Balance | What each family still owes for the season. |
| Past due today | What a family should have paid by now and hasn’t. |
| Status | Paid in full, On track or Late, each in its own color. |
| Adjustment | A discount or an extra charge for one family, like a sibling discount. |
The shaded cells are yours to type in. The rest are formulas, and they are ones Excel, Google Sheets and Numbers all share.
Using it in Google Sheets or Numbers
- Upload the file to Google Drive.
- Double-click it. A preview opens.
- At the top, click Open with Google Sheets.
To keep it as a Google Sheet, click File, then Save as Google Sheets. Apple Numbers opens the file as it is.
What a spreadsheet can’t do
It can show you who is late. It can’t ask them. Somebody still has to open it, find the late families and send the message, every time a payment comes due.
The tracker shows who owes. Team Nudge asks them.
Team Nudge sends the reminders for you. Add your families and what’s due once, and each family hears from us before the due date and after it, until they pay.
- Reminders 7, 3 and 1 days before each due date, and follow-ups when it’s late
- One tap on “I paid” stops that family’s reminders and tells you
- One board that updates when a family taps “I paid”
- Families pay you directly, so Team Nudge never touches the money
Free to sign up. Each team is free for 30 days, then $19 a month. Cancel anytime.
Questions
Is the tracker really free?
Yes. It is a plain spreadsheet file. There is no sign-up, no email to give and nothing to install.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive, double-click it and click Open with Google Sheets. Every formula in it is one that Excel and Google Sheets share.
How many families and payments does it hold?
It has rows for 30 families and columns for 6 payments. For a bigger team, copy a whole family row and insert it between two others, so the totals keep counting it.
Can one family owe a different amount?
Yes. The Adjustment column takes a discount or an extra charge for one family. Type -100 for a $100 discount, like a sibling discount.
What does Past due today mean?
It is what a family should have paid by today and hasn’t. The tracker compares each due date with today’s date, and you can type another date over it to see how things stood on that day.
Does it send reminders?
No. A spreadsheet can show you who is late, but it can’t ask anyone. That part is still yours, or Team Nudge’s.
Sources
- Google Docs Editors Help, Use both Excel and Sheets
- Google Docs Editors Help, Import data sets and spreadsheets
- Apple, Numbers User Guide for Mac
Team Nudge is not connected to Microsoft, Google or Apple. Excel, Google Sheets and Numbers are their products.