Scout Troop Treasurer Spreadsheet
Instant download Secure checkout Google Sheets & Excel Formula guarantee
Instant download on our Etsy shop — one-time purchase, no subscription.
Every scout's own account — dues owed, outing charges, fundraising credit, payments, balance — plus the troop's money in and out, budget vs actual, and a treasurer's report that prints for the committee. One connected workbook.
What’s inside
- Scout Accounts — dues − paid + outing charges − outing payments − fundraising credit = balance; In credit / Part paid / Owed; by patrol
- Outings — outing, date, cost per scout, an x under each scout who went; every account is charged automatically
- Fundraising Sales — each scout's sales per fundraiser; the credit % you set goes to their account
- Income and Expenses — 400 rows each; paid by, receipt? and reimbursed on every expense
- Budget and Fundraisers — budget vs actual; goal vs raised minus product cost per sale
- Treasurer Report — pick a month; balance at start, income and expenses by category, net, balance at end
- Dashboard — cash now, owed by families, credit held for scouts, scouts owing, sales and credit totals, by patrol, by month
- 118 automated formula checks passed before listing; Google Sheets or Excel
Who it's for: the troop committee treasurer who inherited a shoebox and a popcorn spreadsheet and needs to tell nine families what they owe before summer camp.
Ten connected tabs for $14.99, one-time — the only troop-treasurer workbook on Etsy that keeps individual scout accounts.
