This guide will assist you in calculating an employee's daily rate salary using excel import.
Note: Ensure that the Wage Type is set to ‘Daily’ and the Basic Rate is properly defined in the employee’s profile.
To calculate an employee's daily rate salary using excel import, click on Payroll > Time Attendance Import under Payroll Management.
Click on Template to download the excel template format.
Open the excel template and maintain the necessary information such as Employee Code, Worked Days, Working Days, & etc and save the file to reimport later on
Head back to AutoCount HRMS Time Attendance Import and click on Import.
Select the desired Period and Payroll Type to import the Time Attendance excel template.
Select the Time Attendance Excel template and import.
Save the time attendance import.
Go to Payroll > Process Payroll under Payroll Management.
Select New Payroll Process to create a new payroll process.
Select the Payroll Type, Payroll Period, & select the employee. Ensure these details matches the details that you have selected during importing the time attendance.
You will be directed to the Payroll Preview page, click on Process to proceed to the next page.
The payroll process will be created, the basic will be calculated based on the number of days worked multiply by the daily rate. Click on it to break down the details.
END OF GUIDE