We provide here the GST Calculator for India in a downloadable Excel format. It is entirely offline and you do not need an internet connection for this. Firstly, download the GST Calculator Excel here.
The calculation of the amount of GST payable at the time of filing returns is quite a complex task.
A taxpayer must consider all aspects and provisions such as reverse charge, exempted supplies, inter-state sales along with eligible and non-eligible ITC before calculating the amount of GST payable.
If you pay less amount, then you are liable to pay interest @18% on the shortfall. This is why calculating the correct amount of payable GST becomes vital.
The GST liability is calculated by adding up the GST on output supplies, GST payable on reverse charge, and GST on inward supplies. Also, the opening balance of electronic cash ledger and the electronic credit ledger should also be considered while arriving at the GST liability for a month.
This liability is calculated automatically in the process of filing GST Returns from every month, But a taxpayer may want to calculate their liability in advance to make sure that the required money is set aside to pay the GST liability.
If you are a taxpayer who wants to calculate the GST liability in advance here is a GST calculator that will help you with.
The blank calculator will look like this-
In this GST Calculator, you are required to fill up all the yellow-coloured cells. Other cells will be automatically populated.
You need to provide the following numbers in the Indian GST Calculator-
- Month for which the calculations are being done
- Due date of filing return for the month
- Actual date of filing the return
- Your total tax liability during the month
- Your purchases attracting Reverse Charge Mechanism *
- Eligible ITC (from GSTR-2)
- Opening balance of cash ledger
- Opening balance of your credit ledger
Please refer our guide below to understand how to calculate these inputs.
* Note: RCM on buying from unregistered dealers has been further suspended until 30th June 2018 2018 from the earlier extension of 31st March 2018 via Central Tax rate Notification dated 23rd March 2018.
GST Calculator Guide
How to calculate the output tax liability?
The output tax liability has to be calculated by multiplying the GST rate with the total value of supplies and advances.
For example (assuming applicable GST rate is 18%):
|Total value of interstate sales||25 lakh|
|Total value of intrastate sales||30 lakh|
|Advance Received – interstate||10 lakh**|
|IGST||25 lakh * 18% = 4.50 lakh
10 lakh * 18% = 1.80 lakh
Total = 6.30 lakh
|CGST||30 lakh * 9% = 2.70 lakh|
|SGST||30 lakh * 9% = 2.70 lakh|
Enter IGST, CGST and SGST values in the respective columns.
You can also easily get the information from your GSTR-3B. Please refer our guide below for the steps.
** Note: As per 22nd GST Council Meeting of 6th Oct’17, taxpayers having turnover up to Rs. 1.5 crores will not be required to pay GST on advances on account of supply of goods. The GST on such supplies shall be payable only when the goods are supplied.
Opening balance of electronic cash ledger and electronic credit ledger
You can find the opening balances of electronic cash ledger and electronic credit ledger on the GST portal. Please refer our guide below to know the steps of finding out the balances.
After entering all the values, your calculator will look like this-
Once all these numbers are entered the GST liability will get calculated automatically. Along with the liability, the interest, and late fees if any, on account of late filing of GST return is also calculated.
Please refer our detailed guide on calculator below. For any further queries please feel free to contact us at firstname.lastname@example.org or call us on 080-67458707.