Blog · Board and management reporting · Education
Analyze an education provider's operating revenue by institution, program and contract. A worked example separates delivery volume, realized fees and contract movements, with spreadsheet formulas and a reconciliation to recorded revenue.
Education revenue analysis explains a provider's recorded operating revenue by institution, program, contract and period. Start with the finance total, then separate changes in delivered services, realized fees and contract activity. This is a provider operating review, using institutional and program summaries rather than individual student finances.
Obtain the recorded revenue export for the periods you want to compare. Include institution ID, contract ID, program ID, posting period, revenue account, document reference, currency and signed amount. Keep refunds and adjustments visible instead of presenting gross fees as net revenue.
Add the contract register for service dates, approved fee terms and commercial status. Bring program delivery summaries if they contain the units finance uses to support recorded revenue. Institution and contract identifiers should join these files without relying on names that can change.
Keep contract value, invoicing and cash collection distinct. The IRS explanation of accrual accounting describes income as generally reported when earned regardless of when payment is received. That illustrates the timing difference; finance must approve the accounting treatment for the provider's particular services.
A prepaid annual access contract and a completed training session may require different revenue schedules. Do not impose one seat-based formula on every program. The example below uses contracts for which finance has confirmed that completed training seats and their net realized fees explain the recorded revenue in the displayed periods.
An illustrative US training provider compares the second and third quarters of 2026. The second quarter is April through June; the third is July through September. Each row is a separate institutional contract and program, all in USD. A completed seat means a delivered training place under the example's approved revenue schedule.
| Institution and program | Q2 completed seats | Q2 net fee per seat (USD) | Q2 revenue (USD) | Q3 completed seats | Q3 net fee per seat (USD) | Q3 revenue (USD) |
|---|---|---|---|---|---|---|
| North College: technical training | 120 | 500 | 60,000 | 130 | 520 | 67,600 |
| West College: instructor training | 80 | 750 | 60,000 | 70 | 750 | 52,500 |
| New College: compliance training | 0 | 800 | 0 | 40 | 800 | 32,000 |
| Ended College: leadership training | 30 | 600 | 18,000 | 0 | 600 | 0 |
| Total | 230 | 138,000 | 240 | 152,100 |
The fee for New College in Q2 is its signed contract rate, shown only to support the later volume calculation; there were no delivered seats or recorded revenue in that quarter. The Ended College row retains its last applicable fee for the same reason.
In Excel or Google Sheets, put seats in B and E, fees in C and F, and revenue in D and G. Enter the following formulas in D2, G2 and H2, respectively:
=B2*C2
=E2*F2
=G2-D2
Fill down through the contract rows. Sum the revenue columns; do not multiply total seats by a simple average of the listed program fees.
Recorded revenue increased by $14,100: $152,100 minus $138,000. Percentage growth is $14,100 / $138,000 = 10.2%, rounded to one decimal place. The following bridge shows exactly where the change arose.
Use the prior-period fee for the volume effect and current-period seats for the fee effect. This convention assigns their interaction to the fee effect, so the components add exactly to each contract's revenue change.
Volume effect = (Current completed seats - Prior completed seats) × Prior net fee
Fee effect = Current completed seats × (Current net fee - Prior net fee)
| Contract | Volume effect (USD) | Fee effect (USD) | Total revenue change (USD) |
|---|---|---|---|
| North College | 5,000 | 2,600 | 7,600 |
| West College | -7,500 | 0 | -7,500 |
| New College | 32,000 | 0 | 32,000 |
| Ended College | -18,000 | 0 | -18,000 |
| Total | 11,500 | 2,600 | 14,100 |
Enter the following spreadsheet formulas in I2, J2 and K2, respectively:
=(E2-B2)*C2
=E2*(F2-C2)
=H2-I2-J2
Every K cell must be zero. The overall proof is $138,000 + $11,500 + $2,600 = $152,100. These effects describe the arithmetic, not a claim that fee changes caused demand to rise or fall.
The contract register confirms New College as a new signed contract and Ended College as a contract whose service term ended. North renewed with a higher realized fee; West continued with fewer completed seats. Without those supporting records, label the rows as activity movements rather than claiming wins, losses or renewals.
For fee comparisons, distinguish a change in agreed prices from discounts, refunds or a different service package. Use customer revenue analysis to see the institution's combined activity across its programs. Use education cost analysis to investigate whether growth also improved the provider's economics.
The delivery calculation must reproduce recorded revenue, not replace it. Suppose Revenue!A:A holds contract IDs, B holds posting dates and C holds signed recorded revenue. Put the relevant contract ID in summary cell A2 and rebuild Q3:
=SUMIFS(Revenue!C:C,Revenue!A:A,A2,Revenue!B:B,">="&DATE(2026,7,1),Revenue!B:B,"<"&DATE(2026,10,1))
The Google Sheets SUMIFS documentation describes sums restricted by multiple criteria. Here, the contract and posting period define the included rows. Covirage is not affiliated with Microsoft or Google.
The contract totals must equal the program totals, institution totals and selected revenue accounts. Investigate differences such as deferred delivery, manual adjustments or refunds separately. Revenue leakage in a B2B ledger covers transaction exceptions, while the revenue-driver analysis approach explains the purpose of a bridge that adds up.
Finance owns the reconciliation and fee definitions. Program operations owns delivery records. Account teams confirm contract status and explain changes in customer requirements; none of those explanations should change the recorded total without an approved adjustment.
Bring a sample of your own institution, contract and program revenue exports to Covirage; it maps the columns, and its tools compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.
See Covirage for education providers for the industry context.
Use the operating revenue recorded under the provider's approved accounting policies. Depending on the business, this can include delivered training, content access or institutional service contracts. Separate unrelated income, tax and cash collections so the analysis measures a consistent scope.
They can help, but only when enrollment corresponds to the service unit used in the revenue schedule. Cancellations, refunds, incomplete delivery and fixed-fee contracts can break that relationship. Reconcile a defined delivery measure to recorded revenue before using it as a volume driver.
Track renewal status as supporting context, then compare the recorded revenue associated with the continuing contract. A renewal may change fees, delivery volume or service dates. The signed contract value alone does not show how much revenue belongs in the current period.