Gross-to-Net Pay Calculator

All versionsPercent

Take gross pay down to take-home. Stack the deductions — taxes, benefits, retirement — subtract them from gross, and you have net pay. The pattern is just percentages and subtraction, kept tidy and rounded.

Quick formula: for gross in B1 and a combined deduction rate, net is:

=B1 - ROUND(B1*taxRate, 2) - ROUND(B1*retireRate, 2) - fixedDeductions

Compute each deduction from gross, round to cents, and subtract. The remainder is net (take-home) pay.

Functions used (tap for the full reference guide):

ROUND SUM

The example

Gross $4,000 with tax, retirement, and a fixed benefit deduction.

	A	B
1	Item	Amount
2	Gross	$4,000.00
3	Tax 18%	−$720.00
4	401(k) 5%	−$200.00
5	Benefits	−$150.00
6	Net pay	$2,930.00

The formula

Subtract each deduction from gross:

=B2 - ROUND(B2*0.18,2) - ROUND(B2*0.05,2) - 150 // $4,000 → $2,930 net

How it works

Each deduction is a slice of gross, then subtracted:

Compute percentage deductions from gross: tax = gross × taxRate, retirement = gross × rate. ROUND each to 2 decimals.
Add any fixed deductions (benefits, parking) as flat dollar amounts.
Net pay = gross − (sum of all deductions).
Keep each deduction in its own cell so the stub is auditable; the net formula just subtracts the column.

This is a simplified model. Real payroll has pre-tax vs post-tax order, wage caps (Social Security), bracketed withholding, and local rules. Use this for estimates and illustration — not as a substitute for payroll software or tax advice.

Try it: interactive demo

Live demo

Set gross, tax %, retirement %, fixed deductions.

Gross $

Tax %

401k %

Fixed $

Net pay

Variations

Pre-tax retirement

Reduce taxable pay first:

=(B2 - retire) * (1 - taxRate) - benefits

Effective take-home %

Net as a share of gross:

=net / B2

Annual from per-period

Scale up:

=net * paychecksPerYear

Pitfalls & errors

Order of deductions matters. Pre-tax items (401(k), some benefits) reduce taxable pay before tax is computed. Model the order your situation actually uses.

Round each deduction. Rounding only the final net can leave the stub’s lines not adding up to the total.

Not tax advice. Real withholding uses brackets and caps. Treat this as an estimate.

Practice workbook

📊

Download the free Gross-to-Net Pay Calculator practice workbook

A gross-to-net stub with percentage + fixed deductions, the pre-tax, take-home-%, and annualize variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate net pay from gross in Excel?

Compute each deduction from gross (rounded to cents), then subtract them all: =gross - ROUND(gross*taxRate,2) - ROUND(gross*retireRate,2) - fixedDeductions.

How do I handle pre-tax deductions?

Subtract pre-tax items from gross before applying tax: =(gross - preTax) * (1 - taxRate) - postTaxDeductions.

Is this accurate for real payroll?

It's a simplified estimate. Real payroll uses bracketed withholding, wage caps, and pre/post-tax ordering — use dedicated payroll software for official figures.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: ROUND · SUM