Opens in a new tab
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 the 12% super guarantee rate, 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 (12% super guarantee), 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 worked out from the rate in cell H4: set it to 12%, the super guarantee rate for 2026–27

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

Built for sole traders.

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.

important

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).

Get the templates

Enter your details and we'll send them straight to your inbox.

Get the free resource

Simple Payroll Calculator — Pay Run Template for Small Business

Frequently asked questions

Common questions

The template uses one flat estimated withholding rate (32.5% in the file) as a rough guide only; real PAYG withholding depends on each pay and the ATO tax tables. For exact amounts, use the ATO’s Tax Withheld Calculator at ato.gov.au/calculators. Always verify before lodging.

12%. It has been 12% since 1 July 2025 and stays 12% for 2026–27. From 1 July 2026, under Payday Super, employers pay super each payday. If your template shows 11.5% in cell H4, change it to 12%.

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.

General information only, not tax advice.

This page is up to date as at: 28 October 2026