Platform · platform & data

A budget on the same dimensions as your actuals

Most budget-versus-actual reporting fails for a boring reason: the budget was built at a different granularity than the ledger records. Budgeted by department, actuals coded by account only — so the comparison requires a mapping somebody maintains, and the variance is arguable rather than useful.

Rows
DeliverySalesG&A
New York$412K$286K$104K
Austin$238K$141K$62K
Remote$176K$88K$39K
Every dimension is on the journal line, so any combination is a query rather than a rebuild.
Same dimensions as actualsRolling forecast from real activityVariance to the transaction

What it does

Six things, specifically.

Budget at the ledger’s granularity

Account plus entity, department, location, and project — the same dimensions actuals carry, so comparison needs no mapping and no maintenance.

Distributed input

Department heads enter their own numbers within a scope you set, with a submission deadline and a consolidated view of who has not submitted.

Rolling forecast

Updated from actuals as periods close and from committed cost, contracted revenue, and payroll — rather than being a static annual number nobody revisits by March.

Variance decomposed

Not a percentage. The specific transactions and drivers responsible, ranked by contribution, with timing effects separated from real movement.

Scenarios

A hiring plan, a lost account, a price change, a delayed project — modelled against the real cost base rather than as a percentage haircut on last year.

Headcount-driven planning

Payroll modelled per role and per start date rather than as a monthly total, because for most companies at this size labour is the budget.

The granularity mismatch

A budget built in a spreadsheet by department and a ledger that codes only to account cannot be compared without a mapping. Somebody maintains that mapping, it changes when the organisation does, and the variance report inherits every judgement in it.

The consequence is that budget variance stops being trusted, which means it stops being used, which means the budget becomes an annual ritual rather than a management tool. Fixing it is not a reporting problem — it is capturing dimensions at the transaction so both sides speak the same language.

A budget your actuals cannot be compared to without a mapping is a document, not a control. Most companies discover this in month three and quietly stop looking.

Headcount is the budget

For most service and software businesses between $10M and $150M, labour is the majority of cost, and budgeting it as a monthly total loses the two things that matter: which roles and when they start.

Modelling per role with a start date makes the budget respond correctly to a delayed hire — which is the most common real variance and the one a monthly-total budget handles worst. It also makes the hiring conversation quantitative rather than a negotiation about a lump sum.

Rolling beats annual, if the inputs are real

A rolling forecast is only better than an annual budget if it updates from something real. Ours pulls closed actuals, committed cost from open purchase orders, contracted revenue from agreements, and payroll from the plan — so the forward view moves when the business does rather than when somebody re-forecasts.

Where an input is an assumption rather than a fact, it is labelled as one. A forecast presented as a single confident line hides exactly the information needed to judge it.

Limits

Where this does not help.

Not full FP&A

Driver-based models with complex allocations, workforce planning at scale, and consolidation modelling across dozens of entities belong in a dedicated planning tool. We cover budgeting and rolling forecast for the mid-market.

It cannot fix a budget nobody believed

Variance against a number set to satisfy a board rather than to reflect a plan is arithmetic against a fiction. The analysis will be correct and useless.

Dimensions have to exist

Budgeting by department only works if actuals carry department. Where they do not, the fix is at the point of entry and no budgeting tool substitutes for it.

Questions

What people ask.

Can we keep budgeting in Excel?
Yes, and many customers import from it. What changes is that the import lands at the ledger’s granularity, so comparison needs no mapping.
Do you replace Anaplan or Adaptive?
No. If you run a dedicated planning tool with driver-based models, keep it and we integrate. We cover budgeting and rolling forecast for companies that do not have or need one.
How does headcount planning work?
Per role with a start date, loaded cost, and department — so a delayed hire flows through the forecast correctly rather than needing a manual adjustment.
Can department heads enter their own numbers?
Yes, scoped to their department, with a deadline and a view of who has not submitted. That last part is what makes the cycle finish.
What if our actuals lack dimensions?
Then budget-versus-actual by department is not achievable and we will say so. The fix is capturing dimensions at entry, which is a separate and worthwhile engagement.

Make the variance report usable.

Tell us how you budget today and we will show you what comparable actuals would take.