Payroll Register Template
Every employee, gross to net, totalled for the period.
Details
payroll register templateUploads
Your logo
A photo or picture
Goes on this page only. Drag it anywhere and pull its corner to resize it.
Your signature
Draw it with a finger, a mouse or a trackpad, and it goes on the page like a picture.
Pictures and signatures stay on this device. Nothing is uploaded to a server.
Red highlights mark what is still blank. Click anything on the page to change it. Your draft is kept on this device as you work.
For the period [date] to [date].
| Employee | Role | Gross | Deductions | Net |
|---|---|---|---|---|
| [add one employee per line] |
What is a Payroll Register?
A payroll register is the period-by-period record of what each employee was paid: gross pay, every deduction, employer contributions and net pay, totalled across the workforce. It is what you reconcile the bank payment against, what feeds the general ledger, and what an auditor or a tax authority asks for first. Without it, a single payroll query becomes an exercise in rebuilding a whole month from individual payslips.
Payroll administrators, bookkeepers and small-business owners produce a register every pay run — weekly, fortnightly or monthly. Accountants use it to post the payroll journal and reconcile control accounts. Auditors sample it. Managers use it to check headcount and overtime against budget. It carries most of the workload at year end, when the totals in the register have to agree with the returns filed with the tax authority and with the payments that actually left the bank account.
The columns change with the country. A UK register carries PAYE income tax, employee and employer National Insurance, pension contributions under auto-enrolment and student loan deductions; a US one carries federal and state withholding, Social Security and Medicare, and state-specific items; an Indian one carries provident fund, employee state insurance where applicable, professional tax and tax deducted at source. Retention periods differ too, and are set separately by tax and employment law. Check the current record-keeping requirement with the relevant revenue authority before designing yours.
The register is a record, not a calculation engine, and it does not decide employment status, tax codes or contribution rates — those come from the employee's paperwork, the tax authority and your payroll software. It is not a payslip, which is the individual statement each employee is entitled to and which usually has its own legally required contents. It is not a substitute for the statutory filings themselves. And it is not the place for quiet corrections: an amended figure needs a documented reason, not an overwrite.
What to put in a Payroll Register
These are the details this template asks for. Anything left blank is marked in red on the preview so you can see what is still missing.
| Field | What goes in it |
|---|---|
| Issuing organisation | For example: Maple Grove Homeowners Association |
| Organisation address | For example: 1420 Kinnear Road, Columbus, OH 43212 |
| Period from | Free text |
| Period to | Free text |
| Payroll rows | One per line: Name | Role | Gross | Deductions | Net |
How to write a Payroll Register
Fix the period and the pay date
Head every register with the pay period covered and the actual payment date, because they are different and the tax treatment usually follows the pay date. A December register paid on 2 January falls in a different tax month or year in most systems. Number the runs sequentially, and keep off-cycle runs — bonuses, corrections, final pay — as their own numbered registers rather than merging them in.
List every worker paid, including leavers
One row per person paid in the period, with employee number, name, department or cost centre, and status. Leavers paid part of the month still appear; so do new starters, casual staff and anyone paid an off-cycle amount. A register showing only currently active employees will never reconcile to the bank, and the missing rows are precisely the ones that generate queries.
Build gross pay in its components
Show basic pay, overtime at each rate, allowances, commission, bonus, statutory payments such as sick or parental pay, and any taxable benefit, then total to gross. A single gross figure cannot be checked against a timesheet or a commission statement, and cannot be split between cost centres. Where a component is non-taxable or treated differently, give it its own column rather than netting it off.
Separate employee and employer amounts
Deductions taken from the employee — income tax, social security, pension, loan repayments, union dues, court-ordered attachments — reduce net pay. Employer contributions and employer social security do not, but they are a cost and a liability. Keeping them in distinct column blocks prevents the classic error of understating payroll cost, and makes the journal to the ledger a direct read rather than a reconstruction.
Total, cross-check and lock the run
Total every column, then check three things: gross minus total employee deductions equals total net; total net equals the bank payment or the sum of transfers; and each deduction total equals what you will remit to the relevant authority. Record who prepared and who approved it, then lock the file. Any later change belongs in a correction run with its own record.
Common mistakes
- Recording the pay period date as the pay date, which puts a run in the wrong tax period and produces a reconciliation difference nobody can find at year end.
- Omitting leavers and off-cycle payments, so the register never agrees with the bank and the difference gets written off as unexplained.
- Showing only a single gross figure, which makes it impossible to check overtime against timesheets or split cost between departments.
- Mixing employer contributions into employee deductions, which understates payroll cost in the accounts and misstates the liability owed to the authority.
- Emailing the full register to a manager who only needs their own team, exposing every salary in the company and creating a data protection incident.
Frequently asked questions
What is the difference between a payroll register and a payslip?
The register is the employer's internal record covering everyone paid in the period, with totals; the payslip is the individual statement given to each employee. Payslip contents are often prescribed by law, while the register's format is generally yours to design provided it supports your filings and audits. One feeds the other, but they are not interchangeable, and the register is never handed to employees.
How long do I need to keep payroll records?
Several years in most jurisdictions, but the exact period is set separately by tax law and employment law, and the two do not always match. The UK, the US at federal and state level, Canada, Australia and India each set their own. Take the longest applicable period, and remember that pension and long-service records may need keeping longer than the tax minimum.
Does a payroll register need to be in a specific format?
Generally not — what matters is that it contains the information your tax authority and auditors require, and that it reconciles. Most payroll software produces one automatically; a spreadsheet is acceptable for a small workforce provided it is version-controlled and access-restricted. Check your revenue authority's record-keeping guidance for the data points they expect, rather than for a prescribed layout.
How do I reconcile the payroll register to the bank?
Total the net pay column and compare it with the sum of transfers on the pay date, then account for anything paid outside the main run: cash payments, off-cycle corrections, returned payments from closed accounts, and third-party payments such as attachments paid direct. List each difference by name and reason. A single unexplained variance almost always means a missing or duplicated employee row.
Who should have access to the payroll register?
The smallest possible group — payroll staff, the approver, finance for posting, and auditors on request. Salary data is personal data under most privacy regimes, and a whole-company register is one forwarded email away from an incident. Give managers a filtered report for their own cost centre rather than the full file, and keep the master in a restricted location with access logged.
This page explains general practice and is not legal advice. Requirements differ between countries and, in some cases, between states — check what applies where the document will be used.