Download GST Price Comparison Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Narrow Ruled Paper

This type of lined paper allows the writer to fit more words in a single …

Read More

GST Sales Register

It is mandatory for all to maintain records of sales and purchase under the new …

Read More

Daily Exercise Log

A printable daily exercise log is very useful for helping you track of your accomplishments and …

Read More

Employee Disciplinary Memo

Employee Disciplinary Memo is an ready excel template that helps to issue a memo for …

Read More
Search
Generic filters

With continuous 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.

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

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

The reason behind is that the benefit of input credit is not forward to the end consumer.

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

This is helpful to Individuals, manufacturers, wholesalers, retailers.

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: Enter the amount in white boxes. All other amounts cells are pre-formula and will make calculations automatically.

1. Header Section

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

2. Manufacturer Section

In manufacturer section, there are calculations of Excise Duty which is 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.

Price including Excise + VAT = Total.

Total – Input of VAT = Price To Wholesaler.

Calculation of Post GST Regime

Cost of Production + Profit = Price Including Profit.

GST removed Excise and so excise is included in GST itself.

Price including Profit + GST = Total.

Total – Input of GST = Price To Wholesaler.

3. Wholesaler Section

Excise is applicable only in manufacturing and so it does not include in wholesaler section. All other calculations are similar.

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 for 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 for Retailer.

4. Retailer Section

Calculations of 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 removed VAT and VAT have been included in GST itself.

Price including Profit + GST = Total.

Total – Input of GST = Price To End Consumer.

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

Download GST Price Comparison Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download GST Price Comparison Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: