Payroll Excel template for Uzbekistan
List your employees and the sheet works out income tax, take-home pay, social tax and vacation pay for each of them. Works in Excel, LibreOffice and Google Sheets.
Rules checked by the RealMaosh team against the legal texts on lex.uz as of 27.09.2026
Download the template
XLSX · 41 KB · rules as of 27.09.2026
XLSX · 42 KB · rules as of 27.09.2026
- No macros, sends nothing over the internet, no sign-up. Whatever you type stays in your file.
- If you open the file in Google Sheets, it is uploaded to your Google account.
What's inside
- Payroll sheet — one row per employee: gross, income tax, take-home, social tax and total employer cost, with company totals.
- Vacation sheet — average pay, paid days without Sundays and holidays, vacation pay before and after tax.
- Rules sheet — every rate with its legal article, a lex.uz link and the date it was checked.
- How-to sheet — short instructions and what the sheet does not cover.
| No. | Name or staff number | Position | Gross, UZS | Income tax, UZS | Take-home, UZS | Social tax, UZS | Total employer cost, UZS |
|---|---|---|---|---|---|---|---|
| Total | Employees: 1 | 5 000 000 | 600 000 | 4 400 000 | 600 000 | 5 600 000 | |
| Sample | Sample — delete me | Accountant | Gross, UZS5 000 000 | Income tax, UZS600 000 | Take-home, UZS4 400 000 | Social tax, UZS600 000 | Total employer cost, UZS5 600 000 |
| No. | Name or staff number | Earnings for the period, UZS | First day of leave | Calendar days | Paid days | Vacation pay, gross | Take-home |
|---|---|---|---|---|---|---|---|
| Sample | Sample — delete me | Earnings for the period, UZS84 000 000 | First day of leave05.10.2026 | Calendar days21 | Paid days18 | Vacation pay, gross4 980 237 | Take-home4 382 609 |
Fill in the white cells; the grey ones calculate themselves.
How to use it: 4 steps
- Download the file and open it in Excel, LibreOffice or Google Sheets.
- On the Payroll sheet, choose the employer type and the pay month.
- Enter each employee's gross pay — tax, take-home pay and social tax fill in automatically. Delete the sample row.
- For vacation pay, fill in the Vacation sheet: earnings for the period, number of full months, first day and length of leave.
How the sheet calculates
Income tax is 12% of gross (7.5% for employees of IT Park residents), rounded to the sum. Take-home = gross − tax. The employer pays social tax on top: 12%, 25% in budget organisations, 0% for IT Park residents.
Average monthly = earnings ÷ full months, average daily = average monthly ÷ 25.3; both rounded to the tiyin. Sundays are unpaid; public holidays extend the leave and are unpaid. The sheet knows holidays up to 28.02.2027 — for later dates, enter the paid days by hand.
The sheet does not cover: INPS (it sits inside the income tax and does not change take-home pay), pay for unused leave, working back from take-home to gross, individual reliefs, non-residents, reduced industry rates, sick and maternity pay.
For a single employee, the online calculators are quicker: Take-home pay · Vacation pay
Rules in the sheet
| Rule | Value | Checked |
|---|---|---|
| Personal income tax O'RQ-599, 381-modda | 12% | Checked: 27.09.2026 |
| Income tax, IT Park resident's employee PF-5099, 8-band | 7.5% | Checked: 27.09.2026 |
| Social tax O'RQ-599, 405-modda | 12% | Checked: 27.09.2026 |
| Social tax, budget organisation O'RQ-599, 405-modda | 25% | Checked: 27.09.2026 |
| Social tax, IT Park resident PF-5099, 5-band | 0% | Checked: 27.09.2026 |
| Average working days per month O'RQ-798, 257-modda, 8-qism | 25.3 | Checked: 27.09.2026 |
| Calculation period, months O'RQ-798, 257-modda, 1-qism | 12 | Checked: 27.09.2026 |
| Minimum annual leave, calendar days (reference) O'RQ-798, 217-modda | 21 | Checked: 27.09.2026 |
| Minimum wage (reference) PF-115, 3-band, "b" kichik bandi, (i) | 1 360 000 UZS | Checked: 27.09.2026 |
Real take-home salaries
Median across the countryMedians from data employees submitted anonymously.