Template library

Payroll formulas

27 ready-made pay structures — 3P by grade, fixed, piece-rate, hourly, KPI/commission based — each a set of earnings and deductions with formula, taxable and social-insurance flags.

27 templates in XBuddy · 8 examples shown here

Open in XBuddy: Payroll → Salary Model Templates
Used in: Payroll

Payroll formulas — Payroll → Salary Model Templates

Example templates

Basic Monthly - Office

7 components

Pay for actual days worked: base_salary / std_work_days * actual_work_days
Lunch allowance: 730000
Phone allowance: 0
Social insurance (employee) (8%): bhxh_base * 0.08
Health insurance (employee) (1.5%): bhxh_base * 0.015
Unemployment insurance (employee) (1%): bhxh_base * 0.01

Probation Salary

6 components

Probation pay at 85% of monthly salary by actual days. BHXH/BHTN exempt via payroll config; BHYT still applies.

Probation pay (85%): base_salary * 0.85 / std_work_days * actual_work_days
Lunch allowance: 730000
Social insurance (employee) (8%): bhxh_base * 0.08
Health insurance (employee) (1.5%): bhxh_base * 0.015
Unemployment insurance (employee) (1%): bhxh_base * 0.01
Personal income tax: progressive_pit(gross - bhxh_ee - bhyt_ee - bhtn_ee - personal_deduction - dependent_deduction)

3P Salary - Manager

9 components

P1 – Position pay (60%): base_salary * 0.6
P2 – Competency pay (20%): base_salary * 0.2 * completion_coefficient
P3 – KPI bonus (20%): base_salary * 0.2 * kpi_achievement_pct / 100
Position allowance: 0
Lunch allowance: 730000
Social insurance (employee) (8%): bhxh_base * 0.08

KPI Salary - Sales

9 components

Fixed base (70%): base_salary * 0.7
KPI bonus (30%): base_salary * 0.3 * kpi_achievement_pct / 100
Sales commission: commission_amount
Phone allowance: 0
Travel allowance: 0
Social insurance (employee) (8%): bhxh_base * 0.08

Shift Salary - Production Worker

7 components

Pay for actual days worked: daily_rate * actual_work_days
Shift meal allowance: 0
Hazard allowance: 0
Social insurance (employee) (8%): bhxh_base * 0.08
Health insurance (employee) (1.5%): bhxh_base * 0.015
Unemployment insurance (employee) (1%): bhxh_base * 0.01

Pure Commission Salary

7 components

Salary floor: base_salary
Sales commission: commission_amount
Above-plan bonus: 0
Social insurance (employee) (8%): bhxh_base * 0.08
Health insurance (employee) (1.5%): bhxh_base * 0.015
Unemployment insurance (employee) (1%): bhxh_base * 0.01

Part-time / Seasonal

2 components

Hourly pay: hourly_rate * actual_days * 8
Personal income tax (10%): (hourly_rate * actual_hours) * 0.1

Senior Executive Salary

9 components

Base salary: base_salary
Position allowance: 0
Responsibility allowance: 0
Strategic KPI bonus: base_salary * kpi_achievement_pct / 100
Phone allowance: 0
Social insurance (employee) (8%): bhxh_base * 0.08

Rather not pick yourself?

Guided setup in 28 apps asks a few questions about your size, industry and way of working, then proposes matching templates and configuration. You preview every change and click apply yourself — the assistant never writes data on its own.

Other template groups

See this template group on your data

A 30-minute demo: we load the templates, adjust them to your company and run one business cycle.

Book a demo