Home/Spreadsheets/PTA & Treasurer/League Treasurer
League Treasurer
A treasurer's ledger for any group that pools money - bowling and golf leagues, poker nights, rec teams, card clubs and fishing clubs. Set your buy-in and payout split once, then log dues, scores, attendance and fines as the season runs. The dashboard shows what has been collected, what is still outstanding and who owes it, and the standings and payouts work themselves out. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What it does
- Live treasurer dashboard showing total pot, collected, outstanding, members paid and attendance rate
- Dues tracker with payment date and method - status flips to Paid, Partial or Owed on its own
- Payout split you control, with a total that flags itself if it does not add up to 100%
- Rename the period from Week to Night, Session or Round and every header in the file follows
- Attendance grid that counts each member's turnout and works out their percentage
- Fines and side bets log with a running collected total, and season standings that rank themselves
- Opens in Excel and in Google Sheets
Instant digital download · one-time purchase · no subscription
Secure checkout on Etsy · ★★★★★ 5.0-star shop

See it in action
What buyers say
- ★★★★★
Seller went above and beyond with support! Listing says to message if there are any questions and they responded immediately to my post-sale inquiry. If you need a spreadsheet/tracker this is who you want to obtain it from!
Read this listing's reviews on Etsy
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, in order, read out of the workbook itself.
- START HERE
- Dashboard
- Members and Dues
- Weekly Scores
- Attendance
- Fines and Side Bets
- Season Standings
- Settings
Works in
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets — upload to Drive and open
- No macros, no add-ins, no subscription
Others in PTA & Treasurer
- Excel + Google SheetsPTA Treasurer SpreadsheetA PTA treasurer spreadsheet for PTOs and booster clubs: enter every transaction once on…$16.99View →

- ExcelAll-in-One Event PlannerOne event, eight linked views — budget, timeline, vendors and a day-of run sheet that…$24.99View →

- Excel + Google SheetsChurch Event CalendarA full-year church event planner: one workbook for every service, study and outreach…$14.99View →

- Excel + Google SheetsNonprofit and Sports Task TrackerMost task templates give you a list. This one names who is behind and by how much, with…$13.99View →
