A3.101 : How to auto calculate daily rate worker’s salary USING time attendance excel import?
Question : How to auto calculate daily-rated employee’s salary USING time attendance Excel import?
Answer :
*Make sure that in the affected employee profile, Wages Type and Basic Rate are properly defined.
1) Go to Payroll > Payroll Management > Time Attendance > Template (to download the template) as in Figure 1.
Figure 1
2) Fill in the template as in Figure 2.
In my example, Worked Days is 28 days.
Figure 2
3) Import from the time attendance template. Define the Period and Payroll Type, and click on Import Time Attendance > Save (as in Figure 3)
Figure 3
4) Go to Payroll Management > Process payroll > Add New > Detail as in Figure 4.i
Figure 4.i
Click on the Basic Salary amount, you can see the Sub Detail as in Figure 4.ii. Salary is auto calculated based on your setting: Daily rate RM 30 and working days 18.
Figure 4.ii
--Source from AutoCount Wiki --
Related Articles
A3.139 : How to auto calculate daily rate worker’s salary WITHOUT USING time attendance excel import?
Question : How to auto calculate daily-rated employee’s salary WITHOUT USING time attendance Excel import? Answer : *First, set calendar for daily rated employee 1) Go to Tools > General Maintenance > Calendar > Add New as in Figure 1. Figure 1 2) ...A3.242 : I have 4 employees on the list of import time attendance Excel but after imported only 2 employees were captured.
Question : I have 4 employees on the list of import time attendance Excel but after imported only 2 employees were captured. Possible Reason : You are using your own Excel file format and the configuration setting was not set correctly. From the ...A3.243 : I have imported 3 employees in Time Attendance excel import and process the payroll. But why the screen is showing 2/3 processsed?
Question : I have imported 3 employees in Time Attendance excel import and process the payroll. But why the screen is showing 2/3 processsed? Possible Reason : Overtime table is not assigned for the 3rd employee in employee maintenance. Answer : 1) ...A3.84 : How to change unpaid leave daily rate formula?
Question : How to change unpaid leave daily rate formula? Effective 01st January 2023, Malaysia government has suggested the formula to calculate employee’s unpaid leave by using All Days in Calendar. You are advised to make the following payroll ...A3.146 : Employee - How to upload employee information using Excel import?
Question : How to upload employee information using Excel import? Answer : 1. Download the employee Excel file template. Go to Tools > Options > Excel Import> Templates > Employee. 2. Fill up the necessary information. Notes:Red shaded header means ...