Latest release v0.0.0

Budgeting and forecasting on your own data warehouse.

Planners see their actuals and enter their plan in one place. Controllers see where every cost center stands. The approved plan lands next to your warehouse data, ready for reporting. Open source and self-hosted.

  • Self-hosted
  • One container
  • Apache 2.0
The planning sheet: one cost center with accounts down the side, months across and last year's actuals beside each line.

Sound familiar?

  • ?Is planning in your ERP clumsy, expensive to set up, or not possible at all?
  • ?Do you already have your data in a data warehouse or data lake for analytics?
  • ?Is getting budget and plan values into the right place tedious admin work?

Then Planlayer is worth a look.

What it is

A planning tool for the yearly budget and the forecasts in between.

Planlayer reads master data and actuals from your data warehouse, gives each planner their cost centers to plan, takes the plan through approval, and writes the result back next to your warehouse data.

It is built for companies whose actuals already sit in a warehouse, and whose planning still runs on files sent around by email, collected and loaded by hand.

Features

See it in the app.

Planning can get complicated. Planlayer modules guide users through the process and allow for collaborative planning work.

Home

Everything waiting for you on one page: cost centers to approve, investments to confirm, a colleague's position to take over, notes that ask you something. Below it, every open round with its progress.

Who uses it

One round, four roles.

Controllers

Set up the round: what is planned, by whom, in what form, and against which comparisons. They follow progress and publish the result.

Planners

Cost center owners and their deputies plan their own cost centers, with last year's actuals beside each line.

Approvers

Review, send back or approve, from the cost center up through the hierarchy.

HR

Keeps salaries and decides who reads them.

How it fits in

Between your warehouse and your reports.

  1. source

    Your warehouse stays the source.

    For each dataset Planlayer needs (cost centers, accounts, hierarchies, actuals), you give it a query or a view and name the columns. Every sync shows what it will change before it writes anything.

  2. planlayer_app

    Your Postgres holds the plan.

    Planlayer keeps its data in a schema of its own, in a Postgres you already run. There is no separate database server to look after.

  3. planlayer_out

    The result lands next to your data.

    Published plans go to a second schema, as documented fact tables and views. Your reports read them like any other table.

01 Planning

Convenient to plan

A planner opens Planlayer and finds what is waiting for them: their cost centers, the deadline, the notes addressed to them. Each sheet shows one cost center with last year's actuals beside every line, so the plan starts from something real.

Typing a year total is enough. Planlayer spreads it over the months the way the controller set up for that line (evenly, by season, or like last year), and the months always add up to the total. Planners who want to work month by month can. Undo goes back several steps, and if a colleague changed the same cell in the meantime, Planlayer says so instead of overwriting it.

02 Status

Transparent from start to finish

Every cost center has a state: not started, in progress, submitted, approved. The status page rolls those states up the hierarchy, so a controller sees at a glance which division is behind, and a department head sees what is waiting for their approval.

Totals are computed from the lines, never stored on the side, so a roll-up always matches what was planned. Comparison columns show prior years and other versions next to the plan. Notes sit on the line they are about, with mentions and tasks, and stay open until someone resolves them. Every change records who made it, when, and what the value was before.

03 Setup

Set up once, carry it forward

A planning round is a budget, a forecast or a scenario for one fiscal year. The controller decides per account group whether planners type months or a year total, which accounts each cost center sees, and which columns they compare against. A preview beside the settings shows the sheet the planner will get.

The next round starts from the last one: pick what to carry over, optionally with the plan values and an uplift.

Forecasts close the months that are behind you. Those months show actuals and can't be planned; a year total typed in a forecast covers the whole year, and the remainder goes to the open months.

04 Control

Rules that hold

Approvers are assigned on the hierarchy, so a department head sees their area and the CFO sees everything. A cost center goes back to its planner with a comment, or forward with an approval.

Locks and rights live in Postgres itself, through row-level security and triggers. A submitted cost center can't be changed by the app, a script, or someone with a SQL console and the app's credentials.

Modules

Beyond the cost center sheet

Modules are switched on per round, so a company uses what it needs.

Capacity

Plan hours per work center and activity type; hours times rates credit the productive cost center.

Cost forwarding

Pass service costs on to the cost centers that use them, by shares, a fixed amount, or rate times quantity. Both sides see the result on their sheet, exact to the cent.

Workforce

Plan FTE and headcount, or individual positions with entry and leave dates. Positions move between cost centers by proposal and acceptance.

Personnel costs

Salaries, raises, yearly extras and contributions calculated per position and month. Pay stays with HR and the people HR names.

Investments

One list of planned investments across a planner's cost centers, large projects broken into lines, confirmation one by one, and the cash out by period.

Publishing

Preview, then publish

When the plan is ready, the controller previews what will change in the output: rows added, changed and removed, per cost center. The run writes exactly that, or refuses if something changed in between. By default only approved cost centers are published. The same data can be downloaded as CSV or Parquet.

Scope

What it doesn't do

Planlayer plans; it doesn't consolidate. There is no FX translation, intercompany elimination, allocation engine or general formula language, and no balance sheet planning.

Open source

Apache 2.0. One container. Your database.

Planlayer is licensed under Apache 2.0. It runs as one container against Postgres 18 or newer. A DBA creates two schemas and a role with the install script; Planlayer manages its own tables from there.

The project is in active development, and more features are coming. See the backlog for what is planned, and request a feature by opening an issue on GitHub.

# what an installation needs
postgres   ≥ 18
schemas    planlayer_app
           planlayer_out
container  planlayer
license    Apache-2.0