How to Calculate GST in Excel | Australia 10% & New Zealand 15% | Beginner Tutorial

Learn how to calculate GST (Goods and Services Tax) in Microsoft Excel using simple formulas. In this beginner-friendly Excel tutorial, we look at how GST calculations work in Australia and New Zealand and how to use Excel to calculate GST amounts and prices including GST. Australia: 10% GST New Zealand: 15% GST What you will learn: How to enter GST rates as percentages in Excel How to calculate the GST amount using a simple multiplication formula How to calculate the total price including GST How to change the GST percentage for Australia and New Zealand How to use the same basic calculation method with different tax rates Example Excel formulas: GST Amount = Price × GST Rate Total Including GST = Price + GST Amount For example, if the original price is $100: Australia (10% GST): GST = $10 Total = $110 New Zealand (15% GST): GST = $15 Total = $115 These examples assume the original price excludes GST. This lesson is suitable for adult beginners, students, small business owners and anyone who wants to build confidence using Excel. About Unlock Futures At Unlock Futures, we make digital skills, financial literacy and everyday technology easier to understand through practical, step-by-step learning. 📚 Explore More with Unlock Futures 🌐 Website – Free lessons and learning resources https://unlockfutures.com.au 🛍️ Shopify – Digital learning resources https://shop.unlockfutures.com.au 🎨 Etsy – Printable worksheets and educational resources etsy.com/shop/UFLearning 📰 Substack – Financial literacy, investing and learning articles https://unlockfutures.substack.com Unlock Futures | Learn calmly. Build confidence. Important: This video is for general educational purposes only and is not tax, accounting or financial advice. The examples use standard GST rates and assume the goods or services are taxable. Some goods, services and transactions may have different GST treatment. Check the Australian Taxation Office (ATO) or New Zealand Inland Revenue (IRD) for official guidance. If you found this tutorial useful, consider subscribing to Unlock Futures for more beginner-friendly Excel, computer skills and financial literacy lessons. #ExcelForBeginners #GSTCalculation #MicrosoftExcel #UnlockFutures #ExcelTutorial GENERAL EDUCATION ONLY Unlock Futures is operated by Skills Forward Pty Ltd (ABN 81 686 531 484). Our videos are general educational information only. We do not hold an Australian Financial Services Licence and do not provide financial product advice. Nothing in this video takes into account your objectives, financial situation or needs, and we do not recommend any share, ETF, fund or other financial product. Share values can fall as well as rise and you may lose money, including your capital. Before acting on anything here, seek advice from a licensed financial adviser. Past performance is not an indicator of future performance. Full disclaimer: unlockfutures.com.au/disclaimer — Mandeep Kaur Aujla · Unlock Futures Learn calmly. Build confidence. unlockfutures.com.au