Automated Excel Sheet Recording and Reporting of educational Center - Payroll

Project Goal: To automate the manual payroll sheet for your educational center's diverse staff, allowing you to process payroll accurately and quickly—whether for salaried teachers or hourly after-school aides.

What I Built (The Automated Excel System):

One-Click Import: A macro that pulls raw timeclock data or submitted timesheets directly into the master sheet from multiple departments.

Smart Role Recognition: The sheet automatically applies different pay structures depending on the employee role (Teacher - Salary, Aide - Hourly, Substitute - Daily Rate, Coach - Stipend).

Overtime & Extra Duty Logic: Automation that catches after-school hours, weekend events (sports, fairs), and substitute days to add the correct premium pay or stipend amounts.

Leave & Deduction Handling: The sheet automatically prorates salary deductions for unpaid leave, sick days, or personal days based on the center's attendance policy.

Error-Checking Mode: The sheet visually flags any missing approvals, timesheet anomalies, or budget overruns before you run payroll.

Management Dashboard: A clean, one-page view that shows total payroll costs by department (or grade level) and alerts you to excessive substitute usage or overtime trends.

The Outcome: You get a reliable, auditable, and fast payroll tool that runs without manual typing, broken formulas, or confusion between salaried and hourly staff.