How to Correctly Calculate GST Figures - Kiwi Tax (2024)

How to Correctly Calculate GST Figures - Kiwi Tax (1)

It seems quite a few people are struggling to calculate GST correctly, they are incorrectly subtracting 15% from a GST inclusive amount to find the GST content and exclusive figures. So, we’ve posted a super clear tutorial on how to work out GST figures & as always please ask if you have any questions!

First some basic calculations

Let’s calculate 15% GST for a GST exclusive figure of $100…
$100 x 15% = $15 GST

To get the total GST inclusive figure simply add the GST to the GST exclusive amount…
$100 + $15 GST = $115 GST Inclusive.

Here’s Inland Revenue’s recommended formula to find the GST amount from a GST inclusive price…
GST Inclusive Price X 3 ÷ 23 = GST Amount

Now let’s work backwards

To find correctly calculate GST and GST exclusive amount from the total GST inclusive figure, we’ll use Inland Revenue’s recommended formula of multiplying the inclusive amount by 3 then dividing by 23. Doing this we get…
$115 X 3 ÷ 23 = $15 GST

We now know the GST amount from the GST inclusive figure. Don’t worry about how the multiply by 3 then divide by 23 works, it just does! To work out the GST exclusive amount simply subtract the GST from the GST inclusive amount to get the original GST exclusive figure so…
$115 – $15 GST = $100

We’re now back to the start with a GST exclusive figure. As you can see the $15 GST amount stays the same when adding GST on and finding the GST amount from the inclusive figure – when using the correct formula.

Here’s why subtracting 15% from the GST inclusive figure is incorrect

Let’s calculate and subtract 15% from our $115 GST inclusive figure from above…
15% of $115 = $17.25 (not $15)

$115 – 15% = $97.75 (not $100)

What’s happened is we’ve calculated 15% of the GST inclusive, not 15% of the GST exclusive! The result is quite different and incorrect. From the correct method above we know the exclusive figure is $100 and the GST should be $15

15% of $100 = $15 GST

$115 – $15 GST = $100

We hope this shows exactly why subtracting 15% off the GST inclusive amount is the wrong way to work out the GST content. If you’re still unsure or would like help with your GST returns please ask us!

To make working out GST super easy use the Kiwitax GST Calculator!

About Kiwitax – Award winning business improvement, tax and accounting service

Here’s the thing. As abusiness,rental property owner orstart-up, you get a kick out of having your own gig. But chances are dealing with yourtax and accountingleaves you cold. Good news! We love it, so hand it over to Kiwitax and we’ll look after it all for you.

Whether you deal with us online, by phone or drop into our Napier office, you’ll find a friendly, professional hardworking team ready to work with you, however you keep track of your financial information and from wherever you do business. And all for a fixed price. It takes just two minutes to get a quote.

Plus if you’re at a loss to know how to improve aspects of your business – from growth planning to cashflow management, even tax debt and so much more – we’re all over that too. OurBusiness Improvementadvisors can help you make a plan and put it into action.

Kiwitax are a preferred training provider for Business Improvement services through the Regional Business Partner Network Capability Voucher Scheme. This is a government funded scheme designed to boost business capability by providing funding of up to 50% of approved training programs with specified training providers up to a maximum value of $5000.

If you liked this article and want to make improvements in your business, with quarterly coaching sessions specifically tailored to support you to identify and achieve your business goals, lets chat!

How to Correctly Calculate GST Figures - Kiwi Tax (2024)

FAQs

How to Correctly Calculate GST Figures - Kiwi Tax? ›

Let's calculate 15% GST for a GST exclusive figure of $100… To get the total GST inclusive figure simply add the GST to the GST exclusive amount… $100 + $15 GST = $115 GST Inclusive.

What is the formula for calculating GST in New Zealand? ›

If you have a GST inclusive sales price and wish to calculate the 15% GST component of the total price, you can either divide it by 1.15 or follow this formula: Multiply the total sales price by 3. Divide the result by 23. The answer will be your GST component.

What is the proper way to calculate GST? ›

GST Calculation Formula
  1. GST Amount = (Tax Rate/100) x Amount Excluding GST.
  2. Total Amount (including GST) = Amount Excluding GST + GST Amount.

How do you calculate GST from a total figure? ›

To work out the cost including GST, you multiply the amount exclusive of GST by 1.1. You divide a GST inclusive cost by 11 to work out the GST component.

How do you calculate GST in numbers? ›

The easiest way to calculate GST on a net price (exclusive of GST) is to multiply the amount by 1.1. To calculate the amount of GST on GST-inclusive goods and services, you'll need to divide the amount by 11.

What amount of GST is included in NZ? ›

Tāke hokohoko (GST) GST (goods and services tax)

GST is charged at a rate of 15%. Overview of how GST works for buyers and sellers of goods and services. If you supply goods or services you might need to register for GST. Find out if you need to register and how to do it.

What is the GST percentage? ›

The primary GST slabs for any regular taxpayers are presently pegged at 0% (nil-rated), 5%, 12%, 18% & 28%. There are a few lesser-used GST rates such as 3% and 0.25%. Also, the composition taxable persons must pay GST at lower or nominal rates such as 1.5% or 5% or 6% on their turnover.

Why do we divide by 11 for GST? ›

The value of a taxable supply is the consideration payable for the supply (before GST is added). For example, if the value of the supply is $100, the GST payable is 10 percent of $100, being $10. The price GST inclusive of the supply is $110. To work out the GST paid, you can divide by 11.

Why do we calculate GST? ›

A comprehensive tax levied on the supply of goods and services in India is called Goods and Services Tax. GST was implemented as a single tax system to replace most of the other indirect taxes at that time. GST replaced the other tax systems - Central Excise Duty, Entry Tax, VAT, Octroi, etc.

How do you calculate 2% of an amount? ›

To calculate a percentage, you typically divide the part (the smaller value) by the whole (the larger value), and then multiply the result by 100. This gives you the percentage value as a number between 0 and 100.

How do you divide by 11 to calculate GST? ›

In fact, we need to divide by 11 to find the GST then multiply by 10 to find the GST exclusive price. For example, if we want to find both the GST paid on a $100 product and the GST-exclusive price of a $100 product, use the following steps: $100 divided by 11 = $9.09. $9.09 is the GST.

How to calculate GST in Excel? ›

GST = Original cost price x (Rate of GST/100)

Similarly, SGST and CGST can be calculated. In the above example, GST can be bifurcated into SGST = Rs. 600/- and CGST = Rs. 600/-.

How to calculate GST turnover? ›

Value of all (taxable supplies+Exempt supplies+Exports+Inter-state supplies) – (Taxes+Value of inward supplies+Value of supplies taxable under reverse charge + Value of non-taxable supplies) of a person having the same PAN(Permanent Account Number) across all his business entities in India.

How do you calculate 7 GST from a total? ›

To find the GST from a total, divide the total amount by the 7% divided by 100 plus 1.

How do I make a formula in numbers? ›

Create your own formula

Click the cell where you want the formula result to appear, then enter the equal sign (=). The formula editor opens. Enter a left parenthesis ( to begin your formula. Select a cell to use as the first argument in your formula, or enter a value (for example, a number such as 0 or 5.20).

How to calculate percentage? ›

How Do We Find Percentage? The percentage can be found by dividing the value by the total value and then multiplying the result by 100. The formula used to calculate the percentage is: (value/total value)×100%.

What is exempt from GST in NZ? ›

Some goods and services are exempt from GST. Financial services, residential rent, and donated goods sold by non-profits fall into this category. You should never charge GST on exempt goods or services. And if they're all you sell, then you can't register for GST.

How to add GST to an invoice? ›

Include the total price of the goods or services, with a statement that indicates 'all prices include GST', or. Include the GST as a line item for each individual good or service.

Top Articles
Latest Posts
Article information

Author: Madonna Wisozk

Last Updated:

Views: 6370

Rating: 4.8 / 5 (48 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Madonna Wisozk

Birthday: 2001-02-23

Address: 656 Gerhold Summit, Sidneyberg, FL 78179-2512

Phone: +6742282696652

Job: Customer Banking Liaison

Hobby: Flower arranging, Yo-yoing, Tai chi, Rowing, Macrame, Urban exploration, Knife making

Introduction: My name is Madonna Wisozk, I am a attractive, healthy, thoughtful, faithful, open, vivacious, zany person who loves writing and wants to share my knowledge and understanding with you.