Kithsiri D

Excel & VBA Payroll

KLC • Freelance

Dec 2021 - Present • 4 yrs 5 mos

An Excel VBA Salary Calculation System is an automated payroll tool developed using Microsoft Excel and Visual Basic for Applications (VBA) to efficiently calculate employee salaries. The system simplifies payroll management by automatically computing salaries based on predefined rules and employee data. Key Features 1. Employee Data Management Store employee details such as: Employee ID Name Department Basic Salary Working Days Overtime Hours 2. Automatic Salary Calculation The system calculates salary automatically using VBA formulas including: Basic Salary Overtime Payment Allowances Bonuses Deductions (tax, EPF, loans, etc.) Example formula logic: Gross Salary = Basic Salary + Overtime + Allowances Net Salary = Gross Salary − Deductions 3. VBA User Form Interface User-friendly VBA forms for: Entering employee information Updating salary data Searching employee records Calculating payroll with one click 4. Automated Buttons Custom VBA buttons allow users to: Calculate salary Save employee records Update payroll Generate salary reports 5. Payroll Reports The system can generate: Monthly payroll summaries Individual employee salary slips Department-wise salary reports 6. Error Reduction VBA automation minimizes manual calculation errors and ensures accurate payroll processing. 7. Time Efficiency Payroll calculations that normally take hours can be completed in seconds.