If you’re wondering how to calculate payroll deductions without relying on a black-box app, here’s the straight answer: start with gross pay, subtract pre-tax deductions to find taxable wages, multiply that base by the applicable tax rates (federal, state, local, and FICA), then subtract post-tax deductions. The core sequence is Gross = (Hourly × Hours) or (Annual ÷ Periods), Taxable = Gross − Pre-tax, Tax = Taxable × JurisdictionRate, and Net = Taxable − Tax − Post-tax. That’s the entire manual framework. Below, I’ll unpack each variable, show worked numbers for hourly and salaried staff, and give you a printable worksheet I’ve used for years.
The Manual Payroll Deductions Formula Every Practitioner Should Know
When a client first asked me, “what is the formula for calculating payroll?” they expected a single equation. Payroll is actually a pipeline of four linked formulas, and skipping any one invites compliance errors. I compare manual calculation to flying with a checklist versus autopilot: the autopilot (calculators) is efficient, but the checklist reveals why the plane stays up.
Gross Pay: The Only Number You Can’t Derive
Gross is the foundation. For hourly staff, Gross = Hourly Rate × Hours Worked, including overtime premiums if applicable. For salaried employees, Gross = Annual Salary ÷ Number of Pay Periods (e.g., 26 for bi-weekly). I always write this at the top of my worksheet because every downstream figure depends on it.
One misconception: salaried does not automatically mean exempt from overtime. If the role is non-exempt under FLSA, you still multiply hours over 40 by 1.5, even if you call it salary. I’ve corrected this for three nonprofits that misclassified program coordinators.
Pre-Tax Deductions and Taxable Wages
Pre-tax deductions—like traditional 401(k) deferrals, health insurance premiums, and HSA contributions—reduce taxable wages. The formula is Taxable = Gross − Pre-tax. The thing nobody tells you about manual payroll is that some state-specific deductions (e.g., pre-tax transit benefits in New York) may not be exempt from local taxes even when federal law allows them. You must check the locality.
Why Jurisdiction Rate Is Not a Single Number
Answering “what is the formula to calculate payroll tax?” requires splitting the jurisdiction rate into components. Tax = Taxable × (Federal Income % + State Income % + Local % + FICA %). FICA itself is 15.3% total, split between employer and employee; the employee portion is 6.2% Social Security up to the wage base and 1.45% Medicare, plus a 0.9% Medicare surtax above $200,000 per the IRS employment tax rates. You apply these percentages to the taxable base, not gross, when pre-tax items are present.
Net Pay: The Final Subtraction
Post-tax deductions (roth 401(k), garnishments, union dues) come out after tax. Net = Taxable − Tax − Post-tax. Note that net is not simply gross minus everything; the tax calculation already used the reduced taxable base, so double-counting pre-tax as a later subtraction is the most common beginner mistake. Manual math forces you to see that relationship.
How to Figure Out Payroll Deductions for an Hourly Employee
If you’ve ever asked, “how to figure out payroll deduction?” for an hourly worker, the process is a straightforward application of the formulas above. Let’s walk through a real scenario I handled for a barista earning $15/hour with a 401(k) deferral. This also answers “how do I calculate payroll manually?” for non-exempt staff.
Step 1: Compute Gross Including Overtime
Assume 40 regular hours and 5 overtime hours at 1.5× rate. Regular = 40 × $15 = $600. Overtime = 5 × $22.50 = $112.50. Gross = $712.50. Most payroll software hides this breakdown; doing it by hand forces you to verify the overtime multiplier, which is where many miscalculations start.
Step 2: Subtract Pre-Tax Deductions
She contributes 5% of gross to a traditional 401(k): $35.63. Taxable wages = $712.50 − $35.63 = $676.87. Note: the 401(k) also lowers FICA taxable amount, a nuance some state calculators miss.
Step 3: Apply Tax Rates
Federal income tax (using simplified 10% for illustration) = $67.69. Social Security (6.2%) = $41.97, Medicare (1.45%) = $9.81. State tax (flat 3% in her state) = $20.31. Local tax (1% city) = $6.77. Total tax = $146.55.
Step 4: Post-Tax and Net
Post-tax garnishment for a student loan = $50. Net = $676.87 − $146.55 − $50 = $480.32. That’s the take-home. When I first ran this by hand, I forgot the city tax and overstated net by $6.77—small, but across 20 employees it’s a $135 reconciliation headache.
For a faster sanity check on these hand figures, I’ll often paste the same inputs into the Payroll Deduction Calculator to confirm the jurisdiction rates haven’t shifted mid-quarter.
How to Calculate Payroll Manually for a Salaried Worker
Salaried payroll looks easier but hides its own traps. The question “how do I calculate payroll manually?” for a salaried person starts with period division. Get this wrong and every later deduction is off.
Step 1: Gross From Annual Salary
A project manager earns $62,400/year, paid semi-monthly (24 periods). Gross per period = $62,400 ÷ 24 = $2,600.00. If you accidentally use 26 periods (bi-weekly), you underpay by $100 per check—a mistake I saw a startup make for three months before a DOL audit.
Step 2: Pre-Tax Adjustments
He pays $200 monthly medical premium (allocated $100 per check) and defers 3% to 401(k) = $78. Pre-tax total = $178. Taxable = $2,600 − $178 = $2,422.
Step 3: Tax Application
Federal income (assume 12% bracket) = $290.64. Social Security = $150.16, Medicare = $35.12. State (4%) = $96.88. No local tax. Total tax = $572.80.
Step 4: Net Calculation and Proration
Post-tax Roth IRA contribution $100. Net = $2,422 − $572.80 − $100 = $1,749.20. The key insight: salaried gross is fixed, but mid-period hires require proration—you can’t just divide annual by periods; you must multiply annual by fraction of year worked. For a start date on the 11th of a 20-workday month, pay (Annual/260)×10.
Applying FICA, Federal, and Local Tax Rates Correctly
The biggest gap in competitor calculators is transparency on rate stacking. Here’s a comparison table I use to train bookkeepers:
| Tax Type | Base | 2024 Employee Rate | Notes |
|---|---|---|---|
| Social Security | Taxable up to $168,600 wage base | 6.2% | Employer matches; see SSA guidelines |
| Medicare | All taxable wages | 1.45% + 0.9% surtax >$200k | No wage cap |
| Federal Income | Taxable wages | 10–37% bracket | Use IRS Pub 15-T percentages |
| State/Local | Varies by jurisdiction | 0–10%+ | Some cities levy flat 1–3% |
This matrix answers the formula for payroll tax concretely: you sum the applicable rates, but only after confirming each base. For example, the Social Security wage base means the 6.2% stops applying once year-to-date hits $168,600, something manual spreadsheets must track cumulatively. I keep a running YTD column for each employee to catch the cutoff.
Federal income tax withholding isn’t a flat percentage; it’s bracketed and allowance-based per IRS Publication 15-T. I often use the percentage method for manual runs because it’s reproducible. Most people don’t realize that claiming “exempt” on a W-4 still requires state withholding in some states—another silent compliance risk.
The Printable Payroll Deductions Worksheet I Use Every Run
Instead of a calculator, I keep a one-page sheet. Here’s the checklist format you can copy:
- Line 1: Employee name, period, pay frequency
- Line 2: Gross (hourly×hrs or salary÷periods) ______
- Line 3: Pre-tax deductions (list each) ______
- Line 4: Taxable = Line2 − Line3 ______
- Line 5: Federal inc tax ______ / SS ______ / Med ______ / State ______ / Local ______
- Line 6: Total tax = sum Line5 ______
- Line 7: Post-tax deductions ______
- Line 8: Net = Line4 − Line6 − Line7 ______
When you’ve filled Line 8, cross-check with the Payroll Deduction Calculator if you process more than five employees; the manual sheet scales poorly but builds intuition. That trade-off is real: hand math teaches you the levers, software prevents arithmetic drift.
I print 30 copies monthly and staple them to timecards. During a 2022 state audit, the auditor praised the paper trail—manual worksheets demonstrate intent to comply, which calculators alone don’t show.
Common Pitfalls That Quietly Break Your Numbers
Overtime Miscalculation
Using straight-time for hours over 40 for non-exempt staff violates FLSA. The premium is 0.5× on top of regular for the overtime hours, not 1.5× of a boosted base—subtle but costly.
Ignored Local Taxes
Over 4,000 US jurisdictions levy local income taxes; many aren’t in federal tables. Missing a 1% city tax is the classic “most people don’t realize…” gap. A client in Pennsylvania withheld zero local tax for a Philadelphia remote worker for six months; the catch-up bill was brutal.
Double-Counting Pre-Tax
Subtracting a 401(k) both before tax and again as post-tax slashes net incorrectly. I’ve audited books where this happened for a year, creating a $3,000 underpayment to the employee.
Wrong Period Count
Bi-weekly (26) vs semi-monthly (24) confusion changes annual totals by 2 paychecks. Always confirm the employer’s established schedule in the offer letter or handbook.
Uncapped Medicare Surtax
The 0.9% Medicare surtax has no wage base cap, but only applies above $200k single. Manual runs must track YTD Medicare wages separately from Social Security wages—a nuance cloud tools handle silently.
My $400 Local Tax Mistake—and What It Taught Me About Manual Payroll
When I first ran payroll for a 12-person landscaping crew in Ohio, I made the mistake of trusting a federal-only calculator. The city of Columbus imposes a 2.5% municipal tax that I’d never seen on a federal form. For one quarter, I under-withheld by about $400 total across the team. The city sent a gentle letter, but the penalty plus interest was wholly avoidable.
Here’s what I learned: manual calculation isn’t just about math; it’s about jurisdiction research. I now keep a spreadsheet of every work location’s local tax ID. The thing nobody tells you about manual payroll is that remote workers create nexus in multiple cities, and you may need to apportion wages by days worked in each. That’s an edge case no generic calculator fully automates.
Advanced Edge Cases: Bonuses, Garnishments, and Mid-Period Starts
Once you master the base formula, real-world wrinkles appear. Bonuses can be taxed at the optional 22% federal flat rate per IRS rules, but state may require aggregate method. Garnishments (e.g., child support) are post-tax but have priority ordering under CCPA; you can’t just subtract them arbitrarily.
Tipped Employees Complicate FICA
For tipped staff, reported tips are added to taxable wages, and the employee still pays 7.65% FICA on them. The employer claims a credit for the employer share, but the manual net formula stays the same—just ensure tips are in Line 2 gross. I’ve seen servers shorted because tips were left out of gross entirely.
Mid-Period Salary Changes
If a salaried employee gets a raise on the 1st, easy. But a promotion on the 15th of a semi-monthly period requires splitting the period: old salary/24 for first half, new for second. Manual spreadsheets need a date-effective rate table. This is where most payroll errors hide.
Finally, remember that pre-tax deductions often have cafeteria plan limits; exceeding them becomes taxable. Manual runs force you to read the plan document, not just trust a checkbox. The limitation of hand calculation is speed; the advantage is comprehension. Use both, and you’ll answer any “how to calculate payroll deductions” question with confidence.