Excel tax calculator updated to 2019-20
The July 2019 tax amendments approved by parliament include an increase to LMITO which have now been incorporated into the latest spreadsheet calculations for the 2019 and 2020 years.
The spreadsheet tax calculator has also been updated to reflect the 2019 Budget increase in the Low and Middle Income Tax Offset. The basic tax scale for 2019-20 otherwise remains the same as 2018-19.
The current version of the Excel spreadsheet has separate tabs for tax years 2018, 2019 and 2020.
Useful as a planning tool, this spreadsheet tax calculator provides current resident tax rate calculations, with LITO, LMITO 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.
Get the free calculator
Request a download – simply send an email with the words “tax calculator” anywhere within to atotaxrates(at)fastmail.com.
You will be immediately emailed your download link. Your privacy is respected and assured. The email address you provide is only used for this purpose and there is no follow up unless you request something else or have a question.
This page was last modified 2019-07-09