Cloud Payroll - How to auto calculate daily rate worker’s salary USING time attendance excel import?

From AutoCount Resource Center
Jump to navigation Jump to search

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.

TA dailyRate 1.png

Figure 1


2) Fill in the template as in Figure 2.

In my example, Worked Days is 28 days.


TA dailyRate 2.png

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)

TA dailyRate 3.png

Figure 3


4) Go to Payroll Management > Process payroll > Add New > Detail as in Figure 4.i

TA dailyRate 4.png

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.

TA dailyRate 5.png

Figure 4.ii



Prepared by ChenOng 200713, Azirah 200713, P200727



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations