Home/ Services/ Planning & EPM
SERVICE · 01 / PLANNING & EPM

Plans, numbers,
and the why
behind them.

An xP&A practice built around driver-based planning, rolling forecasts, and a close that doesn't take all month — wired into Power BI and Microsoft Fabric so every plan, actual, and forecast lives in one model.

Stack ACTERYS POWER BI FABRIC EXCEL WRITE-BACK
DRIVER TREE · LIVE
WRITE-BACK // APPROVED
FORECAST V12 · ROLLING
DRIVER · TREE
EBITDA$48.2M
REVENUE$214M
COGS$118M
OPEX$48M
UNITS142K
PRICE$1,508
MIX62/38
CHANNEL
REGION
SEGMENT
PLAN · ACTUAL · FORECAST
PLANACTUAL
FCST→
SCENARIOS
BASE+8.2%
UPSIDE+14.1%
DOWNSIDE−3.4%
STRESS−9.8%
VARIANCE · MTD
VS PLAN
+4.2%
WHY NOW · 01

Plans disconnect
from numbers.

Most planning lives in spreadsheets. Most reporting lives in Power BI. Most close lives in the GL. Each cycle, finance reconciles the three by hand — and the explanation usually doesn't make it onto the next page.

{ } /01 · DISCONNECTED

Spreadsheets ≠ reports

The annual plan lives in Excel. Actuals live in Power BI. Forecasts live in someone's email. Reconciling them is a job in itself.

/02 · NO DRIVERS

Numbers without a model

Plans built bottom-up by line item — so when a number moves, no one can say which lever changed. Scenario planning becomes guesswork.

/03 · SLOW CLOSE

Eight-day close, two-day variance

By the time the close is signed, the variance commentary lands a week later. Decisions are already being made on stale numbers.

CAPABILITIES · 02

What we build.

Eight focused capabilities across the planning, forecasting, and close cycle. We sequence them — start with the one that hurts most.

/01 — DRIVER MODEL

Driver-based planning

Top-down driver trees that link revenue, cost, and headcount to the operational levers behind them — built in Acterys with write-back to your governed model.

/02 — BUDGETS

Annual budgets & targets

Bottom-up submission templates, top-down allocation, version control, and a workflow that finance teams actually want to use.

/03 — FORECAST

Rolling forecasts

13-week cash, monthly or quarterly P&L, with predictive models on top — so the forecast updates as actuals land instead of every quarter.

/04 — SCENARIOS

Scenario & sensitivity analysis

Base / upside / downside / stress as first-class objects — each one a real version of the model, not a copy of a copy of a tab.

/05 — CLOSE

Close acceleration

Reconciliation automation, journal review workflow, and a daily close monitor that surfaces blockers before they become Friday-night problems.

/06 — VARIANCE

Variance & commentary

Plan-vs-actual reporting with auto-generated variance bridges and structured commentary capture — so the "why" travels with the number.

/07 — WORKFORCE

Workforce & headcount planning

Position-level planning with comp bands, ramp curves, and approval workflow integrated to your HRIS — not a separate Excel file.

/08 — BOARD PACK

Board & investor reporting

One source for the management deck, board pack, and investor update — built on the same model as the operating dashboards.

THE CYCLE · 03

One model.
Every phase.

Plan, forecast, close, and report should be four views of the same model — not four pipelines stitched together. Here's how we wire it.

One model. PLAN · ACTUAL · FORECAST
/01
Plan

driver-based

/02
Forecast

rolling

/03
Close

accelerated

/04
Report

plan vs actual

/01
Plan — set the targets

Driver-based budget with operational levers, version-controlled, with bottom-up submission and top-down allocation in the same model.

/02
Forecast — adjust as actuals land

Rolling forecast that updates monthly. Predictive baseline + finance overrides. Scenario versions sit beside the base, not on top.

/03
Close — faster, calmer

Reconciliation automation, journal workflow, and a close-day monitor. Variance bridges generated as soon as actuals post.

/04
Report — explain the variance

Plan-vs-actual dashboards with structured commentary. The "why" travels with the number — into the board pack, automatically.

PROCESS · 04

How we engage.

Five phases. One sign-off each. A working planning model in production by the end of week eight.

/01 · DAYS 1–5

Discovery

Calendar audit, current spreadsheets, GL chart, source-of-truth map.

/02 · WEEK 1–2

Driver design

Driver tree co-designed with FP&A. The model your CFO would whiteboard.

/03 · WEEK 3–6

Build

Acterys models, Power BI reports, write-back wired to the governed lakehouse.

/04 · WEEK 6–8

Pilot a cycle

Run one full plan-or-forecast cycle in the new model with finance side-by-side.

/05 · ONGOING

Enable & extend

Train finance owners, document the patterns, hand the model over.

OUTCOMES · 05

What you can expect to change.

Outcomes worth aiming for — what we've seen consistently after a focused planning & EPM engagement. Specifics depend on your starting point; we baseline them in discovery.

One model, three views

Plan, actual, and forecast share a single semantic model. The numbers reconcile because they're literally the same numbers.

FOUNDATION
A faster close

Reconciliations, journal workflow, and a close monitor reliably trim multiple days off a typical month-end.

CLOSE
Forecasts that breathe

Rolling forecasts updated monthly with a predictive baseline and structured override — not the annual budget repeated four times.

FORECAST
Scenarios on demand

Base, upside, downside, and stress as first-class versions. New "what-if"s in minutes, not days.

SCENARIOS
Commentary that travels

The "why" attached to the number — visible in the board pack, the dashboard, and the variance bridge.

EXPLAINABILITY
STARTER ENGAGEMENT

Planning & EPM Foundations.

A six-to-eight-week engagement that lands a driver-based plan, a rolling forecast, and one production variance report on a unified model — piloted through one real cycle.

DiscoveryCalendar · sources · GL audit
Driver treeCo-designed with FP&A
Plan + forecastActerys + write-back
Variance packPlan vs actual + bridges
Cycle pilotOne full cycle, side-by-side
Enablement2 sessions · model docs

Engagements scoped per finance org. Fixed-price options available for foundations work; T&M for build-out and additional cycles.

Scope this for us → Other services
FAQ · 06

Common questions.

The questions we get most often during scoping. If yours isn't here, write to info@arkimetrix.com.

Do we have to leave Excel behind?

No. Our finance clients still live in Excel for input and ad-hoc analysis — Acterys gives them governed write-back from the spreadsheet they already know, into a model the rest of the org reports from. The goal is to keep the Excel comfort and add a real model underneath.

Why Acterys?

It sits natively on top of Power BI and Microsoft Fabric, which is where most of our clients already report. That means write-back, planning, and reporting share one semantic model rather than three. We work with other EPM tools too — Acterys is a default, not a religion.

How is this different from "just better dashboards"?

Dashboards read. Planning writes. The hard part is letting finance teams change numbers — by version, by scenario, by user — and feed those changes back into the same model the rest of the company reads from. That's what we build.

Can you work alongside our internal FP&A team?

Yes — that's the default. We bring the modelling patterns and a senior pair-programmer for your analysts. By the end of the engagement, your team owns the driver tree and the documentation.

How long until we feel a difference?

Usually within the first cycle. The discovery phase alone tends to surface reconciliations that can be retired immediately. The driver tree itself, once stakeholders see it on a wall, often changes the conversation.

NEXT STEP

Make planning
connected.

A 30-minute scoping call. We'll look at your calendar, your top three reconciliations, and the question your CFO keeps asking. We'll tell you whether we're a fit — and what we'd do first.

info@arkimetrix.com → Schedule a 30-min intro
Practice leadPlanning & EPM
Typical engagement6 — 8 weeks · foundations
CoverageActerys · Power BI · Excel write-back
What you keepDriver model · plans · forecasts