Council Financial Workbook

What do I get?

• Start Here tab with setup steps, Google Sheets instructions, and the fraternal year inputs
• Lists tab for your income and expense categories and fundraiser names (drives every dropdown)
• Ledger tab with 400 rows, category and fundraiser dropdowns, running balance, and an entry check column
• Budget tab: annual budget vs actual by category, remaining, and percent used
• Fundraisers tab: income, expenses, net profit, and margin per event, with a goal column
• Monthly tab: income, expense, net, and ending balance for each month of the fraternal year, plus a category by month table
• Annual tab: full year summary by category with budget variance and headline figures
• Audit Report tab: pick any period, get receipts and disbursements by category, a bank reconciliation, the five largest disbursements, an audit checklist, and signature lines
• Two files: a blank workbook ready for your data and a sample workbook filled with fake data so you can see how it works

Formats: Excel (.xlsx), Google Sheets (upload the .xlsx, or use the copy link)

How long will it take to set up?

About 20 minutes to enter your council name, opening balance, categories, and budget.

What problem does it solve?

Most councils track money in a mix of a checkbook, a notebook, and someone's memory. When the audit comes, the trustees spend an evening reconstructing the year. This workbook keeps everything in one place so the report is ready when they are.