Build Your Board Budget & Track Variance
Set an operating budget, report actuals each period, and let I'mBoard compute budget-vs-actuals variance — no spreadsheets, no manual math.
I'mBoard gives your board three connected financial views: a forward-looking Budget, an actual P&L (profit & loss), and a Budget vs Actuals (BvA) view that explains the gap between the two. Every line item is a real, defined KPI — so subtotals, gross profit, EBITDA, net income, and variance are computed for you. You never type a total, and the board never sees an arithmetic error.
This guide walks the full cycle: build the budget → report actuals → read variance.
Who this is for
This is the CFO / finance lead flow. It replaces the spreadsheet you paste into the board pack as a screenshot. The line items are structured data, so the same numbers feed the board pack, the AI narrative, and next quarter's report — no re-keying.
How the pieces fit
| View | What it holds | When you use it |
|---|---|---|
| Budget | Your forward-looking operating plan, entered month by month across the fiscal year | Once per planning cycle (usually annually) |
| P&L | The actual income statement for a reporting period, line item by line item | Each period, when you close the month/quarter |
| BvA | Budget vs Actual side by side, with variance $, variance %, and a comment per line | Each period, to explain performance to the board |
| Board Summary | The 30-second read: 8 headline metrics, budget vs actual | Top of the board pack |
The Budget and the P&L are entered on different cadences (the plan is annual; actuals are per period). What lets them sit on the same line item is the scenario dimension — every KPI can carry a budget value and an actual value in parallel. The BvA view reads both and does the subtraction.
1. Build the budget
The budget is its own forward-looking report spanning the fiscal year.
- Open the board's Budget and start a new budget for the fiscal year (or open the existing one).
- Enter your plan month by month across the budget grid. Each row is a P&L line item — subscription revenue, cloud/hosting cost, R&D payroll, and so on.
- As you type the line items, the subtotals compute live — Total revenue, Total COGS, Gross profit, each OpEx section total, Total OpEx, EBITDA, and Net income. These rows are read-only: they are derived from the lines above them, never entered by hand.
- Quarterly and full-year (FY) figures roll up automatically from the monthly cells.
Flows vs. balances roll up differently
Revenue and expenses are flows — the FY figure is the sum of the months. Cash balance, headcount, and ARR are point-in-time — the FY figure is the closing (latest) month, not a sum. I'mBoard knows which is which per line, so a year-to-date roll-up is never silently wrong.
There is no formal approval step
The board reviews the Budget view like any other dashboard — there is no separate "approve" button or approval state. You share the Budget with the board, discuss it, and it becomes the reference the BvA view measures against. (Formal budget approval / decision capture is a separate, future capability.)
2. Report actuals each period
When you close a reporting period, its report carries the actual income statement on the P&L dashboard.
- Open the period's report and go to its P&L dashboard.
- Enter the actuals for each line item for that period. As with the budget, the subtotals, gross profit, EBITDA, and net income compute automatically from the lines you enter.
- The line-item structure is identical to the budget, so you are filling the same statement — just the
actualscenario instead of thebudgetscenario.
3. Read budget vs actuals
The BvA dashboard is where the story comes together. It reads the budget (snapshot-copied into the period at report creation) and the period's actuals, and shows, per line:
Line · Budget · Actual · Variance $ · Variance % · Comment
- Variance is computed (
Actual − Budget, and÷ Budgetfor the percentage) — never typed. A missing or zero budget shows a dash, not a divide-by-zero. - Computed rows re-foot live. Subtotals, Gross profit, EBITDA, and Net income recompute independently for the budget and the actual columns, so both sides always tie.
- Large misses require an explanation. When a line's variance exceeds 10%, the row is flagged and a comment is required — so the board never reads a big swing without a one-line driver ("Cloud costs ran 18% over plan — migrated two clusters early").
Flexible vs. Guided entry
The BvA and Board Summary dashboards offer two data paths:
- Flexible — you enter every value directly on the BvA dashboard. Fully standalone; you own every cell.
- Guided — the
actualcells mirror the report's P&L dashboard and thebudgetcells are seeded from the board's latest Budget, so nothing is re-entered. Linked cells render read-only, and variance derives automatically.
Switch the data path with the Flexible ↔ Guided toggle on the dashboard. Guided is the low-effort path once you have a Budget and a P&L in place; Flexible is there when you want to enter a one-off comparison by hand.
Year-to-date and full-year
Beyond the single period, the BvA view can roll each line up to year-to-date and full-year — summing flows, taking the closing value for balances, and recomputing ratios (like gross margin %) at the rolled-up level rather than averaging the monthly percentages.
4. Put the summary on top
The Board Summary block is the 30-second read for the board pack: eight headline metrics — ARR · Total Revenue · Gross Margin % · EBITDA · Monthly Burn · Ending Cash · Runway · Ending Headcount — each shown as Budget · Actual · Variance % · Comment. It reuses the same budget/actual machinery, so it stays consistent with the detailed statements underneath.
What you get
- Zero manual variance math. Every total and every variance is computed from defined KPIs.
- One structure, reused. The same line items carry budget and actual, this period and next — no rebuilding the deck each cycle.
- A defensible board pack. Because each line is a cited KPI, the numbers are structured data the board can trust and the AI can narrate — not a pasted screenshot.
Related
- Create a Report — the report, dashboard, review, and publish workflow this builds on.