HR spreadsheets that actually work

Ready-to-use XLSX templates for Indonesian HR teams. Tax, payroll, attendance, leave, performance, and more. No login. No database. Just download and open.

Browse templates Download sample XLSX

No signup·No data stored·Excel & Google Sheets·Formulas included

Templates

Free HR templates

Each template is a complete workbook with sample data, formulas, and formatting. Replace the sample rows with your own. Free forever.

Attendance

Attendance Tracker Template

Monthly attendance matrix with generated dates and weekend cues.

Sheets

Setup — Month picker — change once, all dates update

Monthly Tracker — 31-column matrix with dropdown status per day

Summary — COUNTIF-based status counts per employee

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Weekend columns auto-highlighted in amber
✓Dropdown validation on every status cell
✓Change the month in Setup — date headers follow automatically
✓Works well for shift-based and office teams

Best for: Daily attendance tracking in a shared spreadsheet·Team size: 5–50 employees

Download attendance tracker

3 sheets · XLSX · No account

Monthly Tracker — May 2026

#	Employee	Dept	01	02	03	04	05	06	07
2	Dina Prasetya	Ops	Present	Present	Off	Off	Present	Present	Present
3	Rafi Mahendra	People	Present	Present	Off	Off	Leave	Present	Present
4	Sari Wulandari	Finance	Sick	Present	Off	Off	Present	Present	Sick
5	Budi Santoso	Ops	Present	Present	Off	Off	Present	Present	Present
6	Maya Anggraini	Finance	Present	Present	Off	Off	Present	Present	Present

Preview — actual template includes full sample data and formulas

Leave

Leave Tracker Template

Simple annual leave balance and leave usage workbook.

Sheets

Setup — Year and default annual entitlement

Leave Balance — Opening balance, entitlement, used, and remaining

Leave Usage — Leave requests with NETWORKDAYS formula and status dropdown

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓NETWORKDAYS formula calculates working days only
✓Status dropdown: Planned, Pending, Approved, Rejected, Cancelled
✓Approved annual leave auto-rolls into balance via SUMIFS
✓Supports multiple leave types (annual, sick, unpaid)

Best for: Annual leave balance tracking without a dedicated system·Team size: 5–50 employees

Download leave tracker

3 sheets · XLSX · No account

Leave Balance

#	Employee	Department	Opening	Entitlement	Used	Remaining
2	Dina Prasetya	Operations	0	12	3	9
3	Rafi Mahendra	People	2	12	1	13
4	Sari Wulandari	Finance	0	12	4	8
5	Budi Santoso	Operations	1	12	2	11
6	Maya Anggraini	Finance	0	12	0	12

Preview — actual template includes full sample data and formulas

Tax

PPh21 Tax Calculator

Indonesian PPh21 income tax calculator with progressive brackets and PTKP status.

Sheets

Setup — Tax year, PTKP status list, PTKP amounts

Tax Brackets — Progressive PPh21 bracket table (5%, 15%, 25%, 30%, 35%)

Employee Tax — Gross salary, deductions, taxable income, monthly PPh21

Summary — Total annual and monthly tax per employee

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Uses real Indonesian PPh21 progressive tax brackets
✓BPJS deductions auto-calculated from gross salary
✓PTKP status dropdown for easy selection
✓IDR currency formatting pre-applied

Best for: Monthly PPh21 tax withholding calculation for payroll·Team size: 5–100 employees

Download PPh21 tax calculator

4 sheets · XLSX · No account

Employee Tax Summary

#	Employee	Department	Gross Salary	PTKP Status	Taxable Income	Monthly PPh21
2	Dina Prasetya	Operations	7.500.000	TK/0	55.800.000	172.500
3	Rafi Mahendra	People	12.000.000	K/1	105.600.000	525.000
4	Sari Wulandari	Finance	6.800.000	K/0	49.680.000	124.000
5	Budi Santoso	Operations	5.500.000	TK/0	37.200.000	60.000
6	Maya Anggraini	Finance	6.200.000	K/0	42.480.000	87.000

Preview — actual template includes full sample data and formulas

Compensation

THR Tracker

Track Tunjangan Hari Raya (THR) eligibility, calculation, and payment status.

Sheets

Setup — THR year, eligibility rules, religious holiday reference

THR Calculation — Eligibility check, THR amount, payment status per employee

Summary — Total THR disbursement by department

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Pro-rated THR for employees with tenure under 12 months
✓Payment status dropdown (Pending, Paid)
✓IDR currency formatting pre-applied
✓Complies with PP 78/2015 on THR guidelines

Best for: THR disbursement tracking before religious holidays·Team size: 5–200 employees

Download THR tracker

3 sheets · XLSX · No account

THR Calculation

#	Employee	Department	Hire Date	Tenure (mo)	Base Salary	THR Amount	Status
2	Dina Prasetya	Operations	01 Mar 2024	26	7.500.000	7.500.000	Paid
3	Rafi Mahendra	People	15 Jun 2023	35	12.000.000	12.000.000	Paid
4	Sari Wulandari	Finance	01 Jan 2025	16	6.800.000	6.800.000	Pending
5	Budi Santoso	Operations	10 Nov 2025	6	5.500.000	2.750.000	Pending
6	Maya Anggraini	Finance	01 Sep 2024	20	6.200.000	6.200.000	Paid

Preview — actual template includes full sample data and formulas

Compensation

BPJS Contributions Tracker

Calculate employee and company BPJS Kesehatan and Ketenagakerjaan contributions.

Sheets

Setup — Year, all BPJS contribution rates (employee + company)

BPJS Contributions — Per-employee breakdown of all BPJS components

Summary — Total employee and company cost per employee

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓All rates editable in Setup — formulas auto-update
✓Covers JHT, JP, JK, JKK, JPensiun, and BPJS Kesehatan
✓IDR currency formatting pre-applied
✓Compliant with current Indonesian BPJS regulations

Best for: Monthly BPJS contribution calculation for payroll·Team size: 5–200 employees

Download BPJS tracker

3 sheets · XLSX · No account

BPJS Contributions

#	Employee	Dept	Gross Salary	Emp JHT	Emp JP	Emp Kes	Total Emp	Total Company
2	Dina Prasetya	Ops	7.500.000	150.000	75.000	75.000	375.000	585.000
3	Rafi Mahendra	People	12.000.000	240.000	120.000	120.000	600.000	936.000
4	Sari Wulandari	Finance	6.800.000	136.000	68.000	68.000	340.000	530.400
5	Budi Santoso	Ops	5.500.000	110.000	55.000	55.000	275.000	429.000
6	Maya Anggraini	Finance	6.200.000	124.000	62.000	62.000	310.000	483.600

Preview — actual template includes full sample data and formulas

Performance

Performance Review Template

Structured performance review with KPI scoring, rating formulas, and summary.

Sheets

Setup — Review period, rating scale, rating labels

Review Form — Per-employee KPI scores, total, and rating label

Summary — All employees with ratings and department averages

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Score validation: only 1–5 allowed
✓Rating labels auto-generated from total score
✓Best for teams with structured review cycles
✓Editable KPI categories to match your company framework

Best for: Periodic performance review and rating·Team size: 5–100 employees

Download performance review

3 sheets · XLSX · No account

Performance Review — H1 2026

#	Employee	Dept	Quality	Productivity	Teamwork	Total	Rating
2	Dina Prasetya	Operations	4	4	5	21	Good
3	Rafi Mahendra	People	5	5	4	24	Excellent
4	Sari Wulandari	Finance	3	4	4	19	Good
5	Budi Santoso	Operations	4	3	3	18	Meets Expectations
6	Maya Anggraini	Finance	4	4	5	22	Good

Preview — actual template includes full sample data and formulas

Employee

Employee Master Data

Centralized employee personal, employment, and banking information.

Sheets

Setup — Company name, data as-of date

Employee Data — Full employee profile with 17+ fields per row

Statistics — COUNTIF-based headcount breakdowns

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Dropdowns for Gender, Employment Type, and Status
✓NPWP and BPJS number columns for compliance
✓Statistics auto-update as you add employee rows
✓Keep this file as your single source of truth for employee data

Best for: Centralized employee directory and master data·Team size: 5–200 employees

Download employee master data

3 sheets · XLSX · No account

Employee Data

#	Employee No	Name	Gender	Department	Position	Hire Date	Type	Status
2	EMP-001	Dina Prasetya	F	Operations	Staff	01 Mar 2024	Permanent	Active
3	EMP-002	Rafi Mahendra	M	People	Manager	15 Jun 2023	Permanent	Active
4	EMP-003	Sari Wulandari	F	Finance	Analyst	01 Jan 2025	Contract	Active
5	EMP-004	Budi Santoso	M	Operations	Staff	10 Nov 2025	Contract	Active
6	EMP-005	Maya Anggraini	F	Finance	Supervisor	01 Sep 2024	Permanent	Active

Preview — actual template includes full sample data and formulas

Attendance

Overtime Tracker

Track overtime hours with UU Ketenagakerjaan-compliant rate multipliers.

Sheets

Setup — Month, overtime rate multipliers per UU Ketenagakerjaan

Overtime Log — Daily overtime entries with auto-calculated pay

Monthly Summary — SUMIF-based totals per employee

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Rate multipliers comply with UU 13/2003 (Ketenagakerjaan)
✓Day type dropdown (Weekday, Weekend, Holiday)
✓Approval status dropdown
✓IDR currency formatting pre-applied

Best for: Monthly overtime tracking and cost calculation·Team size: 5–100 employees

Download overtime tracker

3 sheets · XLSX · No account

Overtime Log — May 2026

#	Employee	Date	Day Type	Hours	Rate Mult	Hourly Rate	OT Pay
2	Dina Prasetya	05 May	Weekday	2	1,5	42.000	126.000
3	Sari Wulandari	10 May	Weekday	3	1,5	38.000	171.000
4	Budi Santoso	17 May	Weekday	4	1,5	31.000	186.000
5	Rafi Mahendra	24 May	Weekend	4	2	67.000	536.000
6	Maya Anggraini	25 May	Weekend	2	2	35.000	140.000

Preview — actual template includes full sample data and formulas

Turnover Tracker

Log resignations, track reasons, and calculate turnover rates by department.

Sheets

Setup — Year, department list, headcount reference

Resignation Log — Departure details with tenure formula and reason dropdown

Summary — Turnover metrics by department and reason

Notes

✓Compatible with Excel 2016+ and Google Sheets
✓Reason dropdown: Salary, Career Growth, Personal, Relocation, Management, Other
✓Tenure auto-calculated in months from hire to resign date
✓Replacement status dropdown: Open, Filled, N/A
✓Use with employee master data for complete picture

Best for: Tracking employee departures and analyzing turnover trends·Team size: 5–200 employees

Download turnover tracker

3 sheets · XLSX · No account

Resignation Log — 2026

#	Employee	Department	Hire Date	Resign Date	Tenure (mo)	Reason	Replacement
2	Andi Kurniawan	Operations	15 Jan 2023	28 Feb 2026	37	Career Growth	Open
3	Rina Sari	Finance	01 Aug 2024	15 Mar 2026	19	Salary	Filled
4	Tono Widodo	Operations	10 May 2025	30 Apr 2026	12	Personal	N/A
5	Lestari Putri	People	01 Dec 2023	10 Jan 2026	25	Relocation	Filled
6	Hendra Wijaya	Finance	20 Mar 2024	15 May 2026	26	Management	Open

Preview — actual template includes full sample data and formulas

Why this exists

Most Indonesian SMB teams still run HR on spreadsheets

HR operators at small teams often start each month with a blank spreadsheet or a messy template from the internet. They spend hours formatting columns and fixing broken formulas — just to rebuild the same structure they had last month.

PeopleSheet gives those operators a calm starting point. Each template is designed to be immediately useful: realistic sample data, working formulas, and a structure that matches how Indonesian HR teams actually operate.

There is no account system. No employee database. No data transmission. You download a file, replace the sample rows, and keep working in your own spreadsheet tool.

How it works

Download, replace, use

Download

Choose a template. The XLSX file downloads immediately.

Replace

Swap sample rows with your own data. Keep the formulas.

Use

Open in Excel or Google Sheets. Edit as needed.

Privacy

PeopleSheet doesn't store anything

You download a template file, open it in Excel or Google Sheets, and fill in your own employee data. The data stays in that file on your machine. PeopleSheet never sees it.

No account needed

Click download, get the file. No signup, no email, no login wall.

Your data never enters the system

Templates contain only sample data. Your employee information is never uploaded or transmitted.

You own the file

Once downloaded, the XLSX is yours. Edit it, share it, store it however you want.

Fully offline after download

The spreadsheet works without internet. All formulas run locally in Excel or Google Sheets.

Support

PeopleSheet is free and always will be

If these templates saved you time, consider buying me a coffee. Every donation helps keep this project alive and motivates new templates.

☕ Buy me a coffee — Saweria 🎁 Support via Trakteer

No pressure. The templates are free forever. This is just if you want to say thanks.