Payroll Management System

← Back to Hub

This is a Google Apps Script application. It runs inside Google Sheets and cannot be opened directly in a browser. Follow the setup steps below to deploy it to your Google account.

Features

Payroll processing and calendar management
PTO records and summary tracking
Overtime upload, history, trends, and per-employee views
Uniform ordering, catalog, deductions, and summary
Year-end processing wizard
Employee-facing PTO and uniform request forms
System health monitoring and settings management
Dashboard with key payroll metrics
Login and authentication gateway

Setup Steps

Create a new Google Sheet for the Payroll System.
Open Extensions → Apps Script and paste each .gs file.
Create all HTML files as listed below.
Run the initial setup function to create required sheet tabs.
Deploy as a Web App (Deploy → New Deployment → Web App).
Configure settings in the Settings page within the app.

Files in This Project

Code.gs DashboardModule.gs PTOModule.gs ReportsModule.gs AuthGateway.html Index.html MainApp.html MainAppJS.html MainAppStyles.html LoginPrompt.html JavaScript.html Styles.html EmployeePTORequest.html EmployeeUniformRequest.html View_Dashboard.html View_PayrollProcessing.html View_OTUpload.html View_OTHistory.html View_OTTrends.html View_OTEmployee.html View_OTReconciliation.html View_PTORecords.html View_PTOSummary.html View_UniformOrders.html View_UniformCatalog.html View_UniformDeductions.html View_UniformSummary.html View_PayrollCalendar.html View_YearEndWizard.html View_SettingsPage.html View_SystemHealth.html View_Help.html COMPLETE_SETUP_GUIDE.md