Save time for your HR team with this Excel payslip template.<\/h4>\n \n
A standard payroll model made in Excel based on the HMRC template that you can use to prepare your employees' payroll.<\/p>\n \n \n Download for free <\/a>\n <\/div>\n\n Let\u2019s begin by answering the question “what is a payslip?”<\/em> A UK payslip, also known as a salary slip, wage slip or pay stub, is a document given to an employee by their UK employer<\/strong>. Payslips detail the amount of pay given before tax<\/strong>, as well as deductions<\/strong> such as tax, insurance and other company schemes including pensions. Finally, it will state the amount the employee receives after these withholdings<\/strong>. This amount will be shown within the pay period written on the slip, but also the Year to Date (YTD) payroll information so far.<\/p>\n Payslips are issued on a cyclical basis, at the same time and frequency as actual wage or salary payments, usually either weekly, bi-monthly or monthly. Understanding UK payroll is vital if you\u2019re in an HR position. But don’t panic, if your next question is: “how to make a payment slip?” You can get started with our <\/span>free online payslip template.<\/a><\/p>\n One question many HR managers have is \u201chow is a payslip formatted?\u201d Well, there isn\u2019t one way to format a payslip. Each company is different and thus follows a different structure. Yet, one thing many companies have in common is that they want the payslip to be professional, good quality and present all the necessary information in a clear and concise way. A lot of payslips are missing at least one of these necessities. This is why we have detailed what a standard payslip template should include and provided you with a simple payslip template.<\/p>\n A UK payslip template should include the pay before and after deductions. The deductions must also be clearly stated. These include:<\/p>\n Whether you need a simple salary slip format for small organisations or a more complex one for larger businesses, there is no law stating how the payslip should be laid out or structured. There are many different payslip samples to go by, however, there is no one-size-fits-all sample. Saying this, there still exist some common practices. It is commonplace for the gross pay to be stated at the top, followed by deductions and the net pay clearly shown at the bottom. There may also be spaces included somewhere on the document for any miscellaneous information. For example, the reimbursement of expenses or company perks.<\/p>\n Although some companies use a salary slip format in Word, many choose a salary slip format Excel offers. Excel as a tool for creating a basic payslip template is very useful. It allows all the necessary sections and information to be shown in clearly defined tables. What\u2019s more, its calculation tools can be useful for working out totals and percentages on your payslip template.<\/p>\n Before looking at a payslip template it will be useful to understand the format of a payslip template in Excel. Payslip templates in Excel are utilised by many HR managers. Therefore, within this article, we will analyze the different sections of a typical salary slip and their significance. This will help the HR manager with the creation and structure of their own employees\u2019 paychecks.<\/p>\n So what should be included on an employee payslip? Let\u2019s take a look at some of the key parts that are included in a payslip template excel.<\/p>\n The payslip template Excel should start by presenting the employee\u2019s name and address, including on the template for identification purposes. Include any other relevant information that may be required of you due to local regulations or company policies.<\/p>\n This is also known as the employee number, companies use this number to identify individuals on their payroll. It is essentially an employee identification tool and it is normally at the head of your payslip.<\/p>\n The numbers stated here represent the tax period for that particular salary slip. The UK tax period runs from the start to the end of the calendar year.<\/p>\n This code is used to which is used to work out how much Income Tax<\/em> to take from your pay or pension and specifies the percentage rate an individual is taxed at.<\/p>\n This labels the amount of pay an employee receives before taxes and further deductions.<\/p>\n This states an employee\u2019s take-home pay after all taxes and other deductions have been made.<\/p>\n YTD refers to a period of time beginning on the first day of the calendar or fiscal year running up to the current date. It is based on the employee\u2019s gross income and is shown to indicate all earnings received by the employee to date in that year at that company.<\/p>\n This is the employee\u2019s personal social security number. It is used by the authorities to identify the individual. Any deductions made to social security under this number will be recorded against that employee\u2019s name.<\/p>\n If an employee incurs expenses in advance the employer will make the reimbursement on the payslip<\/a> direct to the employee. This could be in the case of booking a business trip in advance or subsistence during the trip.<\/p>\n This section states the amount taken from the gross pay and withheld for contribution to the employee\u2019s pension. Keep in mind, this allows the employee to see how much percentage of their salary is being stored in the company pension scheme.<\/p>\n If the worker receives any workplace benefits, like company health insurance, a company car, or any bonuses this will be clearly indicated on the salary slip.<\/p>\n Above you can see an example of what a UK payslip could potentially look like. Download this sample as well as fill-in-the-blank payslip template<\/a> to make creating employee payslips easier. In addition, you’ll receive a full explanation of the information written on this UK payslip sample so you can replicate it for your employees.<\/p>\n After understanding what goes into the salary payslip format and the distinct sections that must be included, it\u2019s time to look at a free payslip template. Payslip templates set out a general structure for companies to follow, which can be modified to suit the location and needs of the employer. Additionally, payslip templates can prove vital in making sure employers provide all the necessary components and information on each payslip. Below we have included an example of a payroll excel sheet free download, with all the necessary information included.<\/p>\n \n \n \n \n \n ![](\"https:\/\/factorialhr.co.uk\/blog\/app\/plugins\/factorial-utilities\/assets\/images\/banners\/inline\/backgrounds\/default_image.svg\")
\n <\/div>\n <\/div>\n<\/div><\/p>\nWhat is a Payslip?<\/strong><\/h2>\n
How to Create a Payslip Template Sample<\/strong><\/h2>\n
\n
Want see more of Factorial?<\/h4>\n \n
\n
![](\"https:\/\/factorialhr.com\/wp-content\/uploads\/2025\/09\/01114707\/Discover-banner-factorial-laptop.png\")
\n <\/div>\n <\/div>\n<\/div>\nUnderstanding the Employee Payslip Template Excel <\/strong><\/h2>\n
Personal information<\/strong><\/h3>\n
Payroll number<\/strong><\/h3>\n
Tax period<\/strong><\/h3>\n
Tax code<\/strong><\/h3>\n
Gross pay<\/strong><\/h3>\n
Net pay<\/strong><\/h3>\n
Year to Date (YTD)<\/strong><\/h3>\n
Social Security number<\/strong><\/h3>\n
Expenses<\/strong><\/h3>\n
Pensions<\/strong><\/h3>\n
Workplace benefits<\/strong><\/h3>\n
![\"Factorial](\"https:\/\/factorialhr.co.uk\/wp-content\/uploads\/2020\/07\/21131835\/Screenshot-2025-02-21-at-12.14.12%E2%80%AFPM-1024x916.png\")
<\/a><\/h2>\nEmployee Payslip Template<\/strong><\/h2>\n
![\"payroll](\"https:\/\/no-cache.hubspot.com\/cta\/default\/4960096\/ee8dfd7f-2da9-4442-af30-7212b5285891.png\")
\n <\/a>\n <\/span>\n