The workbook contains the payrolls per month. Jan sheet is January payroll, Feb sheet is February payroll and so on. There is a Consol sheet that consolidates (sums) all the monthly payrolls. From the monthly payroll, we prepare individual pay slip (Word) for each employee using mail merge. The This Month is the basic salary, allowances and deductions for the payroll month, say June. The To Date should be the total salaries, allowances and
Deductions of the employee from January to June. The source of the To Date is the Consol sheet
|