What the template includes
- Settings: year and month, working days and hours from the 2026 work calendar, all tax and insurance rates in separate cells.
- Timesheet: 10 employees × 31 days, weekdays filled in automatically, Saturday and Sunday in grey. Codes: number = hours, V = vacation, S = sick leave.
- Payroll: base salary, amount for days worked, bonus, income tax, social insurance (SSPF), unemployment insurance, mandatory health insurance, net pay, employer contributions and total cost.
How it calculates
The rates are the 2026 rules for the private non-oil sector: income tax 3% up to 2,500 ₼ (with the 200 ₼ allowance at the main place of work), 75 ₼ + 10% between 2,500 and 8,000 ₼, 625 ₼ + 14% above; SSPF employee 3%/10%, employer 22%/15%/11%; unemployment insurance 0.5% + 0.5%; health insurance 2% up to 2,500 ₼, 0.5% above. If you enter 2027 as the year, the lower income tax rate becomes 5%, and in 2028, 7%. Allowances under Article 102 of the Tax Code (800 ₼ for shahid families, 400 ₼ for war veterans and persons with war-related disabilities, 200, 100 ₼ and 50 ₼ for 3+ dependants) are chosen per employee in a separate column.
The template gives the same result as the salary calculator. For example, for a gross salary of 3,100 ₼, net pay is 2,600.50 ₼ and the employer's total cost is 3,647.50 ₼.
What to calculate separately
- Vacation pay: vacation calculator.
- Sick leave benefit: sick leave calculator.
- Extra pay for overtime, night shifts and work on public holidays.
Working days by month: work calendar 2026.