Free Australian payslip template (Excel)
Every field is labelled with the regulation that requires it, so you can see at a glance whether a pay slip is complete. Gross, deductions and net pay are formulas, not typed numbers, so edited rows stay correct. Download, fill in, issue.
Payslip template
Excel format (.xlsx) • Ready to download
No signup required
This payslip template lays out the fields required by Fair Work Regulations 2009 reg 3.46 and is a general tool only — not legal, financial or tax advice. It totals the figures you enter; it does not determine award coverage, pay rates, PAYG withholding or superannuation, and using it does not by itself make a pay slip correct. The amounts remain the employer's responsibility. Verify your obligations with Fair Work and the ATO. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
Check the award rate first
A payroll sheet is only as right as the rates going into it. Estimate the correct modern award rate before you run pay — free, no signup.
What's in this template
Grouped by the subregulation each field satisfies
Employer name and ABN
Both required — reg 3.46(1)(a) and (h). The ABN has been mandatory on every pay slip since 1 January 2010, with the employer's address as the fallback where there is no ABN.
Employee name
Required by reg 3.46(1)(b), with an optional classification field so award-covered staff can see the level they were paid at.
Pay period and date paid
Two separate requirements under reg 3.46(1)(c) and (d) — the date the money landed is not the same as the period end, and conflating them is a common error.
Ordinary rate, hours and amount
Reg 3.46(3) wants all three for hourly-paid staff, not just a total. The amount column is a formula so it follows the rate and hours you enter.
Six itemisation rows
Pre-formatted blank lines for penalty rates, overtime, loadings, allowances and bonuses, because reg 3.46(1)(g) requires each to be separately identifiable.
Deductions with destinations
An amount column and a fund-or-account column side by side — reg 3.46(2) requires both, and the second is the one usually left off.
Gross and net formulas
Gross sums the earnings block, net subtracts total deductions. Reg 3.46(1)(e) and (f). Add or delete rows and the totals still hold.
Super amount and fund
Reg 3.46(5) asks for the contribution and the fund name together, with the reg 3.46(5A) first-pay-slip exception noted on the sheet.
Optional extras, clearly marked
Year-to-date totals and leave balances sit in their own block labelled as NOT required by reg 3.46, so you can keep or delete them knowingly.
How to use the payslip template
Four steps, then issue within one working day
1. Download and duplicate
Save one copy per employee per pay period, or duplicate the sheet inside a single workbook. Keep the regulation labels — they are how you check the pay slip is complete.
2. Enter the ordinary hours
Put the ordinary hourly rate and the hours worked at it in their columns; the amount calculates itself. For salaried staff, use the annual rate field instead, per reg 3.46(4).
3. Itemise everything else
Give each penalty rate, allowance, loading and bonus its own line. This is the requirement most pay slips fail, and it is also what lets an employee check their own pay.
4. Issue within one working day
Section 536 of the Fair Work Act gives you one working day from paying the employee, in electronic form or hard copy. Export to PDF, or use the online generator to skip the spreadsheet entirely.
Who uses this template
For anyone who has to issue a compliant pay slip
Small employers without payroll software
A handful of staff, no payroll subscription, and a legal obligation that applies regardless of size.
Casual and shift-based teams
Where penalty rates and casual loading have to appear as separate lines rather than one blended hourly figure.
Fixing historical pay slips
Reissuing corrected pay slips after an audit or an underpayment finding, with the required fields visible.
Checking a payroll provider's output
Use it as a checklist against what your software actually produces — missing fields are common.
Want pay slips that build themselves?
A spreadsheet works, but you are re-keying hours, rates and penalties every run — which is exactly where itemisation errors creep in. RosterElf turns approved timesheets into payroll-ready data with award rates already applied and pushes it to Xero or MYOB, so the itemised lines come from the roster rather than from retyping.
Payroll templates and tools
The steps either side of issuing a pay slip
Payslip generator
Build a pay slip in the browser with a live check against every reg 3.46 field, then download the PDF.
Open the toolPay run checklist
The steps to work through before you finalise and pay, so pay slips are right the first time.
Get the checklistPayroll reconciliation template
Cross-check rostered, timesheet and paid hours to catch variances before pay day.
Get the templatePayroll preparation worksheet
Gather and check every input for a pay run in one place.
Get the worksheetAward pay rate guides
Minimum rates, penalties and allowances for 34 modern awards — where the pay slip figures come from.
Browse the guidesTimesheet calculator
Turn clock-in and clock-out times into the payable hours a pay slip has to show.
Open the toolPayslip template FAQ
-
Yes — no signup, no email gate and no watermark. Download the .xlsx and use it as often as you like, including commercially. If you would rather not work in a spreadsheet, the payslip generator produces the same fields as a PDF in the browser.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it directly in Apple Numbers — the formulas for gross, total deductions and net pay all carry across, because they are plain
SUMand arithmetic rather than anything Excel-specific. -
Yes, and the totals will follow. Gross sums the earnings block and net subtracts total deductions, so inserting a row inside either block is picked up automatically. If you add rows below the last line of a block, check the
SUMrange still covers them. -
Because those labels are the point. Most free payslip templates look tidy and quietly omit a required field — commonly the ABN, the hours behind an hourly rate, or the superannuation fund name. Labelling each field with its subregulation means you can audit a completed pay slip in about ten seconds without looking anything up.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws, awards and workplace requirements.