Employee Management Google Sheets Template 2027 — HR Guide

By Tuân HoangMarch 29, 202610 min read

HR in Google Sheets

For companies under 50 employees, Google Sheets handles most HR needs: employee records, attendance, leave tracking, and basic payroll — at zero monthly cost.

Employee Database Sheet

Key fields: Employee ID | Full Name | Department | Position | Start Date | Contract Type | Base Salary | Bank Account | Tax Code | Insurance Number | Emergency Contact | Notes

Monthly Attendance Tracking

Create a monthly sheet with employees as rows and dates as columns. Use data validation: P (Present), A (Absent), L (Leave), H (Holiday), OT (Overtime).

Working Days: =COUNTIF(B2:AF2,"P")+COUNTIF(B2:AF2,"OT")
Absence Days: =COUNTIF(B2:AF2,"A")
Leave Days Used: =COUNTIF(B2:AF2,"L")
Overtime Hours: =COUNTIF(B2:AF2,"OT")*OT_HOURS_PER_DAY

Leave Balance Tracker

Columns: Employee | Annual Leave Entitlement | Days Used | Days Remaining | Sick Leave Used | Maternity/Paternity Used

Vietnamese Labor Law 2024: minimum 12 days annual leave, increases with seniority.

Payroll Calculation

Gross Salary:
=BaseSalary/WorkingDaysInMonth*ActualDaysWorked + Allowances + OT_Pay

Social Insurance Deduction (employee 8%):
=InsuranceSalary*0.08

Personal Income Tax (simplified):
=MAX(0,(GrossSalary-SocialInsurance-9000000)*TaxRate)

Net Salary: =GrossSalary-SocialInsurance-HealthInsurance-IncomeTax

Vietnamese Payroll Compliance Notes

  • Social insurance base salary: capped at 20x minimum wage
  • Employee contributions: 8% social + 1.5% health + 1% unemployment
  • Employer contributions: 17% social + 3% health + 1% unemployment + 0.5% occupational accident
  • Personal income tax: graduated rates 5%-35%, personal deduction 11M VND/month

Get a complete payroll template at SheetStore.

FAQ

Can Google Sheets replace dedicated HRM software?

For companies under 50 employees with straightforward payroll, yes. For 50+ employees with complex shift patterns, overtime rules, and multi-branch management, dedicated HRM software is more efficient.

Bài viết này cũng có bản tiếng Việt

Try SheetStore for Google Sheets

Management software built on Google Sheets — from $29 one-time

View Pricing