Blog · MarginOct 27, 2026 · 5 min read

Why did margin move? Stop rebuilding the answer by hand

Most firms explain margin changes in a spreadsheet each month. KPilot breaks the change down by driver every day.

The question every partner asks after a month closes is not “what is our margin” but “why did it change”. Most firms answer it by hand. In October 2026, Teamwork.com published a five-lever method for it: on an $80,000 fixed-fee project quoted at 45% margin, $36,000 became $22,900 once leakage, staffing mix, extra effort and unbilled scope were counted. The method works, but it is manual and covers one closed project at a time.

A bridge, every day, for the whole firm

KPilot keeps a version of the P&L every night and lets you save your own, such as the budget. Pick any two and the bridge splits the move into drivers: team and staffing, deals, planned invoicing, late invoicing, budgets and actuals. The tiles add up exactly to the change, so nothing hides in an “other” line you cannot explain.

P&LLive
Mesabrook Advisory LLCInvoicedCompared with
Full-year operating margin14.1%against 14.2% on Yesterday−0.1 pts
Where the move comes from
Team and staffing−$4,800
Late invoicing−$2,400
Actuals+$600
Change in operating income−$6,600
Full-year operating margin14.1%against 15.6% on Oct 31−1.5 pts
Where the move comes from
Team and staffing−$61,400
Deals+$38,500
Planned invoicing−$47,600
Late invoicing−$31,200
Budgets+$18,600
Actuals−$34,900
Change in operating income−$118,000
Full-year operating margin14.1%against 17.5% on Budget, saved Jan 5−3.4 pts
Where the move comes from
Team and staffing−$142,000
Deals+$64,000
Planned invoicing−$88,500
Late invoicing−$52,300
Budgets+$31,500
Actuals−$80,000
Change in operating income−$267,300
Pick a version: the bridge splits the move by driver, and the tiles add up exactly to the change.

What it reads like

At Mesabrook, operating margin is 1.5 points lower than at the end of October. Team and staffing account for −$61,400, mostly the extra days on Lone Star. Deals add $38,500. Planned invoicing that slipped costs −$47,600, and invoices issued late another −$31,200. Each tile opens the records behind it, and the trail says who changed what, and when.

From explanation to action

An explanation is most useful when it leads to an action. The slipped invoices are already in Margin Guard’s ledger, and the Lone Star overrun comes with a drafted change order. Instead of rebuilding the story each month, the team gets a list of actions for the week.

By the KPilot team

See it on your own data.

Start the 14-day trial, or book a demo.