How to Split CGST, SGST, and IGST Automatically in Spreadsheets

Indian GST compliance requires every invoice to calculate CGST, SGST, and IGST components accurately depending on whether the sale is Intra-State (within the same state) or Inter-State (outside the state).

Entering these tax components manually is tedious. This guide details how to write automated spreadsheet formulas to split taxes based on customer State Code.


The Split Logic

Suppose your business state is Karnataka (State Code 29).

  • If Customer State Code is 29: Intra-state sale. Charge CGST (9%) and SGST (9%).

  • If Customer State Code is NOT 29: Inter-state sale. Charge IGST (18%).


Spreadsheet Formula Setup

Step 1: Compare State Codes

Enter Customer State Code in cell B4. Compare it with your base state code in cell B2 (29):
=IF(B4=B2, "Intra-State", "Inter-State")

Step 2: Calculate CGST

If the transaction is Intra-State, apply half the tax rate (e.g., 9% on a 18% slab). If Inter-State, CGST is 0:
=IF(B4=B2, NetAmount * 0.09, 0)

Step 3: Calculate SGST

SGST matches CGST:
=IF(B4=B2, NetAmount * 0.09, 0)

Step 4: Calculate IGST

Charge IGST only on Inter-State sales:
=IF(B4<>B2, NetAmount * 0.18, 0)

Unified Invoicing inside FlexSheet OS

You can bypass spreadsheet math completely by generating compliant tax bills in the FlexSheet Invoice Generator. The tool detects customer state registration codes client-side, splits tax components instantly in browser memory, and packages the ledger vouchers for Tally XML import.

Frequently Asked Questions

Is it safe to run How to Split CGST, SGST, and IGST Automatically in Spreadsheets?

Yes. All processing occurs locally in your device memory. No files are uploaded to any server.

Can I use this tool offline?

Yes, once loaded, the application operates fully client-side without internet connectivity.