{"id":692,"date":"2024-12-27T12:38:51","date_gmt":"2024-12-27T12:38:51","guid":{"rendered":"https:\/\/salesforcecrmtraining.in\/blog\/?p=692"},"modified":"2024-12-27T12:38:51","modified_gmt":"2024-12-27T12:38:51","slug":"how-to-calculate-gst-in-an-excel-sheet","status":"publish","type":"post","link":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/","title":{"rendered":"How to Calculate GST in an Excel Sheet?"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In today\u2019s fast-paced business world, managing tax calculations efficiently is crucial for businesses of all sizes. Goods and Services Tax (GST) is a major component of the tax system, and accurately calculating GST can be time-consuming if not done correctly. Excel, however, can simplify the GST calculation process with a structured approach. This blog will guide you on calculating GST in Excel without using complex code, offering an easy-to-follow step-by-step method to streamline your tax calculations. If you want to enhance your skills in managing GST calculations and other tax-related tasks, consider enrolling in <\/span><a href=\"https:\/\/www.fita.in\/gst-training-in-chennai\/\"><span style=\"font-weight: 400;\">GST Training in Chennai<\/span><\/a><span style=\"font-weight: 400;\"> to gain a deeper understanding and proficiency in the field.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">GST is a value-added tax levied on the sale of goods and services, and businesses need to calculate it correctly to ensure compliance. Excel is a versatile tool that can be used for various business purposes, including tax calculations. By setting up a few simple columns and formulas, businesses can calculate GST efficiently without needing coding knowledge. This blog will walk you through creating an Excel sheet to calculate GST for sales and purchases.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Setting Up the Excel Sheet<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To begin calculating GST in Excel, you must first set up your spreadsheet. Create the following columns in your Excel sheet:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>Product\/Service Description<\/b><span style=\"font-weight: 400;\">: A brief description of the item or service.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Quantity<\/b><span style=\"font-weight: 400;\">: The number of items being sold or purchased.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Unit Price<\/b><span style=\"font-weight: 400;\">: The price of a single item.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>GST Rate<\/b><span style=\"font-weight: 400;\">: The applicable GST rate (e.g., 5%, 12%, 18%, or 28%).<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>GST Amount<\/b><span style=\"font-weight: 400;\">: The amount of GST to be applied.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Total Price (Including GST)<\/b><span style=\"font-weight: 400;\">: The final price including the GST.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">This simple structure will allow you to calculate the GST for each item and the total amount payable, all in one sheet.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Also Read: <\/span><a href=\"https:\/\/dailyconsumerlife.com\/what-are-the-key-components-of-goods-and-services-tax\/\"><span style=\"font-weight: 400;\">What Are the Key Components of Goods and Services Tax?<\/span><\/a><\/p>\n<h3 style=\"text-align: justify;\"><b>Input Data into the Sheet<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">After setting up your columns, input the necessary data for each product or service. This includes the quantity, unit price, and the applicable GST rate for each item. For example, if you&#8217;re selling a product with a unit price of \u20b95,000 and a GST rate of 18%, you would enter this data into the respective columns.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ensure each product or service has its corresponding GST rate filled in the spreadsheet.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Calculating the GST Amount<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Once you&#8217;ve entered your data, the next step is to calculate the GST amount. The GST amount is determined by applying the GST rate to the unit price of each item. You can calculate it by using the following Excel GST formula:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>GST Amount = Quantity \u00d7 Unit Price \u00d7 GST Rate<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">For example, if you are selling 10 items at \u20b95,000 each with an 18% GST rate, the GST amount would be calculated as:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>GST Amount = 10 \u00d7 \u20b95,000 \u00d7 18% = \u20b99,000<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In Excel, you can manually calculate this by multiplying each item&#8217;s quantity, unit price, and GST rate. Excel will automatically apply this to each row if you follow the above structure. To better understand Excel\u2019s capabilities and improve your proficiency in creating efficient worksheets, consider enrolling in an <\/span><a href=\"https:\/\/www.fita.in\/advanced-excel-training-in-chennai\/\"><span style=\"font-weight: 400;\">Advanced Excel Training in Chennai<\/span><\/a><span style=\"font-weight: 400;\">. This will help you master Excel\u2019s advanced features and enhance your overall data management skills. You can apply the GST formula in Excel for seamless and accurate tax calculations.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>GST calculation formula in Excel<\/b><span style=\"font-weight: 400;\">: You can implement this formula in Excel to perform GST calculations for all items seamlessly.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Calculating the Total Price Including GST<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">After calculating the GST amount for each item, you can calculate the total price, which includes the cost of the product or service and the GST. Add the GST amount to the base price (Quantity \u00d7 Unit Price) to find the total price.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Total Price = (Quantity \u00d7 Unit Price) + GST Amount<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">For the example above:<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Total Price = (10 \u00d7 \u20b95,000) + \u20b99,000 = \u20b959,000<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">This calculation will give you the total amount payable after GST for the given quantity and product.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Handling Multiple Products and Rates<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">The process remains the same if you are dealing with multiple products with different GST rates. You must input the appropriate GST rate for each product and follow the same calculation process. Excel allows you to easily adjust and apply formulas to different rows and columns, making it simple to calculate GST for various products at once. To further enhance your skills in Excel and streamline your calculations, consider enrolling in a <\/span><a href=\"https:\/\/www.fita.in\/training-institute-in-chennai\/\"><span style=\"font-weight: 400;\">Training Institute in Chennai<\/span><\/a><span style=\"font-weight: 400;\"> that offers specialized courses to help you become proficient in Excel and its advanced functionalities.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Finalizing the GST Sheet<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Once you have entered all the data and applied the formulas, it\u2019s time to review your sheet for accuracy. Ensure that the GST calculations are correct and that there are no mistakes in the data entry. You can also format the sheet to make it more readable, such as using currency formatting for prices or highlighting key totals.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Calculating GST in Excel is an efficient and straightforward way to ensure tax compliance for your business. By setting up a structured sheet and applying simple formulas, you can accurately calculate the GST for sales and purchases. Excel makes it easy to handle complex data without requiring coding skills, and its flexibility allows for customized calculations for different GST rates. If you wish to enhance your Excel skills further, you can explore <\/span><a href=\"https:\/\/www.fita.in\/advanced-excel-course\/\"><span style=\"font-weight: 400;\">Advanced Excel Course Online<\/span><\/a><span style=\"font-weight: 400;\"> to gain a deeper understanding of Excel\u2019s powerful features, which can be beneficial for managing your GST calculations and other business processes.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Also Read: <\/span><a href=\"https:\/\/fitaporur.in\/advanced-excel-hacks-that-every-seo-should-do\/\"><span style=\"font-weight: 400;\">Advanced Excel Hacks That Every SEO Should DO<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In today\u2019s fast-paced business world, managing tax calculations efficiently is crucial for businesses of all sizes. Goods and Services Tax (GST) is a major component of the tax system, and accurately calculating GST can be time-consuming if not done correctly. Excel, however, can simplify the GST calculation process with a structured approach. This blog will [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":693,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[218,205,219],"class_list":["post-692","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education","tag-advanced-excel-training","tag-excel-training","tag-gst-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Calculate GST in an Excel Sheet?<\/title>\n<meta name=\"description\" content=\"Learn how to easily calculate GST in an Excel sheet with a step-by-step guide for efficient tax management and compliance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Calculate GST in an Excel Sheet?\" \/>\n<meta property=\"og:description\" content=\"Learn how to easily calculate GST in an Excel sheet with a step-by-step guide for efficient tax management and compliance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Salesforce CRM Training\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-27T12:38:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"salesforcecrmtraining\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"salesforcecrmtraining\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\"},\"author\":{\"name\":\"salesforcecrmtraining\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/person\/e1395386e5c4d70088463c2484445e46\"},\"headline\":\"How to Calculate GST in an Excel Sheet?\",\"datePublished\":\"2024-12-27T12:38:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\"},\"wordCount\":908,\"publisher\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp\",\"keywords\":[\"Advanced Excel Training\",\"Excel Training\",\"GST Training\"],\"articleSection\":[\"Education\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\",\"url\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\",\"name\":\"How to Calculate GST in an Excel Sheet?\",\"isPartOf\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp\",\"datePublished\":\"2024-12-27T12:38:51+00:00\",\"description\":\"Learn how to easily calculate GST in an Excel sheet with a step-by-step guide for efficient tax management and compliance.\",\"breadcrumb\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage\",\"url\":\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp\",\"contentUrl\":\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp\",\"width\":800,\"height\":400,\"caption\":\"How to Calculate GST in an Excel Sheet?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/salesforcecrmtraining.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Calculate GST in an Excel Sheet?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#website\",\"url\":\"https:\/\/salesforcecrmtraining.in\/blog\/\",\"name\":\"Salesforce CRM Training\",\"description\":\"Salesforce tutorials and articles\",\"publisher\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/salesforcecrmtraining.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#organization\",\"name\":\"Salesforce CRM Training\",\"url\":\"https:\/\/salesforcecrmtraining.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2021\/07\/cropped-site-logo.png\",\"contentUrl\":\"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2021\/07\/cropped-site-logo.png\",\"width\":206,\"height\":100,\"caption\":\"Salesforce CRM Training\"},\"image\":{\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/person\/e1395386e5c4d70088463c2484445e46\",\"name\":\"salesforcecrmtraining\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/16d83ed8157d92d71f9df385405e9a4f459de489a247ab113f81f2473bc49bd3?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/16d83ed8157d92d71f9df385405e9a4f459de489a247ab113f81f2473bc49bd3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/16d83ed8157d92d71f9df385405e9a4f459de489a247ab113f81f2473bc49bd3?s=96&d=mm&r=g\",\"caption\":\"salesforcecrmtraining\"},\"url\":\"https:\/\/salesforcecrmtraining.in\/blog\/author\/salesforcecrm_fita\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Calculate GST in an Excel Sheet?","description":"Learn how to easily calculate GST in an Excel sheet with a step-by-step guide for efficient tax management and compliance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/","og_locale":"en_US","og_type":"article","og_title":"How to Calculate GST in an Excel Sheet?","og_description":"Learn how to easily calculate GST in an Excel sheet with a step-by-step guide for efficient tax management and compliance.","og_url":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/","og_site_name":"Salesforce CRM Training","article_published_time":"2024-12-27T12:38:51+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp","type":"image\/webp"}],"author":"salesforcecrmtraining","twitter_misc":{"Written by":"salesforcecrmtraining","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#article","isPartOf":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/"},"author":{"name":"salesforcecrmtraining","@id":"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/person\/e1395386e5c4d70088463c2484445e46"},"headline":"How to Calculate GST in an Excel Sheet?","datePublished":"2024-12-27T12:38:51+00:00","mainEntityOfPage":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/"},"wordCount":908,"publisher":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/#organization"},"image":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp","keywords":["Advanced Excel Training","Excel Training","GST Training"],"articleSection":["Education"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/","url":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/","name":"How to Calculate GST in an Excel Sheet?","isPartOf":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage"},"image":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp","datePublished":"2024-12-27T12:38:51+00:00","description":"Learn how to easily calculate GST in an Excel sheet with a step-by-step guide for efficient tax management and compliance.","breadcrumb":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#primaryimage","url":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp","contentUrl":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2024\/12\/How-to-Calculate-GST-in-an-Excel-Sheet.webp","width":800,"height":400,"caption":"How to Calculate GST in an Excel Sheet?"},{"@type":"BreadcrumbList","@id":"https:\/\/salesforcecrmtraining.in\/blog\/how-to-calculate-gst-in-an-excel-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/salesforcecrmtraining.in\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Calculate GST in an Excel Sheet?"}]},{"@type":"WebSite","@id":"https:\/\/salesforcecrmtraining.in\/blog\/#website","url":"https:\/\/salesforcecrmtraining.in\/blog\/","name":"Salesforce CRM Training","description":"Salesforce tutorials and articles","publisher":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/salesforcecrmtraining.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/salesforcecrmtraining.in\/blog\/#organization","name":"Salesforce CRM Training","url":"https:\/\/salesforcecrmtraining.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2021\/07\/cropped-site-logo.png","contentUrl":"https:\/\/salesforcecrmtraining.in\/blog\/wp-content\/uploads\/2021\/07\/cropped-site-logo.png","width":206,"height":100,"caption":"Salesforce CRM Training"},"image":{"@id":"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/salesforcecrmtraining.in\/blog\/#\/schema\/person\/e1395386e5c4d70088463c2484445e46","name":"salesforcecrmtraining","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/16d83ed8157d92d71f9df385405e9a4f459de489a247ab113f81f2473bc49bd3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/16d83ed8157d92d71f9df385405e9a4f459de489a247ab113f81f2473bc49bd3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/16d83ed8157d92d71f9df385405e9a4f459de489a247ab113f81f2473bc49bd3?s=96&d=mm&r=g","caption":"salesforcecrmtraining"},"url":"https:\/\/salesforcecrmtraining.in\/blog\/author\/salesforcecrm_fita\/"}]}},"_links":{"self":[{"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/posts\/692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":3,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"predecessor-version":[{"id":696,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/posts\/692\/revisions\/696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/media\/693"}],"wp:attachment":[{"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salesforcecrmtraining.in\/blog\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}