Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • In the financial budget workbook, click the Add button at the bottom of the worksheet, then enter a name for the tab, select the Headcount tab type, and click Add.

    Image Removed
  • Enter a password for the headcount driver (something you will easily remember - see the warning above) and click Unlock.

  • On the Configuration tab, edit

    When you (the budget owner) add the Headcount driver:

    • Two Headcount worksheet tabs are automatically generated for you, Input and Output, and both are blank initially. The Input tab is where you enter the headcount data and Output tab is where all other users view a summary of that data.

    • You are the owner and administrator of Headcount driver, therefore, you are the only user who can access Input tab (until you add other users).

    Note

    To protect the privacy of your employee headcount data, the Headcount driver tab is locked by a password.

    • When you add this driver tab, it is important to use a password that you will remember, as it cannot be recovered or reset if you forget it.

    • In the event you forget your password, you will be locked out of the driver tab and unable to access your headcount data. Contact us to discuss your options.

    • To limit the risk of losing your headcount data, we recommend you add one or more administrators to this tab.

    Tip

    If there is already a Headcount driver tab in the workbook, you might prefer to clone that tab rather than follow the steps below to add a new one from scratch.

    a Headcount tab, its setup screen opens automatically. This is where you select the accounts you want to drive with the headcount data and add benefits and benefit plans that are mapped to those accounts.

    You can edit this setup later, as your needs change. You return to the setup screen in the same way you edit any other tab setup. You can also use the Headcount settings button in the top-right toolbar.

    image-20240514-055409.pngImage Added

    The headcount setup process involves several steps and settings, which are organized into tabs.

    Configuration

    1. Edit the name of the new tab, if required. 

    2. Add other headcount administrators, if required. By default, as you are the headcount owner (creating the tab), you are also a headcount administrator. You can add other administrators to help you manage the workflow on this tab. Ensure the selected administrators have full access to the database on which the budget is based. If you do not see the required user(s) in the list, check they have access to the headcount feature.

      image-20240508-042732.png
    3. Click Next.On the Accounts tab, click

    Accounts

    1. Click the blue Add account button, select .

    2. Select the General Ledger account(s) that you want to drive (such as Salary & Wages and Commission & Bonus), and click out of the box.

      image-20240508-042658.pngImage Removed

      with this Headcount tab. Common accounts include Salaries, Wages, Commissions, Bonuses, and Benefit Plans.

    3. Click out of the account list to apply your selection.

    4. Click Next.

    Benefits

    1. Add benefits, if required (you can do this later), then click Next.

    2. Add benefit plans, if required (you can do this later), then click NextClick the blue Add benefit button.

    3. In the grid, enter a name for the benefit, and a description, if required.

    4. Set up the benefit calculation:

      • Fixed amount per annum: select Fixed amount p/a as the Calculation method and enter that amount in the Calculation box.

      • Percentage of the employee’s remuneration: Select % Remuneration as the Calculation method and enter that percentage value in the Calculation box, then enter the Floor (minimum) and Cap (maximum) values, if required.

    5. Select the General Ledger account applicable to this benefit, such as Employee Benefits. If you do not see the required account in the list, you need to go back to the Accounts tab (click Previous) and add it there.

    6. Clear the FTE checkbox, if applicable. This checkbox is selected by default, indicating that this benefit applies to full-time employees only. Learn more about this setting below.

    7. Repeat the above steps to add more benefits, as required.

    8. Click Next.

    Expand
    titleLearn more about benefits

    New content coming soon.

    You can add the benefits information when you setup the Headcount driver initially, or you can add or edit it later. The process involves three steps: add benefits, add benefit plans and assign benefits to benefit plans. When this information is all setup, you can then select the applicable benefit plan for each employee. The system automatically calculates the employee’s benefit value, along with how much it will 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.

    image-20240514-060531.pngImage Added
    Expand
    titleLearn more about the FTE setting

    The FTE checkbox is used to prorate the benefit for non-FTE employees. For example, if an employee works part-time and is 0.5 FTE in the Headcount worksheet, only 0.5 of the benefit is applied. This setting only applies to fixed amount benefits because the percentage of remuneration benefits already factors this in (the remuneration is at a part-time rate).

    Benefit plans

    1. Click the blue Add benefit plan button.

    2. In the grid, enter a name for the benefit plan.

    3. Click the yellow cell, then select the benefit(s) you want to map to this plan, and click Save. If you do not see the required benefit in the list, you need to go back to the Benefits tab and add it there (click Cancel, then click Previous).

    4. Repeat the above steps to add more benefit plans, as required.

    5. Click Save and finish.

    6. Proceed to add the employee data (see below).

    7. Invite headcount users, if required (you can do this later).

    8. Proceed to add (import) the employee dataEnter a password for the headcount driver (something you will easily remember - see the warning above) and click Unlock.

    Note

    To protect the privacy of your employee headcount data, the Headcount driver tab is locked by a password.

    • When you add this driver tab, it is important to use a password that you will remember, as it cannot be recovered or reset if you forget it.

    • In the event you forget your password, you will be locked out of the driver tab and unable to access your headcount data. Contact us to discuss your options.

    • To limit the risk of losing your headcount data, we recommend you add one or more administrators to this tab.

    Next steps

    After you complete the setup and create a password, two Headcount worksheet tabs, Input, and Output, are automatically generated for you. Both worksheets are blank initially. When employee data is entered on the Input tab, a summary of that data is automatically displayed on the Output tab.

    Proceed as required:

    On this page

    Table of Contents
    2
    minLevel1
    maxLevel3
    outlinefalse
    styledisc
    exclude.*Related articles
    typelist
    printabletrue

    Related pages

    Panel
    bgColor#E3FCEF

    Academy videos

  • Introduction to Headcount driver

  • Create a benefits plan using the Headcount driver