Payroll Assistant

Total Employees

—

Gross Pay

—

Total Deductions

—

Net Pay

Recent Payslips

Attendance Snapshot

Quick Actions

Setup Status

1Upload biometric CSV

⇧

Click to upload CSV

ZKTeco · Hikvision · Any device export

No file uploaded yet

to try it out

2Map CSV columns

Employee ID column

Date column

Time In column

Time Out column

Columns are auto-detected from headers.

3Work schedule rules

4Process attendance

Upload CSV, then click Process to compute late, absences, and overtime.

Attendance records

Employee	ID	Date	Time In	Time Out	Hours	Late (min)	OT (min)	Status
Upload a CSV or load sample data

Name	ID	Department	Position	Basic Salary	Allowance	Email	Status

Payroll computation

Employee	Basic	SSS	PhilHealth	Pag-IBIG	Tax	Late Ded.	OT Pay	Net Pay

Generate payslip

Select an employee above to view their payslip.

🔒 Employee Portal Passwords

Assign passwords so employees can log in to view only their own payslip.

⚠ Important: Share each employee's password with them privately (in person or by sealed envelope). Do not send passwords via group chat.

Name	Employee ID	Department	Portal Password	Status

🏢 Company Information

Appears on every payslip, printed PDF, and payslip email.

Company Name

TIN

Address

Contact / HR Email

⚙ Payroll & Schedule Rules

Used when processing attendance and computing payroll. These were previously on the attendance screen — they now live here as the single source of truth.

Shift start

Shift end

Grace period (minutes)

Overtime rate multiplier

Late deduction method

Working days per month (for daily rate)

Session auto-lock (minutes)

📋 Statutory Contribution Table

SSS employee share by monthly salary bracket. Edit these to match the current SSS contribution schedule — the app does not update them automatically.

Monthly salary below	SSS employee share (₱)

PhilHealth premium rate (%)

PhilHealth employee cap (₱/month)

Pag-IBIG rate (%)

Pag-IBIG employee cap (₱/month)

🔗 Google Sheets Sync

Optional. Paste your deployed Apps Script Web App URL to sync employees and payroll. Leave blank to run fully offline using this browser's storage.

Apps Script Web App URL

🔒 Admin Password

Changes the password for this browser only. Important: it is stored unencrypted and is readable by anyone who opens this file or inspects browser storage. Treat this as a convenience lock, not real security.

Current password

New password (min 8 characters)

💾 Data Management

Employee records and settings are saved in this browser. Export a backup before clearing anything or switching computers.