danielcompton/gist:6724333

Created September 27, 2013 04:53

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/danielcompton/6724333.js"></script>
Save danielcompton/6724333 to your computer and use it in GitHub Desktop.

Download ZIP

Excel formula for calculating NZ tax paid on annual income.

Raw

gistfile1.txt

=IF(B2<=14000,SUM(B2*10.5%),IF(B2<=48000,SUM(B2-14000)*17.5%+1470,IF(B2<=70000,SUM(B2-48000)*30%+7420,IF(B2>=70001,SUM(B2-70000)*33%+14020))))

Dialga commented May 25, 2023

A modified version of @inspiredearth's formula:
This includes ACC levy of 1.53% and 3% Kiwisaver.
=(($A1-SUMPRODUCT(--($A1>={1;14000;48000;70000;180000}),($A1-{0;14001;48001;70001;180001}),{0.105;0.07;0.125;0.03;0.06}))-($A1*(0.0153+0.03))

Turbo-Jet commented Mar 21, 2024 •

edited

Hi all,
Just created a Google Sheet to help calculate the tax, also the ability to include deductions for Kiwisaver and ACC levy. You can add your custom values to the boxes in green.

https://docs.google.com/spreadsheets/d/1hPtxMEZgM4t4Z2_cyE-G05yDzwvaSKH_f3U48-s9B0o/edit?usp=sharing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment