Tax Statement

Bernard linked to these spreadsheets on the Treasury website, which include the details of the spending allocated in the budget.

So using this and plugging in the basic income tax rates from the IRD site, I’ve put together this simple spreadsheet to implement the idea I mentioned here last week, breaking the total tax paid amount down by government department:

Tax Statement Generator

At the top are the usual suspects: Transport, Health and Education.  Towards the bottom some of the smaller and lesser known departments: Archives, Women’s Affairs, and the Serious Fraud Office.

By default it shows the breakdown for the average household income ($67,973 as at 30 June 2007, according to Statistics New Zealand).

If you like you can also download a copy and enter your own income at the top to see how much tax you paid and how it will be spent.

There are probably lots of things that I could add into this – for example, at the moment it doesn’t account for Kiwisaver, or Working For Families.  If somebody wants to have a hack at the underlying spreadsheet drop me a line and I’ll invite you in as an editor in Google Docs.

What do you think?  Surprised by the results?

8 Responses to “Tax Statement”


  1. 1 Ed Corkery June 8, 2008 at 8:25 pm

    Astonished that the IRD’s budget is so large.

    More details here:
    http://www.ird.govt.nz/aboutir/reports/annual-report/annual-report-2007/part-5/ar-2007-part5-statements.html#performance

    And $40 million in just one year on consultants and contractors doing “Projects and information technology”:
    http://www.ird.govt.nz/aboutir/reports/annual-report/annual-report-2007/additional-info/ar-2007-additional-information-widepage.html#fig-42

    That’s 2.6 x the previous years expenditure in the same category.

  2. 2 Jeffrey June 8, 2008 at 9:35 pm

    It would be interesting to see the difference in taxes paid between other countries as well. I don’t imagine that the same salary would be taxed the same amount in America, or spent in the same areas of government. Very useful though, I wonder how other parties would prioritize spending in those categories…

  3. 3 Ben June 9, 2008 at 9:09 am

    You should throw this up on its own url – it might get a life of its own if the media pick up on it. People will love to see where the government is spending their individual taxes!

  4. 4 Johnny-johnny June 9, 2008 at 10:49 am

    Along the same vein as Kiwisaver and WfF… you need to account for the tax the average household pays thanks to GST, ciggies, petrol, alcohol, etc.

  5. 5 Johnny-johnny June 9, 2008 at 11:44 am

    P.S. Is Govt spending next year really going to be $93billion!?!?!?

  6. 6 Lee McClelland July 23, 2008 at 11:44 am

    Imagine if we could vote online as to how our Tax money is actually distributed.

    Business could vote on their company Tax & GST distribution and Families could vote on their personal Tax and GST component distribution.

    It would give a good indicator to the requirements of both.

    Dictators wouldn’t like the idea I’m sure.

    Thanks for the interesting article.

  7. 7 Minister of Finance November 28, 2008 at 1:01 am

    The Ministry of Justice revenues over $3 Billion Dollars last year. Your $212 does not equate. It would more like $1,000 per person. And, although these figures would be hard to calculate on a broad spectrum, there is no justification as to what we at the IRD spend your money on. I’ll let you into a secret though, the IRD, Ministries of Transport & Justice all belong as private corporations with Her Majesty the Queen in Right of New Zealand. It all boils down to who owns who. You keep on paying like obedient TAX PAYERS and we’ll keep on spending like crazy. Cheers, and Bottoms UP!


  1. 1 How my taxes are spent in the United States vs. New Zealand | jeffrey Trackback on June 9, 2008 at 4:09 pm
Comments are currently closed.



Enter your email address to receive notifications of new posts by email.

Latest Links

Books for sale

Buy my old books at Fishpond

Fishpond Logo Borderless

Categories

Companies

Latest tweets

Older Posts

Contact Details

Rowan Simpson
PO Box 3210
Wellington, 6140
New Zealand
Twitter: rowansimpson

Policy

These words are my own. Please don't assume that they represent the opinion of any other person or organisation.

And, if you want to quote me please either ask first or provide a link back.