Payroll Calculator Spreadsheet for Small Businesses

Payroll is the single largest expense for most small businesses — and the one with the highest stakes for getting wrong. Underpay an employee and you have a labour dispute. Miscalculate withholding and you owe the IRS penalties. Miss a payroll tax deposit deadline and the penalties accelerate fast: the IRS charges 2% for deposits 1–5 days late, 5% for 6–15 days late, and 10% for deposits more than 15 days late, plus interest. Unlike income tax underpayments, payroll tax penalties are personal — the IRS can hold business owners individually liable under the Trust Fund Recovery Penalty.

The stakes are why most payroll advice says “use software” or “hire a service.” And for businesses with 10+ employees, multiple pay schedules, or complex benefits, that advice is correct. Gusto, ADP Run, and QuickBooks Payroll handle compliance, tax filing, and direct deposits for $40–$150/month plus per-employee fees.

But for the smallest businesses — a sole proprietor with one or two part-time employees, a startup with a three-person team, a family business with a handful of workers — the monthly cost of payroll software may exceed what you save in time, and the learning curve feels disproportionate to the task. If you are running payroll for 1–5 employees on a consistent schedule with straightforward compensation (hourly or fixed salary, no complex benefits), a well-structured spreadsheet handles the calculation reliably.

This spreadsheet calculates gross-to-net pay for each employee, including federal income tax withholding (using the 2026 brackets), FICA taxes (Social Security and Medicare, both employee and employer portions), and placeholders for state income tax withholding. It also tracks your employer payroll tax obligations so you know exactly what to deposit and when.

Disclaimer: This calculator is provided for informational and educational purposes only. It does not constitute tax, legal, or payroll advice. Payroll tax compliance carries significant legal liability. Errors in withholding or deposit timing can result in substantial penalties. Consult a qualified accountant or payroll professional before using this tool for actual payroll processing. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

What the Spreadsheet Calculates#

Per-Employee Gross-to-Net Calculation#

For each employee, you enter their name, filing status (from their W-4), number of dependents or additional withholding amounts, pay rate (hourly or salary), hours worked (for hourly employees) or pay period salary, and any pre-tax deductions (retirement contributions, health insurance premiums if applicable).

The spreadsheet then calculates gross pay for the period, federal income tax withholding (using the 2026 percentage method based on the employee’s W-4 information and the applicable bracket), Social Security tax (6.2% of gross pay up to the $168,600 annual wage base), Medicare tax (1.45% of all gross pay, plus the additional 0.9% on wages exceeding $200,000), state income tax withholding (using a placeholder percentage — you must enter your state’s rate or withholding table), any post-tax deductions, and net pay (the amount the employee receives).

Employer Tax Obligations#

The spreadsheet tracks the employer’s matching obligations separately: the employer’s 6.2% Social Security match, the employer’s 1.45% Medicare match, and federal unemployment tax (FUTA, 0.6% after the standard credit on the first $7,000 of each employee’s wages). State unemployment tax (SUTA) rates vary by state and employer experience rating — the spreadsheet includes a placeholder for your state’s rate.

A summary section shows total employer payroll tax liability per pay period, year-to-date employer tax obligations, and estimated deposit amounts and due dates.

Pay Period Support#

The spreadsheet supports weekly, biweekly, semi-monthly, and monthly pay periods. The withholding calculations adjust automatically based on the pay frequency selected — this is important because the IRS withholding tables are annualised and must be prorated to the pay period.

Annual Summary per Employee#

At year-end, the spreadsheet provides a summary for each employee showing total gross wages, total federal tax withheld, total Social Security and Medicare taxes (employee share), total state tax withheld, and total net pay. These figures correspond to what appears on the employee’s W-2, making year-end reporting straightforward.

The 2026 Payroll Tax Landscape#

Several numbers changed for the 2026 tax year under the OBBBA and annual IRS adjustments.

Federal income tax brackets are permanent under OBBBA at 10%, 12%, 22%, 24%, 32%, 35%, and 37%, with inflation-adjusted thresholds. The spreadsheet uses the 2026 bracket thresholds from IRS Revenue Procedure 2025-32.

Social Security wage base for 2026 is $168,600. Employees and employers each pay 6.2% on wages up to this threshold. Once an employee’s cumulative wages for the year exceed $168,600, Social Security withholding stops for the remainder of the year. The spreadsheet tracks cumulative wages and automatically stops Social Security withholding at the wage base.

Medicare tax has no wage base — the 1.45% rate applies to all wages. The additional 0.9% Medicare tax applies to wages exceeding $200,000 (this is only withheld from the employee; there is no employer match on the additional Medicare tax).

FUTA rate remains 6.0% on the first $7,000 of each employee’s annual wages, with a standard credit of 5.4% for employers who pay state unemployment taxes on time, resulting in an effective rate of 0.6%.

Standard deduction increased to $16,100 (single) and $32,200 (joint), which affects withholding tables. The new $6,000 senior deduction (for employees 65+) may also affect withholding for older workers.

Common Payroll Mistakes That Cost Small Businesses#

Payroll errors are expensive in both direct costs (penalties, interest) and indirect costs (employee dissatisfaction, compliance risk). These are the mistakes the spreadsheet helps prevent.

Misclassifying employees as independent contractors. This is the highest-risk payroll error. If you control how, when, and where someone works, they are likely an employee — not a contractor — regardless of what your contract says. Misclassification exposes you to back taxes (the employer share of FICA for the entire misclassified period), penalties, interest, and potential state labour law violations. The spreadsheet is designed for W-2 employees only — if you are paying 1099 workers, that belongs in your business expense tracking, not your payroll.

Failing to track cumulative wages against the Social Security wage base. If an employee earns above $168,600, Social Security withholding must stop. Over-withholding creates a refund obligation; under-withholding (if you stop too early or start late for a mid-year hire) creates a penalty. The spreadsheet tracks cumulative wages automatically and stops Social Security deductions at the correct threshold.

Missing the deposit deadline. Payroll tax deposits are due on different schedules depending on your total liability — monthly or semi-weekly. Mixing up your schedule or depositing late triggers penalties that escalate rapidly. The spreadsheet tracks your cumulative liability and indicates when deposits are due.

Not accounting for the true cost of employment. When you hire someone at $50,000/year, your actual cost is not $50,000. Add the employer share of Social Security (6.2%), Medicare (1.45%), FUTA (0.6%), SUTA (varies, often 2–4%), and any benefits you provide (health insurance, retirement match). On a $50,000 salary, employer taxes alone add roughly $4,600 — before benefits. The spreadsheet calculates total employer cost per employee so you can budget accurately.

How to Use the Spreadsheet#

Step 1: Collect W-4 information from each employee. Every employee must complete a Form W-4 before their first paycheck. The 2020-and-later W-4 does not use allowances — instead, employees indicate filing status, claim dependents, report other income, and request additional withholding. Enter this information into the spreadsheet for each employee.

Step 2: Set up the pay period and pay date. Select your pay frequency (weekly, biweekly, semi-monthly, or monthly) and enter the pay date. Consistency matters — irregular pay dates complicate withholding calculations and deposit timing.

Step 3: Enter hours and pay rates each period. For hourly employees, enter hours worked (including any overtime, which must be paid at 1.5× the regular rate for non-exempt employees under the FLSA). For salaried employees, the gross pay is the same each period.

Step 4: Review calculations and process payment. Verify that gross pay, withholding, and net pay look correct before issuing paychecks or direct deposits. The spreadsheet is a calculation tool — you still process the actual payment through your bank or payment method.

Step 5: Make timely tax deposits. The IRS requires payroll tax deposits on either a monthly or semi-weekly schedule, depending on your total tax liability. Monthly depositors must deposit by the 15th of the following month. Semi-weekly depositors must deposit within 3 business days of the pay date. The spreadsheet tracks your cumulative liability and indicates deposit amounts due.

Step 6: File quarterly and annual returns. File Form 941 quarterly (reporting total wages, tips, withholding, and employer taxes) and Form 940 annually (reporting FUTA taxes). Issue W-2s to employees by January 31. The annual summary tab provides the figures needed for these filings.

Download: Payroll Calculator — Excel (.xlsx)

When to Switch to Payroll Software#

The spreadsheet works well for 1–5 employees with straightforward compensation. Switch to dedicated payroll software or a payroll service when you hire your 6th employee (the compliance overhead starts exceeding the software cost), you need to manage benefits (health insurance, retirement plans, FSAs — software handles deductions and compliance far more reliably), you operate in multiple states (multi-state withholding is complex enough to warrant automation), you want direct deposit (most payroll software includes integrated direct deposit; spreadsheet-based payroll requires manual bank transfers), or you are spending more than 2 hours per pay period on payroll calculations and recordkeeping.

The leading options: Gusto ($40/month + $6/employee) is the best fit for small businesses wanting a modern, user-friendly platform with benefits administration. QuickBooks Payroll ($50–$130/month + $6/employee) integrates directly with QuickBooks accounting. ADP Run (pricing varies) is the industry standard for growing businesses that will scale beyond 25 employees. Wave Payroll ($20–$35/month + $6/employee) is a budget option for businesses already using Wave’s free accounting.

For integrating payroll costs into your broader business budget, see our small business budget template. For forecasting the cash impact of payroll on your weekly cash position, see our 13-week cash flow forecast. And for calculating your own self-employment tax obligations as a business owner, see our tax estimator spreadsheet.

Frequently Asked Questions#

Can I really run payroll with a spreadsheet instead of software?

For 1–5 employees with simple compensation structures, yes — but with important caveats. You remain personally responsible for correct withholding, timely deposits, and accurate filings. The spreadsheet calculates the numbers; you execute the payments and filings. If you are not confident in your ability to stay current with tax law changes and deposit deadlines, software or a payroll service is the safer choice. The IRS does not accept “I used a spreadsheet” as an excuse for incorrect withholding.

What payroll records am I required to keep?

The IRS requires you to retain payroll records for at least four years after the tax becomes due or is paid, whichever is later. Records must include each employee’s name, address, and Social Security number, total wages paid, withholding amounts, dates and amounts of tax deposits, and copies of W-4s and W-2s. The spreadsheet’s annual summary and pay-period records satisfy most of these requirements if maintained consistently.

How do I handle overtime in the spreadsheet?

Non-exempt employees (most hourly workers) must receive overtime pay at 1.5× their regular hourly rate for all hours worked beyond 40 in a workweek. The spreadsheet includes an overtime hours field — enter regular hours and overtime hours separately, and it calculates total gross pay using the correct rates. Note that some states have additional overtime rules (California requires daily overtime after 8 hours, for example).

What about state payroll taxes?

State income tax withholding varies dramatically — nine states have no income tax, others have flat rates, and many have progressive brackets. The spreadsheet includes a state tax placeholder where you enter either a flat withholding percentage or a per-pay-period amount calculated from your state’s withholding tables. You must research your state’s specific requirements — the spreadsheet cannot automate 50 different state tax systems.

Do I need to withhold taxes for independent contractors (1099 workers)?

No. Independent contractors are responsible for their own tax payments. You do not withhold income tax, Social Security, or Medicare from payments to contractors. You do need to report payments of $600 or more on Form 1099-NEC by January 31. The payroll spreadsheet is for W-2 employees only — contractor payments belong in your business expense tracking.

What is the Trust Fund Recovery Penalty?

If your business fails to deposit withheld employee taxes (income tax and the employee share of FICA), the IRS can assess the Trust Fund Recovery Penalty — equal to 100% of the unpaid trust fund taxes — against any “responsible person” in the business. This can include business owners, officers, and even bookkeepers who had authority over financial decisions. This penalty is personal, not just business — it survives bankruptcy and can be collected from personal assets. This is why payroll tax compliance is non-negotiable.

How do I calculate the employer’s total payroll cost per employee?

Total employer cost per employee includes gross wages, employer Social Security match (6.2% up to the wage base), employer Medicare match (1.45% of all wages), FUTA (0.6% on the first $7,000), SUTA (varies by state, typically 1–5% on the first $7,000–$50,000+ depending on state), and any employer-paid benefits (health insurance, retirement match). The spreadsheet calculates the tax portions automatically. As a quick estimate, employer payroll taxes add approximately 7.65–10% to the gross wage cost before benefits.