Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Below gives you the details of how to create a Monthly Rate filter against a placement. 

...

Field NameDescription/Purpose
Applicable When

This field is not mandatory but will help other users to understand the parameters and purpose of the filter.

Original Rate NameThis 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 NameThis 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 DaysEnter 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 DaysIf 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. 

Image RemovedImage Added

The filter have the following properties.

...

Example of Setting up Placement Rates section:
Image Removed
Image Added


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 >Image Removed

Timesheet Rates >
Image Removed

Image Removed

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.
Image Added

Your timesheet rates would look as below.
Image Added


Image Added

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 >
Image Removed

Timesheet Rates >
Image Removed

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. 
Image Added

Your timesheet rates would look as below.
Image Added


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 >
Image Removed

Timesheet Rate>
Image RemovedBill & 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.
Image Added

Your timesheet rates would look as below.
Image Added


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 

Image Added

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 >
Image Removed

Timesheet Rate >
Image Removed

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.
Image Added

Your timesheet rates would look as below.
Image Added


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 > 
Image Removed

Timesheet Rates >
Image Removed

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.
Image Added

Your timesheet rates would look as below.
Image Added