Verksamhetskoll Planning · Budget and forecast

Budget and forecast: the tool that keeps the plan alive

Try it yourselfThe demo opens in the budget view, no sign-up needed.

The budget is the plan decided before the period, and it stands still. The forecast is the updated assessment of how the period will actually end. In Verksamhetskoll they sit in the same grid, directly against the books: you choose how far actuals apply, those months are fetched from the books and locked, and the variance shows as soon as the books have been read in.

This page goes through how a budget is built so that it can be kept alive, what a rolling twelve-month forecast requires, and what the AI adviser does with a hire described in a single sentence.

Updated · Written by Cenrotech AB

What is the difference between budget and forecast?

The difference is not academic, it decides what the figures may be used for. The budget is a decision: this is how we think the year will look, and actuals are measured against it. If the budget changes during the year, the yardstick is gone. The forecast is instead an assessment that should change as often as reality does.

Swipe sideways to see the whole table

BudgetForecast
DecidedOnce, before the periodContinuously during the period
ChangedPreferably notEvery time something new is known
Based onPlan and targetsActuals so far plus an assessment for the rest
AnswersWhat we decidedWhere we will land
Used byBoard and owners at follow-upManagement in decisions here and now

A common situation is that the company has a budget but no forecast. The variance is then discovered only at the year-end close. The opposite, a forecast without a budget, means nobody can say whether actuals are good or bad. Both are needed, and they should sit next to each other in the same view.

What is a rolling forecast?

A rolling forecast always looks the same distance ahead, usually twelve months, wherever in the calendar year you are. When March passes, March is locked as actuals, and March of next year is added at the end. The horizon never shrinks.

Without it the company gets the effect that makes planning in November hard: in January you plan twelve months, in November two. The decisions made in the autumn are often the largest, and that is when the basis is at its thinnest.

In Verksamhetskoll you choose a month in Actuals through in the toolbar. The months up to and including it are fetched from the books and locked, and the rest stay as forecast to adjust. Tick Keep the annual total, and the difference between actuals and budget is placed on the open months so that each account's annual total stays. If a quarterly or annual invoice came a month early, or a quarterly invoice is missing, it is moved to the right month. If the horizon is to extend past the year end, you start next year's set of figures with the last twelve months as its basis.

For a year that has begun, the forecast can also start trend-adjusted: the seasonal pattern comes from last year and the level from this year's actuals so far. That gives a starting point to correct, instead of an empty grid to fill.

How the budget is built

A set of figures for the budget is a grid with months in the columns and the business in the rows. The rows have three levels, and you work at the one that suits the question:

  1. 1

    Cost centre or another dimension

    Department, project, property, vehicle or whatever you post on. The dimensions in your books come along automatically, so the budget can be broken down in the same way as the actuals.

  2. 2

    Layout row

    The rows in your own report layout, for example contribution margin per stage in an installation firm or property management result in a property company. The budget then speaks the same language as the reports.

  3. 3

    Individual account

    All the way down to account level when needed, with the option to expand and collapse. The totals add up all the way.

Build with drivers instead of lump sums: quantity times unit price, for example number of employees times average salary or number of vehicles times running cost. If a driver changes, everything that depends on it is recalculated. A selected area can also be adjusted in bulk with a percentage, when a whole cost type is to go up or down.

A set of figures does not have to start empty. The starting point decides the content, and the default is Last 12 months: the level is the sum of the last twelve full months, with the seasonality dampened. Items that come once a quarter, half-year or year, such as contract invoices, are placed in the months they usually come. We chose the method after testing the starting points on the books of just over 100 companies, where it hit the annual total best. The other starting points are previous actuals, actuals plus or minus a percentage, a copy of an existing set of figures, the AI adviser and an empty plan. The content can be previewed before the set of figures is created.

An annual amount is spread over the months with a distribution key: twelve monthly weights that sum to 100 per cent, for example for a business with seasonality. A pattern you have put together can be saved as a new key. If the company has a broken financial year, the budget follows it.

Budget in plain language

Most budget work is about translating decisions into accounts. Someone decides that an electrician is to be hired in August, and then it has to become salary account, employer contributions, company car, fuel, phone and computer, spread over the right months and the right cost centre. That is the translation the AI adviser does.

You write: We are hiring an electrician in August. 45,000 a month, company car and mobile phone. The AI finds the cost centre, chooses the salary account, puts the employer contributions on a row of their own and spreads the costs from August to December. If an amount is missing it asks a question with clickable sums instead of guessing.

The proposals are placed as pending rows. Nothing is saved until you approve, and each approved row gets the AI's rationale as a comment, so that whoever reads the budget half a year later can see why the row exists.

0:00 / 1:53
From the real product, in 6 chapters, with narration. The film is in Swedish. Click the film for sound, or choose a chapter.The fictitious Installation AB in the real product. The set of figures is created, filled and delegated for real during the recording.

When more than one person fills in

The budget process usually breaks down in the collection. The finance function sends out a spreadsheet per department, gets back eleven versions with different structures, and then spends a week putting them together. Next week a correction arrives on one of them.

The alternative is that the frameworks are set centrally and the department heads fill in their own parts directly in the system, in the same structure as everything else. Changes are logged with who and when, can be commented on row by row and undone freely. There is no merging left to do, because everyone has worked in the same set of figures.

Each set of figures has its own permissions: the roles View, Edit and Administer, and whoever is not to see the set of figures does not see it at all. With permissions per area of responsibility, a business unit, a project or whatever the books call it, the department head also sees only their own actuals. Delegation and the roles are included in Planning for organisations.

Budget on a dimension that is missing in the books

Many want to budget per region but post per cost centre. The budget then sits on one row while actuals are spread over some twenty codes, and the comparison does not add up.

Create the dimension in Verksamhetskoll instead. Under Statement layouts you group the codes that exist, for example the cost centres into regions or projects in combination with cost centres into business areas. The new dimension is then available as a row and a filter in the reports and as a level in the budget, as if it were posted. The same cost centre can belong to a region and a department at the same time, because each grouping is its own dimension.

In the budget you put the row on the region, and the forecast reads in actuals from all the cost centres that belong to it. New codes that fall within the group's range follow along without you touching the group.

Your own dimensions are included in Planning for organisations, in the reports and in the budget.

From draft to adopted budget

A set of figures has one of three levels. The level decides who sees it and whether follow-up counts it.

  1. 1

    Private

    Nobody else at your company sees the set of figures. Good for trying out a scenario undisturbed.

  2. 2

    Draft

    The working mode. Authorised users see and edit the set of figures, and Compare and Consolidation include it, but follow-up does not read it until it is published.

  3. 3

    Published

    The set of figures appears in the Health Check, the reports, the AI analysis and the group view. The most recently published one per year, type and area of responsibility is the one that applies.

  • An adopted budget is locked and is then read-only for everyone, until it is unlocked.
  • Every save is stored with time and user. The whole set of figures can be restored to an earlier save, and a cell, row, month or group can be rolled back on its own.
  • Comments are set on cell, row and group, and the comments list gathers all comments in the set of figures.
  • Next year starts with New round, in Planning for organisations: a new set of figures for several companies in one go, with the comments along if you want.

How the forecast is kept alive

A budget that nobody looks at after February has cost more than it gave. What keeps it alive is that the variance is visible without anyone having to produce it.

  • Actuals against budget are ready in the report builder, per account, dimension and period.
  • Actuals are read in up to the month you choose and locked, so that the forecast is calculated on what has actually happened.
  • Comments and a change log mean the figures can be justified afterwards, with undo and redo.
  • The AI adviser has budget variances as one of its ready-made questions, answers with the largest variances per cost centre and account, and you take the answer further with follow-up questions in the same dialogue.
  • The Consolidation and Compare tabs show the whole picture and the difference between versions.

The variance leads on: click the figure in the report and the rows behind it open, and one more click expands the whole journal entry. That path is described on the page about financial follow-up.

When the month has been booked, the forecast explains its own change: the month-end agent shows that the forecast said SEK 1.5 million, now 1.2, and why.

Try it yourself

The budget grid in the demo

The demo opens Planning with fictitious companies. The Budget and forecast tab shows the grid per cost centre, and the button to expand everything takes you down to account level. Changes are saved only in your own browser. In the AI panel there is a prepared example: a salesperson hired from August. The AI asks about the salary, calculates the employer contribution and puts the rows in the grid. Sentences of your own are answered only in the live product.

Try it yourself

The demo opens in Swedish. Switch to English with the SV button at the bottom of the demo's menu.

Excel in both directions

The spreadsheet does not disappear from finance work, and does not need to. What should disappear is that it is the only place where the budget exists.

  • Out: the whole set of figures is written as an Excel file with account, account name, dimensions and one column per month, with the actual period date, plus a total.
  • Back into the same set of figures: change the file and read it in. Rows are matched on account, dimension and sub-account, and a combination that is missing is added as a new row, if the account is in the chart of accounts and the dimensions are part of the set of figures.
  • In as a new set of figures: the file becomes a set of figures of its own, with name, year and type proposed from the file.
  • Single figures: copy in Excel and paste into the grid with Ctrl+V, positionally from the selected cell.
What is read in ends up as unsaved changes. You see what the file changed and can undo it, and new rows are created only when you save.

How to do it in Verksamhetskoll

Budget and forecast is a tab in Verksamhetskoll Planning, built against the same books as the reports. What is budgeted can be followed up directly, without anyone moving figures between systems.

  • Budget grid on three levels: dimension, layout row and account, with expand and bulk adjustment by percentage.
  • Starting points with preview, where Last 12 months is the default, and distribution keys for seasonality.
  • Drivers instead of lump sums, so that a change is recalculated through the whole budget.
  • The AI adviser takes a description in plain language and proposes rows, accounts and months, as pending proposals you approve.
  • Private, draft or published, a lock for the adopted budget and a history that restores an earlier save.
  • Change log, comments on all levels, undo and redo.
  • Actuals up to the month you choose, with Keep the annual total, and a trend-adjusted forecast for a year that has begun.
  • Excel out as the whole set of figures, Excel back into the same set of figures or as a new one, and Ctrl+V straight into the grid.
  • In Planning for organisations: delegation to department heads with roles per set of figures, and your own dimensions that are missing in the books, to follow up and budget on.

Connections exist to Hogia, Fortnox and Spiris, and SIE 4, the Swedish standard format for exporting accounting data, works with any system. Prices and terms are published on the pricing page.

Common questions

Questions that often come up.

What is the difference between budget and forecast?
The budget is the plan decided before the period and it stands still, so that actuals can be measured against it. The forecast is the updated assessment of how the period will actually end, calculated with what has happened so far. The budget is the yardstick, the forecast is the steering instrument.
What is a rolling 12-month forecast?
A rolling twelve-month forecast always looks twelve months ahead, wherever in the calendar year you are. When a month passes it is locked as actuals and a new month is added at the end. The company avoids the usual effect where the planning horizon shrinks to a few weeks in November.
Do we have to build the budget by account, or can it be by department?
Both. The grid has three levels: cost centre or another dimension in the books, layout row according to your own report layout, and individual account. You budget at the level that suits, and the totals add up all the way.
Can department heads fill in their own figures?
Yes. You set the frameworks centrally and let department heads fill in their parts directly in the system, instead of collecting spreadsheets by email. Every change is logged with who and when, and can be commented on and undone. Delegation is included in Planning for organisations.
Is it still possible to work in Excel?
Yes, in both directions. The whole set of figures is written out as an Excel file with accounts, dimensions and one column per month. The file can be edited and read back into the same set of figures: rows are matched on account, dimension and sub-account, and what is missing is added as new rows. Everything ends up as unsaved changes that you review before anything is saved. The file can also become a new set of figures, and single figures are pasted straight into the grid with Ctrl+V.
What does the AI do in the budget work?
The AI adviser takes a description in plain language, for example that an electrician is hired in August with a certain monthly salary, a company car and a mobile phone, and proposes the rows: the right cost centre, the right salary account, employer contributions on a row of their own and the costs spread over the right months. If an amount is missing it asks a question with clickable sums. The proposals sit as pending rows until you approve them, so nothing is saved without you having seen it.

Further reading

See the budget built on your own figures.

Book a walkthrough, and we will go through the budget process as it looks at your company and show how it would work in Verksamhetskoll.

The demo opens in Swedish. Switch to English with the SV button at the bottom of the demo's menu.