Skip to main content

Check and edit employee details and add employees

How to check the imported employees in the table of the Employee details step of Workforce Cost Forecast, change values and revert to the Teamso value, work with the keyboard, paste from Excel, fill and undo, apply a value to many rows, add, copy and…

This article explains how to check, change and add employees in the Employee details step of a budget plan. In a plan that starts with Teamso data, employees, their salaries, family and cost centre details come from Teamso by themselves. Changes here only affect this plan; employee data in Teamso does not change.

The plan's owner, a person the plan is shared with for editing and a person with the Workforce Cost Forecast Admin Permission make changes. A person the plan is shared with for viewing only looks at the table. Rows of employees from Teamso contain salaries, so only a person with the salary viewing permission who is responsible for the employee's branch sees them; other people see how many employees are not shown.

Before you start

Step by step

Look at the table and change values

  1. Open the Employee details step in the step strip. The table groups its columns such as Salary, Employment and Social security and incentives: a thin coloured line on top of each column header marks its group and a line between groups marks where a group starts; the group name shows when you hover the header. The one toolbar row above the table has search and Only my changes on the left and, on the right, the employee count, the Go to column, Manage columns, Views, Download table and Paste from Excel icons, Add employee and Save. Shortcuts and tips are in the window that the ⓘ next to the step title opens; the Employee column and the row actions stay in place while you scroll sideways.

    Employee details table with a changed salary
  2. Type a name or department in the search box. The Only my changes chip shows only the Teamso employees whose values you changed. With Filter in the ⋯ menu of a column header you add a value, range or date filter, and Sort ascending and Sort descending sort the table. Active filters are collected in the Filters and sort chip; Clear all removes them.

  3. Select the cell you want to change and start typing, or double-click the cell (clicking the selected cell again, Enter and F2 also edit). Enter keeps the value and moves to the cell below, Tab moves to the cell on the right, Esc cancels. Numbers use the decimal separator of your interface language and accept "85k"; enter dates as DD.MM.YYYY; pick option values from the list and clear them with the cross. If you clear a value that came from Teamso, the Teamso value comes back.

  4. When you change a value that came from Teamso, a dot appears on the left of the cell and the row's Source badge becomes Changed. Click the dot to see the Teamso value and the Value in this plan; Revert to Teamso value brings the Teamso value back, and Undo in the message undoes that. For all changes of a row use Revert to Teamso value in the row's ⋯ menu; for all changes of a column use Undo changes in this column in the column header's ⋯ menu.

  5. The number of changes is shown next to Save. Save, or Next at the bottom of the page, saves only the changed rows.

The Source column shows where a row comes from: Teamso, Changed, Added manually, Excel or AI suggestion. A person whose start date in Teamso falls in the plan period also gets Planned start, a person whose leaving date falls in the plan period Planned exit. A retiree or an employee with SSI document type 2 gets incentive law 0000 and the cell is locked.

Work with the keyboard, select ranges and fill

  1. Click a cell, or Tab into the table and press an arrow key. The arrow keys, Tab and Shift+Tab move between cells; Ctrl with an arrow key (Cmd on a Mac) jumps to the edge of the table, Home and End to the start and end of the row. A screen reader reads the column, the row and the value of every cell. To select several cells drag with the mouse, click another cell while holding Shift, or use Shift with the arrow keys.

    Selected range, fill handle, undo and column width
  2. Drag the small square in the bottom right corner of the selection (the fill handle) down or up: the values of the selected rows repeat in order. Ctrl+D (Cmd+D on a Mac) copies the first row of the selection to the rows below; with a single row selected the value of the row above comes in. Delete empties the selected cells (a cell from Teamso gets its Teamso value back). Type a value and press Ctrl+Enter to write it to every selected cell with the same rule as applying a value to many rows; in a number column "10%" raises the current value by 10 percent.

  3. The Undo (Ctrl+Z) and Redo (Ctrl+Shift+Z) buttons in the page header undo or redo the last action. Cell edits, pasting, filling, applying a value to many rows, clearing and Revert to Teamso value can be undone. Undo in the message and Ctrl+Z undo the same action; an action is never undone twice. The same buttons also undo changes made in other steps (Version history, undo and comments).

  4. Change a column's width by dragging the right edge of its header; with the edge selected the left and right arrow keys change it too, and a double-click goes back to the first width. Column widths and the sort are kept for you and come back when you open the table again. Ctrl+C copies the selected cells in a form you can paste into Excel.

Name, surname and national ID from Teamso, a locked law number, family and cost centre cells do not change when you fill, clear or paste. With view access you can move around and copy but not change anything.

Paste from Excel

  1. Copy cells in Excel or Google Sheets. In the table select the cell where pasting should start and press Ctrl+V (Cmd+V on a Mac), or use the Paste from Excel icon in the toolbar. The copied block goes to the right of and below the selected cell; if you paste a single value while several cells are selected, the whole selection is filled. In manually added rows a full name pasted into the Employee column is split into name and surname at the last space.

    Paste from Excel preview with an unrecognised cell
  2. The Paste from Excel window says how many rows and columns will be pasted and how many cells were not recognised (for example "3 rows x 2 columns will be pasted, not recognised: 1."). In option columns the spelling is matched to a label ("gross", "Gross", "G", "brüt" and "B" become Gross, "N" becomes Net) and what you typed shows in brackets. Numbers such as "85.000", "85,000.50", "120 bin", "1,2 milyon" and "₺95.000" are read; rate columns accept "3%". Dates can be DD.MM.YYYY, DD/MM/YYYY or YYYY-MM-DD. An unrecognised cell shows in red with not recognised.

  3. Click Paste. Recognised cells go into the table; unrecognised cells do not change and stay marked red in the table (hover to see what you typed). Cells that cannot be changed are skipped and the window says how many; rows that do not fit below the table are not pasted. Save with Save; Ctrl+Z undoes the whole paste.

Apply a value to many rows

  1. Choose Apply to all in the ⋯ menu of a column header. With selected rows the value goes to them, with a filter to the visible rows, otherwise to all rows; the window says how many rows.

  2. Enter the value. In a number column "10%" raises the current value by 10 percent. Clear empties the value.

  3. Click Apply; the changes go into the table and Save stores them.

When you select rows, the N records selected bar appears at the bottom: Apply to all, Revert to Teamso value and Delete work on the selected rows from there.

Add an employee

  1. Click Add employee in the toolbar above the table.

    Add employee window
  2. First name and Last name are required. A National ID must have 11 digits and be valid; it is not sent to the calculation service.

  3. Salary, Salary type, Pay period, Pay currency and Start date are required. The salary must be greater than 0. For a foreign currency the rate comes from the exchange rate assumption in the Parameters step.

  4. With Add spouse enter the spouse's date of birth, gender and whether they are a dependant and working. Add child adds up to 6 children; date of birth, gender and education are required for each child.

    Children and cost centre sections
  5. With Add cost centre enter the cost centres the cost is split over and their percentages. The Total percentage badge turns green at 100; the window does not save while the total is not 100. For a manually added employee to be in the accounting report, type the code of a Teamso cost centre in Code; a manually added employee without a cost centre is left out of the accounting report.

  6. Click Add. The employee is saved to the table at once with the Added manually badge.

To change an existing employee in the same window, choose Edit in the row's ⋯ menu or click the Employee, Spouse and children or Cost centre cell. The name and national ID of an employee from Teamso come from Teamso and cannot be changed here.

Copy and delete

  1. Choose Copy in the row's ⋯ menu and enter the Number of copies (between 1 and 50). Copies have empty first and last names and the source Added manually; they cannot be saved until you fill in the names.

  2. To delete, use Delete (for a Teamso employee Remove from plan) in the row's ⋯ menu, or Delete in the bar for selected rows. An employee added manually, by Excel or from an AI suggestion is deleted for good together with their own timesheet, expense and increase scenarios. An employee from Teamso is not deleted for good; they go to the Removed from plan list in the Data sources step and can be restored there. Their own timesheet, increase and expense rows wait in the meantime: they are not shown in the steps, do not block the calculation and come back with the employee.

Fix errors

  1. When a field is missing or wrong, a band above the table says N required fields are empty in N rows. Fix them to create the report. and the cells are framed in red. Hover over a cell to see what to do.

    Required field errors on copies and the error navigator
  2. Move between the cells with the arrows on the right of the band (the error navigator); the table scrolls to the cell. A hidden column is shown when an error is in it.

  3. While a changed row has an error, Save does not save and the band says Not saved. Fix the marked cells.

Manage columns and download the table

  1. Manage columns opens a panel on the right where columns are listed under their group titles: search columns, switch them on and off, or use Show all and Hide empty. Columns without values show an Empty badge. Your choice is saved for you and applies to every plan. Required columns are not in the list.

  2. Go to column finds a column (the list is split into groups) and scrolls the table to it.

  3. Download table downloads an Excel file with the columns and rows shown on screen. The first sheet has the Source column, the Teamso values sheet lists the Teamso values of the cells you changed.

Result

Saved changes mark the plan as needing recalculation, and the step strip shows the number of employees or errors under Employee details. The report cannot be created while rows have errors.

Common problems

Symptom: The band says Not saved. Fix the marked cells.
​Cause: A row you changed or added has an empty required field or a value that breaks a rule (for example salary 0, an invalid national ID, the same national ID on two rows, cost centres not totalling 100).
​Fix: Go to the cells with the error navigator, correct them as the cell's hint says and save again.

Symptom: The pay currency cell says No USD rate for ....
​Cause: The plan has no rate for the currency of an employee paid in a foreign currency.
​Fix: Enter the exchange rate assumption in the Parameters step (Set legal parameters and exchange rate assumptions in a budget).

Symptom: The incentive law cell is locked.
​Cause: The employee is retired or has SSI document type 2; the law number must be 0000.
​Fix: Change Retired or SSI document type first.

Symptom: A note above the table says N employees are not shown ....
​Cause: These employees come from Teamso and are outside your salary permission or your branches.
​Fix: The rows appear once your permissions change; until then you can work with manually added employees.

Symptom: Paste from Excel says "The browser did not allow reading the clipboard".
​Cause: Your browser does not let the site read the clipboard.
​Solution: Select the starting cell in the table and paste with Ctrl+V (Cmd+V on a Mac); the shortcut needs no permission.

Symptom: Some cells are red after pasting.
​Cause: The text in those cells could not be turned into one of the column's options, a number or a date; the previous value was kept.
​Solution: Hover over the cell to see what you typed, then double-click the cell and pick or type the right value.

Symptom: The Someone else changed this plan. band appears.
​Cause: Someone saved employee details while you were editing.
​Fix: Click Refresh; your unsaved changes stay in this browser as a draft, bring them back with Restore.

Related articles

Did this answer your question?