How haideristaken/automated-salary-slips-sheets works
Project Type and Purpose
• This is a macro-enabled Excel application (.xlsm) that automates payroll processing.
• Its purpose is to simplify and streamline salary calculation, attendance tracking, and automatic payslip generation for up to 1,000 employees.
• The design relies on integrated worksheets linked via formulas (VLOOKUP, SUM, IF) and custom VBA code (e.g., converting net salary to words).
Analyzing the File Structure
• The project consists of a single macro-enabled Excel file that contains all the logic and UI.
• The three core logical “modules” (worksheets) are embedded within the workbook:
– Attendance Worksheet: Captures and calculates employee attendance metrics.
– Salary Sheet Worksheet: Computes various salary components including basic salary, HRA, allowances, overtime, deductions, and tax.
– Payslip Generator Worksheet: Dynamically produces individual payslips by referencing data via lookups and VBA.
• Additionally, the use of VBA macros ties these modules together, automating the recalculation and generation process.