Simple Payroll Calculator - Pay Run Template for Small Business

Free Payroll Calculator for Small Business – PAYG, Super and Net Pay in One Sheet

Running payroll doesn’t have to mean expensive software. This free payroll
calculator for small businesses in Australia lets you calculate gross pay, PAYG
withholding, superannuation at 11.5% SGC, and net pay for each employee –
in one straightforward Excel spreadsheet. STP-ready summary included.

What You Get :

  • Per-employee pay run with Gross Pay, PAYG Withholding estimate, Super
    (11.5% SGC), and Net Pay
  • Supports Weekly, Fortnightly and Monthly pay frequencies
  • PAYG Withholding auto-estimated from gross pay (flag to verify with ATO Tax
    Withheld Calculator)
  • Super calculated at 11.5% SGC (2024-25 rate — update cell H4 if rate
    changes)
  • Pay Run Totals row for payroll summary
  • STP Ready flag column — checklist before lodging with Sole App’s STP
    reporting feature

Who It’s For :

Small business owners, sole traders who employ one or more people, and
anyone doing their first payroll run and wanting a simple reference before
moving to in-app payroll.

ATO / Compliance Note :

From 1 July 2018, Single Touch Payroll (STP) is mandatory for all employers in
Australia. This template prepares your pay run data for STP lodgement via Sole
App. PAYG withholding must be reported and paid to the ATO each quarter (or
monthly for large withholders).


FAQ :

Is the PAYG withholding calculation accurate?

The template uses an estimated 32.5% withholding rate as a guide. For exact
amounts, use the ATO’s Tax Withheld Calculator at ato.gov.au/calculators.
Always verify before lodging.

What is the SGC rate for 2024-25?

11.5%. It increases to 12% from 1 July 2025. Update cell H4 when the rate
changes.

What is STP and do I have to use it?

Single Touch Payroll (STP) requires you to report employee pay, tax and super
to the ATO each time you run payroll. Sole App’s Payroll feature handles STP
Phase 2 reporting automatically.