Which Excel payroll template do you need?
Our two payroll templates calculate income tax, salary deductions and company contributions for monthly-paid employees and produce payslips and department reports. Tax tables, rebates, deductions and contributions are all set up by you, so the templates can be configured for the rules that apply in your country.
The main question is whether your employees' earnings change from month to month. If you only need to check the tax on a salary or bonus, the Income Tax Calculations template is enough.
Quick answer: which template should you choose?
- Monthly Payroll Template: choose it if earnings change from month to month, for example overtime, commission or fringe benefits.
- Basic Monthly Salary Template: choose it if employees earn a fixed monthly salary, with at most one annual bonus and one salary increase a year.
- Income Tax Calculations Template: choose it if you only need to work out income tax, net salary or the tax on a bonus, without running a payroll.
Feature comparison
| Feature | Monthly Payroll | Basic Monthly Salary | Income Tax Calculations |
|---|---|---|---|
| Purpose | Full monthly payroll | Full monthly payroll | Tax and net salary calculator |
| Employees | Up to 50 (recommended) | Up to 50 (recommended) | One calculation at a time |
| Pay frequency | Monthly only | Monthly only | Monthly salary |
| Variable monthly earnings (overtime, commission) | ✓Yes | –No | ✓Yes |
| Fringe benefits | ✓Yes | –No | Travel allowance inclusion |
| Annual bonus | ✓Yes | One bonus month | ✓Yes |
| Income tax and medical tax credits | ✓Yes | ✓Yes | ✓Yes |
| Salary deductions and company contributions | ✓Yes | ✓Yes | Pension and unemployment insurance |
| Payslips | ✓Yes | ✓Yes | –No |
| Gross and net pay by employee or department | ✓Yes | ✓Yes | –No |
The templates in detail
Monthly Payroll Template
Monthly payroll calculations for variable monthly earnings.
- Best for:
- Businesses with up to 50 monthly-paid employees and variable earnings such as overtime, commission or fringe benefits
- Not suitable for:
- Weekly or fortnightly pay runs, or more than 50 employees (calculations slow down). Fixed salaries: Basic Monthly Salary is simpler
View the Monthly Payroll template
Basic Monthly Salary Template
Automated payroll calculations for fixed monthly earnings.
- Best for:
- Businesses with up to 50 monthly-paid employees on fixed salaries with one annual bonus and increase
- Not suitable for:
- Variable earnings such as overtime or commission, fringe benefits or non-annual bonuses (use Monthly Payroll), or weekly pay
View the Basic Monthly Salary template
Income Tax Calculations Template
Calculates personal income tax based on any tax brackets.
- Best for:
- Employees and employers checking income tax, net salary and tax on a bonus
- Not suitable for:
- Running a payroll with payslips (use Monthly Payroll)