Tax Withheld Spreadsheet Calculator

Free Download

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

The tax instalment rates for the tax years ended 30 June 2022, 2023 and 2024 in place since 13 October 2020 remain unchanged with the exception of student debt calculations.

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 options 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 using 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 each of the tax years from 1 July 2021. 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 2023-24 calculator has updated student loan repayments applying from 1 July 2023, but is otherwise the same as 2022-23.

2022-23 calculator

2023-24 calculator

This page was last modified 2023-06-12