View Full Version : GST Calculations

Digby

16-01-2011, 10:41 AM

Hi Guys

Any of you traders or retailers out there come up with an easy formula to calculate the GST component and the net of a items retail price.

We used to divide by 9.

Its easy to add on 15% to the net, but going the other way is not so easy. Or even a spreadsheet formula would be a help.

I remember reading years ago that the next easy GST figure would have been 17.5%.

lakewoodlady

16-01-2011, 10:54 AM

try here http://www.kiwitax.co.nz/infobase/43/how-to-calculate-gst-content-when-gst-is-1525.aspx

LL

Terry Porritt

16-01-2011, 11:01 AM

Already been discussed on this forum, try sorting the wheat from the chaff from here:

http://pressf1.co.nz/showthread.php?t=112882 :banana

Paul.Cov

16-01-2011, 11:03 AM

Divide the GST inclusive price by 1.15 to get the amount before GST was added.

Subtract that result from the GST inclusive price to get the GST figure.

Used to be a lot simpler when GST was only 10% at the start. 12.5% was also a breeze to work out but 15 percent is a bit odd ball. 20% is the next higher easy to work out (don't tell the government).

I put the formula supplied by lakewoodlady thru its paces - works for me.

Multiply the full GST inclusive price by 3 then divide that result by 23. The end result will be the GST amount.

lakewoodlady

16-01-2011, 11:47 AM

Divide the GST inclusive price by 1.15 to get the amount before GST was added.

Subtract that result from the GST inclusive price to get the GST figure.

This one works very well. Thanks Paul.Cov

LL

Digby

16-01-2011, 12:10 PM

Great thanks guys

So its multiply the gross by 3 then divide by 23 to get the gst amount

And its divide the gross by 1.15 to get the net amount

Looks like I'll have to throw my Casio MS 8T calculator away.

mikebartnz

16-01-2011, 01:25 PM

PM me with your email addy and I can send you a calculator I did for that purpose that can be made to stay on top of other windows.

Webbnzl

21-01-2011, 03:06 PM

You can also divide the gst inclusive amount by 7.66666666 (Has to be to 8 decimal points) to get the gst portion. Have a look here: http://www.ird.govt.nz/changes/gst/businesses/calculating/

Powered by vBulletin® Version 4.2.5 Copyright © 2019 vBulletin Solutions Inc. All rights reserved.