Cloud Payroll - How to use the overtime rounding setting in rule maintenance

From AutoCount Resource Center
Revision as of 03:00, 27 June 2023 by Azirah (talk | contribs) (Created page with "'''Question :''' How to use the overtime rounding setting in rule maintenance? 800px <u><b>Answer :</b></u> <br>This function is used to rounding the overtime worked hours. There are three options – No Rounding, Round Up, Round Down, and 5 choices of rounding time: 5 mins, 15 mins, 30 mins, 45 mins and 1 hour.</br> <br><b><i>The Calculation will be:</i></b></br> <br>Total Worked Hours – Shift Working Hours = Overtime Wo...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Question : How to use the overtime rounding setting in rule maintenance?


Answer :


This function is used to rounding the overtime worked hours. There are three options – No Rounding, Round Up, Round Down, and 5 choices of rounding time: 5 mins, 15 mins, 30 mins, 45 mins and 1 hour.


The Calculation will be:

Total Worked Hours – Shift Working Hours = Overtime Worked Hours

Overtime Worked Hours – Excluded Overtime Worked Hours = Acceptable Overtime Worked Hours

Acceptable Overtime Worked Hours will be rounded based on your selection.


For example, the shift-in time set as 10:00 am; the shift-out time at 4:00pm with 1 hour break 1. The shift working hours will be 5 hours


Below scenario is example for calculation for overtime when rounding option is selected.



(a) OT Rounding = Round Up, and OT Rounding Time = 15 mins


Clock in at 10.36 am and clock out at 5.48 pm

Total Worked Hours = 5.48 pm – 10.36 am = 7.2 hours


Overtime Worked Hours = Total Worked Hours – Shift Working Hours

= 7.2 – 5

= 2.2


Excluded Overtime Worked Hours = Before Shift Time + Break 1 Time

= 0+ 1

= 1.0


Acceptable Overtime Worked Hours = 2.2 -1.0

= 1.2

1.2 hours will convert to mins = 1h12m

1h12m round up to 15 mins = 1h15m


Hence in attendance transaction > overtime > actual will show the 1h15m



Explanation in Attendance Transaction > Scenario






Prepared by ChenOng 230609, Azirah 230616, P230626



Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations