Free Excel download β’ Use online β’ Print or share
A Payslip Worksheet is a structured form that calculates and records every component of an employee's pay for a given period β gross earnings by type, all statutory tax withholdings, authorized voluntary deductions, employer contributions, net pay, and running year-to-date totals. It functions simultaneously as a calculation tool, an employee-facing pay statement, and a retained payroll record. Unlike a simple pay summary, a properly completed payslip worksheet shows the arithmetic behind every figure, making it auditable by the employee, a bookkeeper, or a tax authority.
Issuing an undocumented or incomplete pay statement exposes a business to wage-claim disputes, tax-authority inquiries, and employee relations problems β all preventable with a consistent per-period record. When an employee questions a deduction or a tax authority requests payroll substantiation, a well-structured payslip worksheet answers both in minutes. Without it, reconstructing pay calculations from memory or scattered notes is time-consuming and error-prone. Year-to-date fields on each worksheet also feed directly into W-2 preparation, making December reconciliation straightforward rather than a scramble. This template gives you a complete, print-ready payslip you can complete in under 15 minutes per employee and retain as a reliable payroll audit trail.
| If your situation is⦠| Use this template |
|---|---|
| Recording pay for hourly employees with variable hours each period | Hourly Payslip Worksheet |
| Documenting salary payments for full-time salaried staff | Salaried Employee Payslip |
| Tracking contractor payments without statutory deductions | Contractor Payment Record |
| Summarizing payroll costs across all employees for a single period | Payroll Register |
| Calculating commission-based earnings for sales staff | Commission Payslip Worksheet |
| Issuing pay documentation in a jurisdiction requiring bilingual records | Bilingual Payslip Template |
Why it matters: FICA wage bases and income tax brackets change each January. Applying prior-year rates results in either under-withholding β leaving employees with a tax bill β or over-withholding, which reduces their take-home pay unnecessarily.
Fix: Download IRS Publication 15-T and your state's withholding guide at the start of every calendar year and update the worksheet before the first pay run.
Why it matters: Bonuses and commissions added after the initial gross calculation are taxed at the wrong rate, understating withholding and creating year-end W-2 discrepancies that require corrected filings.
Fix: Add all earnings β regular, overtime, and supplemental β to gross pay first, then apply all deduction calculations to that single consolidated figure.
Why it matters: YTD figures feed directly into W-2 preparation. Incorrect cumulative totals mean W-2 boxes will not match payroll records, triggering IRS notices and requiring amended returns.
Fix: When adopting a new template after January 1, manually carry forward YTD totals from the last completed payslip on the old template before processing the next pay run.
Why it matters: Withholding amounts an employee did not authorize β even minor adjustments β exposes the employer to wage claims and erodes employee trust.
Fix: Require a signed or digitally confirmed election form for any change to voluntary deductions and attach it to the corresponding payroll file before processing.
Fill in the company name, the employee's full legal name, employee ID, department, and job title. These fields anchor every record to the correct entity.
π‘ Use the employee's name exactly as it appears on their Social Security card β discrepancies cause W-2 matching failures with the IRS.
Enter the first and last day of the pay period covered and the date the payment will actually be issued or deposited.
π‘ Keep a pay schedule on file so you can pre-fill these dates for the entire year rather than entering them manually each cycle.
Enter hours worked and the applicable rate for hourly employees, or divide the annual salary by the number of pay periods for salaried staff. Add overtime, bonuses, commissions, and shift differentials as separate line items.
π‘ List each earnings type on its own line β this makes it straightforward to audit individual components and supports accurate year-end reporting.
Sum all earnings lines to produce the gross pay total. Confirm this figure includes every supplemental payment before proceeding to deductions.
π‘ Double-check that the gross figure matches what is entered in your payroll journal or accounting software before calculating taxes.
Use the IRS withholding tables (Publication 15-T) and your state's equivalent for the current tax year to calculate federal and state income tax. Apply FICA rates of 6.2% (Social Security) and 1.45% (Medicare) to gross pay.
π‘ Verify the Social Security wage base each January β once an employee's YTD earnings exceed the annual cap, Social Security withholding stops for the remainder of the year.
Record each authorized deduction β health premiums, 401(k) deferrals, HSA contributions, garnishments β on its own line. Confirm each deduction is still active and matches the employee's current election on file.
π‘ Pre-tax deductions (most 401(k) deferrals, HSA contributions, Section 125 premiums) reduce taxable income β ensure they are subtracted before calculating income tax withholding, not after.
Subtract all deduction lines from gross pay to produce net pay. Then add this period's figures to each YTD column so the cumulative totals remain current.
π‘ Reconcile YTD totals quarterly against your payroll ledger β catching drift early prevents a costly correction scramble in December before W-2 preparation.
Export the completed worksheet as PDF and deliver a copy to the employee. Retain the original for your payroll records for a minimum of four years in line with IRS record-keeping guidance.
π‘ Store payslips in a folder organized by year and then by employee ID β this structure makes responding to a payroll audit or employee query a matter of minutes.
A payslip worksheet is a structured form used to calculate and document all components of an employee's compensation for a specific pay period β gross earnings, statutory tax withholdings, voluntary deductions, employer contributions, and net pay. It serves as both a calculation tool and an official pay record distributed to the employee and retained for payroll compliance.
In the United States, federal law does not mandate a written payslip, but most states require employers to provide pay statements showing hours worked, rates, gross pay, and deductions. In the UK, employers are legally required to provide an itemized payslip on or before every payment date. In Canada, provincial employment standards legislation requires written pay statements in most provinces. Check the requirements for the specific jurisdiction where the employee works.
A payslip is an individual document issued to one employee showing their specific pay details for a single period. A payroll register is a company-level summary listing every employee's pay figures side by side for the same period β used for accounting, reconciliation, and tax remittance. Both are typically generated from the same underlying payroll calculation; the payslip is the employee-facing record, and the register is the internal control document.
The IRS recommends retaining payroll records β including individual pay statements β for a minimum of four years from the date the tax was due or paid, whichever is later. The Fair Labor Standards Act requires payroll records for non-exempt employees to be kept for at least three years. Several states impose longer retention requirements; always check the longest applicable period for your jurisdiction.
A worksheet template is sufficient for businesses with fewer than ten employees running a straightforward payroll with standard salaried or hourly pay. As headcount grows, deduction types multiply, or multi-state tax obligations arise, dedicated payroll software reduces manual error risk significantly. The worksheet remains a useful audit and verification tool even for businesses that rely on software.
A complete payslip shows all statutory deductions β federal income tax, state and local income tax, Social Security (6.2%), and Medicare (1.45%) β as well as any voluntary deductions the employee has authorized, such as health insurance premiums, 401(k) deferrals, HSA contributions, and wage garnishments. Each deduction should be listed separately so the employee can verify every withholding against their elections.
Gross pay is the total amount an employee earns before any deductions β base wages, overtime, bonuses, and commissions combined. Net pay is what the employee actually receives after all statutory taxes and voluntary deductions have been subtracted. The gap between the two is sometimes called the deductions total or total withholdings.
Pre-tax deductions β such as traditional 401(k) contributions, Section 125 health insurance premiums, and HSA contributions β are subtracted from gross pay before federal and state income tax is calculated. This reduces the employee's taxable income for the period, lowering the income tax withheld. FICA taxes are still calculated on gross pay for most pre-tax benefit deductions, with the exception of HSA and certain cafeteria-plan contributions.
A payroll register consolidates all employees' pay figures onto a single summary sheet for a given period, used for accounting entries and tax remittances. A payslip worksheet is the individual employee-facing record showing one person's pay breakdown. Both are generated from the same calculations; the register is the internal control tool, and the payslip is the employee's personal record.
An invoice is issued by a seller to a buyer requesting payment for goods or services delivered β typically used by contractors and vendors. A payslip worksheet documents employer-to-employee compensation within an employment relationship, including statutory withholdings that do not appear on any invoice. Using an invoice in place of a payslip for employees creates a misclassification risk.
A timesheet records when an employee worked and how many hours were logged against specific tasks or projects. A payslip worksheet takes those hours as an input and calculates the resulting pay, deductions, and net amount. The timesheet is the source document; the payslip is the financial output derived from it.
An expense report documents out-of-pocket costs an employee incurred on behalf of the business and seeks reimbursement β these amounts are not earnings and carry no tax withholding. A payslip worksheet records compensation subject to statutory deductions. Reimbursements processed through an expense report should not appear as gross pay on a payslip.
Tracking billable-hour bonuses, client entertainment reimbursements, and professional licensing stipends alongside standard salary deductions.
High proportion of hourly and part-time staff with variable hours, tip income reporting, and frequent overtime calculations across short pay periods.
Prevailing wage requirements on public contracts, certified payroll documentation, multi-rate pay for different trade classifications, and union dues deductions.
Shift differentials for nights and weekends, on-call pay, licensure reimbursements, and employer-paid malpractice insurance contributions tracked as separate fields.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small businesses and sole proprietors running payroll for fewer than ten employees with straightforward salaried or hourly pay | Free | 10β15 minutes per employee per pay period |
| Template + professional review | Businesses with multi-rate pay, multiple voluntary deductions, or employees in more than one state | $100β$300 for a payroll specialist or bookkeeper review | 1β2 hours setup, then 15β20 minutes per cycle |
| Custom drafted | Organizations with 20 or more employees, union payroll, certified payroll obligations, or complex multi-jurisdiction tax requirements | $500β$2,000+ for dedicated payroll software implementation or a managed payroll service | 1β2 weeks setup |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
