Web-based Attendance and Payroll System -- 2
Publicada el 2026-07-26
Descripción de la oferta
I'm seeking a developer to create a web-based attendance and payroll system. Core functionalities needed: - Employee clock-in/out - Payroll calculation - Leave management A. Employee Master Data Each employee should have one unique record: ◆ Personal Details ◆ Contact Details • Employee ID (Primary Key) • Full Name • Gender • Father Name • PAN Number • Aadhaar Number • Address • Mobile Number • Email ID ◆ Statutory Details ◆ Bank Details ◆ Employment Info ◆ Salary & Policy • OT Type: • UAN (PF) • PF Type: o Restricted (₹1800 max) o Actual (Basic + DA) • ESIC Number • ESIC Applicable (Yes/No) • Professional Tax State • Account Number • IFSC Code • Bank Name • Department • Designation • Date of Joining • Date of Exit • Exit Reason • Salary Structure (Template ID) • Tax Regime (Old/New) • Bonus Eligible (Yes/No) • Attendance Bonus Type: o Physical Days o Paid Days o Single Rate o Double Rate B. Salary Structure (Template-Based) Create salary templates to avoid repetition. ◆ Earnings Components • Basic Salary • HRA • DA • Special Allowance • Conveyance • Bonus (Statutory / Fixed) • Attendance Bonus • Incentives • Leave Encashment • Overtime • Other Earnings Keep this dynamic (add/remove components) ◆ Deductions • PF (12% of Basic + DA) • ESIC (.75% on Basic +DA) • Professional Tax ( State wise) • TDS (Income Tax) • Canteen Deduction • Salary Advance • Other Deductions C. Monthly Input Sheet (Dynamic Upload) This is your monthly transaction sheet: Emp ID Month Days Leaves Payable Days OT Hours Incentive Night Allowance Additional Arrears Advance Other Deduction • System should be update ONLY matching Employee ID • No duplication D. Core Payroll Calculations 1. Payable Days Payable Days = Physical Days + Paid Leaves 2. Earned Salary (Pro-rata) Earned Component = (Monthly Component / Month Days) × Payable Days 3. PF Calculation • Applicable on Basic + DA • Two options: o Restricted → Max ₹1800 o Actual → 12% of (Basic + DA) PF = MIN(12% × (Basic + DA), 1800) [if restricted] PF = 12% × (Basic + DA) [if actual] 4. ESIC Calculation Eligibility: (Basic + DA) ≤ ₹21,000 Rates: • Employee: 0.75% • Employer: 3.25% 5. Professional Tax • Based on state-wise slabs • Applied on earned gross 6. Statutory Bonus Bonus = 8.33% × (Earned Basic + DA) 7. Leave Encashment Leave Encashment = (Basic + DA) / 26 × Leave Days 8. Attendance Bonus Depends on selection: • Physical Days OR • Paid Days 9. Overtime Calculation OT Rate per hour = (Basic + DA) / (26 × Working Hours) OT Amount = OT Hours × Rate × (1 or 2) 10. Gross & Net Earned Gross- Sum of all earned components Net Salary Net = Earned Gross – Total Deductions 11. CTC Calculation Earned CTC = Earned Gross + Employer PF + Employer ESIC 12. Fixed Gross Actual Gross = Monthly defined salary (fixed structure) E. Reports (Auto Generated) ◆ Statutory Reports • EPF Report (ECR Format) • ESIC Report (MC Template) • Professional Tax Report • Form 16 ◆ Payroll Reports • Payslip • Salary Register (Wage Register) • Bank Statement • Advance Register • MIS Reports ◆ Operational Reports • Attendance Register • OT Report (Hours + Amount) • Bonus Register (Monthly/Yearly) • Leave Encashment Register ◆ Employee Reports • Active Employees • Exit + Active Employees F. System Logic Requirements Data Update Logic • Update only selected Employee ID(s) Flexibility • Add/remove salary components • Configurable: o PF type o OT type o Bonus eligibility o Attendance bonus rule • Upload (Excel Upload) • Import (Excel import) Please provide samples of similar work done and an estimated timeline for completion.
Skills
Fuente original: freelancer