I use Excel to prepare payroll for my staff. I have 12 workbooks, one for each month. Each workbook has 3 spreadsheets (departments). Each spreadsheet has 4 tables, one below the other depending how many weeks the month has. Each table has headings...
I use Excel to prepare payroll for my staff. I have 12 workbooks, one for each month. Each workbook has 3 spreadsheets (departments). Each spreadsheet has 4 tables, one below the other depending how many weeks the month has. Each table has headings for name of employee, rate, social security... and so forth.
I am looking for a way to compile all these workbooks in a way such that I get a total (cumulative) for the entire year for every employee his/her total gross pay, social securities, and the count (no. of weeks worked) - all this into a single table, preferably new workbook.
If this can be done through Excel or Access, please help me. If not, can someone recommend me a payroll program where I prepare payroll, customize social securities, pay date, deductions, additions, hours/day pay by class and get monthly or annual reports such as I am asking.
I have attached a sample of the workbook.
Attached Files
Payroll.xls (85.5 KB)
Linear Mode
