Free Australian Income Tax Excel Spreadsheet Calculator

This free to download Excel tax calculator has been updated for the 2021-22 and later years 2022-23, 2022-24 and 2024-25 and includes the March 2022 Budget increase of $420 to the Lower and Middle Income Tax Offset for the 2021-22 year.

The current version of the Excel spreadsheet (xlsx) has separate tabs for tax years 2018 to 2024-25.

The sheet runs on simple formulae and does not contain macros. MS Excel for Windows PC version is required.

The tax rates used are the official tax rates as legislated by parliament and published by the Tax Office.

Please bear in mind that tax rates for future years are included in the calculator for convenience, but can be changed at any time according to government policy.

Useful as a planning tool, this spreadsheet tax calculator provides current adult resident tax rate calculations, with LITO, LMITO, manual medicare selectors and a scratch pad area where you can review the results with adjustments and after-tax calculations.

This is a simple spreadsheet calculator which enables the calculation of income tax plus Medicare Levy and LITO/LMITO for taxable income on an annual basis. (For periodic income payments, there is a calculator for tax instalment PAYG purposes here.)

Get the free calculator

[Budget 2022 Update 29 March 2022] Tax calculations have been updated to include the Lower and Middle Income Tax Offset increase of $420 for the 2021-22 year. More details on the LMITO page.

This page was last modified 2022-04-01