{"id":16189,"date":"2020-04-27T16:45:31","date_gmt":"2020-04-27T14:45:31","guid":{"rendered":"https:\/\/factorialhr.com\/blog\/?p=16189"},"modified":"2025-09-03T11:50:32","modified_gmt":"2025-09-03T09:50:32","slug":"payslip-template-excel","status":"publish","type":"post","link":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/","title":{"rendered":"Creating an Employee Payslip [Free Payslip Template Excel]"},"content":{"rendered":"<p>Payslips can be confusing. They contain a huge amount of information. Eyes immediately look to the bottom of the page to see the amount received that month. Yet, often it\u2019s a smaller amount than employees were expecting. The final number is often quite a bit less since money is taken out for taxes, insurance and pension plans. Understanding all the figures in a payslip template can prove difficult. <strong>As HR managers, employees may come to you with queries and concerns about these withholdings.<\/strong><\/p>\n<p>Therefore, it\u2019s important that you choose a <strong>payslip template<\/strong> to follow and make sure you know all of the sections on it like the back of your hand. Today we\u2019re going to look at a <strong>salary slip sample<\/strong>, provide a payslip template in excel to download for free and review the benefits of payroll software.<span style=\"font-size: 18pt;\"><strong><!-- end HubSpot Call-to-Action Code --><\/strong><\/span><\/p>\n<h2><a name=\"format\"><\/a><strong>What is a Payslip?<\/strong><\/h2>\n<p>Let\u2019s begin by answering the question \u201c<a href=\"https:\/\/www.moneyadviceservice.org.uk\/en\/articles\/understanding-your-payslip\" target=\"_blank\" rel=\"noopener noreferrer\">what is a payslip<\/a>\u201d? A payslip, also known as a salary slip or pay stub, is a document given to an employee by their employer. Payslips detail the amount of pay given before tax, as well as the tax, insurance and other company schemes including pensions, that have been deducted. Finally, it will state the amount the employee receives after these withholdings. 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<p>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. <a href=\"https:\/\/factorialhr.com\/blog\/understanding-usa-payroll\/\" target=\"_blank\" rel=\"noopener noreferrer\">Understanding US payroll<\/a> is key if you\u2019re in an HR position, and, having a template for payslip management will prove essential to help you get started!<\/p>\n<h2><a name=\"structure\"><\/a><strong>Employee Payslip Format<\/strong><\/h2>\n<p>One question many HR managers have is \u201chow is an employee payslip formatted?\u201d Well, there isn\u2019t one single 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.<\/p>\n<h2>Payslip Sample<\/h2>\n<p>A sample of a typical payslip format includes the pay before and after deductions. The deductions must also be clearly stated. These include:<\/p>\n<ul>\n<li>Taxes<\/li>\n<li>Social Security<\/li>\n<li>Insurance<\/li>\n<li>Pension schemes<\/li>\n<\/ul>\n<p>Whether you need a simple salary slip format for small organizations 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, and there is not a 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.\u00a0There may also be spaces included somewhere on the document for any miscellaneous information. For example, the reimbursement of expenses or company perks.<\/p>\n<p>Although some companies use a salary slip format in Word, many choose a salary slip format offered by Excel. 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.<\/p>\n<p><span data-sheets-root=\"1\">Say goodbye to chaos with smarter <a href=\"https:\/\/factorialhr.com\/\">Business Management Software.\ud83d\udc47<\/a><\/span><br \/>\n<a href=\"https:\/\/factorialhr.com\/\"><img decoding=\"async\" class=\"alignnone wp-image-158812 size-full\" src=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2024\/02\/15165042\/Banner-Demo-Factorial-All-in-One-English.png\" alt=\"Business Management Software\" width=\"1212\" height=\"500\" srcset=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2024\/02\/15165042\/Banner-Demo-Factorial-All-in-One-English.png 1212w, https:\/\/factorialhr.com\/wp-content\/uploads\/2024\/02\/15165042\/Banner-Demo-Factorial-All-in-One-English-300x124.png 300w, https:\/\/factorialhr.com\/wp-content\/uploads\/2024\/02\/15165042\/Banner-Demo-Factorial-All-in-One-English-1024x422.png 1024w, https:\/\/factorialhr.com\/wp-content\/uploads\/2024\/02\/15165042\/Banner-Demo-Factorial-All-in-One-English-768x317.png 768w\" sizes=\"(max-width: 1212px) 100vw, 1212px\" \/><\/a><\/p>\n<h2><a name=\"understanding\"><\/a><strong>Understanding the Payslip Template Excel\u00a0<\/strong><\/h2>\n<p>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 utilized 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<p>So what should be included on an employee payslip online? Let\u2019s take a look at some of the key parts that are included in a payslip template excel.<\/p>\n<h3><strong>Personal information<\/strong><\/h3>\n<p>The payslip template Excel should start by presenting the employee\u2019s name and address, included on the template for identification purposes.<\/p>\n<h3><strong>Payroll number<\/strong><\/h3>\n<p>Companies use this number to identify individuals on their payroll. It is essentially an employee identification tool.<\/p>\n<h3><strong>Tax period<\/strong><\/h3>\n<p>The numbers stated here represent the tax period for that particular salary slip. The US tax period runs from the start to the end of the calendar year.<\/p>\n<h3><strong>Tax code<\/strong><\/h3>\n<p>This code is issued by a Federal government tax document, which is used to specify the percentage rate an individual is taxed at. Check out our <strong><a href=\"https:\/\/factorialhr.com\/blog\/employers-guide-to-payroll-tax\/\" target=\"_blank\" rel=\"noopener noreferrer\">Employers Guide to Payroll Tax<\/a>\u00a0<\/strong>for more information.<\/p>\n<h3><strong>Gross pay<\/strong><\/h3>\n<p>This labels the amount of pay an employee receives before taxes and further deductions.<\/p>\n<h3><strong>Net pay<\/strong><\/h3>\n<p>This states an employee\u2019s take-home pay after all taxes and other deductions have been made.<\/p>\n<h3><strong>Year to Date (YTD)<\/strong><\/h3>\n<p>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<h3><strong>Social Security number<\/strong><\/h3>\n<p>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<h3><strong>Expenses<\/strong><\/h3>\n<p>If an employee incurs expenses in advance the employer will make the reimbursement on the payslip direct to the employee. This could be in the case of booking a business trip in advance or subsistence during the trip.<\/p>\n<h3><strong>Pensions<\/strong><\/h3>\n<p>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<h3><strong>Workplace benefits<\/strong><\/h3>\n<p>If the worker receives any <a href=\"https:\/\/factorialhr.com\/blog\/guide-to-employee-benefits-and-compensation\/\">workplace benefits<\/a>, like company health insurance, a company car, or any bonuses this will be clearly indicated on the salary slip.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48064 size-full\" src=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103536\/payslip-template-excel-1.jpeg\" alt=\"payslip template excel\" width=\"795\" height=\"450\" srcset=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103536\/payslip-template-excel-1.jpeg 795w, https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103536\/payslip-template-excel-1-300x170.jpeg 300w, https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103536\/payslip-template-excel-1-768x435.jpeg 768w, https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103536\/payslip-template-excel-1-688x388.jpeg 688w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><\/p>\n<h2><a name=\"excel\"><\/a><strong>Employee Payslip Template<\/strong><\/h2>\n<p><a name=\"template\"><\/a>After understanding what goes into the salary payslip format and the distinct sections that must be included, it&#8217;s 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<p><center><!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-d48fea18-eb2e-47df-888d-ce4d61e48b5f\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-d48fea18-eb2e-47df-888d-ce4d61e48b5f\" class=\"hs-cta-node hs-cta-d48fea18-eb2e-47df-888d-ce4d61e48b5f\"><!-- [if lte IE 8]>\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><a href=\"https:\/\/factorialhr.com\/templates\/download-free-payslip\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" id=\"hs-cta-img-d48fea18-eb2e-47df-888d-ce4d61e48b5f\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/4960096\/d48fea18-eb2e-47df-888d-ce4d61e48b5f.png\" alt=\"New call-to-action\" width=\"751\" height=\"438\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(4960096, 'd48fea18-eb2e-47df-888d-ce4d61e48b5f', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code --><\/center><br \/>\nYou may be wondering if the payslip template provided can be used by any company? The simple answer is yes. It can easily be applied to any organization, big or small. Yet there are some guidelines that should be taken into account regarding its use. Let\u2019s take a look at the step-by-step instructions that managers need to be aware of:<\/p>\n<h3><strong>Customizing for your business<\/strong><\/h3>\n<p>Firstly, edit the employee and company information sections at the top so that they apply to your business and each individual. Secondly, make sure to edit the earnings, deductions and YTD information. This will be different for each employee, depending on what they earn with the company. You can add or remove rows on the payslip template depending on how much information you feel you need to include for each worker.<\/p>\n<h3><strong>Entering hours and payment amounts<\/strong><\/h3>\n<p>Next, the working time of each employee needs to be updated. The YTD worksheet which states the hours, rates of pay and payment amounts will need to be updated here. Then after these have been calculated, you can go ahead and input them into the payroll sheet example under the pay date section. This will update all the payment details in the payslip.<\/p>\n<h3><strong>Pay periods<\/strong><\/h3>\n<p>Finally, you must be aware of what to do each pay period. Here are the steps you should take:<\/p>\n<ol>\n<li>Create a new row in the YTD worksheet. Enter all the information for a pay date, pay period, hours, and payment amounts.<\/li>\n<li>Select the pay date from the drop-down at the top of the free payslip template. The hours and amounts will update.<\/li>\n<li>Double-check, print and send the payslip to the employees.<\/li>\n<\/ol>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/factorialhr.com\/blog\/understanding-usa-payroll\/\" target=\"_blank\" rel=\"noopener noreferrer\">Understanding USA Payroll<\/a><\/strong><\/p>\n<p><strong>Additionally, be aware that this payslip template does not calculate taxes. You must do this separately.<\/strong><\/p>\n<p>Each company must inform itself of the necessary legal requirements of its location. This means learning what taxes, deductions and information must be included on the payslip by law. Then, you can go ahead and adapt this free payroll check template to suit your needs.<!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-2493a455-07a7-4965-9faf-ec449b8bbc5b\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-2493a455-07a7-4965-9faf-ec449b8bbc5b\" class=\"hs-cta-node hs-cta-2493a455-07a7-4965-9faf-ec449b8bbc5b\"><!-- [if lte IE 8]>\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/4960096\/2493a455-07a7-4965-9faf-ec449b8bbc5b\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" id=\"hs-cta-img-2493a455-07a7-4965-9faf-ec449b8bbc5b\" class=\"hs-cta-img aligncenter\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/4960096\/2493a455-07a7-4965-9faf-ec449b8bbc5b.png\" alt=\"New call-to-action\" width=\"900\" height=\"308\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(4960096, '2493a455-07a7-4965-9faf-ec449b8bbc5b', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code --><\/p>\n<h2><a name=\"checklist\"><\/a><strong>Payslip Checklist<\/strong><\/h2>\n<p>Now you\u2019ve successfully used the simple payslip template to create your employees\u2019 salary slips and they\u2019re almost ready to be sent out. Next, you need to double-check that you\u2019ve not left anything out. Mistakes are common and it will save everyone time and stress if you follow a payslip checklist to ensure nothing has been missed out. Follow our free payroll checklist template below, to ensure you&#8217;ve covered all the necessary information.<\/p>\n<h3><strong>Check leave accrual<\/strong><\/h3>\n<p>One thing that is commonly mistaken is checking employee <a href=\"https:\/\/factorialhr.com\/blog\/time-in-lieu-explained\/\">leave accrual<\/a>. Although putting this information on a payslip is not a legal requirement, some companies do it. If you\u2019re going to do so, make sure that each individuals\u2019 leave times are being calculated properly and at the same rate through each pay period.\u00a0 Remember to input this into the payroll slip template before sending it.<\/p>\n<h3><strong>Overtime hours<\/strong><\/h3>\n<p>Another common mistake made when inputting information into the payroll check template is the incorrect calculation of <a href=\"https:\/\/factorialhr.com\/blog\/managing-overtime-exempt-employees\/\" target=\"_blank\" rel=\"noopener noreferrer\">overtime hour<\/a>s. If an employee works overtime, make sure to pay them the correct amount as stated in your overtime policy. Therefore, be aware of the overtime workers are doing and make sure you\u2019re aware of the rate of pay overtime is paid at. Some companies offer the same rate of pay as normal hours. Others pay 1.5 hours or double time. This will vary between organizations so it is important to familiarise yourself with this.<\/p>\n<h3><strong>Deductions and contributions<\/strong><\/h3>\n<p>Deduction types are defined as the amount paid by an employee to cover employment expenses.\u00a0Below is a list of common deductions that may appear within payroll:<\/p>\n<ul>\n<li>Health Insurance- If an employee is part of a company&#8217;s health insurance plan, then these deductions will be taken away from an employee&#8217;s paycheck.<\/li>\n<li>Life Insurance- This deduction is taken away if life insurance coverage is provided by an employer and employees have signed up to receive life insurance through their place of work.<\/li>\n<li>Accidental Death &amp; Dismemberment (AD&amp;D)- Dependent on the different types of accidents within the plan, AD&amp;D provides employees with financial protection in the case of an injury, accident or death.<\/li>\n<li>Pension plan- Within the US there are 2 types of pension plans: defined benefit plan and defined contribution plan. A defined benefit plan is a set amount of money paid to an employee when they retire. It is dependent on their salary and the length of time in which they worked in the company. An example of a defined contribution plan is below.<\/li>\n<li>401(k)\/Registered Retirement Saving Plan- This is a plan for those employees that want to put money aside for when they retire. This money would be deducted straight from their payroll.<\/li>\n<\/ul>\n<p>It is of the utmost importance that you familiarize yourself with the taxes, social security, insurance, pension schemes and any other contributions your employees must make. It&#8217;s critical that no errors exist in deductions and contributions since many withholdings are legal requirements.<\/p>\n<h3><strong>Public holiday pay<\/strong><\/h3>\n<p>The correct holiday rate pay must be provided if an employee is required to work a public holiday. It could be standard pay, pay and a half or double pay. This will depend on each organization. Make sure to check this before sending out the payslip to the workers.<\/p>\n<h2><a name=\"abbreviations\"><\/a><strong>USA Payslip Abbreviations<\/strong><\/h2>\n<p>Payslips include a lot of information which is often confusing for employees. Let\u2019s decode some of the abbreviations here so you can apply them to the payslip template Excel offers.<\/p>\n<p><strong>YTD &#8211; Year To Date<\/strong><\/p>\n<p>YTD is the total amount of transactions from the start of the financial year up to the current date.<\/p>\n<p><strong>SUI &#8211; State Unemployment Insurance<\/strong><\/p>\n<p>This salary slip deduction provides funds to States for temporary support of workers who have become unemployed.<\/p>\n<p><strong>SDI &#8211; State Disability Insurance<\/strong><\/p>\n<p>The SDI tax is deducted from paychecks to help fund disability benefits for workers who have become disabled. Not every State has this tax, so it may not appear on payslips.<\/p>\n<p><strong>FICA &#8211; Federal Insurance Contributions Act<\/strong><\/p>\n<p>Deducted from workers&#8217; paychecks to pay their Social Security retirement and Medicare insurance benefits. It is a mandatory payroll deduction.<\/p>\n<p><strong>FWT \u2013 Federal Withholding Tax<\/strong><\/p>\n<p>This is the amount an employer withholds from a paycheck to pay the Internal Revenue Service (IRS) of the US Federal government on behalf of the employee.<\/p>\n<p><strong>SWT \u2013 State Withholding Tax<\/strong><\/p>\n<p>This is the amount an employer takes out to pay to the State government on the employee\u2019s behalf. This will depend on the employee\u2019s place of residence.<\/p>\n<p><strong>401k\/RET<\/strong><\/p>\n<p>This is a standard retirement savings contribution that employers deduct from paychecks. It shows the amount that goes into the pension pot for future retirement.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48065 size-full\" src=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103706\/payroll-templates.jpeg\" alt=\"payroll templates\" width=\"795\" height=\"450\" srcset=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103706\/payroll-templates.jpeg 795w, https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103706\/payroll-templates-300x170.jpeg 300w, https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103706\/payroll-templates-768x435.jpeg 768w, https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/12103706\/payroll-templates-688x388.jpeg 688w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><\/p>\n<h2><a name=\"automate\"><\/a><strong>Automate Your Payroll<\/strong><\/h2>\n<p>Now we\u2019ve covered all of the payslip basics, from formatting to a free payslip template, it\u2019s time to think about how to manage the payroll. The popularity of paperless payroll distribution is growing rapidly. This is partly due to the advent of direct deposits and payment cards. There are many different kinds of <a href=\"https:\/\/factorialhr.com\/payroll\">payroll softwares<\/a> available that help with the management of the entire payroll process. There are many benefits to automating this process by using specialist payroll software. These benefits include:<\/p>\n<h3><strong>Saves costs and time<\/strong><\/h3>\n<p>Using payroll software to automate the process saves costs and time. This is because it reduces the need for HR departments to dedicate time and resources to payroll. HR no longer has to spend hours pouring over employee documentation with their hours, <a href=\"https:\/\/factorialhr.com\/blog\/emergency-paid-leave\/\" target=\"_blank\" rel=\"noopener noreferrer\">sick leave<\/a> and different taxes and contributions. The software simply takes care of it.<\/p>\n<p><iframe title=\"BEST Payroll Software - Quickbooks Factorial Integration \ud83d\udcb0\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/o3jOKyNdCRg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3><strong>Reduces the likelihood of mistakes<\/strong><\/h3>\n<p>Payroll software reduces the risk of errors. When information is filled in correctly, the calculations, formatting and creation of payslips are smooth and error-free. This, in turn, removes the worry of legal ramifications for any errors made on payslips regarding tax withholdings and such problems.<\/p>\n<p>In this sense, it is hugely beneficial for HR to use payroll software. Automating processes will free up time for HR managers to focus their attention on other things, without needing to worry whether payroll is managed correctly and efficiently.<\/p>\n<h2><strong>Payslip Conclusions<\/strong><\/h2>\n<p>Using the payslip template that is provided in this post will aid any HR manager looking for help with payroll and payslip creation. The checklist is essential to ensure that nothing has been missed. It is also worth considering <a href=\"https:\/\/factorialhr.com\/apps\/integration\/quick-books\">installing payroll software<\/a> to help with the smooth running of the entire payroll process.<\/p>\n<p><center><!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-b92c84f6-4ac5-449c-b8f1-43085918502d\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-b92c84f6-4ac5-449c-b8f1-43085918502d\" class=\"hs-cta-node hs-cta-b92c84f6-4ac5-449c-b8f1-43085918502d\"><!-- [if lte IE 8]>\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><a href=\"https:\/\/factorialhr.com\/templates\/download-free-payslip\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" id=\"hs-cta-img-b92c84f6-4ac5-449c-b8f1-43085918502d\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/4960096\/b92c84f6-4ac5-449c-b8f1-43085918502d.png\" alt=\"download-payslip-template\" width=\"337\" height=\"58\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(4960096, 'b92c84f6-4ac5-449c-b8f1-43085918502d', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code -->\u00a0<\/center><em>Written by <\/em>Charlotte Stace<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Payslips can be confusing. They contain a huge amount of information. Eyes immediately look to the bottom of the page to see the amount received that month. Yet, often it\u2019s a smaller amount than employees were expecting. The final number is often quite a bit less since money is taken out for taxes, insurance and<a href=\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\" class=\"read-more\"> [&#8230;]<\/a><\/p>\n","protected":false},"author":97,"featured_media":16201,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[146],"tags":[],"class_list":["post-16189","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-legal-hr"],"acf":{"topics":"payroll"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating an Employee Payslip [Free Payslip Template Excel]<\/title>\n<meta name=\"description\" content=\"Your comprehensive guide to create your own payslip using the free payslip template complete with instructions and template checklist.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating an Employee Payslip [Free Payslip Template Excel]\" \/>\n<meta property=\"og:description\" content=\"Your comprehensive guide to create your own payslip using the free payslip template complete with instructions and template checklist.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Factorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/Factorial\/100064908455810\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-27T14:45:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-03T09:50:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/27151533\/payroll-template.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"795\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Viktorija Nikoloska\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@factorialapp\" \/>\n<meta name=\"twitter:site\" content=\"@factorialapp\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Viktorija Nikoloska\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\"},\"author\":{\"name\":\"Viktorija Nikoloska\",\"@id\":\"https:\/\/factorialhr.com\/blog\/#\/schema\/person\/b9093d450bd0137de0f032810e7b1151\"},\"headline\":\"Creating an Employee Payslip [Free Payslip Template Excel]\",\"datePublished\":\"2020-04-27T14:45:31+00:00\",\"dateModified\":\"2025-09-03T09:50:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\"},\"wordCount\":2555,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/factorialhr.com\/blog\/#organization\"},\"articleSection\":[\"Legal &amp; Finance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\",\"url\":\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\",\"name\":\"Creating an Employee Payslip [Free Payslip Template Excel]\",\"isPartOf\":{\"@id\":\"https:\/\/factorialhr.com\/blog\/#website\"},\"datePublished\":\"2020-04-27T14:45:31+00:00\",\"dateModified\":\"2025-09-03T09:50:32+00:00\",\"description\":\"Your comprehensive guide to create your own payslip using the free payslip template complete with instructions and template checklist.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/factorialhr.com\/blog\/#website\",\"url\":\"https:\/\/factorialhr.com\/blog\/\",\"name\":\"Factorial\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/factorialhr.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/factorialhr.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/factorialhr.com\/blog\/#organization\",\"name\":\"All-in-one business management software - Factorial\",\"url\":\"https:\/\/factorialhr.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/factorialhr.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/factorialhr.com\/wp-content\/uploads\/2023\/07\/18155144\/factorial-logo.png\",\"contentUrl\":\"https:\/\/factorialhr.com\/wp-content\/uploads\/2023\/07\/18155144\/factorial-logo.png\",\"width\":946,\"height\":880,\"caption\":\"All-in-one business management software - Factorial\"},\"image\":{\"@id\":\"https:\/\/factorialhr.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/Factorial\/100064908455810\/\",\"https:\/\/twitter.com\/factorialapp\",\"https:\/\/www.linkedin.com\/company\/factorialhr\",\"https:\/\/www.youtube.com\/@factorialmedia\",\"https:\/\/www.instagram.com\/factorial\/#\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/factorialhr.com\/blog\/#\/schema\/person\/b9093d450bd0137de0f032810e7b1151\",\"name\":\"Viktorija Nikoloska\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/factorialhr.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/72290ec8440d0d53b0b003fa417fd396?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/72290ec8440d0d53b0b003fa417fd396?s=96&d=identicon&r=g\",\"caption\":\"Viktorija Nikoloska\"},\"description\":\"Content and Outreach Marketing Specialist with experience in the Marketing industry since 2015.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/viktorijanikoloska\/\"],\"url\":\"https:\/\/factorialhr.com\/blog\/author\/viktorija\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating an Employee Payslip [Free Payslip Template Excel]","description":"Your comprehensive guide to create your own payslip using the free payslip template complete with instructions and template checklist.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/","og_locale":"en_US","og_type":"article","og_title":"Creating an Employee Payslip [Free Payslip Template Excel]","og_description":"Your comprehensive guide to create your own payslip using the free payslip template complete with instructions and template checklist.","og_url":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/","og_site_name":"Factorial","article_publisher":"https:\/\/www.facebook.com\/people\/Factorial\/100064908455810\/","article_published_time":"2020-04-27T14:45:31+00:00","article_modified_time":"2025-09-03T09:50:32+00:00","og_image":[{"width":795,"height":450,"url":"https:\/\/factorialhr.com\/wp-content\/uploads\/2020\/04\/27151533\/payroll-template.jpg","type":"image\/jpeg"}],"author":"Viktorija Nikoloska","twitter_card":"summary_large_image","twitter_creator":"@factorialapp","twitter_site":"@factorialapp","twitter_misc":{"Written by":"Viktorija Nikoloska","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/#article","isPartOf":{"@id":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/"},"author":{"name":"Viktorija Nikoloska","@id":"https:\/\/factorialhr.com\/blog\/#\/schema\/person\/b9093d450bd0137de0f032810e7b1151"},"headline":"Creating an Employee Payslip [Free Payslip Template Excel]","datePublished":"2020-04-27T14:45:31+00:00","dateModified":"2025-09-03T09:50:32+00:00","mainEntityOfPage":{"@id":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/"},"wordCount":2555,"commentCount":5,"publisher":{"@id":"https:\/\/factorialhr.com\/blog\/#organization"},"articleSection":["Legal &amp; Finance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/factorialhr.com\/blog\/payslip-template-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/","url":"https:\/\/factorialhr.com\/blog\/payslip-template-excel\/","name":"Creating an Employee Payslip [Free Payslip Template Excel]","isPartOf":{"@id":"https:\/\/factorialhr.com\/blog\/#website"},"datePublished":"2020-04-27T14:45:31+00:00","dateModified":"2025-09-03T09:50:32+00:00","description":"Your comprehensive guide to create your own payslip using the free payslip template complete with instructions and template checklist.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/factorialhr.com\/blog\/payslip-template-excel\/"]}]},{"@type":"WebSite","@id":"https:\/\/factorialhr.com\/blog\/#website","url":"https:\/\/factorialhr.com\/blog\/","name":"Factorial","description":"","publisher":{"@id":"https:\/\/factorialhr.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/factorialhr.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/factorialhr.com\/blog\/#organization","name":"All-in-one business management software - Factorial","url":"https:\/\/factorialhr.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/factorialhr.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/factorialhr.com\/wp-content\/uploads\/2023\/07\/18155144\/factorial-logo.png","contentUrl":"https:\/\/factorialhr.com\/wp-content\/uploads\/2023\/07\/18155144\/factorial-logo.png","width":946,"height":880,"caption":"All-in-one business management software - Factorial"},"image":{"@id":"https:\/\/factorialhr.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/Factorial\/100064908455810\/","https:\/\/twitter.com\/factorialapp","https:\/\/www.linkedin.com\/company\/factorialhr","https:\/\/www.youtube.com\/@factorialmedia","https:\/\/www.instagram.com\/factorial\/#"]},{"@type":"Person","@id":"https:\/\/factorialhr.com\/blog\/#\/schema\/person\/b9093d450bd0137de0f032810e7b1151","name":"Viktorija Nikoloska","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/factorialhr.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/72290ec8440d0d53b0b003fa417fd396?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/72290ec8440d0d53b0b003fa417fd396?s=96&d=identicon&r=g","caption":"Viktorija Nikoloska"},"description":"Content and Outreach Marketing Specialist with experience in the Marketing industry since 2015.","sameAs":["https:\/\/www.linkedin.com\/in\/viktorijanikoloska\/"],"url":"https:\/\/factorialhr.com\/blog\/author\/viktorija\/"}]}},"_links":{"self":[{"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/posts\/16189"}],"collection":[{"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/comments?post=16189"}],"version-history":[{"count":49,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/posts\/16189\/revisions"}],"predecessor-version":[{"id":167377,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/posts\/16189\/revisions\/167377"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/media\/16201"}],"wp:attachment":[{"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/media?parent=16189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/categories?post=16189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/factorialhr.com\/blog\/wp-json\/wp\/v2\/tags?post=16189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}