What it is
Most of a charter school’s revenue is state aid driven by the count-day enrollment. A wrong count, a missed weighting or an unrecorded true-up passes straight into revenue and into the receivable at year end.
This workbook recomputes expected aid by grade from the count and the per-pupil rate, compares it with the ledger, and lists every funding stream with the amount earned, received, receivable or advanced, and cash received after year end.
When to use it
- At year end, to support state aid revenue and the receivable from the state.
- After the funding notice or a state true-up arrives.
- When the school applies for a charter renewal or a loan and must support its revenue.
What’s inside
- Enrollment tab with 16 grade rows, per-pupil rate, optional weighting and expected aid
- Reporting framework selector for FASB not-for-profit or GASB governmental schools
- Funding tab with 25 sources, receivable, advance and subsequent receipts test
- Tie-outs of receivable, advances and per-pupil aid to the ledger and between tabs
Standard cited
This template follows FASB or GASB framework. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Does the framework change the reconciliation?
No. The arithmetic is the same. The framework changes the equity captions and some of the statement presentation.
When is grant revenue recognized?
When the school meets the conditions of the grant, such as incurring allowable expenditures. The sheet separates earned from received so the receivable or advance shows by source.
What supports a receivable that was not collected after year end?
The funding notice, the state payment schedule or written confirmation. The sheet flags any receivable with no subsequent receipt.
Related templates
- Audit Program: Charter School
- Audit Program: Independent School
- Single Audit Checklist: Compliance Requirements by Type (2 CFR 200, Subpart F)
- Audit Program: Nonprofit Organization
Last updated 11/05/2026. All free templates.