Club & Small Charity Treasurer: Dues, Cash Book, Bank Reconciliation & Annual Accounts
Keep the books of a fictional rowing club like a volunteer treasurer: membership dues and arrears, a running cash book, petty cash, bank reconciliation, fundraising events, budget vs actual, reserves and a cash forecast, and the annual accounts for the members' meeting, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
You keep the books of a fictional rowing club like a volunteer treasurer, one checked formula at a time. You look up membership fees, pro-rate them for members who join during the year and total the arrears. You keep a cash book with a running balance and SUMIFS by category, close a month of petty cash under the imprest system and reconcile the cash book with the bank statement until the difference is zero. Then you compare fundraising events per volunteer hour, report budget vs actual with favourable and adverse variances, calculate free reserves in months of spending, find the low point of a cash forecast and prepare the annual accounts for the members' meeting.
Lessons
- Membership Dues: Fee Categories, Pro-Rata Joiners and Arrears Pro
- The Cash Book: Receipts, Payments and a Running Balance Pro
- Petty Cash: Imprest Float, Vouchers and the Monthly Top-Up Pro
- Bank Reconciliation: Uncleared Items and the Adjusted Balances Pro
- Fundraising Events: Income, Net Result and Return per Volunteer Hour Pro
- Budget vs Actual: Year-to-Date Variances and a Run-Rate Forecast Pro
- Reserves Policy and a Twelve-Month Cash Forecast Pro
- Capstone: Annual Accounts for the Members' Meeting Pro