A store meets GST from two sides every day. The supplier's bill adds GST on top of a rate. The counter bill takes GST out of a price the customer already sees. Mix up the two directions and your cost, your margin and your monthly GST all come out wrong.
GST billing software does this sum on every bill, but knowing the method lets you check a bill when a number looks wrong.
This guide shows how to calculate GST both ways, with a made-up supplier bill and a made-up counter sale, and then how the two meet when the month's GST is worked out. Items are called Item A and Item B on purpose: GST rates are set per item by notification, and you should check each one with your accountant. This is general information, not tax advice.
The two formulas
| Direction | When you use it | Formula |
|---|---|---|
| GST added on top (exclusive) | Supplier bill, wholesale price, any price written "+ GST" | GST = Taxable value × rate. Total = Taxable value + GST |
| GST taken out (inclusive) | MRP, shelf price, counter bill | Taxable value = Price / (1 + rate). GST = Price − Taxable value |
The most common mistake is using the first formula on an inclusive price. 5% of ₹105 is ₹5.25, but the GST inside ₹105 at 5% is only ₹5. On one pack the difference is small. On a month of sales it is not.
Direction 1: GST on a supplier bill
A made-up distributor bill for a regular (not composition) store, in-state, so CGST and SGST:
| Line | Qty | Rate | Amount | Trade discount | Taxable value | GST rate | GST | Line total |
|---|---|---|---|---|---|---|---|---|
| Item A | 24 packs | ₹40.00 | ₹960.00 | 5% = ₹48.00 | ₹912.00 | 5% | ₹45.60 | ₹957.60 |
| Item B | 12 packs | ₹150.00 | ₹1,800.00 | none | ₹1,800.00 | 18% | ₹324.00 | ₹2,124.00 |
| Total | ₹2,712.00 | ₹369.60 | ₹3,081.60 |
The ₹369.60 shows on the bill as ₹184.80 CGST and ₹184.80 SGST.
Step by step for each line:
- Amount = Qty × Rate.
- Take off the discount printed on the bill. Section 15(3)(a) of the CGST Act keeps a discount given before or at the time of supply out of the taxable value, as long as it is recorded on the invoice. So GST is worked out after the discount, not before.
- GST = Taxable value × rate. Split it into two equal halves for CGST and SGST.
- Line total = Taxable value + GST.
Check every supplier bill this way at purchase entry. If your total and the bill's total differ by more than a rupee of rounding, something is off: a wrong rate on a line, a discount taken after GST, or a quantity that does not match what came in.
Your real cost is usually the taxable value
This is where many owners get their margin wrong. If your store is a regular GST registered store and the purchase meets the input tax credit conditions (more on those below), the GST on the supplier bill comes back to you as credit. Your cost per pack is the taxable value, not the line total.
| Item A | Per pack |
|---|---|
| Line total with GST (957.60 / 24) | ₹39.90 |
| Taxable value without GST (912 / 24) | ₹38.00 |
Use ₹38.00 as the cost when you work out margin. Using ₹39.90 makes every margin look smaller than it is.
A composition store is different. Section 10(4) says a composition store cannot collect GST from customers and gets no input tax credit. For that store, the GST paid on purchases is part of the cost, so ₹39.90 is the right number.
Direction 2: GST inside a counter sale
At the counter the price already includes GST. The MRP on a pack is inclusive of all taxes, and the store cannot add GST on top. (The published guide on GST on a supermarket bill covers why, and what the bill must show.)
Say Item A has an MRP of ₹50 and you sell it at ₹48:
- Taxable value = 48 / 1.05 = ₹45.714, rounded to ₹45.71
- GST = 48 − 45.71 = ₹2.29
- CGST and SGST are half each: ₹1.15 and ₹1.14, or the other way round, depending on where your billing puts the odd paisa
GST is charged on what the customer actually pays. Section 15(1) of the CGST Act sets the value of a supply as the price actually paid or payable. So when you sell below MRP, the GST is worked out on ₹48, not on ₹50.
Now the margin per pack, both sides without GST: ₹45.71 − ₹38.00 = ₹7.71.
Rounding: line by line
Most bills round GST to two decimals on each line, then add up the lines. Rounding only the bill total gives a slightly different figure. Neither is a big amount, but pick one way and use it everywhere, or your sales report and your GST report will never match to the paisa.
In Excel, with the price in B2 and the rate in C2 (typed as 5%):
- Taxable value from an inclusive price:
=ROUND(B2/(1+C2),2) - GST on an exclusive price:
=ROUND(B2*C2,2) - CGST and SGST:
=ROUND(GST/2,2)each, and check they add back to the GST
What the store pays at the end of the month
The two directions meet here. In broad terms:
GST payable = GST on your sales (output tax) − input tax credit on your purchases
A made-up month:
| Amount | |
|---|---|
| GST inside all counter sales | ₹30,000 |
| GST on purchase bills that qualify for credit | ₹22,000 |
| Paid in cash, roughly | ₹8,000 |
The order in which CGST, SGST and IGST credits are set off against each other is laid down in the Act and is your accountant's job. What the store controls is whether the credit is there to use. Section 16(2) of the CGST Act allows it only when:
- You have the supplier's tax invoice or debit note.
- The supplier has reported that invoice in their return (their GSTR-1), so it reaches you.
- You have received the goods.
- The supplier has actually paid the tax.
- You have filed your own return.
Point 2 is the one that hurts stores. A distributor who files late, or puts a wrong GSTIN on your bill, can hold up your credit. Keep every supplier bill, and enter it with the supplier's GSTIN exactly as printed.
Common mistakes
| Mistake | What goes wrong | Fix |
|---|---|---|
| Taking 5% of an MRP as the GST | GST shown too high | Divide by 1.05, do not multiply by 0.05 |
| Discount taken after GST on a purchase | Bill total does not match | Discount first, then GST |
| Counting GST in the cost of a pack (regular store) | Margins look lower than they are | Cost = taxable value when credit is available |
| One GST rate for every item | Wrong tax on many lines | Set the rate per item, with your accountant |
| Supplier GSTIN typed wrong at entry | Credit does not match | Copy it from the bill, check it once |
Where software helps
Doing these sums once is easy. Doing them on every line of every bill, both ways, all day, is where mistakes creep in. Billing software should take the rate from the item list, work out the GST inside each counter price, keep purchase cost and GST apart at purchase entry, and give the accountant one clean report. The rate on each item is still yours and your accountant's to set.
How MarCat handles it
We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. GST in both directions is part of every day there. This is what MarCat does:
- GST at the counter. Scan the barcode and the item, price and GST come up, from the rate saved in the item list.
- Purchase entry that follows the supplier bill. Every purchase moves stock with batch, MRP and cost tracking, and vendor records and outstanding balances stay in the same system.
- Margins you can trust. Purchase and margin reports, so cost and selling price are compared in one place.
- Reports for your accountant. GST-ready reports to download and hand over.
If you want to see a mixed-rate bill and a purchase entry on a real counter, message us on WhatsApp at +91 96787 65518.
