This article explains how to compare a budget study with the real payrolls closed in Teamso. The Actuals step puts the budgeted amounts next to the amounts of the payrolls closed for the same months: budgeted, actual and deviation for gross salary, benefits and employee cost; monthly charts; a table by employee and an Excel file.
The actual amounts come from Teamso's closed payrolls and equal the payroll Cost Report. The comparison writes nothing to the payroll and never recalculates it.
Before you start
The study comes from Teamso. Studies from Excel or headcount have no Actuals step.
The report of the budget you compare with was created at least once. Without it the step says Create the budget report first to compare it with the actuals.; use Go to the report (Creating and recalculating the budget report).
The payroll of at least one month of the study is closed in Teamso. If none is, the step says something like Starts when the January 2027 payroll closes; data of another year is never shown.
Amounts of employees from Teamso need the salary viewing permission; a person with Workforce Cost Forecast Manager sees only the employees of the branches they are responsible for.
Step by step
Open the study and go to the Actuals step in the step strip (the Actuals analysis button of the Report step takes you there too). The first time, the comparison is made automatically.
Check Budget compared with. By default it is the company's approved budget of the year ((approved budget)); without one, or if you may not open it, it is the study itself ((this study)). You can switch between the two.
Choose the Start period and the End period. By default the period runs from the first month of the study to the last closed payroll month, shown under the field as Last closed payroll month. Compare reads the closed payrolls again.
Read the cards. Periods shows the Budget end period and the Last actual period. The Gross salary, Benefits and Employee cost cards show Budgeted (the compared months), Total budgeted (every month of the budget) and Actual, with the deviation amount and rate below. A deviation above the budget is red, below the budget green.
The Budget and actual chart shows the monthly budgeted (dashed) and actual (solid) cost and earnings; Cumulative deviation shows how the cost deviation adds up month by month.
The Planned and actual head count card shows how many planned hires of the compared budget took place, the Raises card how much of the budget the compensation plans linked to it use in Compensation (Hiring requests, raise targets and tracking from the approved budget).
In the By employee table every employee has two rows: Budgeted and Actual in the Comparison type column. The columns are the compared months, then Total, Deviation and Deviation (%).
With Amount shown choose the amount of the months: Employee cost, Gross salary, Benefits, Total gross earnings, Net pay.
Filter with the tabs In budget and payroll, Only in budget, Only in payroll. An employee in the budget without a payroll has the badge Not hired (a planned hire or a row added by hand) or No payroll (a Teamso employee); an employee in the payroll but not in the budget has Unbudgeted hire.
Search by employee name; sort with Sort or the Employee, Deviation and Deviation (%) headers.
Download Excel gives a file with three sheets: Summary (the budget and period, the cards, monthly totals and the cumulative deviation), Comparison (employee x month, a Budgeted and an Actual row for every month) and Deviation (budgeted, actual, deviation and rate per employee). With a search or a tab chosen, the file holds only the matching employees.
Actuals summary makes the executive summary PDF of this comparison: comparison summary, deviation tables, monthly trend, social security and tax burden and the top 5 deviating employees (Budget and actuals executive summary PDF).
To explore the comparison with your own pivot tables, press Design report on the table's card: the rows are employee months, the values hold the budgeted, actual and deviation amounts (Building pivot tables and saving layouts with Design report).
Rules and limits
Actual amounts come from the last successfully calculated payrolls of closed payroll periods: total gross earnings, net pay, SSI and unemployment shares, income and stamp tax, total employer cost. They equal the payroll Cost Report to the kuruş. Gross salary is the gross of the worked and paid days (leave and holidays included); the rest of the gross earnings are benefits.
Budget and payroll employees are matched by the Teamso person. If the budget's import had branch, department or position filters, only payroll employees within them are shown among those without a budget row.
When a payroll period closes, the actuals of the studies covering that month are updated automatically. If the end period was the last closed month, the new month is added; an end you chose is kept.
If a payroll period is closed or reopened after the comparison, the Payroll periods changed band appears; update with Compare again.
You see only the employees you are allowed to see; under the cards it says Only the N employees you are allowed to see are shown; the totals are theirs too.
The comparison is not an input of the budget: it works on an approved or pending budget too and never changes the budget.
With Keep up to date with actuals on, the step also has the rolling forecast card: closed months are fixed with actuals in the study, the chart shows the remaining months forecast as a dashed line, and the Year-end forecast and Deviation alert cards appear (Rolling forecast and deviation alerts).
Common mistakes and FAQ
The step only says "starts when the payroll closes": The study belongs to a later year and no payroll of that year is closed yet. The comparison starts by itself when the first one closes.
An actual amount differs from the payroll report: The payroll may have been recalculated after the comparison. Read it again with Compare.
An employee shows as "Not hired" and as "Unbudgeted hire": The planned hire row of the budget is not linked to a Teamso person; once the person is hired, their payroll shows on its own row.
There is no approved budget option: The company has no approved budget for this year, or you may not open it (Send a budget for approval and the approved budget).



