Skip to main content

Creating and recalculating the budget report

How to have payroll calculated for every employee and month of a budget plan with Create report, follow the progress, fix employees that could not be calculated and recalculate the report after the plan changes.

This article explains how to create the report of a budget plan. With Create report Teamso calculates payroll for every employee and every month of the plan: gross and net pay, social security and tax deductions, employer shares and the total employee cost. The expenses you entered in the Expenses step are added to the total cost.

The calculation takes from a few seconds to a few minutes; you can leave the page meanwhile. If it takes longer than 30 seconds you get a {plan} budget report is ready notification when it is done.

Before you start

  • A person with the Workforce Cost Forecast Admin Permission or the Workforce Cost Forecast Manager Permission can calculate their own plan, a person the plan is shared with for editing can calculate the shared plan. A person it is shared with for viewing only sees the result.

  • No errors are left in the readiness check (Calculation readiness check). Warnings do not block the calculation.

Step by step

  1. Open the plan and go to the Report step in the step strip.

  2. Click Create report in the middle of the step. While there are errors the button is disabled and the Calculation readiness line at the top of the step says Fix {n} errors first. See the readiness list.

    Create report in the Report step
  3. While the calculation runs, the Your first report is being prepared card (Payroll is being recalculated when you create it again) shows a progress bar and {done} / {total} employees calculated. If you leave the page and come back, the progress continues where it was.

    Calculation progress
  4. When it is done the Budget report is ready message appears and the report opens: Total employees, Total payslips (employees x months), Total gross salary, Total gross benefits, Total employee cost; with expenses also Total expenses and Total cost with expenses. The table, the charts and the Excel file are explained in Reading, filtering and exporting the budget report.

  5. If some employees could not be calculated, a N employees could not be calculated. Totals exclude them. band above the totals lists the reason for each. Edit takes you to that employee's row in the Employee details step. After fixing, create the report again.

    Employees that could not be calculated and the totals
  6. If you change something in the plan after the report was created (an employee, timesheet, expense, increase or parameter), the report is out of date: an Out of date badge appears in the header. When you open the Report step, the Payroll needs recalculation dialog asks once for these changes: Create report recalculates, See last report keeps the old report. After that the step keeps showing the The report is out of date. band; you can click Recalculate in the bar at the bottom of the page at any time.

    Payroll needs recalculation dialog

Rules and limits

  • One calculation runs for a plan at a time. While it runs the button reads Calculating and is disabled; nobody else can calculate the plan then.

  • If nothing changed since the last report, Recalculate does not calculate again: it says No changes, showing the last result and shows the same report. The same data always gives the same result.

  • If the calculation service cannot be reached, a The report could not be created. band appears; your previous report is kept. Click Try again a little later.

  • When the main calculation service cannot be reached, the report may be created with the alternative method. It is used only for studies whose legal parameters equal the values in force and which have no timesheet item entered as a salary multiplier, and it gives the same result. The totals then show the note Calculated with the alternative method. When you recalculate, the main method is tried again.

  • Employees removed from the plan are not calculated. The months between an employee's start and end dates are calculated; in the start and end month pay follows the days worked.

  • If the plan does not start in January, the employee's cumulative tax base of that year, the social security bases carried from earlier months and the minimum wage exemption base come from the last payroll, so tax brackets and exemptions continue correctly during the year.

  • A person with the Workforce Cost Forecast Manager Permission sees only the employees of their branches in the totals (Only the {n} employees you are responsible for are shown; totals follow.). Employees that could not be calculated and that you may not see are listed as An employee you cannot see.

  • The calculation never uses employees' names, national ids or registry numbers; employees are calculated with a row number only. The budget does not change payroll or employee data in Teamso.

  • The last three calculations are kept; older ones are deleted at night.

Common mistakes and FAQ

  • Create report is disabled: The readiness list has at least one error. Open the Readiness list, go to the step with Show and fix it.

  • It says a month could not be calculated: A timesheet item of that month may no longer be usable, or the employee's start and end dates may be the wrong way round in that month. Open the employee with Edit and check the dates, and the items in the Timesheet step.

  • I left the page and do not know whether it finished: Come back to the Report step to see the progress or the result; a calculation longer than 30 seconds also sends a notification.

Related articles

Did this answer your question?