Tabellab
Accounting Beginner

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.

20 lessons 20 labs Certificate

  • 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

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy