Skip to content

    01Plan. Build the model.Available

    Your financial model. One version of the numbers.

    OnePlan brings your company's financial reality into one model: budget, actuals, forecast, scenarios, consolidation, headcount, close and reporting. You start from your Excel.

    Book a demoOpen the model

    One figure. One source.

    EBITDA · Mar · Actualfx= 197

    197

    Plan
    214
    Variance
    −7.9%

    € thousands

    Version
    Actuals + 3+9 forecast
    Period
    March · closing
    Source
    actuals_march.xlsx · 1,281 valid rows

    Used in

    • March board pack · P&L vs plan
    • Management dashboard · EBITDA
    • Aurora · explanation of the variance

    Sample data

    Sheet 1P&L

    Plan, actuals and forecast. On the same sheet.

    The budget doesn't live in one file and the actuals in another. Every P&L line has its plan, its actuals and its forecast, by entity, department and account, and the forecast starts from the latest actuals.

    P&L 2026 · Consolidated group

    On the sheet: Actuals + 3+9 forecast€ thousands

    On mobile: March and the H1 total.

    Sample model: the group's 2026 P&L, January to June · Actuals + 3+9 forecast
    LineMarActualH1
    Sales1,2307,435
    Procurement−317−1,877
    Gross margin9135,558
    Personnel−150−894
    Other expenses−566−3,384
    EBITDA1971,280
    • Closed period
    • Closing
    • Forecast
    • Changes in the scenario

    Versions

    VersionH1 EBITDA · vs budget
    • Actuals + 3+9 forecastIn progressActuals January to March; forecast from April.1,280−3.0%
    • Budget v3ApprovedThe year's plan, approved with a record.1,320—
    • Scenario · two hires in AprilDraftThe forecast with two new hires in Sales.1,262−4.4%

    Sample data

    Sheet 2Structure

    Every entity and every person, inside the same model.

    The group consolidates from its entities and personnel cost comes from the headcount plan. If a hire changes, the P&L reflects it.

    Consolidation

    Several entities in one model and a consolidated view of the group.

    Sample consolidation: March sales and EBITDA by entity
    EntitySalesEBITDA
    Parent company905142
    Sales subsidiary32555
    Group · consolidated1,230197

    Flows to the P&L

    • P&L · Sales · Mar1,230
    • P&L · EBITDA · Mar197

    Headcount

    The staff plan by department, connected to personnel cost in the P&L.

    Sample headcount plan: people and monthly cost by department in March
    DepartmentPeopleCost / month
    Finance4−22
    Sales9−40
    Operations14−58
    Management3−30
    Total30−150
    Scenario · two hires in Sales from April+2−6

    Flows to the P&L

    • P&L · Personnel · Mar−150
    • Scenario · P&L · Personnel · Apr−156

    Sample data

    Sheet 3Close

    Figures that are validated, approved and closed.

    March's close happens inside the model: actuals come in validated row by row, variances get reviewed, every budget version is approved or returned with its reason, and the period is locked.

    Close · March 2026

    2 of 5 tasks done

    1. 01

      Import March actuals

      Start from your Excel or CSV. Every row is validated before it enters the model.

      actuals_march.xlsx1,284 rows · 1,281 valid · 3 held back with issues

      • Row 214 · account 6290 not mapped
      • Row 877 · date outside the period
      • Row 1,102 · amount is not a number
      Status: Done
    2. 02

      Review the variances

      March EBITDA: 197 against a plan of 214.

      Status: Done
    3. 03

      Approve the budget revision

      Every budget version is approved or returned with its reason, and there is a record of who approved what.

      «The increase in procurement still needs a justification.»

      Finance leadership · Budget v4 · Operations
      Status: Returned
    4. 04

      Close the period

      A closed period isn't touched again: nobody writes to it, Aurora included.

      1. JanClosed
      2. FebClosed
      3. MarClosing
      4. AprOpen
      5. MayOpen
      6. JunOpen
      Status: Pending
    5. 05

      Publish the board pack

      It comes from the same model, with the period's figures already closed.

      Status: Pending

    Task 02 · Aurora, inside the model

    You ask it.

    You

    What explains the 17 of EBITDA missing in March?

    Aurora

    Three P&L lines. Other expenses, in line with plan.

    March EBITDA variance by line
    Sales−10−0.8%
    Procurement−5−1.6%
    Personnel−2−1.4%
    EBITDA−17−7.9%

    Every figure links to its cell. What it can't verify, it flags.

    Meet Aurora

    Sample data

    Sheet 4Reporting

    What management sees comes from the same model.

    The month's board pack, the scenarios compared with plan and the management dashboards read the same figures as finance. Nobody copies them into a presentation.

    OnePlan · Board pack

    Board pack · March 2026

    1. 01Month summarySource: P&L · Mar
    2. 02P&L vs planSource: P&L · Mar · Plan and Actual
    3. 03Scenario · two hires in AprilSource: Versions · Scenario
    4. 04The month's narrativeSource: Aurora · reviewed by you
    PDF · PPTXShareSchedule

    Management dashboard · March

    € thousands

    Sales
    1,230−0.8% vs plan
    EBITDA
    197−7.9% vs plan
    EBITDA margin
    16.0%Plan 17.3%

    Sample data

    • Board packs

      Generate the month's board pack, export it to PDF or PPTX, share it and schedule it.

      Available

    • Compared scenarios

      Compare each scenario with plan on the metrics you have configured.

      Available

    • Management dashboards

      Dashboards on the same model finance uses.

      Available

    • The month's narrative

      Aurora drafts the narrative with cited figures. If a figure doesn't reconcile, the narrative is held back.

      With limits

    Plan.Delegate.Decide.

    Book a demo tailored to your case.

    Book a demoSomething new is coming to OnePlan
    Manifesto
    1. From data
    2. to model
    3. to work
    4. to decision