Payroll summary sheet

This prompt is designed to work in Microsoft Copilot in Excel. Paste into the Copilot chat sidebar.

Help me build a monthly payroll summary sheet that pulls together gross wages, super, PAYG withholding, and net pay per employee. AU rules apply.

Here is what I have:
- Number of employees: {{headcount}}
- Pay cycle: {{cycle}}
- What data I already have exported and from where: {{source}}
- Which totals I need at the bottom: {{totals}}
- Who will read this: {{audience}}

Please give me:
1. The column structure by employee: Name, Award or role, Hours, Gross, PAYG, Super (SG rate applied), Deductions, Net.
2. The formulas for gross to net, using named cells for the SG rate and tax scale reference so I can update them in one place.
3. A totals row with SUM plus a check that Gross = PAYG + Deductions + Net.
4. A separate STP-ready summary block showing totals by category.
5. A short reminder list of the AU compliance items I should have on file (super paid on time, TFN declarations, single touch payroll lodged).

I am not asking you to give tax advice, just help me structure the sheet.

Tone: helpful bookkeeper. AU English, no em-dashes.