Dotnet-PH-Payroll-API

Key Features

• Dynamic Attendance: Calculates Gross Pay based on "Present" logs within a specific date range.
• Schedule Support: Built-in support for MWF and TTHS work shifts to ensure accurate logging.
• Automated PH Deductions:
• SSS: 4.5% of Gross Pay.
• PhilHealth: 5% of Gross Pay.
• Pag-IBIG: Fixed ₱100.00 contribution.
• Smart Tax Logic: Automatically applies a 15% Withholding Tax only when taxable income exceeds the ₱20,833.00 monthly threshold.

Test Results

• Scenario,Gross Pay,Total Deductions,Withholding Tax,Net Pay,Result
• Low-Income (3 Days),"₱3,000.00",₱310.00,₱0.00,"₱2,690.00",✅ Pass
• Mid-Income (6 Days),"₱9,000.00",₱730.00,₱0.00,"₱8,270.00",✅ Pass
• High-Income (7 Days),"₱24,500.00","₱2,092.80",₱277.80,"₱22,407.20",✅ Pass

Tech Stack

• Backend: ASP.NET Core Web API (.NET 8)

• Database: SQL Server (MS SQL)

• Frontend: JavaScript, HTML5, CSS

• LINK: https://jinji-tan.github.io/Dotnet-PH-Payroll-API/

• Demo Note: The GitHub Pages link demonstrates the Frontend UI.**

• Backend is a .NET API connected to a local SQL Server, the data operations (CRUD and Computation) require the API to be running locally.