Tabellab

Treasurer’s Report for the Board: Year-on-Year Summary and Chart

Lesson 12 of 20 Lab 🔒 Locked

Lessons in this course

  1. Donation Log: Totals by Campaign with SUMIF and COUNTIFLabFree
  2. Membership Dues Tracker: Who Has Paid and What Is Still OpenLab Locked
  3. Annual Budget vs Actual: Variances and Overspent LinesLab Locked
  4. Restricted vs Unrestricted Funds: Who Owns Which DollarLab Locked
  5. Grant Spend-Down: Remaining Budget and Spending PaceLab Locked
  6. Fundraising Event: Gross Income, Costs and Net ResultLab Locked
  7. Bank Reconciliation of the Club AccountLab Locked
  8. Volunteer Expense Claims: Receipts, Approval Limits and PaymentLab Locked
  9. Cash Flow for the Year: Monthly Balances and the Tight MonthLab Locked
  10. Program vs Admin Costs: Allocating Expenses and the Program RatioLab Locked
  11. Volunteer Hours and In-Kind Gifts: Showing Support Beyond CashLab Locked
  12. Treasurer’s Report for the Board: Year-on-Year Summary and ChartLab Locked
  13. Monthly Budget Phasing: Budget to Date, Variance to Date and a Full-Year ForecastLab Locked
  14. Pledges & Promised Gifts: Outstanding Amounts, Days Overdue and an Ageing TableLab Locked
  15. Petty Cash & Event Float: Counting the Box, Over/Short and the Top-UpLab Locked
  16. Equipment Register: Straight-Line Depreciation, Book Value and This Year's ChargeLab Locked
  17. Event Planning: Break-Even Guests and a Price × Guests Scenario TableLab Locked
  18. Reserves Policy: Free Reserves, Months of Spending Covered and the Target RangeLab Locked
  19. Before the Examiner: Duplicate Payments and Missing Receipt NumbersLab Locked
  20. Final Project – Year-End Statement by Fund with Reserves Check and ChartLab Locked