Skip to main content

Data sources and importing employees from Teamso

How employees and the other Teamso data arrive by themselves in a budget plan that starts with Teamso data, how to switch sources on and off, add planned hires, use suggestions, restore removed employees and import again.

This article explains Data sources, the second step of a budget plan created with Start with Teamso data. As soon as the plan is created, the active employees in Teamso arrive with their salary, organisation, family, incentive, pension, R&D and cost centre data, together with benefits, regular and one-off payments, planned starters and leavers, severance and notice pay, approved forward dated raises, forward dated unpaid leave, exchange rates, legislation and carried over values. On this step you see how many records each source brought, switch sources on and off, add hires that are not in Teamso and change the import settings.

Changes you make here only affect this budget plan; employee data in Teamso does not change.

Before you start

  • You have Workforce Cost Forecast Admin or Workforce Cost Forecast Manager together with the salary viewing permission. Without salary permission the step shows You cannot import from Teamso without salary permission; import from Excel or add employees.

  • The plan was created with Start with Teamso data (Creating a budget plan).

Step by step

See the import result

  1. Open the plan and click Data sources in the step strip. In a new plan the import starts by itself; while it runs the band Your Teamso data is being imported. shows and you can leave the page.

    Data sources step and the import result
  2. When it finishes the band shows how many employees were imported; if some were not, it says they are other people than the imported ones and why (for example Employees imported: 44. Other employees not imported: 44 (no salary record).). Show skipped lists them one by one. In the Data sources card each source (Active employees, Planned starters, Planned leavers, Severance and notice pay, Approved forward dated raises, Benefits, Regular payments and deductions, Forward dated unpaid leave, Exchange rates, Legislation, Carried over values) shows the number of records it brought and the number skipped; the card title shows Last fetched.

  3. Click Details on a source. For Active employees the Import details dialog shows how many employees were added, updated, removed and kept, the skipped employees with their reasons and the benefits that have no budget item. The other sources list the records taken and the records skipped with their reasons (for example advances and net deductions are not added because they do not change the cost, and a leaver without a severance calculation gets no severance pay).

    Import details dialog

In a plan opened from a template (other than Blank plan) payroll is calculated automatically when the import is done; the step first shows Your first report is being prepared. and then the Your Teamso data has arrived, the first report is ready. band; on the same line it gives the total cost and how many employees were imported and skipped, with Details and See report beside it (Create a budget plan). The ⓘ next to the step title opens what the step does and which data comes from Teamso; the dialog also has Open the guide. With the Hiring plan template the Planned starters card is highlighted and open ATS positions come first in the suggestions. If none of the employees is paid in a foreign currency, the Exchange rates card does not show.

If the plan starts in the middle of a year, the cumulative income tax base and the carried over social security base of the last payroll go to the plan's first month. If the last payroll is not the month before the plan, Carried over values come from the {month} payroll. is shown.

Switch sources on and off

  1. If a source should not go into the budget, switch it off on its card. Its records leave the plan and the card shows Off; switch it on again and the records come back from Teamso. The change is applied by an import in the background; the switches wait while it runs. Active employees and Legislation are required and cannot be switched off.

With planned leavers on, the employee's last day is the exit date; an employee who leaves before the plan's first month is not taken into the plan. Severance and notice pay come net in the exit month from the employee's latest severance calculation in Teamso. Forward dated unpaid leave reduces the regular days of its month. Exchange rates start from the company's rate settings, or else the last central bank rate; rates you entered yourself are kept.

You can add employees who are not in Teamso from an Excel file with Add from Excel in the title of the Data sources card (Importing employees into a budget plan from Excel).

Add a planned hire

  1. Click Add planned hire in the title of the Data sources card.

  2. Fill in Position, optionally Branch and Department, Number of people and Start month. Gross salary suggests the average of the employees in the same position, or else the minimum wage; you can change it.

  3. Click Add. As many Planned hire rows as people are added to the budget; no employee is created in Teamso.

    Add planned hire dialog

Suggestions and removed employees

  1. Teamso employees you remove from the plan are not deleted for good. Click Removed from the plan (N).

  2. Click Restore on the employee you want back; the employee returns to the plan. While an employee is out of the plan, their own timesheet, increase and expense rows (including their benefits and payments from Teamso) are not shown in the steps and do not block the readiness check or the calculation; when you restore the employee, these rows come back too.

  3. The Suggestions from Teamso card lists open positions in recruitment and raises awaiting approval; nothing goes into the budget until you add it. Add an open position as a planned hire with Add, add a raise awaiting approval with Choose month and add after choosing the effective month (it enters the Increases step as a row with the Awaiting approval badge), and close a suggestion you do not want with Hide. Undo removes a suggestion you added; Add all adds them all. The card also shows the bonus, premium, overtime, expense and headcount suggestions drawn from your history (Suggestions from Teamso).

    Removed from the plan and suggestions from Teamso
    Removed from the plan dialog

To take later changes in Teamso without losing your own values, see Updating from Teamso.

Change the settings and import again

  1. In the Import settings card choose in Month which month's active employees are imported. With Import a date range on, everyone active at least one day between Start month and End month is imported.

  2. Narrow the import with the Branch, Department and Position filters if you like.

  3. With Add planned raises as increase scenarios on, forward dated salary records and approved salary change requests inside the plan period are kept for increase scenarios. This is the same switch as the Approved forward dated raises source.

  4. Click Import again, or Import and continue to import and go to the next step. Changing the settings and clicking Next imports again as well.

Importing again updates the Teamso values. Values you changed, employees you added and your scenarios are kept; employees no longer in Teamso leave the plan.

Rules and limits

  • A person with Workforce Cost Forecast Manager imports and sees only the employees of the branches they are responsible for.

  • First name, last name, national ID and registry number stay in Teamso; they are not sent to the calculation service.

  • Employees with incentives the budget cannot calculate (such as 7103, 7252, 6486) are calculated without the incentive and their rows show a warning. An employee paid in an unsupported currency is imported, but the report cannot be created until the currency is fixed.

  • Only one import runs at a time in a plan.

  • A manager sees only the records of their branches in Removed from the plan and in the suggestions.

  • Source switches, planned hires and suggestions change the budget; the report needs a new calculation.

Common mistakes and FAQ

  • No active employees in the selected period. No employee was active in Teamso in that month, or the filters left everyone out. Choose another month or a date range; the plan's data does not change.

  • An employee was skipped: see the reason in Details. For No salary record valid for this month check the employee's salary record; for Not included in payroll check the employee's payroll details.

  • An import of this plan is running. Wait until it finishes. Try again when the previous import has finished.

Did this answer your question?