Pledges & Promised Gifts: Outstanding Amounts, Days Overdue and an Ageing Table
Lessons in this course
- 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