Turkish timesheet (puantaj) template: ready Excel sheet
A puantaj cetveli is the monthly grid showing each employee's worked days, leave, sick days and overtime, day by day. Turkish employers must document working time with suitable means (Labor Law Art. 63, Working Time Regulation Art. 9), and the timesheet is what backs both that duty and the monthly SGK premium-day filings (Law No. 5510, Art. 86). The Excel template ships with a 31-day grid and a code legend.
Template preview
Puantaj
| Sıra | Adı Soyadı | Görevi | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Normal Gün | Hafta Tatili | Genel Tatil | Yıllık İzin | Raporlu | Ücretsiz İzin | Fazla Mesai (saat) | Prim Ödeme Gün Sayısı |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ÖRNEK: Ayşe Yılmaz | Uzman | N | N | N | N | N | N | HT | N | N | N | N | N | N | HT | Yİ | Yİ | Yİ | Yİ | Yİ | N | HT | N | N | N | N | N | N | HT | N | N | 21 | 4 | 0 | 5 | 0 | 0 | 0 | 30 | |
| 2 | |||||||||||||||||||||||||||||||||||||||||
| 3 | |||||||||||||||||||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||||||||||||||||||
| 5 |
İşyeri / İşveren: ____________________ Dönem (Ay/Yıl): ____________________
Düzenleyen (ad, tarih, imza): ____________________ Onaylayan (ad, tarih, imza): ____________________
Kodlar ve Dayanak
| Kod | Açıklama |
|---|---|
| N | Normal çalışılan gün |
| HT | Hafta tatili (İş Kanunu m.46) |
| GT | Ulusal bayram / genel tatil (m.44, m.47) |
| Yİ | Yıllık ücretli izin (m.53) |
| Üİ | Ücretsiz izin |
| R | Raporlu / istirahatli |
| D | Devamsızlık (mazeretsiz) |
| FM | Fazla mesai — saat olarak ayrıca yazınız (m.41) |
Dayanak: İşveren, işçilerin çalışma sürelerini uygun araçlarla belgelemek zorundadır (İş Kanunu m.63; İş Kanununa İlişkin Çalışma Süreleri Yönetmeliği m.9).
Aylık prim ödeme gün sayıları ve eksik gün nedenleri SGK'ya bildirilir (5510 sayılı Kanun m.86); işyeri kayıt ve belgeleri, ilgili olduğu yılı izleyen yıl başından itibaren 10 yıl süreyle saklanır (5510 m.86).
Puantaj kayıtları çalışanın özlük dosyasının parçası olarak saklanır (İş Kanunu m.75).
Bu şablon Otto HR (ottohr.com) tarafından bilgilendirme amacıyla hazırlanmıştır; hukuki danışmanlık değildir. Şablonu kullanmadan önce kendi durumunuza göre uyarlayın ve gerekiyorsa bir avukata danışın.
Excel (.xlsx)
Download the template free
Leave your work email and the file downloads immediately.
Why the timesheet is mandatory
The documentation duty is statutory: to police the 45-hour week (Labor Law Art. 63), the employer must document employees' working time with suitable means (Working Time Regulation, Art. 9). Overtime's 50% premium and its 270-hour annual cap (Art. 41) can likewise only be tracked from daily records.
On the SGK side, monthly premium days and missing-day reasons are reported through the Art. 86 filings, and workplace records must be kept for ten years from the start of the year following the one they concern (Law No. 5510, Art. 86). The timesheet is also the record that produces the day-count input of the payslip — payroll and puantaj must agree.
How to use the template
Sheet one is the monthly grid: one row per employee, columns 1–31 for the days. Cells take the codes from sheet two (N worked, HT weekly rest, Yİ annual leave, R sick, Üİ unpaid leave, GT public holiday). Overtime hours go in their own column. At month end, the totals columns collect worked days, leave and sick days, and the premium-day count reported to SGK. One example row comes pre-filled.
From timesheet to payroll
The totals columns are payroll inputs: the premium-day count feeds the SGK filing, overtime hours feed the 50% premium (Art. 41), unpaid-leave days feed the missing-day report. The classic manual-timesheet failure is leave and sick days drifting against the payroll period, and generating the timesheet from attendance-device (PDKS) data closes that gap.
| Working week | 45 hours maximum (Labor Law Art. 63) |
| Daily ceiling | 11 hours (Art. 63) |
| Overtime | 50% premium, 270 hours/year cap (Art. 41) |
| Documentation duty | Working time documented with suitable means (Working Time Reg. Art. 9) |
| Retention (SGK) | 10 years from the following year (5510 Art. 86) |
Frequently asked
Yes. The employer must document employees' working time with suitable means (Working Time Regulation, Art. 9), and the timesheet is the standard form of that documentation. In a working-time dispute, an employer without records has surrendered its strongest evidence against overtime claims.
No code set is prescribed by law, so the workplace picks a consistent one and applies it every month. The template's legend follows common practice: N worked, HT weekly rest, GT public holiday, Yİ annual leave, Üİ unpaid leave, R sick, D absence — with overtime hours kept in a separate column.
For SGK purposes, workplace records and documents are kept for ten years from the start of the year following the one they relate to (Law No. 5510, Art. 86). Timesheets also belong to the personnel file (Labor Law Art. 75) and can be demanded as evidence years later in working-time disputes.
PDKS is the attendance-control system holding raw clock-in/clock-out records, while the puantaj is the monthly summary produced from it — days worked, on leave, sick, and overtime hours per person. PDKS feeds the timesheet, the timesheet feeds payroll, and the three must reconcile.
The templates and explanations on this page are for information only and are not legal advice. Adapt each document to your own situation before use and consult a lawyer where needed.