Skip to main content

Headcount based budget (organisational breakdown and head counts)

How to budget in Workforce Cost Forecast with head counts and a representative salary per branch, department and other breakdowns instead of person by person; the breakdown order rule, value selection, representative salary methods, the group grid, head…

This article explains how to budget with head counts instead of person by person. In a headcount based plan the employees in Teamso are grouped by the breakdown you choose (e.g. branch and department); every group gets a Head count and a Representative salary. The report cost is the payroll calculated for the group's representative person times that month's head count.

Managers and deputy managers open the plan and import the breakdown; anyone who can edit the plan changes the group cells and the representative salary method; viewers only look. The calculation service receives one representative person per group: first name, last name, national id and registry number are never sent, and no personal data is sent however small a group is.

Before you start

Step by step

Open a headcount based plan

  1. Go to Pay and expenses > Workforce Cost Forecast > Budget plans and click New plan (for your first plan click Change settings on the start page). Enter the name and the period.

  2. As Data source choose Headcount based plan. The source cannot change after the plan is created.

    Headcount based plan option of a new plan
  3. Click Start (on the start page Prepare my budget). The plan's 2nd step is called Headcount breakdown. This plan has no Actuals step.

Choose and import the breakdown

  1. Click Headcount breakdown on the step bar.

  2. In Base period choose One month (employees active in that month are grouped) or Date range (employees who worked at least one day in it, at most 12 months), then the month or From and To. For next year's budget the default is the current month. The month fields open under Base period, wide enough to read the full month name.

  3. In Representative salary choose the salary used for every person of a group: Group average (default), Group median, Minimum wage or Manual. A group without salaries starts with the minimum wage.

    Headcount breakdown step
  4. The Available fields card lists the Hierarchical fields (Company, Branch, Department) and the Additional fields (Position, Title, Timesheet type, Cost centre). Add a field to the breakdown with Add or by dragging it onto the Selected breakdown card. The default breakdown is Branch, Department and Position. Title is the occupation of the employee's social security declaration; Cost centre is the employee's cost centre with the largest share.

  5. In Selected breakdown change the order with the up and down arrows or by dragging; remove a field with the cross (or drag it back to Available fields).

  6. The order rule: hierarchical fields go from general to specific (Company, Branch, Department) and additional fields go below the hierarchical ones. When the rule is broken the row turns red, "Hierarchical fields must go from general to specific: Company, Branch, Department. Additional fields go below them." shows and Import and continue stays disabled.

    Red row and message when the breakdown order is wrong
  7. In Value selection the button of every breakdown shows the number of chosen values (e.g. Branch: 2 / 3). Click the button; in the window find values with Search values, and employees of a value you untick are not imported. The number of people in the base period shows next to every value. Select all removes the filter; when every value of a breakdown is chosen no filter applies to it. Click Apply.

    Value selection window
  8. Click Import and continue. The groups are created and the Employee details step opens. When you import again with the same breakdown, the head counts and salaries you changed are kept; groups that no longer exist are removed.

Check and edit the groups

  1. On the Employee details step the Headcount groups card shows every group's breakdown values, Head count, Representative salary and source. The card head shows the number of groups and people. Every group is named by its breakdown values (e.g. Sales / Sales Manager / Full time); an empty breakdown value is left out of the name. The Employee list in increases, timesheets and expenses, the report, the Excel file and the digest show the same name.

  2. Change the representative salary method of all groups with the selection on the top right. If you entered salaries by hand, switching to another method asks for confirmation and the amounts you entered are replaced by the new method's amounts.

    Headcount groups and the head count by month
  3. To change a group's head count click the Head count cell, type the new number and press Enter (0 to 100,000, at most 2 decimals). The change is saved at once and the row gets the Changed badge.

  4. To change a group's salary click the Representative salary cell and type the amount. Groups of people paid net, daily or hourly show this next to the amount; employees with the same breakdown values but a different kind of salary form separate groups.

  5. The undo button (Back to the Teamso value) brings a changed head count or salary back to the value of the base period.

  6. The Head count by month card shows every group's head count month by month and the total, with the people added, the new counts and the percentage increases of the increase scenarios.

Add a head count increase

  1. Click Increases on the step bar. In a headcount plan Headcount is at the top of the Target list and is the default target.

  2. The default Scope is Workplace (the branch in Teamso); choose one or more branches next to it. You can choose another kind of scope if you like.

    Headcount target and Add people in Increases
  3. Keep Headcount as the Target and choose the Start month.

  4. In Increase type choose Add people (a negative value lowers the head count), New count or Percentage increase. With a percentage the head count keeps at most 2 decimals (e.g. 5% on 10 people: 10.5).

  5. Type the value, click Add and then Save. When several increases fit a group in the same month the most specific scope wins; increases of different months apply one after another. The head count never goes below 0 in any month. The line applies to every group of the scope on its own: Add people 6 for nine groups is 54 people in total. Below the add fields and under the value of the line in the table this is written out (e.g. Groups × people per group: 9 × +6 = +54).

Calculation and report

  1. On the Report step click Create report (or Recalculate) (Creating and recalculating the budget report).

  2. Every row of the report is a group; the Headcount column is the group's head count in the month and comes first among the identity columns. Amounts, days and hours are the group's representative person's result times that month's head count; the Salary column is the representative person's salary.

  3. When you click an amount and open How was this number calculated?, the breakdown is shown for one person of the group; the Times the head count section at the bottom gives one person's amount, the other people of the group and the group's amount in the cell.

  4. The Total employees card shows the head count of the busiest month and Total payslips shows people x months. In this mode the Accounting report is disabled and there is no Actuals step.

Result

A headcount plan lets you plan staff costs without a list of people. Employee records in Teamso do not change; the budget writes to its own tables only. For users without salary permission the salary of groups built with the average or median shows as Hidden in the grid and those groups are not shown to them in the report; groups with the minimum wage or an amount entered by hand are visible to everyone.

Common problems

Symptom: Import and continue is disabled and a row is red.
​Cause: The breakdown order breaks the rule (e.g. Department above Branch, or Position above a hierarchical field).
​Fix: Move the red row to the right place with the up or down arrows.

Symptom: "No employees found for the chosen period and values." shows.
​Cause: No employee is active in the base period or the value selection leaves everyone out.
​Fix: Change the base period or choose more values in Value selection.

Symptom: Group average and Group median are missing from Representative salary and some groups show Hidden as salary.
​Cause: You do not have the salary viewing permission.
​Fix: Choose Minimum wage or Manual; amounts you enter are visible to you. Ask a user with the permission for the average.

Symptom: A group's salary shows the minimum wage.
​Cause: The people of the group have no salary in Teamso, or their salary is in a currency the forecast cannot calculate.
​Fix: Enter the salary by hand in the Representative salary cell.

Related articles

Did this answer your question?