Control Sheet - Salaries & Wages

Access Salaries or Wages Control Sheets

1. Navigate to Contract Admin.

2. Control Sheets.

3. Click on Salaries or Wages.

Open

Entering Forecast Information on the Salaries or Wages Control Sheet

1. Enter work area. This can be left blank if not required.

2. Select a name. Once selected the position will auto-populate.

3. If there are positions that have not been allocated to a name as yet, click on position and select the position from the drop down.

4. Choose one or more allowances for the employee if required. If not required leave blank. When an allowance is selected, the weekly rate calculation is updated for that person to include the selected allowance(s).

5. The start date is when the employee is starting on the project and the finish date is for when the employee is expected to finish on the project. Note: each employee may be different.

Open

Insert or Append Row

1. Click on the Insert Row or Append Row button.

• Insert Row will insert a row after the selected row.

• Append Row will add a row to the bottom of the list.

Open

Months and Year Columns

The first month / year column is when the project commenced.

RED indicates that a weekly salary and / or allowances have not been set up for that year (in the example below 2024). Refer here Control Sheets - Salaries and Wages | Salaries Rates

You can click in any month column and row to change the percentage allocation for that employee.

Open

Default Allocations

When set up by your administrator the control sheet will display:

• A Start Date column (Month - Year selection)

• A Finish Date column (Month - Year selection)

• A row for default allocation % (Default 100%)

When both the start and finish dates are entered, the applicable months will be pre-allocated as per the default allocation.

Open

Escalation Rate and Month

Refer here for information regarding escalation rate and month Control Sheets - Escalation Month

Open

Weeks

Refer here for more information regarding weeks calculations Control Sheets - Weeks Calculation

Open

Monthly Forecast

The monthly forecast will auto-populate. Note you must have at least 3 unique employee positions entered in the forecast area in order for the forecast to work.

Open

Cumulative Forecast

The cumulative forecast is the total of the previous forecast amounts including that month.

Open

Total Forecast

The total forecast is the forecast total for the life of the project.

Open

Enter Actuals

1. Manually enter each month the total actual salaries for that month.

2. You can only have one line item in the Actual table.

3. The monthly variance is the forecast minus the actual.

Open

Cumulative Total

The cumulative total is the previous month plus the current month month actuals.

Open

Cumulative Variance

The cumulative variance is the previous months variances plus the current month’s variance.

Open

Budget & Forecasting

Budget Rows

• Original Budget (Number) (Manual Entry only)

• Approved Variations (Number) (Manual Entry only)

• Approved Budget (Calc) (Original Budget + Approved Variations)

• Gain / Loss: Approved Budget - Final Forecast Cost (Calculation)

• Append Delta to Worst, Target and Best labels.

• Update Excel export based on new rows / columns and config settings.

Comment Boxes

On Salaries and Wages Control sheets there are comment boxes for:

• One-off Cost

• Worst

• Target

• Best

• Forecast Final Cost

Worst, Target & Best

• Time (no. of weeks) (Number)

• Weekly Cost (Number)

• Other Items (Number)

• Total Position: (Time x Weekly Cost) + Other Items (Calculation)

Approve Button

(Can only be done by Control Sheet Approvers)

• Copies Final Forecast Cost into Previous Forecast

• Variance is difference between Current and Previous Forecast

Open