PayByDateTools

GST Dates

GST 18 percent already in the bill, how to split

2023-07-14 · updated 2026-06-03

GST 18 percent already in the bill, how to split

Matching tool: Invoice GST split

Customer paid 11,800 and asked taxable value. I split it on the counter. Tea in my left hand. Pen in the right. He said GST 18 percent is already in the bill. He needs taxable for his GSTIN. I did not want to look like I dont know my own shop.

Inclusive bill is common in Jaipur small shops. We say 11,800 all in. Customer hears one number. Portal wants two. Taxable and tax. Split is not a feeling. It is a divide.

If you want the split without arguing with a calculator under the fan, open Invoice GST split on PayByDate. Inclusive or exclusive. Rate 5, 12, 18 or 28. Type the rupee. Read the two parts. Then still check your invoice copy.

This is an estimate. Confirm on the official portal. Invoice you issue is what GSTR-1 will carry. Tool is a helper.

How I split 11,800 at 18 percent

Inclusive 18 percent means the 11,800 already has tax sitting inside.

Shop talk formula people use. Taxable = amount × 100 / 118. Tax = amount − taxable. Or tax = amount × 18 / 118.

I did it on paper first. 11,800 divided by 118. Times 100. Taxable came 10,000. Tax 1,800. CGST 900. SGST 900 if intra-state. That is the usual Jaipur to Jaipur story. Inter-state is IGST. I dont mix that on a local counter bill.

He nodded. He wanted 10,000 in his purchase book. I wanted 10,000 in GSTR-1. Same number. Good day.

If the bill was exclusive, 10,000 plus 18 percent is 11,800. Same pair. Direction of the sum changes. Inclusive you peel tax out. Exclusive you add tax on.

Wrong direction is the classic fight. Customer thinks 11,800 plus 18 percent more. Shop looks greedy. Or shop peels tax from a number that was already exclusive and taxable becomes too small. GSTR-1 then looks drunk.

I keep Invoice GST split on the phone for the helper at the counter. He is faster than my long division.

Why this shows up in GSTR-1 week

GSTR-1 wants invoice value and taxable and tax. If you type 11,800 as taxable and then 18 percent on top, you overstate. Buyer ITC and your output tax both go mad.

I almost did that in 2023 on a busy Saturday. Two bills still open. I wrote 11,800 in the taxable column by habit. Caught it at tea time. Amended mood.

Typical GSTR-1 window around 11th. See GSTR-1 last date this month, what if I miss it. Split must be done before that, not on 11th night with portal lag.

3B output tax should match the tax you actually charged. If you charged inclusive and then 3B uses a different split, cash and return fight. Rajasthan shop GSTR-3B on phone, what to keep ready. Paper slip has taxable and tax, not only the cash you put in the drawer.

If 3B is already late, that is another story. GSTR-3B late by 8 days. Still split right. Late fee plus wrong tax is two pains.

HSN rate must match. If item is 18 and you split at 12 because customer requested, that is not a split. That is a wrong rate. I dont do that for a smile.

Small stories from the counter

A man bought a fan. Sticker said 4,720. He asked if GST extra. I said 18 already in. He wanted a GST invoice. Taxable 4,000. Tax 720. He was happy. His office needed the GSTIN bill.

A woman paid 5,900 for two chairs. Inclusive 18. Taxable 5,000. She paid UPI. UPI shows 5,900. Books show 5,000 plus 1,800 wait no. 5,900 at 18 inclusive is 5,000 taxable and 900 tax. I said 1,800 by habit because 11,800 was still in my head. Helper caught me. Notebook saved me.

Round off is a small devil. Split gives paise. Invoice may round to rupee. GSTR-1 table may show 0.50 somewhere. I dont fight 50 paise like a court case. I keep a round-off line if the software has it. If I write by hand, I round the way the printed bill already rounded.

Discount 25 percent before a festival is a different tool. Split GST after the discount, not before, if the deal is on the final price. Shop discount 25 percent before Diwali, final price. Then split. Else tax sits on a price nobody paid.

Inclusive vs exclusive, I say it slow

Inclusive. Customer pays one number. That number has tax inside. Peel.

Exclusive. Customer pays base plus tax. Add.

Same rate 18. Same pair 10,000 and 1,800 when the full money is 11,800. The label on the sticker decides which way you talk.

5 percent inclusive is divide by 105. 12 by 112. 28 by 128. People forget and always divide by 118. Fan at 28 percent then looks wrong. I ask the rate first. Always.

Tool lets you pick 5, 12, 18, 28. Use it. Invoice GST split.

Percentage of a number if you are lost: Percentage calculator. Still, GST split is the special divide, not a random percent of bill for tip.

Split bill among friends is not GST. Split bill calculator is for tea and samosa. Dont put GSTIN on that.

What I write on the invoice

GSTIN of shop. GSTIN of buyer if B2B. Invoice number. Date. HSN. Taxable. CGST. SGST. Or IGST. Total.

If I only write total 11,800, buyer accounts clerk in some other city will call. I already got that call from Ahmedabad last year. They said invoice not useful. I reprinted.

E-invoice if you are in that world, IRN must match these numbers. Changing taxable after IRN is a mess. Split before you generate.

Credit note later if you overcharged. That is another GSTR-1 line. Dont silently change last month invoice in the notebook only.

Nil month you have no invoices to split. You still file. Nil GST return, do I still file.

QRMP IFF needs the same split on B2B invoices you furnish. QRMP IFF and GSTR-1.

Mistakes I still make when busy

Using 18 on a 5 percent item because 18 is the shop default in my brain.

Splitting after adding a delivery charge that was already GST-inclusive, then adding GST again on delivery. Double tax. Customer shouts. Rightly.

Taking taxable from MRP and tax from the discounted price. Two different worlds on one bill.

Writing IGST on a Jaipur to Jaipur bill. Intra is CGST SGST. I check the buyer pincode. Lazy brain says IGST because it is one box.

Trusting the helper’s mental math on 28 percent. 28 inclusive is divide by 128. He divided by 118. We caught it before print.

Copying last bill and only changing the total. Rate stayed 18. Item was 12. GSTR-1 will carry the lie until you amend.

Night before GSTR-1 I check splits

I pull five biggest B2B bills. Recheck inclusive split. Match notebook. Match print.

Then smaller B2C if the table needs it. Then file around the typical 11th.

If cash ledger for 3B will need the tax you split, keep challan ready. Cash ledger empty, challan first or return first. GSTR-3B tax payable.

Payment fail is a different headache. GSTR-1 payment failed.

I am not GSTN. Rate on an item is from your HSN and the law, not from my tea stall. Tool assumes the rate you type.

This is an estimate. Confirm on the official portal.

Customer paid 11,800. Taxable 10,000. Tax 1,800. I wrote it. He left. Tea went cold. Bill was right. That is a good afternoon on Tonk Road.

This is an estimate. Confirm on the official portal.