ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Timesheet and payroll
Excel template · Payroll

Timesheet and payroll template 2026

Enter each employee's hours by day on the timesheet and the base salary on the payroll sheet. The template calculates all deductions and the employer's cost under the 2026 rules.

Updated:
Valtera_Timesheet_and_payroll_EN.xlsx · 18 KB · Sheets: Guide, Settings, Timesheet, Payroll
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Timesheet_and_payroll_EN.xlsx — Payroll · Preview with sample data
EmployeePositionMain jobAllowance, ₼ (art. 102)3+ dependantsBase salaryDays workedNorm
Aynur MammadovaChief accountantYes-No2,8002222
Elchin HasanovSales managerYes-Yes1,6002222
Sabina GuliyevaManagerYes-No1,2002222
Rauf AliyevWarehouse managerYes400No1,1001722
Tural IsmayilovDriverNo-No8502222
Nigar KarimovaOffice managerYes-No9502022
22
22
22
22
Total8,500

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

Working days by month: work calendar 2026.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.