Commission statement builder
Create a downloadable illustrative worksheet with source references, rates and a reconciled total.
Illustrative commission total
$43.00- Combined basis
- $130.00
- Source rows
- 3
Illustrative calculation · AUD where amounts are shown.
| Reference | Date | Item | Basis AUD | Rate % | Commission AUD |
|---|---|---|---|---|---|
| S-101 | 2026-09-21 | Cut and finish | $200.00 | 40% | $80.00 |
| S-102 | 2026-09-22 | Shampoo | $30.00 | 10% | $3.00 |
| R-101 | 2026-09-23 | Partial refund | -$100.00 | 40% | -$40.00 |
See how the number is made.
Use exactly the headers Reference, Date, Item, Basis and Rate. Dates must use YYYY-MM-DD and fall inside the selected period. The download is an illustrative commission worksheet with your supplied assumptions. It is not a payslip, payroll submission or evidence that a payment was made.
The working
Statement total = sum of each source basis × its row rate, rounded line by line.
The three sample rows produce $80.00, $3.00 and −$40.00, for a $43.00 worksheet total.
- Illustrative commission worksheet for Mia Chen · Example salon · 2026-09-21 to 2026-09-27.
- Supplied assumptions: Entered bases exclude supplied tax. Service rate 40%; retail rate 10%. Refund shown as a mathematical adjustment.
- AUD. Monetary results use nearest-cent rounding; exact half cents round away from zero.
- This is not a payslip, payroll submission or confirmation of payment. Source decisions, employment requirements and payment execution are outside this tool.
Use the calculation basis and rules you have agreed. A tool result is a working record; it does not establish an entitlement or send a payment.