Skip to end of metadata
Go to start of metadata

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




Write a comment…