• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog

Download Pre GST and Post GST Price Comparison Template in Excel

Download Pre GST and Post GST Price Comparison Template in Excel

With recurring requests from our readers as well as authorities for making Pre GST and Post GST Price Comparison Template in excel, today we have created an excel template for the same.

GST was implemented on July 1st, 2017. It has been around 3 months now.

The main objective behind GST was to provide good and services at a lower price to the end consumer.

According to our study, there has been a less impact on prices after GST.

The reason behind it is that the benefit of input credit is not being forwarded to the end consumer.

We have created an excel template for Pre GST and Post GST Price Comparison Template.

This can be helpful to Individuals, manufacturers, wholesalers, retailers and even to the anti-profiteering department to compare price in pre-GST as well as Post GST regime.

Pre GST and Post GST Price Comparison Template

Click here to Download Pre GST and Post GST Price Comparison Template.

Click here to Download All GST Excel Templates for Rs 199.

You can download GST templates like GST TRAN-1, GST Input Output Tax Report, and GST Export Invoice from here.

Let us discuss the contents of the template in detail.

Contents of Pre GST and Post GST Price Comparison Template

This template consists of 4 sections:

  1. Header Section
  2. Manufacturer Section
  3. Wholesaler Section
  4. Retailer Section

Important Note: Just enter the amount in white boxes only. all other amounts cells are pre-formulated and will make calculations automatically.

1. Header Section

As usual, the header section consists of the name of the company, address of the company, logo, and heading of the sheet ” Pre GST and Post GST Price Comparison Template.”

Pre GST and Post GST Price Comparison Template

2. Manufacturer Section

In manufacturer section, there are calculations of Excise Duty which was applicable in the pre-GST regime.

Calculations of Pre GST Regime

Cost of Production + Profit = Price Including Profit.

Price Including Profit + Excise Duty = Price Including Excise. (In earlier regime Excise duty paid was not provided as input.)

Price including Excise + VAT = Total.

Total – Input of VAT = Price To Wholesaler.

Now let us see the calculations of Post GST Regime.

Calculation of Post GST Regime

Cost of Production + Profit = Price Including Profit.

GST has removed Excise and thus excise has been included in GST itself.

Price including Profit + GST = Total.

Total – Input of GST = Price To Wholesaler.

As you can see in the below image, The price difference between Pre-GST and Post GST is around Rs. 78.44.

Pre GST and Post GST Price Comparison Template

3. Wholesaler Section

Excise is applicable only in manufacturing and so it is not included in wholesaler section. All other calculations are similar to the above.

Calculations of Pre GST Regime

Cost of Goods + Other Cost + Profit = Price Including Profit.

Price Including Profit + VAT or Other Taxes = Total

Total – Input of VAT = Price To Retailer.

Calculation of Post GST Regime

Cost of Production + Other Costs + Profit = Price Including Profit.

GST has removed VAT and VAT have been included in GST itself.

Price including Profit + GST = Total.

Total – Input of GST = Price To Retailer.

There is a price difference between Pre-GST and Post GST of Rs. 47.68.

  Pre GST and Post GST Price Comparison Template

4. Retailer Section

Calculations of the retail section are similar to wholesale section.

Calculations of Pre GST Regime

Cost of Goods + Other Cost + Profit Margin = Price Including Profit.

Price Including Profit + VAT or Other Taxes = Total

Total – Input of VAT = Price To End Consumer.

Calculation of Post GST Regime

Cost of Production + Other Costs + Profit = Price Including Profit.

GST has removed VAT and VAT have been included in GST itself.

Price including Profit + GST = Total.

Total – Input of GST = Price To End Consumer.

As shown in below image, there is a price difference between Pre-GST and Post GST of Rs. 7.99 to the end consumer.

Pre GST and Post GST Price Comparison Template

This all is applicable to some sectors only. Many other sectors are feeling the heat and things are getting costly.

For example, earlier the textile industry was not taxable, textile products are becoming costlier than the pre-GST regime.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

« Download Monthly GST Input Output Tax Report Excel Template
Download Performa LUT (Letter of Undertaking) in MS Word »

Filed Under: GST Templates in Excel

You are Here: Home / Excel Templates / GST Templates in Excel / Download Pre GST and Post GST Price Comparison Template in Excel

About Fahim Lashkaria

I love working in Excel and I share functional excel templates at ExcelDataPro.

Comments

  1. PRADIP SINGH says

    May 15, 2018 at 12:55 pm

    We are working on sales and service sector like supply led lights and installation in site. how can we calculate the Pre-GST and Post GST. All deptt. asking fpr release payment. please share excel sheet if available of this format. Thanks

    Reply
    • Fahim Lashkaria says

      May 19, 2018 at 7:35 am

      I presume that you haven’t understood the purpose of this template. It will help you define price different before GST was implemented and prices after GST was implemented. What exactly are you looking for?

      Reply
  2. bhushanam says

    February 19, 2019 at 1:11 pm

    very good comparison and can you please share the same workings for Works Contract services

    Reply
    • Fahim Lashkaria says

      February 21, 2019 at 1:50 pm

      I haven’t done any comparison for work contract services yet. Noted and will be soon updated on the website.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

GST Templates in Excel

  • GST Receipt Voucher Excel Template For Advance Payments Under GST
  • GST Refund Voucher Excel Template For Refunding Advance Under GST
  • GST Payment Voucher Excel Template for Payments Under Reverse Charge
  • GST Debit Note Format In Excel Under GST 2017
  • GST Credit Note Format In Excel Issued Against Goods Return Or Over Billing
  • GST Delivery Challan Format in Excel For Transportation Of Goods Without The Tax Invoice
  • GST Compliant Voucher Formats In Excel
  • Simplified GST Invoicing and Effortless GSTR Filing
  • GST Purchase Register Excel Template
  • GST Sales Register Excel Template
  • GST TRAN-1 Return Excel Template
  • GST TRAN-2 Return Excel Template
  • Monthly GST Input Output Tax Report Excel Template
  • Pre GST and Post GST Price Comparison Template in Excel
  • Performa LUT (Letter of Undertaking) in MS Word
  • 10 GST Invoice Templates in Excel
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2021. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT