CFO Boardroom Engine
No company loaded
Saved
UNITS
Company Setup
Configure company profile and time periods before loading data.
Company Profile
Reporting Unit

Numbers stored in full units. This controls display only — switch any time including during a boardroom session.

R 1 234 567 displays as: 1 234 567
Cost Categories
#Category name
Sector Collection Benchmarks EXPERIAN DATA LAYER

Benchmark collection rate per sector. The gap between this and a customer's actual rate is an early-warning signal on the Output screen.

Period Manager

Add periods in chronological order — actuals first, then budget, then forecasts. Actuals default to read-only.

#LabelTypeYearRead-only
Suggested: Two or three actual years (read-only) → current budget → one to three forecasts.
Data Management

Two ways to move data in and out of the model. JSON preserves everything — all settings, scenarios and calculated state — use it as your session backup. Excel is for populating the budget: export a blank template, fill it in Excel, import it back.

JSON — Full Model Backup
Saves all data including scenarios, settings and sector benchmarks. Use before every board session.
Excel — Budget Population
Export a structured workbook, populate it in Excel, import back. Periods must be defined in Setup first.
Reset is permanent. Export a JSON backup first.
Fixed Cost Register
100 cost lines grouped by category. Activate a line to include it in the BEP calculation. Amounts are per-period — select a period above to enter or review figures.
Period
View
Scale active %
Total fixed costs
—
select a period
Active lines
—
of 100 cost lines
Largest single cost
—
—
Categories active
—
of — categories
Activating a line: Toggle a row on to include it in Fixed Costs for the selected period. Enter the amount. The BEP lenses on the Output tab recalculate automatically when you switch to that tab. Inactive rows are stored but excluded from all calculations.
Products & Contribution
Define your products and their C/S ratios. Assign budgeted revenue per period — this weights the contribution margin and feeds directly into all three BEP lenses on the Output tab.
Period
View
Weighted C/S ratio
—
revenue-weighted average
Budget revenue
—
select a period
Best margin product
—
—
Active products
—
in selected period
Product Categories
#Category name
Product categories group your product lines. Examples: Hardware, Software, Services, Maintenance, Consulting. Each product is assigned to one category.
C/S ratio: Enter Selling Price and Variable Cost and the ratio calculates automatically. Or enter the ratio directly if you work from margin percentages. Budget Revenue is the total revenue you expect from this product in the selected period — it weights the C/S ratio. The weighted C/S on the Output tab comes from here.
Branches & Areas
Register every branch and the area it belongs to. The active toggle is the boardroom lever — de-select a branch and its revenue and fixed cost allocation drop out of the BEP calculation instantly.
Period
View
Active branch revenue
—
select a period
Active FC allocation
—
fixed costs in scope
Active branches
—
— inactive
Areas registered
—
covering all branches
Areas & Regions

Areas group branches geographically — provinces, countries, regions or divisions. Each branch is assigned to one area.

#Area / Region name
Branch Register Toggle a branch off to exclude it from BEP calculations for the selected period
# Active Branch name Area Budget revenue FC allocation Contribution
Budget revenue is what this branch is expected to generate in the selected period. FC allocation is the share of fixed costs attributable to this branch — overheads, branch management, occupancy. When a branch is toggled off, both figures are excluded from the BEP calculation on the Output tab. In the Scenarios tab, you will be able to apply these toggles as named what-if scenarios without permanently changing the data.
Customer Register
Two collection rates, side by side. What your ledger says a customer pays — and what Experian's sector benchmark says they should. The gap between those two numbers is the signal the sales budget is hiding.
View
Group by
At-risk threshold % gap
Avg actual collection
—
across active customers
Avg Experian benchmark
—
sector expectation
At-risk customers
—
paying below benchmark
Active customers
—
of — registered
Collection rate actual comes from your debtor ledger — what percentage of invoiced revenue actually arrives as cash. Experian benchmark defaults from the sector but can be overridden per customer. A red gap means this customer is paying materially below what their sector peers pay — a signal the sales budget should not ignore.
Sales Lines
Revenue by customer, product, branch and period. Each line is the atomic unit of the model — this is what the Output tab calculates from. Not the budget assumption. The actual line.
Period
Branch
View
Total revenue
—
all periods
Cash-adjusted revenue
—
after collection rates
Weighted contribution
—
revenue × C/S ratio
Active lines
—
of — total
Quick Add
On Customer Product Branch Period Revenue Qty C/S% Cash-adj
Cash-adjusted revenue applies the customer's actual collection rate to the invoiced revenue — what will realistically arrive as cash. The gap between total revenue and cash-adjusted revenue is the accrual fiction gap. That gap feeds directly into the Divergence panel on the Output tab.
Scenarios
Named what-if overlays on the base data. Nothing is permanently changed — each scenario is a set of instructions applied on top of a base period. Build the scenarios before the meeting. Run them in the room.
Active scenario
🎯
No scenario selected
Click + New scenario to create your first what-if. Give it a name, pick a base period, then apply overrides below.
No scenario selected
Select a scenario in the Scenarios tab
📈
No scenario active
Create a scenario in the Scenarios tab, select a base period and apply any overrides. Then return here to see the three lenses.