📂 Project Description

The Payroll & Alphalist Automation System is a web-based platform that automates payroll processes, including 13th month pay computation and generation of BIR Alphalist Schedule 1 & 2 files. It simplifies payroll processing, reduces manual errors, and ensures compliance with statutory reporting requirements, improving overall efficiency for HR and accounting teams.

❗ Problem & Solution

Problem: Payroll processing and statutory reporting are often time-consuming and prone to manual errors. Computing 13th month pay and generating BIR Alphalist files manually can be tedious and may result in compliance risks.

Solution: The Payroll & Alphalist Automation System streamlines payroll computation, automatically calculates 13th month pay, and generates BIR Alphalist Schedule 1 & 2 files in the correct format. This reduces manual work, minimizes errors, and ensures timely and accurate compliance with statutory requirements, allowing HR and accounting teams to focus on higher-value tasks.

🚀 Features

• Automated 13th month pay computation
• BIR Alphalist Schedule 1 & 2 file generation
• Payroll processing with error reduction
• Compliance with statutory reporting requirements
• User-friendly interface for HR and accounting teams
• Centralized record management for employees

🛠️ Tech Stack

• Framework: ASP.NET Core 8.0 (MVC + Razor Pages)
• Database: Microsoft SQL Server
• UI: Bootstrap 5 + SweetAlert2 + Font Awesome
• Excel Library: EPPlus or ClosedXML
• Authentication: ASP.NET Core Identity
• Language: C# & JavaScript

📹 Project Demo

Watch the demo below