SDSimpleDesigns

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
$13.99one-time, no subscription
Buy on Etsy

Instant digital download · one-time purchase · no subscription

Secure checkout on Etsy · ★★★★★ 5.0-star shop

League Treasurer — the workbook open in Excel

See it in action

What buyers say

Read this listing's reviews on Etsy

What it looks like

League Treasurer screenshot
League Treasurer screenshot

Every tab in the workbook

These are the actual sheet names in the file, in order, read out of the workbook itself.

Works in

Others in PTA & Treasurer

League Treasurer$13.99Buy on Etsy