Employee Master Data Sheet - Xls Download

EMPLOYEE MASTER DATA SHEET
CTC BREAKUP & SETTLEMENT DETAILS
MONTHLY SALARY TRANSFER BREAK-UPS
SALARY STUBS
PF DEDUCTIONS - EMPLOYER
PF CALCULATION
NEW JOINEE DETAILS
RESIGNED EMPLOYEES
RESIGNATION PROCESS
CHALAN DETAILS
PF CHALAN
Form 12 A
Form 5
Form 10
22nd July 2013 From India, Lucknow

Attached Files (Download Requires Membership)

Employees Master Sheet.xls (2.27 MB, 14428 views)

Dear Ritesh
Your work is excellent and over & above thanks for sharing with members
While opening it is warning about a missing link (PF calculation with salary sheet.xls) which is connected with "C:\Rekha Roy".
My concern is that would this missing link create any error in giving the final output (in any manner) when the user using this master data sheet?
Please check about that particular file and its influence in the output from your master data.
With regards,
Suresh
24th July 2013 From India, Pune

Dear Saxena, The excel is excellently linked. good work. do we still need pf challan this way generated?. since now the remittance is online.
24th July 2013 From India, Gurgaon

Well, it was really an interesting and informative sheet for employee data management and can be use a checklist.
However, there are so many advanced HR and Payroll software available that have various module that helps in managing all those with no hassle.
Regards,
Couvery
24th July 2013 From India, Lucknow

Hey Cauvery,
I understand your point, Thanks for comparing it with HRM Software & its subsequent modules. Also I think that this sheet is more likely to be used by the Companies who can't afford a high operating cost software and can easily modify as per their needs and requirements.
Cheers
Ritesh Saxena
24th July 2013 From India, Lucknow