Below gives you the details of how to create a Monthly Rate filter against a placement.
...
Field Name | Description/Purpose |
---|---|
Applicable When | This field is not mandatory but will help other users to understand the parameters and purpose of the filter. |
Original Rate Name | This would be the no pay/charge rate (selectable by worker), you must enter the rate name exactly as it appears on the Main tab. |
Monthly Rate Name | This would be the monthly pay/charge rate (not selectable by worker), you must enter the rate name exactly as it appears on the Main tab. |
Minimum Days | Enter the minimum number of days that must be have hours or units entered against on the timesheet for the monthly rate to be paid to the worker. If the days worked is over the minimum days set, the full monthly rate will be paid. |
Pro Rata Days | If the days worked is under the minimum days specified, days worked divided by pro-rata days will be applied. Enter the pro rata days to be applied, this is usually 20 or 21 days for the average number of working days in a month. |
...
You have the ability to create a Pro-Rata filter within the placement. Below we have provided you with formulas and example calculations to help you set up your filters. If you have any further questions our Support Team can help you
Go to Placement - Advanced Tab - Filter - Add a Filter scroll down to Filter and expand by clicking on the plus sign - Select Pro-Rata Filter.
The filter have the following properties.
...
Example of Setting up Placement Rates section:
Pro-Rata Type: All Calendar Days
Formula:
Pro-rata = # of days worked. / # of days in (month/week[for weekly timesheet])
Bill and & Pay = Pro-Rata * Monthly Bill & Pay RatesAdvanced >
Timesheet Rates >
CalculationCalculation Example:
Pro-Rata = 4/7 = > 0.57
Pay Bill Amount = > 0.57 * 22 32 = > 1218.5424
Bill Pay Amount = > 0.57 * 32 = > 18.2412.54
Your filter would be set as this within the Advanced Tab on your placement.
Your timesheet rates would look as below.
Pro-Rata Type: Fixed Number of Days
Formula:
Pro-rata = # of days worked. / Specified number of Days
Bill and Pay = Pro-Rata * Monthly Bill & Pay Rates
Advanced >
Timesheet Rates >
CalculationCalculation Example:
Pro-Rata = 10/19 = > 0.526 = > 0.53
Bill Amount = > 0.53 * 65 = 34.45
Pay Amount = > 0.53 * 55 = 29.15
Your filter would be set as this within the Advanced Tab on your placement.
Your timesheet rates would look as below.
Pro-Rata Type: Fixed Number of Hours
Formula:
Pro-rata = # of days worked. / Specified number of Hours
Bill and Pay = Pro-Rata * Monthly Rates
Advanced >
Timesheet Rate>
Bill & Pay Rates
Calculation Example:
Pro-Rata = 80/100 = > 0.8
Bill Amount = > 0.8 * 65 = > 52
Pay Amount = > 0.8 * 55 = 44
Your filter would be set as this within the Advanced Tab on your placement.
Your timesheet rates would look as below.
Pro-Rata Type: Weekdays Less Public Holidays
You can set your public holidays up within the System Configuration page, click on the system cog and within the general panel you will see Public Holidays. This calendar can then be applied to your placement on the Timesheet Tab
Formula
Pro-rata = # of days worked. / (Number of Working Days in the month – Public Holidays)
Bill and Pay = Pro-Rata * Monthly Bill & Pay Rates
Advanced >
Timesheet Rate >
CalculationCalculation Example:
Public Holidays set for August = 3 days (Set up in Public Holiday section and set on placement)
Pro-Rata = 12/(23-3) =>1212/20 = > 0.6
Bill Amount = > 0.6 * 63 = 37.8
Pay Amount = > 0.6 * 73 = 43.8
Your filter would be set as this within the Advanced Tab on your placement.
Your timesheet rates would look as below.
Pro-Rata Type: Weekdays Including Public Holidays
Formula:
Pro-rata = # of days worked. / (Number of Working Days in the month including Public holidays)
Bill and Pay = Pro-Rata * Monthly Bill & Pay Rates
Advanced >
Timesheet Rates >
CalculationCalculation Example:
Public Holidays set for September= 2 (Set up in Public Holiday section and set on placement)
Total Number of Working Days = 22
Pro-Rata = 13/(22) = > 0.59
Pay Bill Amount = > 0.59 * 53 59 = 3134.2781
Bill Pay Amount = > 0.59 * 59 = 34.8153 = 31.27
Your filter would be set as this within the Advanced Tab on your placement.
Your timesheet rates would look as below.