Financial planning
A rolling 12-month forecast where 24 cost-centre owners type their numbers into one grid, and the consolidated P&L and cash runway update from the same data.
Built in Trulyp Analytics on Helvara Group forecast (demo data): writeback tables and a Tableau semantic model. Click the screenshot to open it at full size.
The planning problem
A rolling forecast usually travels by email: a spreadsheet per cost centre goes out, comes back in different shapes, and someone in group finance spends days copying numbers into the consolidation. By the time the P&L is ready, the numbers are old.
Here every owner types into the same grid, filtered to their own lines. Saved cells go straight to a database table. Positions, capex projects and cash items have their own pages. The Group P&L page reads the same tables through a Tableau model, so the consolidated view is one click away from the input.
Pick your name and you see only your lines and months, with actuals, budget and prior year next to the editable Forecast column.
A chart next to the grid shows actual months, your forecast and the budget line, and two tiles total what is in view.
Sales and EBIT for 2026 against budget, the FTE plan and the lowest cash balance in the next twelve months, on one page.
A P&L in the IBCS style with subtotals and variance bars, expandable from section to line.
What finance gets
Planning and reporting share one set of tables, so nobody consolidates by hand. In the demo data the Group P&L shows this as soon as the owners are done.
Owners see only their own lines. Actual months are filled from SAP and the budget, the Forecast column is the only thing they type, and every cell is saved as they go.
Positions, start and end months, FTE and salaries feed personnel cost. Capex projects with go-live dates feed depreciation and cash-out. Change a date and the P&L follows.
Sales for 2026 land at CHF 49.9M against a CHF 51.9M budget. EBIT is CHF 4.19M against CHF 4.93M, mostly from the sales shortfall, partly offset by lower cost of sales.
The running cash balance comes from Tableau table calculations on working capital, capex and cash items. The low point, CHF 6.89M in May 2027, is on the page before anyone asks.
Page by page
Four input pages for the owners and one page for group finance. A row of buttons in every header moves between them.
01
Pick your name and the grid shows your P&L lines for the forecast months. Item and month are fixed, actuals and budget are reference columns, and the Forecast column is where you type. Saved cells go straight to the database.
02
Next to the grid, actual months as dark bars, forecast months in teal and the budget as a line. It reads from the grid itself, so it moves as you type.
03
One row per position, with cost centre, job title, status, start and end month, FTE and base salary. Add a row for a new hire, and personnel cost per month follows from FTE, salary, bonus and social security.
04
Capex projects with budget and forecast amounts and go-live months, and the initiatives for the 2027 budget with cost, timing, ROI and payback. Move a go-live date and depreciation and cash-out move with it.
05
Sales and EBIT for 2026 against budget, the FTE change to Sep 2027 and the lowest month-end cash balance in the forecast.
06
Latest estimate, budget and prior year by P&L section, with subtotals for gross profit, EBIT and net result and variance bars against budget. Expand a section to see its lines.
07
Month-end cash as a line and net cash flow as bars. Receivables, inventory and payables come from rolling averages and days ratios, calculated in Tableau and read live.
How it is wired
The input runs on Trulyp writeback tables; the group view reads the same tables through a Tableau model.
One writeback table each for P&L lines, positions, capex, initiatives and cash items. The spreadsheet visuals edit them directly.
Each input page has the same header, owner filters, a grid and a chart or tiles that read from the grid, so owners always see the effect of what they type.
A published Tableau data source relates the tables and calculates personnel cost, depreciation, the latest estimate and the cash flow. Assumptions such as DSO and DIO are lookups on a table, not parameters.
MIN([Opening Cash Sep 2026]) + RUNNING_SUM(ZN([CF Net Cash Flow]))Trulyp reads the Tableau data source as a semantic model, so the Tableau calculations, including table calculations, arrive ready to use.
HTML tiles for the headline numbers, FinanceTables for the P&L, and native charts for sales and cash. Header buttons link every page.
Collect input in Trulyp, model it where you already do, and report it on the same canvas.