Excel tax calculator now updated for 2018-19
The 2018-19 calculator has now been updated to reflect the first set of changes, which include threshold movements and the introduction of a new Low and Middle Income Tax Offset. Legislation for these measures was approved by parliament in June 2018.
Following release of the Budget 2017, the 2017-18 basic tax scale was confirmed as unchanged from the previous year. However the Temporary Budget Repair Levy of 2% on higher incomes ($180,000+) expires on 30 June 2017, and the 2017-18 tax calculator has been updated to reflect this.
The current version of the Excel spreadsheet has separate tabs for tax years 2018 and 2019.
Useful as a planning tool, this spreadsheet tax calculator provides current resident tax rate calculations, with LITO, manual medicare calculations and a scratch pad area where you can check the results with offsets and see after-tax calculations.
This is a simple spreadsheet calculator which enables the calculation of income tax plus Medicare Levy and LITO for taxable income on an annual basis.
The sheet runs on simple formulae and does not contain any macros. MS Excel for Windows PC version is required.
Note: This is an annual tax calculator, which won’t give exactly the same result as the tax instalment calculator which is used for for payroll deduction purposes. That’s because the formulae the ATO use for tax withholdings for payroll purposes (PAYG) are not identical to the actual tax scale. Also due to rounding, some convenient assumptions and a variety of other possible causes, the calculations may not match those of your official tax assessment. The spreadsheet is unprotected, enabling inspection and modification of all formulae if you wish.
This page was last modified 2018-06-27