Home

PAYExcel Payroll

Purchase

FAQs

News

PAYExcel

PAYE Online Filing

For information on PAYE online filing please click here.

Other PAYExcel FAQs and Tips

  1. What is PAYExcel ?
  2. What should I know before using PAYExcel ?
  3. How do I deal with Statutory Sick Pay, Statutory Maternity Pay or other Statutory Payments?
  4. How do I deal with Student Loan Deductions ?
  5. How do I deal with a change to an employee's tax code ?

What is PAYExcel ?

PAYExcel is a standard .xls file for use with Microsoft Excel 97 or later and is designed for anyone running the payroll of a small business, club, organisation, etc. in the UK, as well as accountants, auditors and others handling employer's PAYE and NIC matters.

The low cost and ease of use of PAYExcel also makes it an ideal tool for employees to check the deductions being made from their pay.

Back to Top

What should I know before using PAYExcel ?

In most instances, PAYExcel only requires you to enter the pay date, gross pay and tax code to calculate the correct deductions and net pay.  However, because PAYExcel emulates the manual procedures for running a payroll, you may find it useful to familiarise yourself with the normal operation of PAYE and National Insurance Contributions.  HMRC provide guidance on the Web at www.hmrc.gov.uk/paye/intro/index.htm

Also, be sure to read the 'QuickTour' and 'Notes' worksheets in PAYExcel before you start to use the workbook.

Back to Top

How do I deal with Statutory Sick Pay, Statutory Maternity Pay and other Statutory Payments?

In the relevant cell on the 'Records' worksheet, enter 'yes'.  This will generate a line on the payslip in the 'Input' worksheet to enable you to enter the amount due.  Please note that PAYExcel does not calculate the amount of SSP or SMP, etc. due.  HMRC provide online calculators at www.hmrc.gov.uk/calcs/stat-calcs.htm

Back to Top

How do I deal with Student Loan Deductions ?

In the relevant cell on the 'Records' worksheet, enter 'yes'.  This will generate a line on the payslip in the 'Input' worksheet to enable you to enter the amount.

Back to Top

How do I deal with a change to an employee's tax code ?

When an employee's tax code changes do not overwrite the existing code on the 'Records' sheet - enter the new code on the next available 'amended code' cell, then enter the date from which the amended code is applied in the cell below.

Back to Top