Excel-Skills.com

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?

Feature comparison

Feature Monthly PayrollBasic Monthly SalaryIncome 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)

View the Income Tax Calculations template

Frequently Asked Questions

Can these payroll templates be used outside South Africa?
Yes, if your payroll rules fit the template design. The income tax tables, rebates, salary deductions and company contributions are all user-defined, so you can enter the rates that apply in your country. You need to know the correct rates; we provide technical support on the template, not tax advice.
Can I pay employees weekly or fortnightly?
No. Both payroll templates are designed for employees who are paid monthly, and they cannot be customised for weekly or bi-weekly pay periods.
How many employees can the payroll templates handle?
There is no fixed limit, but the templates are designed for businesses with 50 or fewer monthly-paid employees. With more employees, the calculations can slow down considerably.
Do the payroll templates include updates for new tax years?
The once-off price does not include annual updates. You update the tax tables and rates yourself for each new tax year. If regulations change in a way the design cannot accommodate, a new version of the template may be needed.
What is the difference between Monthly Payroll and Basic Monthly Salary?
Monthly Payroll handles earnings that change every month, fringe benefits and bonuses in any month. Basic Monthly Salary is simpler: it fills in all 12 months automatically from fixed salaries, with one annual bonus month and one annual salary increase.