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.

Download the tracker

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
The first families on the tracker’s Example tab
FamilyDepositSep 15, $200Second paymentNov 1, $600Final paymentJan 15, $600BalanceStatus
Garcia family$200$600$600$0Paid in full
Chen family$200$600Nothing yet$600On track
Peterson family$200Nothing yetNothing yet$1,200Late
Smith family$200$600Nothing yet$600On track
Johnson family$200$300Nothing yet$900Late
Patel family$200$600$600$0Paid in full
6 of the 16 families on the Example tab, as they stood on November 14, 2026. A cell turns green when that payment is paid in full.

How to use it

  1. Type your team and season at the top of the Tracker tab.
  2. Name each payment, then give it a due date and the amount each family owes. There is room for six payments.
  3. List your families, one to a row. Type over the example row first.
  4. When money comes in, type the amount under that payment, in that family’s row.
  5. 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

What the tracker calculates
Total due, Collected and Still owedFor the whole team, across the top.
Families paidHow many families have paid each payment in full, like 11 of 16.
BalanceWhat each family still owes for the season.
Past due todayWhat a family should have paid by now and hasn’t.
StatusPaid in full, On track or Late, each in its own color.
AdjustmentA 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

  1. Upload the file to Google Drive.
  2. Double-click it. A preview opens.
  3. 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
Start free

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

  1. Google Docs Editors Help, Use both Excel and Sheets
  2. Google Docs Editors Help, Import data sets and spreadsheets
  3. Apple, Numbers User Guide for Mac

Team Nudge is not connected to Microsoft, Google or Apple. Excel, Google Sheets and Numbers are their products.

More guides