Excel Payslip Template
A payslip you get as a working Excel file, not a locked PDF. Earnings and deductions side by side, totals that recalculate, and net pay written out in words.
Preview
A simple payslip template in excel. Most payslip templates hand you a finished PDF. This one hands you an Excel file, with the sums still live. Answer the questions, generate it, and what you download is an excel file, .xlsx you can open, adjust and reuse next month; plus a .csv if you want the raw figures.
Payroll is always changing: a bonus may come later, an allowance is prorated, someone's unpaid day is discovered after the run. With a spreadsheet you fix the number in the cell and the totals follow.
The layout
The grid puts earnings and deductions side by side rather than stacked, so the whole picture fits on one screen and one page:
- A header with your company name and address
- Employee details — name, designation, department, date of joining, pay period and days worked
- Earnings on the left, one row per component, with a running total
- Deductions on the right, one row per component, with its own total
- Net pay, calculated as total earnings minus total deductions
- Net pay again in words, the way a cheque states an amount
- Signature blocks for employer and employee, and a footer note
The totals are formulas, not typed numbers
Total earnings, total deductions and net pay are real Excel formulas in the generated file, and they cover exactly the rows you filled. Change an amount after downloading and every total below updates. This is the difference between a spreadsheet and a picture of a spreadsheet, and it is the reason to choose this template over a PDF one.
It also removes the most common payslip error at the source: a total that no longer agrees with the lines above it because someone edited one and forgot the other.
What to put in earnings and deductions
Earnings usually start with basic pay and then whatever your structure adds — housing or rent allowance, transport, meal or shift allowances, overtime, commission, incentive pay, a bonus. Listing each separately is what makes the slip useful to the employee, and to a lender or landlord who later asks them to prove their income.
Deductions typically cover statutory items first; income tax or PAYE, the pension or provident fund contribution, national insurance or social security; followed by anything company-specific: a salary advance, a loan repayment, union dues, unpaid leave.
Name them the way your payroll records name them. A line an employee cannot recognise generates the email you were hoping to avoid.
Why net pay is repeated in words
Writing the amount out — "Nine Thousand Five Hundred Dollars Only" — is a habit borrowed from cheques, and it survives for a good reason: a figure with a misplaced decimal looks plausible, whereas the words next to it do not. It gives the reader a second, independent statement of the same number. This template fills it in for you from the figures you entered, and lets you edit the wording if you want it phrased differently.
How to create your payslip
1. Open the template and click Generate.
2. Enter the company and employee details, the pay period and the days worked.
3. Add your earnings rows and your deduction rows — one line per component.
4. Check the net pay wording, which has filled itself in from the figures.
5. Generate and download the .xlsx, then send it or print it to PDF.
Next month, reopen the document, change the period and the figures that moved, and generate again.
Limitations
The earnings and deductions bands hold eight rows each. That is a deliberate consequence of how the file is built; the totals sit immediately below the bands, so a ninth row would land on top of them. Eight is more than most payslips need; if your structure genuinely runs longer, group related components onto one line rather than listing every item separately.
Who is this for
Small businesses running payroll in a spreadsheet rather than payroll software; office and HR managers who want the file, not just the print-out; accountants and bookkeepers preparing slips for clients who will want to adjust them.
Note: This template is provided for convenience and general information only and is not legal, tax or payroll advice. Which deductions are mandatory, what a payslip must show and how long you must keep records depend on where you and your employee are based. Check your local employment and tax rules, or ask whoever prepares your payroll. A payslip must reflect pay that was genuinely earned and genuinely paid.
- Professional formatting and layout
- Easy customization with guided questions
- Multiple export formats: pdf, xlsx
- Legally reviewed and compliant
- Instant download after generation
What format do I get, and can I edit it afterwards?
You get an Excel file (.xlsx), and a .csv if you want the raw figures. The Excel file is fully editable; this is the point of choosing it over a PDF payslip. Open it, change an amount, and the totals recalculate, because they are real formulas rather than numbers typed in at generation time. Print it to PDF when you are happy with it.
Are the totals calculated automatically?
Yes, twice over. As you fill the form, the net pay wording is worked out from your rows. In the generated file itself, total earnings, total deductions and net pay are Excel formulas covering exactly the rows you filled, so they keep working after you download it. Edit a figure in the file and everything below follows.
How many earnings and deductions rows can I add?
Eight of each. The totals sit directly beneath the item bands, so a ninth row would overwrite them; the limit is a property of the layout rather than an arbitrary cap. Eight is more than most payslips need; if yours genuinely runs longer, group related items onto a single line, which usually reads better anyway.
How do I show my currency?
Enter it as a symbol and it is applied to the number format of every amount cell in the file, so figures display as $1,000.00 without you typing the symbol into each one. That also means they stay numbers rather than text, which is what lets the sums work. The separate currency code is used only when the net pay is written out in words, so it reads 'Dollars' or 'Rupees' correctly.
Why is the net pay written out in words as well as figures?
For the same reason cheques do it: a figure with a misplaced decimal still looks plausible, while the words beside it do not. It gives the reader a second, independent statement of the same amount. This template fills the wording in from your figures and follows them as they change, right up until you type your own version — after which your wording is left alone.
Can I put my company logo on it?
Not on this one. It is a spreadsheet template, and the generator fills cell values rather than placing images, so the header carries your company name and address as text. If a logo matters to you, use one of the HTML payslip templates instead; those place your logo from your company profile and produce a PDF.
What should go under earnings and deductions?
Earnings usually begin with basic pay, then whatever your structure adds; housing or transport allowance, meal or shift allowances, overtime, commission, incentive pay, bonuses. Deductions typically start with statutory items such as income tax, the pension or provident fund contribution and social security, followed by company-specific ones like a salary advance, a loan repayment or unpaid leave. Name each line the way your payroll records name it, so the employee recognises it.
Can an employee use this to prove their income?
Payslips are the standard evidence of income for lenders, landlords and embassies, and this one shows the full earnings-to-net trail alongside the employer and employee details those reviewers look for. Many will ask for a PDF rather than a spreadsheet, so print or export the file before sending it. It must reflect pay that was genuinely earned and paid - producing a payslip for income that was not received is fraud.
Does it work for weekly or fortnightly pay?
Yes. The pay period is free text, so 'August 2026', 'Week 32, 2026' or '1–15 August 2026' all read correctly, and the worked-days field records how much of that period was actually paid. For hourly staff, put the hours and rate in the earnings description; for example 'Regular hours (86 × 25.00)' - so the calculation behind the figure is visible on the slip.
How is this different from your PDF payslip templates?
Purpose, mostly. The PDF templates produce a finished document with your logo, designed to be sent as-is; this one produces a working file designed to be adjusted. If you run payroll in a spreadsheet already, or expect to tweak figures after the fact, take this one. If you want the most presentable thing to hand an employee, take one of the PDF designs.