Control Sheet - Salaries & Wages

Allowances 

You can select more than one Allowance for a selected person.

This is only available if there is at least one active (non-retired) allowance on that control sheet type.

When an allowance is selected, the weekly rate calculation is updated for that person to include the selected allowance(s).

Budget & Forecasting Enhancements

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

  • One-off Cost
  • Worst
  • Target
  • Best
  • Forecast Final Cost

Worst, Target & Best fields:

  • Time (no. of weeks) (Number)
  • Weekly Cost (Number)
  • Other Items (Number)
  • Total Position: (Time x Weekly Cost) + Other Items (Calculation)

Approve Button (Only can be pressed by Control Sheet Approvers)

  • Copies Final Forecast Cost into Previous Forecast
  • Variance is different between Current and Previous Forecast

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.

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.

Insert Row

To insert a row, Click on the Insert Row button.

This will insert the row after the currently selected row.Â