UK Payroll Calculation Template

UK Payroll Calculation Template

This template provides a structured framework for calculating monthly gross pay, statutory deductions, and net pay for employees in the United Kingdom. Use this document to ensure compliance with HMRC reporting requirements and to maintain accurate payroll records for your staff.

1. Employee Details

• Employee Name: [Employee Name]
• Employee ID: [Employee ID]
• Tax Code: [Tax Code]
• National Insurance Category: [NI Category]
• Pay Period: [Start Date] to [End Date]

2. Earnings Breakdown

1. Basic Salary: [Amount]
2. Overtime Pay: [Amount]
3. Bonuses/Commission: [Amount]
4. Statutory Payments (SSP/SMP/SPP): [Amount]
5. Total Gross Pay: [Sum of 1-4]

3. Deductions

1. PAYE Income Tax: [Amount]
2. Employee National Insurance: [Amount]
3. Pension Contribution (Employee): [Amount]
4. Student Loan Repayment: [Amount]
5. Other Deductions (e.g., Cycle to Work): [Amount]
6. Total Deductions: [Sum of 1-5]

4. Net Pay Calculation

• Total Gross Pay: [Amount]
• Minus Total Deductions: [Amount]
• Net Pay Payable: [Total]

5. Employer Contributions

• Employer National Insurance: [Amount]
• Employer Pension Contribution: [Amount]
• Total Employer Cost: [Sum of Gross Pay + Employer Contributions]

Pro Tips

• Verify Tax Codes: Always check the latest HMRC notifications for any tax code changes before running your monthly payroll.
• Pension Auto-Enrolment: Ensure your pension contribution percentages align with current UK auto-enrolment minimums.
• Record Keeping: Keep digital or physical copies of these payroll records for at least three years as required by HMRC.
• NI Thresholds: Regularly update your spreadsheet formulas to reflect any changes to National Insurance thresholds announced in the annual budget.

FAQ

How often should I update the tax codes in this template?

You should update tax codes whenever you receive a P6 or P9 notice from HMRC or when a new employee provides their P45.

Does this template include calculations for student loans?

Yes, you can input the student loan deduction amount in the deductions section based on the specific plan type (Plan 1, 2, 4, or Postgraduate Loan) assigned to the employee.

How do I handle statutory payments?

Statutory Sick Pay (SSP), Statutory Maternity Pay (SMP), and other statutory payments should be entered in the Earnings section and tracked separately to ensure you are meeting your legal obligations.