Excel for Nonprofit Treasurers & Volunteers: Donations, Budgets & Reports
20 hands-on labs for volunteer treasurers of charities, clubs and associations: donation log, membership dues, budget vs actual and monthly phasing, restricted funds, grant spend-down, pledges and ageing, event results and break-even scenarios, petty cash, bank reconciliation, expense claims, cash flow, an equipment register, reserves policy, examiner checks, program ratio, volunteer hours and the year-end statement by fund.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course gives volunteer treasurers of charities, clubs and associations 20 practical Excel labs. You total a donation log by campaign, track membership dues, compare budget and actual for the year and month by month with a seasonal profile, and keep restricted and unrestricted money apart. You follow a grant's spending pace, age outstanding pledges, plan an event with break-even guests and a scenario table, count the petty cash box and reconcile the bank account. Later labs cover expense claims, monthly cash flow, an equipment register with straight-line depreciation, a reserves policy in months of spending, duplicate and missing-receipt checks before the examiner, the program ratio and volunteer hours. You finish with a year-end statement by fund and a chart for the members' meeting.
Lessons
- Donation Log: Totals by Campaign with SUMIF and COUNTIFFree
- Membership Dues Tracker: Who Has Paid and What Is Still Open Locked
- Annual Budget vs Actual: Variances and Overspent Lines Locked
- Restricted vs Unrestricted Funds: Who Owns Which Dollar Locked
- Grant Spend-Down: Remaining Budget and Spending Pace Locked
- Fundraising Event: Gross Income, Costs and Net Result Locked
- Bank Reconciliation of the Club Account Locked
- Volunteer Expense Claims: Receipts, Approval Limits and Payment Locked
- Cash Flow for the Year: Monthly Balances and the Tight Month Locked
- Program vs Admin Costs: Allocating Expenses and the Program Ratio Locked
- Volunteer Hours and In-Kind Gifts: Showing Support Beyond Cash Locked
- Treasurer’s Report for the Board: Year-on-Year Summary and Chart Locked
- Monthly Budget Phasing: Budget to Date, Variance to Date and a Full-Year Forecast Locked
- Pledges & Promised Gifts: Outstanding Amounts, Days Overdue and an Ageing Table Locked
- Petty Cash & Event Float: Counting the Box, Over/Short and the Top-Up Locked
- Equipment Register: Straight-Line Depreciation, Book Value and This Year's Charge Locked
- Event Planning: Break-Even Guests and a Price × Guests Scenario Table Locked
- Reserves Policy: Free Reserves, Months of Spending Covered and the Target Range Locked
- Before the Examiner: Duplicate Payments and Missing Receipt Numbers Locked
- Final Project – Year-End Statement by Fund with Reserves Check and Chart Locked
Learner reviews
Be the first to review this course.