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.

#monthly payslip excel templates

Excel Payslip Template