1. Help Center
  2. Margin (profit/loss)

Setting up costs of your people

A key component to calculating gross margin is having an accurate cost for each person.

Cost information is very sensitive data and will most likely be maintained by your Projectworks administrator in conjunction with HR and Finance.

Projectworks administrators: By default the System Admin access level has access to add/edit costs for all people. The access levels can be amended as needed - use the "more options" area and tick/untick the view costs and edit costs options under Person.


Setting up costs for a person

Costs for each person are set up on their costs screen and can be entered as an hourly figure. There is the option to calculate the hourly rate from an annual figure, which will convert to an hourly cost by dividing the annual amount entered by the number of hours specified on the Financial Year set up.

It is the hourly cost rate that is used through margin reporting.

The costs screen is locked when first accessed and can be unlocked using the toggle at the top right of the table

 

To create a cost, you need to select the cost type (read more about setting up cost types →), currency, relevant dates, how you are entering the cost, and either an hourly cost or annual amount.

Tips

  • Select a date to see what cost applies on that date
  • If the cost is to be ongoing, leave the end date blank. 
  • If the cost for a person changes, set an end date on the previous cost, and create a new cost starting the day after
  • You can set up a future dated costs if required - remember to also set the end date if it is replacing an existing cost
  • Cost types are set up by your administrator in the admin section
  • The reports section includes a People cost report where you can see all the costs that have been entered for all people.

What to do when a cost changes

The cost of people will change over time, either with a change to their pay, or an adjustment to any overheads that are allocated. Changes are handled by either creating a new cost entry, and/or setting an end date to an existing cost entry.

Caution: If the costs associated with a person change they should be updated by adding a new cost record, and setting the end date on the previous version of the cost

Removing a cost

If a cost is no longer applicable it is recommended that it is edited and has an end date set to make it inactive. 

A cost entry can be deleted, but should only be done if the cost entry was an added in error.

Setting up Cost Types

When creating a cost for a person, a cost type must be selected. To ensure that the cost type is included in margin calculations, the cost type must have “This Cost Type is used in the Gross Margin Calculation” selected.

 

A cost type must be active to be applied to a person.

To create or edit a cost types go to Settings > People > Costs.

Activate cost type-gif-1

Cost rate cards for hourly workers

Cost rate cards allow multiple cost cards to be set up for a people who are set up as "Hourly" in their profile.

Create cost rate card-gif

Users who have access to view and edit cost rate cards can create new cost rate cards and edit existing ones.

By default, an hourly person’s costs will be utilised when time is logged. Once a cost rate card is active, if a person has been added to the cost card, the rate card cost can be selected for that person at a Project or Timecode level.

Applying a cost rate card to a Project

The cost of an hourly worker at a project level can be updated in the People Settings of the Project. The hourly person will only have the rate card cost available to them if they have been added to the cost rate card.

Apply cost rate card to project-gif

Users who have access to maintain a project’s settings and can view a project’s cost rate can select the cost of an hourly person 

Time entries logged to that project after updating the hourly person’s cost to a card rate card will use that cost. 

If there are historical hours logged that are utilising the incorrect card rate cost, you can delete and re-enter the time entries.

If there are numerous/ or locked time entries with the incorrect card rate cost associated to them, please contact support.

Applying a cost rate card to a Timecode

The cost of an hourly worker at a timecode level can be updated in the Timecode People & Rates setting. The hourly person will only have the rate card cost available to them for the timecode if they have been added to the cost rate card.

Users who have access to maintain a project’s settings and can view a project’s cost rate can select the cost of an hourly person 

Any new time entries for that timecode logged after updating the hourly person’s timecode settings to a cost rate card will use the new rate.

If historical time entries are using an incorrect cost rate you can delete and re-enter the person’s time entries, or contact support.

Troubleshooting

I can’t calculate an hourly cost

All costs are stored as hourly amounts with the hourly rate used for reporting. The hourly rate can be calculated from an annual amount, where the annual figure will be divided by the number of working hours set on the financial year of the person’s organisation.

  1. The person must have a posting for the date that the cost starts, and

  2. The organisation the person is associated with must have financial year hours for the financial year that the cost starts.

Read more about adding a new posting and setting up a financial year

A person’s annual cost differs to what was entered

If a person’s cost has been entered as an annual amount, this is calculated and saved as an hourly cost.

The hourly cost is calculated by dividing the annual amount entered by the number of hours specified in the Financial Year, and saved to 2 decimal places.

If a person is a salaried/ fixed employee, an annual cost is also displayed on the person > cost screen, calculated by multiplying the saved hourly cost by the number of hours specified in the Financial Year that you are viewing the person’s cost for (displayed to 0 decimal places).