Tax Withheld Spreadsheet Calculator

Free Download

This is a downloadable Excel spreadsheet withholding calculator tax tables all-in-one for the 2021-22 year.

The tax instalment rates for 2022-23 (applying from 1 July 2022) remain unchanged with the exception of student debt calculations. An updated calculator will be released by the end of June 2022.

The calculator covers individuals using the ATO’s tax scales 1 to 6, with weekly, fortnightly, monthly and quarterly calculations available.

The tool handles variations for resident, non-resident, and medicare levy reductions and HECS/HELP loan additions.

Calculations do not include variations for Shearers and Horticulturalists, Backpackers, Seniors, super income streams, redundancy and early retirements payments and return to work payments.

Scales 1 to 6 are the most commonly used tax scales, but please check before ordering that the calculator will meet your requirements. Scales 1 to 6 are identified and described here.

The calculations follow the ATO’s tax withholding formulae for the tax year 1 July 2021 to 30 June 2022. Note that these formulae are Tax Office approximations of the tax required from periodic earnings, which may differ from an annual tax calculation.

FREE to download.

The 2021-22 calculator applies until 30 June 2022. The 2022-23 calculator has updated student loan repayments applying from 1 July 2022.

This page was last modified 2022-06-26