KPI summary
Profit and loss Reported
Cash conversion Modelled
KPI detail
| KPI | Actual | vs budget | vs LY | Commentary |
|---|
Sales by product
Revenue bridge: last year to actual
Revenue bridge: budget to actual
Revenue concentration
Sales by customer
Revenue bridge: last year to actual
Revenue bridge: budget to actual
Revenue concentration
Gross profit
Gross profit bridge: last year to actual
Gross profit bridge: budget to actual
Gross margin % trend
Source: management accounts.
EBITDA bridge
EBITDA bridge: last year to actual
EBITDA bridge: budget to actual
EBITDA trend
Source: management accounts.
Cash conversion
Modelled Management metrics, calculated using period end balances rather than average balances. Days use period revenue or COGS and the days in the period. Core NWC is receivables, inventories and payables. oNWC is the rest of working capital, such as prepayments and accruals. Free cash flow is EBITDA less interest, tax, working capital and capex.
Earnings to cash
Working capital days
Free cash flow bridge: EBITDA to free cash flow
Free cash flow bridge: budget to actual
Cash conversion trend
Source: management accounts. Cash flow is modelled.
Working capital KPIs
Free cash flow build
Financials
Scenario modeling
Modelled
Assumptions for the remaining months
Full year view
Risks and opportunities
Full year budget to forecast landing
EBITDA. Risks and opportunities are probability weighted.
Register
Reporting Controls
Data & export
Upload your numbers, then download the management deck
Step 1
Get the template
An Excel workbook with one sheet each for settings, monthly P&L and cash lines, products, customers and commentary. It opens filled with the data now on screen, so overwrite the numbers with yours.
Step 2
Upload your data
Every page and chart updates from the file. Costs go in as positive numbers. Leave months without actuals empty.
Drop the .xlsx here or click to choose
Step 3
Download the deck
A short leadership briefing for year to date up to the month selected in the sidebar. Charts and tables are native and editable.
Upload check
- Showing the built-in sample data. Upload a file to replace it.
Data quality controls
What the deck contains
Operating expenses
Operating expenses bridge: budget to actual
Red is an overspend against budget.
Detail by function and category
Cost efficiency and headcount
Monthly operating expenses by function
Source: management accounts.
Change log
Every commentary edit, grouped by page — most recent first
Edit history
No changes yet. Edit a comment on any page to see the history here.