Page Comparison

While you can manually enter your employee data row by row, it is more efficient to import this data. You can import a file that you exported from your payroll system or use the Phocas template file. Either way, the system Phocas automatically calculates the employee’s total remuneration value and displays it in the Rem. Total column.

Tip
You might want to assign this task to other users in the workflow. See Manage headcount users.

Before you start - things to consider and do

To avoid issues later on, ensure you consider the following points before you start the import process and take any required action:

Ensure the corresponding account codes General Ledger accounts have been added to the headcount driver settingstab setup. If your import file contains account codes accounts that are not in your headcount settingssetup, you will get a message requiring you to validate the account codes, i.e. accounts, which means map them to your headcount account codes (see step 6 below)accounts. If you don’t have any account codes accounts to map to, you'll need to cancel the import, add the account codes in accounts to the headcount settingssetup, and then restart the import.
The employee ID needs to be a unique identifier, such as an employee code. If you curently use a position description as the ID and that description is duplicated, for example, Sales Rep, you need to create a unique ID for each employee instead. To do so, you could concatenate the position and name, or add a sequential number to each position, for example, Sales Rep 1, Sales Rep 2, and so on.
If your organization uses hourly rates, you need to convert them to a salary equivalent because the Headcount driver headcount works on an annual salary basis. You can do this in two ways:
- (Recommended) Before you import the file: In the file, multiply the hourly rate by the hours worked.
- After you import the file: In the Headcount Input tab, enter formulas in the salary cell. You could enter the formula directly, for example “, =1800*25” 25, or include a reference to a cell in the Manual Entry drivertab. The latter option is useful if you have the hourly rate and hours worked for different types of employees in a single place.

Import employee data

Prepare the import file, eitherusing one of these methods:
- Use your own file: Export the file from your payroll system and save it to your computer.
- Use the Phocas template file: On the Headcount Input tab, click the Tab menu and click Import data > I need to download a template. Open the template and enable editing, then enter your employee data and save the file to your computer.
On the Headcount Input tab, import the file using one of these methods:
- Click the Tab menu and click Import data > I have a file, then select the file you want to import.
- Drag and drop the file into the worksheet.
In the Import window, review the imported data that is automatically mapped to the database , and make any required changes, if required, then click Import.
(If you are required to validate items in your import file, select validation required) Select the matching item(s) in your database and click Import. This step is required when an item in your import file, such as a dimension or account code, cannot be automatically mapped to items in your database. In the case of account codesaccounts, refer to the warning message Before you start section above.
Review Click Import. The Headcount Input tab updates with the imported data and calculated totals. You can see a list of your employees, along with information such as which region they belong to, when they started, and their base bonus and commissions.
Review the imported data and calculated totals.
Proceed to enter add additional headcount details (see below).

Add headcount details manually

tip

You might want to assign this task to other users in the workflow.
On the Headcount Input tab, manually add employee lines, if required:
Scroll or edit the details as required. You might need to scroll to the bottom of the grid to find the blank row, then manually enter .
Employees: Enter the data as required. For example,
enter “New Hire”
type New Hire in the Employee column as a placeholder for a new employee that you plan to recruit during the year.
Enter the employment
Employment end dates
, if applicable:
Scroll to the right of the grid, click the
: Click the employee’s Employee End Date cell and select the month they are planning to leave the company.
Select the benefit plans, if applicable:
Benefit plan: Click the employee’s Benefit Plan column and select the applicable benefit plan. The system automatically calculates the employee’s benefit value
, along with how much it will
and its cost over the budget period (taking the employment end date into account) and displays these values in the Benefit and Budget Period Cost columns, respectively.
Edit the
General Ledger account codes that you are driving
, if required (you
: You selected these
codes
accounts during the headcount
driver
setup and they were automatically applied to the employees
). Click
, but you can change them. In the GL Codes column group, click the employee’s Salary, Bonus or Commission column and select the applicable account
code
.
Proceed to adjust the salary, bonus, and commission values (see below).

Adjust the salary, bonus, and commission values

TipYou might want to assign this task to other users in the workflow.

In the Adjusted FTE Remuneration section, you can adjust an employee’s salary, bonus, and commission. The system automatically adjusts the employee’s total remuneration value accordingly and displays the new total in the second Rem. Total column. You can refer to these values in formulas on the Main and other tabs.
For example, if you want to give an employee a 5% pay increase, enter the formula “=Fte_salary1.*05”05.

Update headcount details

Quickly update headcount details using the export-import method. Export the tab, make your changes, save and close the file, and then import the file (using the same steps above). The existing data is overwritten with your changes.

View headcount output

The result of all your work setting up the Headcount driver Input tab is summarized in the Headcount Output tab and reflected in automatically driven budget values in the Main tab. However, you cannot

Image Added

You can't edit the headcount values in either the Main or Output tabs; you need to return to the Headcount driver Input tab to do so. Other users can also view and use headcount output data.

Image Removed

Delete rows

You can delete headcount rows you no longer need, either individually or in bulk.

To delete one row, hover over the row to display the Delete button, then click the button.
To delete multiple rows at once, select the rows you want to delete (they turn blue) and click the Delete button at the top left of the grid.

Delete the Headcount tab

As explained in the View headcount output section above, the headcount rows drive rows in the Main tab, so you end up with child rows in the Main tab under each mapped account.