Get HR Software

Bio-metric attendance to process payroll - guide me how calculations are made?


I am new to bio -metric attendance system. I need to process payroll. Please find attached and guide me how calculations have been made.
From India, Gurgaon
Attached Files (Download Requires Membership)
File Type: xls Monthly Detailed report Aug-18.xls (1.45 MB, 364 views)

Hi
First you consolidate the Attandance by No of Workings days, Leave and over time using the count if() function and take the details ,then you process the payroll, If you have any clarification on call me.
Regards,
G Prakash
9003009639
From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls Monthly Detailed report Aug-18.xls (1.45 MB, 163 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.


India, Gurgaon
01 September 2018 06.46.47 AM
Views: 1475 Replies: 1 Appreciations: 1
#Over Time
Rule for two off for working 54 hours in a week.
24-12-2022 | India, Pune
Draft Over time policy for workman
30-01-2023 | India, Delhi
Over time work and No pay for that - no one can never leave office before 9 pm
10-02-2023 | India, Mohali




Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.