Cloud Payroll - 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?
*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.
2) Fill in the template as in Figure 2.
In my example, Worked Days is 28 days.
3) Import from the time attendance template. Define the Period and Payroll Type, and click on Import Time Attendance > Save (as in Figure 3)
4) Go to Payroll Management > Process payroll > Add New > Detail as in 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.
Prepared by ChenOng 200713, Azirah 200713, P200727
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations