Ways to work together

Sample deliverable

Monthly executive
financial report.

An illustrative example of the monthly reporting NJTS prepares within Fractional CFO & FP&A and recurring controller engagements: results against budget, what drove the change, cash and balance-sheet watch items, and the decisions that follow.

Illustrative Example | Fictional Data The agency, people, figures, and events below are invented. This is not a client engagement and does not represent actual results.

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

+$14.6 vs. budget (3.7%)

Operating profit
$89.6

+$4.6 vs. budget · margin 21.7%

Underlying operating profit
$79.5

−$5.5 vs. budget, excluding timing items

Operating cash
$612.4

+$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

October revenue, expenses and operating profit, actual versus budget
$ thousandsActualBudgetFav / (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 margin21.7%21.4%
Year to date (10 months)
$ thousandsActualBudgetFav / (unfav)
Revenue$3,962.4$3,910.0+$52.4
Operating profit$742.1$768.0−$25.9
Operating margin18.7%19.6%
Full-year operating profit (forecast vs. budget)$905$938−$33

Operating margin trend

Operating margin, actual versus budget, May to October 2026Actual margin was below budget from May to September. October actual was 21.7% against a budget of 21.4%; excluding timing items the underlying margin was 19.6%.16%18%20%22%MayJunJulAugSepOctActualBudgetOct. underlying 19.6%

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

Operating profit bridge, budget to actual, October 2026Budget operating profit of $85.0 thousand rises to $89.6 thousand. Renewals, contingent commission timing, fees, technology and marketing timing were favorable; new business, producer compensation, staff compensation and professional fees were unfavorable. The vertical axis starts at $70 thousand.$70$80$90$100$85.0Budget−$7.6New business+$12.9Renewals+$7.3Contingent (timing)+$2.0Fees−$4.6Producer comp−$6.2Staff comp+$0.8Technology+$2.8Marketing (timing)−$2.8Prof. fees$89.6Actual$ thousands · axis starts at $70

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

Cash and balance-sheet watch items, October versus September
$ thousandsOct.Sep.Note
Operating cash$612.4$588.113-week low of $540 in mid-December (E&O renewal, year-end bonuses)
Agency-bill premium receivables over 30 days$146.2$118.5Up 23%; two accounts are 61% of balances over 60 days
Amounts due to carriers (agency bill)$1,021.7$984.0Remittance timing reviewed against collections
Direct bill commissions unmatched over 60 days$38.9$52.4Down 26% after statement matching
Premium trust accountReconciledThree documented reconciling items totaling $1.6

Agency-bill receivables aging

Agency-bill premium receivables by age: current $812.4, 31 to 60 days $98.7, 61 to 90 days $31.0, over 90 days $16.5, in thousands of dollarsCurrent$812.431–60 days$98.761–90 days$31.0Over 90 days$16.5

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

Key performance indicators: October results with target and September comparison
MeasureOctoberTargetSeptemberComment
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. budget91%100%93%Third consecutive month below plan
Producer compensation / commission revenue26.9%26.5%26.7%Driven by bonus tier reached on renewals
Revenue per FTE (annualized)$235.8k$227.4k$229.1k21 FTE; flat headcount
Month-end close8 days6 days9 daysLate carrier statements remain the constraint
Direct bill commissions unmatched over 60 days$38.9k<$25k by Dec.$52.4kDown 26% after statement-matching work

Management observations and next steps

  1. Treat October's operating-profit beat as timing. Plan Q1 assuming the contingent commissions are already received.
  2. New business is the main underlying gap. The forecast should reflect the current pipeline rather than the original budget.
  3. Overtime is a symptom of the statement backlog. Fixing the close calendar may cost less than adding capacity.
  4. Older agency-bill receivables are concentrated, so targeted follow-up on two accounts addresses most of the exposure.
Next-step actions with responsible role and timing
ActionOwner (role)Timing
Recast the Q4 forecast using the new-business pipeline by producer.FP&A support with producer leadsBefore the next leadership meeting
Quantify overtime in accounting and service; compare temporary reconciliation support with a close-calendar change.Controller and operations managerNovember 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 managersNext 10 business days
Resolve remaining direct bill commissions unmatched over 60 days.AccountingDecember close
Move carrier-statement cut-off in the close calendar to reach a 6-day close.ControllerStarting with December close

Illustrative Example | Fictional Data. All names, figures, and events are invented to show a reporting format. Not a client engagement, forecast, or representation of results.

Related reading: How to tell whether your insurance agency is actually profitable. Build a report like this for your own forecast with the NJTS planning software.

Start a conversation

Want reporting that explains the numbers?

Monthly reporting like this is built around your business, your chart of accounts, and the decisions in front of you.

Discuss your reporting