Timesheet Rules affect how Ascora automatically calculates time and a half or double time penalty rates. Timesheet Rules ONLY apply to Timesheets created from mobile apps.
1. To enable Timesheet Rules, go to Administration → Timesheet Rules.
2. Tick the box beside “Allow Ascora to adjust entered Times based on specified Timesheet Rules.”
Rates that can be applied through Timesheets
There are four rates than can be applied through timesheet rules:
- 1x (Normal – by default)
- 5x (Time and a Half)
- 2x (Double Time)
- 5x (Double Time and a Half).
If Timesheet Rules have not been configured or a Timesheet does not match configured criteria, it will remain as Normal rate (or the rate specified on the created Timesheet).
For each day, there are three different rules that can be applied:
- Before Specified Time (Only applies to 1.5x rate)
- After Specified Hours
- After Specified Time
A combination of After Specified Hours and After Specified Time can be applied, however, the earliest Rule to be applied will override the other.
For example, if a Timesheet for 7:00AM – 12:00PM was processed with the 1.5x After Specified Hours setting of 4 and the 1.5x After Specified Time setting of 8:00AM, the result would be a timesheet for 7:00AM – 8:00AM at Normal rate and a timesheet for 8:00 AM – 12:00PM at 1.5x rate.
INPUT | OUTPUT | ||||||||||
Timesheet 1 (5 hours) | Timesheet 1 (1 hour) | Timesheet 2 (4 hours) | |||||||||
Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break |
07:00 AM | 12:00 PM | 1x | N/A | 07:00 AM | 08:00 AM | 1x | N/A | 08:00 AM | 12:00 PM | 1.5x | N/A |
Additionally, if two rates overlap, the higher rate will be applied.
For example, if a Timesheet for 7:00AM – 12:00PM was processed with the 1.5x After Specified Hours setting of 4 and the 2x After Specified Hours setting of 2, the result would be a timesheet for 7:00AM – 9:00AM at Normal rate and a timesheet for 9:00 AM – 12:00PM at 2x rate.
INPUT | OUTPUT | ||||||||||
Timesheet 1 (5 hours) | Timesheet 1 (2 hours) | Timesheet 2 (3 hours) | |||||||||
Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break |
07:00 AM | 12:00 PM | 1x | N/A | 07:00 AM | 09:00 AM | 1x | N/A | 09:00 AM | 12:00 PM | 2x | N/A |
For timesheets that go over a day, only the Timesheet Rules for the day the timesheet started on will be applied.
INPUT | OUTPUT | ||||||||||
Timesheet 1 (5 hours) | Timesheet 1 (2 hours) | Timesheet 2 (3 hours) | |||||||||
Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break |
11:00 PM | 04:00 AM | 1x | N/A | 11:00 PM | 01:00 AM | 1x | N/A | 01:00 AM | 04:00 AM | 1.5x | N/A |
Meal Break
When the processed timesheet has a meal break applied, the meal break will be listed against the normal timesheet.
INPUT | OUTPUT | ||||||||||
Timesheet 1 (7.5 hours) | Timesheet 1 (4 hours) | Timesheet 2 (3.5 hours) | |||||||||
Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break | Start Time | End Time | Rate | Meal Break |
08:00 AM | 04:00 PM | 1x | 0.5 hr | 08:00 AM | 12:30 PM | 1x | 0.5hr | 12:30 PM | 04:00 PM | 1.5x | N/A |
Timesheet added in iOS App and showing in Ascora Web with Timesheet Rules enabled
1. The following image is an example of timesheet hours added in iOS App total of 11.5 hours and shown in Ascora web as Normal, Time and a Half, and Double time as per Timesheet Rules applied.
2. After timesheet rules are applied automatically, the updated timesheet calculation will be synched down to the iOS App to reflect the exact breakdown shown in web such as how much hours is general, Time and a Half, and Double Time.
Note: Android app does exactly the same process wherein timesheet hours are pushed to web after completing a sync, then timesheet rules are applied which recalculates the details and then sync down to the app for consistency.
Refer to the image below showing timesheets created in iOS and Android app
1. Timesheet Hours added on the app
2. Timesheet Hours recalculated in web with timesheet rules applied
3. Recalculated hours are pushed down to the app for consistency
To access a quick tutorial about Timesheet Rules you can click the link below:
https://www.ascora.com.au/Portal/TrainingVideos/VideoViewer/Admin-Accounting-TimesheetRules
Related articles
Add Comment