Illustrative Example | Fictional Data
Harbor & Pine Insurance Agency (fictional)
Monthly executive financial report · October 2026 · $ thousands unless noted
Prepared in an NJTS reporting format
Fictional data for illustration only
Summary
- Revenue
- $412.6
- Operating profit
- $89.6
- Underlying operating profit
- $79.5
- Operating cash
- $612.4
+$14.6 vs. budget (3.7%)
+$4.6 vs. budget · margin 21.7%
−$5.5 vs. budget, excluding timing items
+$24.3 vs. September · 13-week low point $540
The headline beat is timing, not performance. Operating profit finished $4.6 above budget, but contingent commissions received earlier than planned (+$7.3) and a delayed marketing campaign (+$2.8) account for more than the entire variance. Excluding those items, operating profit was $5.5 below budget, driven by new-business commissions and staff overtime. Year to date, operating profit is $25.9 below budget, and the full-year forecast moves from $938 to $905.
Budget vs. actual: October
| $ thousands | Actual | Budget | Fav / (unfav) |
|---|---|---|---|
| New business commissions | $78.4 | $86.0 | −$7.6 |
| Renewal commissions | $286.9 | $274.0 | +$12.9 |
| Contingent and bonus commissions | $22.3 | $15.0 | +$7.3 |
| Fee income | $25.0 | $23.0 | +$2.0 |
| Total revenue | $412.6 | $398.0 | +$14.6 |
| Producer compensation | $104.1 | $99.5 | −$4.6 |
| Staff compensation and benefits | $158.2 | $152.0 | −$6.2 |
| Technology and agency systems | $18.7 | $19.5 | +$0.8 |
| Occupancy | $21.0 | $21.0 | $0.0 |
| Marketing | $6.2 | $9.0 | +$2.8 |
| Professional fees and other | $14.8 | $12.0 | −$2.8 |
| Total operating expenses | $323.0 | $313.0 | −$10.0 |
| Operating profit | $89.6 | $85.0 | +$4.6 |
| Operating margin | 21.7% | 21.4% |
| $ thousands | Actual | Budget | Fav / (unfav) |
|---|---|---|---|
| Revenue | $3,962.4 | $3,910.0 | +$52.4 |
| Operating profit | $742.1 | $768.0 | −$25.9 |
| Operating margin | 18.7% | 19.6% | |
| Full-year operating profit (forecast vs. budget) | $905 | $938 | −$33 |
Operating margin trend
Margin has trailed budget since July. October's reported margin is flattered by timing; the underlying figure (19.6%) continues the trend.
Why operating profit changed: budget to actual
Revenue drivers. Renewal commissions (+$12.9) reflect rate increases on commercial renewals. New business (−$7.6) is 9% below plan for a third month. Contingent commissions (+$7.3) arrived a quarter earlier than budgeted and will reverse against Q1.
Cost drivers. Staff compensation (−$6.2) is overtime tied to the carrier-statement backlog. Producer compensation (−$4.6) follows a renewal bonus tier. Marketing (+$2.8) is a deferral to November, not a saving. Professional fees (−$2.8) include a one-time system consultant invoice.
Cash and balance-sheet watch items
| $ thousands | Oct. | Sep. | Note |
|---|---|---|---|
| Operating cash | $612.4 | $588.1 | 13-week low of $540 in mid-December (E&O renewal, year-end bonuses) |
| Agency-bill premium receivables over 30 days | $146.2 | $118.5 | Up 23%; two accounts are 61% of balances over 60 days |
| Amounts due to carriers (agency bill) | $1,021.7 | $984.0 | Remittance timing reviewed against collections |
| Direct bill commissions unmatched over 60 days | $38.9 | $52.4 | Down 26% after statement matching |
| Premium trust account | Reconciled | Three documented reconciling items totaling $1.6 | |
Agency-bill receivables aging
Balances over 30 days total $146.2. The concern is not the total but the concentration: two commercial accounts drive most of the older balances while carrier payments on those policies are already due.
Key performance indicators
| Measure | October | Target | September | Comment |
|---|---|---|---|---|
| Revenue growth vs. October 2025 | +11.2% | — | +6.8% | Includes contingent timing; core commissions and fees +8.7% |
| Policy retention (rolling 12 months) | 91.4% | 92.5% | 91.6% | Slipping for a second month; review lost accounts by line |
| New business commissions vs. budget | 91% | 100% | 93% | Third consecutive month below plan |
| Producer compensation / commission revenue | 26.9% | 26.5% | 26.7% | Driven by bonus tier reached on renewals |
| Revenue per FTE (annualized) | $235.8k | $227.4k | $229.1k | 21 FTE; flat headcount |
| Month-end close | 8 days | 6 days | 9 days | Late carrier statements remain the constraint |
| Direct bill commissions unmatched over 60 days | $38.9k | <$25k by Dec. | $52.4k | Down 26% after statement-matching work |
Management observations and next steps
- Treat October's operating-profit beat as timing. Plan Q1 assuming the contingent commissions are already received.
- New business is the main underlying gap. The forecast should reflect the current pipeline rather than the original budget.
- Overtime is a symptom of the statement backlog. Fixing the close calendar may cost less than adding capacity.
- Older agency-bill receivables are concentrated, so targeted follow-up on two accounts addresses most of the exposure.
| Action | Owner (role) | Timing |
|---|---|---|
| Recast the Q4 forecast using the new-business pipeline by producer. | FP&A support with producer leads | Before the next leadership meeting |
| Quantify overtime in accounting and service; compare temporary reconciliation support with a close-calendar change. | Controller and operations manager | November close |
| Follow up on the two commercial agency-bill accounts that make up 61% of balances over 60 days; confirm timing of amounts due to carriers. | Accounting with account managers | Next 10 business days |
| Resolve remaining direct bill commissions unmatched over 60 days. | Accounting | December close |
| Move carrier-statement cut-off in the close calendar to reach a 6-day close. | Controller | Starting with December close |