Skip to content
The title slide and first slides of the Net Pay Calculator template

Net Pay Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Gross pay on an offer letter says little about what lands in your account. This net pay calculator takes the yearly pay for up to two offers and the number of paychecks per year, then subtracts the deductions you list. Each deduction is either a percent of pay or a fixed dollar amount per paycheck and belongs to a group: tax, benefit or savings. The Result tab shows gross, deductions and net per paycheck, net per month and take-home share, plus offer A against offer B and a doughnut of where one paycheck goes.

No tax rate is built in. The sample figures are examples only, so put in your own estimates from the IRS, your state or your pay stub. Because both offers share one deduction list, the comparison is fair for the same benefits and the same retirement choice. Change one rate at a time to see how much it moves take-home pay.

Useful for

  • Compare take-home pay between two job offers
  • Estimate what a raise adds to each paycheck
  • See how a higher retirement contribution changes net pay

What's included

  • 4 tabs: Inputs, Deductions, Result, How to use
  • Inputs: a table
  • Deductions: a table
  • Result: a dashboard with 5 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Inputs tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I calculate net pay from gross pay?

Divide yearly gross pay by the number of paychecks, then subtract taxes, benefit costs and savings contributions from each paycheck. What remains is net pay. The Result tab handles the arithmetic once you list your rates.

Why is my real paycheck different from the estimate?

Withholding depends on your tax forms, filing status, pre-tax benefits and local rules. Because this calculator uses the flat rates you type, expect an approximation and check it against a real pay stub.

How do I compare two job offers by take-home pay?

Put each yearly gross pay in the Inputs tab and apply the same deductions to both. The Result tab shows yearly take-home pay and monthly take-home pay side by side.

  • #financial-calculator
  • #net-pay-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…