Sole Trader Rate Calculator (Australia) - What to Charge per Hour and per Day after Tax, Super and Costs | Web App + Excel

NEW (24 Oct 2026): Google Sheets edition included. Your download now has the Excel workbook plus a PDF with a one-click link to make your own Google Sheets copy (same formulas, checked cell by cell against the Excel version).

Built and checked by a CPA. Every formula tested against a separate calculation. 30-day money-back guarantee.

NEW in version 1.2 (22 Oct 2026): every tab now looks and works like an app screen, not a worksheet: no gridlines or row numbers, a branded header with a one-line instruction on each tab, Home and Dashboard links, cleaner tables and clearly marked input cells. Same tested formulas: every result was checked identical to the previous version.

NEW in version 1.1: a one-page Dashboard with your hourly rate, day rate, revenue needed and job quote at a glance, a clickable Home page that takes you to every tab, and a cleaner layout throughout. Same tested formulas.

Know exactly what to charge. Start with the take-home pay you want and see the hourly and day rate you need after income tax and Medicare, super, business costs, holidays and unbilled time.

What it works out

• Revenue you need per year and per working week
• Hourly and day rate, with and without GST
• Where your revenue goes: business costs, tax, super and take-home pay
• How much of every invoice to set aside for tax and super (and the GST to put aside)
• The employee salary that gives the same take-home pay and super
• A quote for a job: labour at your rate plus materials with your markup, the GST, and your real margin
• Warnings if your revenue means you must register for GST, or your super is above the concessional cap

What you get

• Interactive web app (.html): opens in any browser and updates as you type
• Excel workbook (.xlsx): the same calculator, with tax rates you can edit

How it was checked

• The web app and Excel give identical results to a separate reference calculation across thousands of test cases; the pay solver lands on your take-home pay to the cent.

Good to know

• Resident tax rates for 2026-27 or 2027-28, the 2% Medicare levy with the low-income reduction, no tax offsets. Super is treated as a deductible personal contribution (the 15% tax inside your fund is not shown).
• Designed by Plain Numbers Co with the help of AI tools.

Get it with the GST & BAS Workbook, Side-Hustle Tax Tracker and 13-Week Cash Flow in the Sole Trader Starter Kit. Save 15% when you buy any 2 or more items with code BUY2SAVE15. Need something different? We build custom spreadsheets: payhip.com/b/Dj7Y6

Important: General information only, not tax, financial or legal advice. Check with a registered tax agent. 30-day money-back guarantee: if it doesn't work for your situation, email hello.plainnumbersco@gmail.com within 30 days. We'll fix it, or refund you in full if you'd rather. This is in addition to your rights under the Australian Consumer Law, which are not excluded.

Licence: for the purchaser's own use. Please do not resell or share the files