Employee Management Template for Google Sheets 2027

HR Basics in Google Sheets

For businesses with 5-50 employees, a Google Sheets HR template handles: employee database, attendance tracking, leave management, and basic payroll calculation.

Vietnamese-specific features: social insurance (BHXH) calculation, personal income tax (PIT) deduction, and 13th-month salary tracking.

Template Structure

Employee Database: Personal info, contract details, department, position, salary, bank account.

Attendance Sheet: Daily check-in/out times. Auto-calculated work hours, overtime, and late arrivals.

Leave Management: Annual leave balance, sick leave, and special leave tracking per employee.

Payroll Calculator: Gross salary, insurance deductions (BHXH 10.5%, BHYT 1.5%, BHTN 1%), PIT, and net salary.

Payroll Formula Example

Vietnamese payroll calculation: Gross Salary - BHXH (8%) - BHYT (1.5%) - BHTN (1%) = Taxable Income before deductions.

Personal deduction: 11,000,000 VND/month for employee + 4,400,000 VND/month per dependent.

PIT rates: 5% (up to 5M), 10% (5-10M), 15% (10-18M), 20% (18-32M), 25% (32-52M), 30% (52-80M), 35% (above 80M).

The template auto-calculates all deductions. Just enter gross salary and number of dependents.