What is in it
- Budget tab. Income by source and expenses by category, each with a budget column, an actual column, the difference and the percent of budget used. Totals and the year's net at the top.
- Monthly tab. Twelve month columns for recording what actually came in and went out. The Budget tab's actual column adds these up for you.
- Year start. Type the first day of your club's financial year on the Monthly tab and the month headings follow it.
How to use it
- On the Budget tab, rename or add lines to match your club, and type your budget figures.
- Each month, type the actual income and spending on the Monthly tab, using your bank statement.
- The Budget tab fills in actual, difference and percent used. A line turns red when spending goes over budget.
- Bring the Budget tab to board meetings. It answers most money questions before they are asked.
Income and expense lines included
| Income | Expenses |
|---|---|
| Membership dues | Venue and meeting space |
| Donations | Events |
| Events and tickets | Insurance |
| Fundraising | Website, email and software |
| Sponsorships | Printing and postage |
| Grants | Bank and payment fees |
| Interest | Supplies |
| Other income | Awards and gifts |
| Filing and registration fees | |
| Other expenses |