To print this page click here, alternatively you can use our GST Calculator to help with your calculations or check your work. Firstly we can see that overall the formula is GST Content =((BASE*3)/23) which on $100 is $13.04.
In the example below, we can see that this calculation is slightly harder, but using the formula can be found quite easily. GST Calculator GST Calculation Formula Example of GST Calculation Tax Calculation under GST Impact of GST on Product Pricing GST Bill Rates and Its. From that point, all we have to do is add the new found GST content ($15) to the base figure ($100) to get the new GST inclusive figure of $115. Given that the rate of GST that we are using is 15% (which is written as 0.15 as a decimal) we can see that in this example we have the base ($100) and to that we have to add the GST of the original amount which in this case is (15% of $100). In the example you see below, we have started with a base figure of $100. For the example below, the base will always be $100 to keep things simple. If you are wanting to add GST, then the base would be the price without GST alternatively if you are looking at finding the GST content of a figure, then the base is the GST inclusive figure.
A very good advance tax calculator in excel. After downloading, open the advance tax calculator file in excel.
#How to calculate gst in excel download#
The formula for calculating GST in New Zealand has changed since the rise in GST, however it is still relatively straight forward.īefore we start, we should understand that all GST calculation is relative to the "base" which is the original figure that you have. Download the above attached, advance tax calculator excel file. Download Monthly GST Input Output Tax Report Excel Template.Manage your GST data for multiple months with balance carried forward from the previous month.