# GST Outward Supply Sales Register Worksheet (Excel Format)

> Source: https://netray.co/tools/gst-outward-supply-register-worksheet-india
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable sales register that splits tax into CGST, SGST and IGST per invoice and totals the monthly liability.

## Category

regional

## Region

India

## Audience

- Accounts executive
- Finance controller
- Small manufacturer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Invoice no.

**Key:** inv_no

**Type:** text

#### Invoice date

**Key:** inv_date

**Type:** date

#### Customer

**Key:** customer

**Type:** text

#### Customer GSTIN

**Key:** gstin

**Type:** text

#### Supply type

**Key:** supply

**Type:** select

**Options:**

- B2B
- B2C
- Export LUT
- SEZ
- Deemed export

#### Place of supply

**Key:** pos

**Type:** text

#### HSN

**Key:** hsn

**Type:** text

#### Taxable value (Rs)

**Key:** taxable

**Type:** number

**Format:** currency

#### GST rate (%)

**Key:** rate

**Type:** number

**Unit:** %

#### Intra-state (1) or inter-state (0)

**Key:** intra

**Type:** number

**Help:** Use 1 when supplier state equals place of supply.

#### CGST (Rs)

**Key:** cgst

**Type:** number

**Expr:** taxable * rate / 200 * intra

**Format:** currency

#### SGST/UTGST (Rs)

**Key:** sgst

**Type:** number

**Expr:** taxable * rate / 200 * intra

**Format:** currency

#### IGST (Rs)

**Key:** igst

**Type:** number

**Expr:** taxable * rate / 100 * (1 - intra)

**Format:** currency

#### Invoice value (Rs)

**Key:** total

**Type:** number

**Expr:** taxable + cgst + sgst + igst

**Format:** currency

**Rows:**

**Inv no:** INV/0412

**Inv date:** 2026-10-14

**Customer:** Kaveri Engineering

**Gstin:** 33BBBBB1111B1Z6

**Supply:** B2B

**Pos:** Tamil Nadu

**Hsn:** 8483

**Taxable:** 125000

**Rate:** 18

**Intra:** 1

**Inv no:** INV/0413

**Inv date:** 2026-10-15

**Customer:** Pune Auto Parts

**Gstin:** 27CCCCC2222C1Z7

**Supply:** B2B

**Pos:** Maharashtra

**Hsn:** 8708

**Taxable:** 84000

**Rate:** 28

**Intra:** 0

**Inv no:** INV/0414

**Inv date:** 2026-10-16

**Customer:** Walk-in customer

**Supply:** B2C

**Pos:** Tamil Nadu

**Hsn:** 7326

**Taxable:** 9500

**Rate:** 18

**Intra:** 1

**Inv no:** EXP/0032

**Inv date:** 2026-10-17

**Customer:** Hartwell Industrial LLC

**Supply:** Export LUT

**Pos:** Other country

**Hsn:** 7318

**Taxable:** 818000

**Rate:** 0

**Intra:** 0

**Inv no:** INV/0416

**Inv date:** 2026-10-19

**Customer:** Delhi Tool House

**Gstin:** 07DDDDD3333D1Z8

**Supply:** B2B

**Pos:** Delhi

**Hsn:** 8207

**Taxable:** 46000

**Rate:** 12

**Intra:** 0

**Totals:**

#### Total taxable value

**Key:** taxable

**Agg:** sum

**Format:** currency

#### Total CGST

**Key:** cgst

**Agg:** sum

**Format:** currency

#### Total SGST

**Key:** sgst

**Agg:** sum

**Format:** currency

#### Total IGST

**Key:** igst

**Agg:** sum

**Format:** currency

#### Total invoice value

**Key:** total

**Agg:** sum

**Format:** currency

**Summary:**

#### Total output tax

**Key:** liability

**Expr:** sum_cgst + sum_sgst + sum_igst

**Format:** currency

**Primary:** true

#### Effective tax rate on taxable value

**Key:** eff

**Expr:** if(gt(sum_taxable,0), (sum_cgst + sum_sgst + sum_igst) / sum_taxable * 100, 0)

**Format:** percent

**Notes:** Working register, not a substitute for your ERP records. Export supplies under LUT carry zero tax, so keep the rate at 0. Credit notes should be entered as separate rows with negative taxable values. Tax rates change by notification, so confirm the rate for each HSN.

## Content

**Intro:** Rule 56 of the CGST Rules requires every registered person to keep accounts of outward supplies, and many small manufacturers still do this in Excel. This register computes the split of CGST, SGST and IGST per invoice and totals what you owe for the month.

**Sections:**

#### How to use the register

**Body:** Enter one row per invoice. Add the taxable value, the GST rate and mark whether the supply is intra-state or inter-state. The worksheet computes CGST and SGST as half the tax each for intra-state sales, and IGST for inter-state sales. Add credit notes as negative rows so the totals net out. At month end, compare the totals with your GSTR-1 summary and with the ERP's tax ledger.

**Bullets:**

- Intra-state: CGST plus SGST, each half of the rate.
- Inter-state and exports: IGST at the full rate, or nil under LUT.
- Keep one register per GSTIN if you have branches in different states.

#### Where each number goes

**Body:** B2B invoices are reported invoice by invoice in GSTR-1 table 4, B2C large invoices in table 5, and B2C small supplies are consolidated by state and rate in table 7. Exports go in table 6A, and HSN summary in table 12. The output tax from this register flows to GSTR-3B table 3.1(a), and exports under LUT to 3.1(b). Mismatches between GSTR-1 and GSTR-3B are a common source of notices.

#### Mistakes to avoid

**Body:** The usual errors are wrong place of supply on service-linked sales, using the dispatch state instead of the delivery state, and missing credit notes issued after the month end. Also check that the rate is applied to the right value base: discounts known at the time of supply reduce the taxable value, while post-sale discounts need a financial credit note under the rules.

**Bullets:**

- Mixing up bill-to and ship-to states.
- Not netting credit notes in the correct month.
- Entering freight and packing outside the taxable value.

**Cta:** If your ERP sales ledger and GSTR-1 never match on the first try, we can help you build a tax reconciliation view.

**Faq:**

#### Is an Excel sales register acceptable?

**Answer:** The law requires you to maintain accounts, and electronic records are allowed if they are complete, secure and available on demand. Most firms rely on ERP or accounting software and use a spreadsheet like this one for review and reconciliation.

#### How do I record a credit note?

**Answer:** Enter a new row with a negative taxable value and the same rate. The register then nets the tax in the month the credit note is issued, which matches how GSTR-1 reports it in the credit and debit notes table.

#### What is the place of supply for goods?

**Answer:** Generally the location where the movement of goods ends, i.e. the delivery state of the buyer. If the goods are delivered on the direction of a third party, the rules treat the third party as the recipient. Check Section 10 of the IGST Act for special cases.

#### How long must I keep sales records?

**Answer:** Normally 72 months from the due date of the annual return for the year, and longer if proceedings are pending. Keep invoices, e-way bills, and the register together.

## Search terms

GST sales register format in excel, outward supply register GST, GST sales register template, GSTR-1 working sheet excel, GST register format rule 56, CGST SGST IGST register, monthly GST liability sheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json