Bio metric Attendance Integration with ERPNext - jigneshpshah/greycube_helpmanual GitHub Wiki

Step 1 : Get Monthly CSV file with the below format from Bio-Metric device

Employee ID, LogDateTime , In/Out

001, 17-08-2018 09:00:05, In

001, 17-08-2018 17:00:05, Out

Step 2: Import the CSV from the device into ERPNext custom doctype EmployeeID Log DateTime Direction (In/Out)

Step 3: Process the imported CSV file and make timesheet enteries against each employee with Necessary fields only

naming_series,company,status,employee,employee_name,start_date,end_date,total_hours

Step 4: Generate Report Showing unprocessed incomplete Timesheets (having single entry In/Out)

Give Option to make default 8 hours entry for those employees for those days

Step 5: Create Salary Structure for each employee and define hourly rate and set salary based on Timesheet

Step 6: Create Payroll Entry for the Employees ( Salary based on Timesheets)

Step 7 : View/Submit the Salary Slip Generated.