Automated Payroll Excel Sheet

I’m looking for a single, self-contained Excel workbook—driven by formulas, VBA and neatly designed sheets—that can run my entire payroll each month. The file must calculate salaries from raw attendance data while letting me set or alter the usual components: basic, HRA, any TA/DA or other allowances, plus statutory items such as PF (percentage of basic), EPF and ESI.

Beyond the core calculation I need the workbook to:
• keep a running employee master (with scope for personal, job and bank details later);
• store attendance and monthly payroll records so I can pull historical reports at any time;
• track loans or advances, let me decide the monthly deduction amount and automatically show the outstanding balance after every pay run;
• generate a clean salary slip that I can print for each employee;
• provide month-wise summary reports on demand.

To protect the data, enable simple “username and password” login before anyone can view or edit the file.
Please deliver a ready-to-use spreadsheet with clear navigation, minimal manual input, and all code unlocked for future tweaks.