Free Download · Committee

Troop Dues & Event Payment Tracker

One spreadsheet, seven linked tabs — track dues, campout fees, and summer camp payments without juggling separate lists or a folder full of files.

Download Clean PDF

Download gives a clean, correctly paginated PDF. Print opens your browser's print dialog.

Get the live spreadsheet

Dropdowns link scouts to events automatically, and the Dues Summary tab calculates balances live. Enter your email and we’ll open a copyable Google Sheet — File → Make a copy to save it to your own Drive.

You'll also get occasional new templates and tips from us. Unsubscribe anytime.

Quick Start

1Add every scout to the Roster tab.
2Add this year's dues and event fees to the Events tab.
3Log each payment in the Payments tab — pick the scout and event from the dropdown menus.
4Open the Dues Summary tab any time to see who owes what.

How the Tabs Work Together

Tab	What it's for
Roster	Every scout in the troop — name, patrol, and parent contact. One row each.
Events	Every fee your troop collects this year — separate Scout Fee and Adult Fee columns, since adults often cost less (or nothing, if they bring their own food).
Payments	The link between scouts and events. Pick a scout, event, and Payer Type from the dropdowns — Amount Due auto-fills the right rate, then log what was paid.
Dues Summary	Auto-calculated — total owed, total paid, and balance for every scout. Updates itself as you log payments.
Adults	Names for the Adult Name dropdown in Payments — add parent/leader names here.
Scout Lookup	Pick a scout from the dropdown to see every payment row for just that scout.
Fundraising Credit	Every fundraiser payout a scout earns — automatically reduces what they owe overall, not tied to one specific due.

Tip: list annual dues as its own row in the Events tab, right alongside campouts and summer camp — that way one Dues Summary tab shows the whole financial picture for every scout, not just event fees.

Want the full walkthrough — mid-year joiners, fixing mistakes, carrying fundraising credit into next year? Read the full setup guide →

Prefer a shared live app instead of a spreadsheet?

The Dues Tracker appcovers the same roster, events, payments, and fundraising credit — but multiple committee members can sign in and edit the same data, so it isn’t all riding on one person’s login or file.

Like this template? Get all 28 in the Full Template Library ($25) — one combined PDF with your troop # and name already filled in on every page.

Independent resource — not affiliated with or endorsed by Scouting America. Always verify current BSA advancement requirements at scouting.org or with your local council. Requirements are updated periodically.