Page Comparison

When you add the Headcount driver, two worksheet tabs are automatically generated for you, Input and Output, and both are blank initially.

...

1. Click the blue plus button next to the Main tab, enter a name for the tab, select the Headcount driver type, then click Add.

2. Enter a password for the driver tab (something you will easily remember - see warning above) and click Save.

3. In the Drivers screen window that displays, click the blue plus button and select the General Ledger account(s) to use for the drivers, for example Salary & Wages.

4. Invite an administrator, if required (you can do this later when you add other users). See Manage Headcount driver users

5. Add benefits and benefit plans, if required (you can do this later). See Manage Headcount driver benefits

6. Click Save and close.

   

7. Proceed to add an administrator, if required, then add the employee data (see below).

...

1. Click the Input tab to open the worksheet.

2. Prepare the import file, either:

   • Use your own file: Download Export the file from your payroll system and save it to your computer.

   • Use the Phocas template file: Click the Import button and select I need to download a template, enter your employee data in the template, then save the file to your computecomputer.

3. Import the file using one of these methods:

   • Click the Import button and select I have a file, then select the file you want to import.

   • Drag and drop the file into the worksheet.

4. 

   In the Import window, map the items that are in your import file to the items that are in the Input tab, then click Import.

5. 

   If required, validate the items, for example if the naming conventions are different, then click Import again.

6. Review the imported data to ensure it imported as expectedand 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.

7. Proceed to enter additional headcount details (see below).

...

1. Manually add employee lines, if required:
   Scroll to the bottom of the grid to the blank row, then enter the data as required. For example, enter “New Hire” in the Employee column as a placeholders for new employees you plan to recruit during the year.

2. Enter employment end dates, if applicable:
   Click the employee’s Employee End Date cell and select the month they are planning to leave the company.

3. Select the benefit plans, if applicable. See Manage Headcount driver benefits

4. Edit the General Ledger codes (drivers), if required. See Manage Headcount driver account codes

5. Proceed to adjust the salary, bonus and commission values (see below).

...

In the Adjusted FTE Remuneration section, you can make adjustments to 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 tab and other tabs.

For example, if you want to give an employee a 5% pay increase, enter the formula “=Fte_salary*1.05”. See Formulas in the worksheet

...

When the headcount data entry is complete, you can proceed to see the headcount driver in action and use the headcount driver to populate budget values. See Overview of the Headcount driver https://helpphocassoftware.atlassian.net/wiki/spaces/~6227f48cb7e7c700715a0c74/pages/2752676420/View+and+use+the+headcount+driver+output.

\uD83D\uDCCB Related articles