Free Excel template

Sales Register Format: Free Excel Template + GST Example

A sales register is a date-wise list of every sale you make, one row per invoice line, with the GST split. Download a blank GST-ready format and a filled one-month example, then see how each column maps to GSTR-1.

Download the Excel template

What is a sales register?

A sales register is a date-wise list of every sale you make, one row per invoice line. Each row records the invoice number and date, the customer and their GSTIN, the place of supply and the HSN code. It also records quantity, taxable value, the GST split into CGST + SGST or IGST, and the invoice total. Add credit and debit notes to the same register so each month's totals are net and match your GSTR-1.

A sales register records each sale. A sales report summarises those sales, for example by month or by customer. Some accountants call the register the sales day book.

The sales account is the ledger total in your books; the register is the detail behind it. A GST sales register has the columns GSTR-1 needs: GSTIN, place of supply, HSN and the tax split.

If you use Tally, its Sales Register shows sales month by month. Open a month to see the voucher register. Press F8 (Columnar) to add party details such as GSTIN as columns.

Sales register format: every column explained

The free sheet has 12 core columns: the register itself. GSTR-1 also needs the invoice total, GST rate and UQC, plus reverse charge and cess where they apply. Add those from the optional list.

The 12 columns in the free sheet

ColumnWhat to enterExample
DateDate of the invoice or note03-11-2026
Doc no.Number as printed; unique in the year, max 16 charactersINV/26-27/101
CustomerLegal name, as on their GSTINBuyer A Pvt Ltd
GSTIN15 characters; blank if the buyer is unregistered27AAAAA1111A1Z1
Place of supplyState code and name where the goods go27-Maharashtra
Supply typeB2B, B2CL, B2CS or ExportB2B
HSNAt least 4 digits if turnover is up to ₹5 Cr; 6 digits above ₹5 Cr7307
QtyQuantity on this line; minus for returns200
Taxable value (₹)Qty × rate − discount90,000
CGST (₹)Same state: half the GST8,100
SGST/UTGST (₹)Same state: the other half8,100
IGST (₹)Other state: the full GST0

Not sure of a state code? Check our GST state code list.

Optional columns to add

ColumnWhat to enterWhen you need it
Invoice totalTaxable value + all taxFor the invoice value in GSTR-1
GST rate and UQCRate for the HSN; GST unit code such as NOS or KGSFor the GSTR-1 HSN summary
Reverse chargeY if the buyer pays the tax, else NIf any sale is under reverse charge
CessCess amountIf items attract cess
Doc type and original invoice no.Invoice, credit note or debit note; for a note, the invoice it correctsIf you issue notes
Item, rate, discountItem name, price per unit, discount in rupeesTo check lines against the invoice
E-invoice IRN and e-way bill no.The 64-character IRN; the e-way bill numberIf you issue them
Due date, received, balancePayment due date, amount received, amount still dueTo follow up on payments

How to fill the sales register, step by step

  1. Set up the header. Type your company GSTIN and state code at the top.
  2. One row per invoice line. Add rows on the invoice date. Repeat the invoice number on every line.
  3. Pick the place of supply. Same state as yours: fill CGST and SGST. Different state: fill IGST.
  4. Enter quantity and taxable value. Taxable value is quantity × rate − discount. Tax is taxable value × GST rate.
  5. Add notes as minus rows. Put the original invoice number in its own column, never inside Doc no.
  6. Never overwrite. To cancel or fix an entry, add a new row.
  7. Close the month. Check the invoice series has no gaps. Then match the totals to your GSTR-1.

For what the invoice itself must show, see our invoice format guide. If you also issue bills of supply, read tax invoice vs bill of supply.

[[IMAGE {"type":"compare","title":"Same state or other state: which GST columns?","columns":["Same state","Other state"],"rows":[["Place of supply","Your own state","Any other state"],["Tax columns","CGST + SGST/UTGST","IGST"],["Rate split","Half the rate each","Full rate"],["At 18% GST","9% + 9%","18%"]]}]]

Worked example: one month's sales register for a small factory

Here is November for a small engineering unit in Maharashtra, state code 27. Its turnover is under ₹5 Cr, so 4-digit HSN codes are enough. All names, GSTINs and numbers are illustrative, with 18% GST on every line for simplicity.

Document and itemCustomer and supplyTaxable valueTax and total
INV/26-27/101, line 1: 200 flanges × ₹450Buyer A, Maharashtra, B2B₹90,000CGST ₹8,100 + SGST ₹8,100 = ₹1,06,200
INV/26-27/101, line 2: 200 gasket sets × ₹60Buyer A, Maharashtra, B2B₹12,000CGST ₹1,080 + SGST ₹1,080 = ₹14,160
INV/26-27/102: 50 shafts × ₹1,800Buyer B, Karnataka, B2B₹90,000IGST ₹16,200 = ₹1,06,200
INV/26-27/103: 100 couplings × ₹1,550, less ₹5,000 discountBuyer C, unregistered, Gujarat, B2CL₹1,50,000IGST ₹27,000 = ₹1,77,000
CN/26-27/007 against INV/26-27/101: 10 flanges returnedBuyer A, Maharashtra, B2B−₹4,500CGST −₹405 + SGST −₹405 = −₹5,310

Month totals: net taxable value ₹3,37,500. CGST ₹8,775, SGST ₹8,775 and IGST ₹43,200. Net sales including tax: ₹3,98,250.

Where each row goes in GSTR-1: rows 1 to 3 go to Table 4A as B2B sales. Row 4 goes to Table 5, B2C Large. The credit note goes to Table 9B.

HSN summary (Table 12): it has separate B2B and B2C tabs, and each line shows the rate, here 18%. B2B: 7307, 190 NOS, ₹85,500; 4016, 200 NOS, ₹12,000; 8483, 50 NOS, ₹90,000. B2C: 8483, 100 NOS, ₹1,50,000. Table 13 lists three invoices and one credit note.

How the sales register maps to GSTR-1

Supply type in the registerGSTR-1 table
B2B (registered buyer)4A, 4B, 6B, 6C
B2C Large5
Exports6A
B2C Others7
Credit and debit notes9B
HSN-wise summary12
Documents issued13

B2C Large means an inter-state invoice to an unregistered buyer above ₹1 lakh. This limit applies from the August 2024 tax period.

Most mismatches start when each invoice is typed twice: once to bill, once in the register. See how the register's details can come from the invoice itself.

Book a demo →

Is a sales register mandatory?

GST law requires every registered business to keep a true and correct account of its outward supplies. A sales register is the usual way to do it.

Electronic records are allowed. Keep them for 72 months, never overwrite an entry, and keep a log of edits.

Common mistakes in a sales register

  • Wrong place of supply. CGST + SGST and IGST get swapped.
  • GSTIN typos. One wrong character puts the sale against the wrong buyer.
  • Credit notes left out. Sales and tax are overstated.
  • Gaps or repeats in invoice numbers. Each must be unique in the financial year, 16 characters at most.
  • One row per invoice, not per line. This breaks the HSN-wise quantity summary.
  • Overwriting cells or deleting old years. Both break the record rules above.
  • Rounding by hand. Small differences pile up against GSTR-1.
  • Filling it monthly. Enter sales daily, while invoices are fresh.

Sales register in Excel vs software

Excel works well for a few invoices a day, and the free sheet is enough to start.

It breaks in three places. Two people edit the file and overwrite each other. Invoices are typed twice, in billing and in the register. And month-end totals stop matching GSTR-1.

Software helps when the invoice and the register are the same record. Compare options in our guide to GST billing software for manufacturers.

Where TranZact fills the sales register for you

In TranZact, the invoice is made once, inside the sales flow: enquiry, quotation, order timeline, dispatch, e-invoicing and payment.

TranZact generates the e-way bill from the GST invoice, with the e-invoice (IRN) in the same flow, on all plans. Read more on e-way bill generation.

So customer, GSTIN, HSN, quantity, tax, IRN and e-way bill number sit on one invoice. Nobody retypes them into a register.

Accounting stays in Tally, Busy or Zoho Books, with one-way sync and no double entry. See how the Tally integration works. TranZact also works with Excel and Google Sheets.

The Grow plan includes 65+ reports. 10,000+ manufacturers use TranZact's manufacturing AI software, and it goes live in 2–3 weeks.

Need a production format too? Get our free bill of materials format.

Download the sheet and use it today. When typing each invoice twice gets old, let us show you the invoice-first way. Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Frequently asked questions

Should I keep one row per invoice or one row per item?

One row per item line, repeating the invoice number on each line. This keeps the HSN-wise quantity summary right, and you can still total by invoice.

Do credit notes go in the sales register?

Yes. Enter them as minus rows with the original invoice number, so the month's sales and tax are net. In GSTR-1 they go in Table 9B.

How do I know whether to charge CGST + SGST or IGST?

Compare the place of supply with your own state. Same state: CGST + SGST, half the rate each. Different state: IGST at the full rate.

How long must I keep my sales register?

At least 72 months from the due date of that year's GST annual return, and longer if a case is pending. Keep old years and don't overwrite them.

Can I keep the sales register in Excel?

Yes. GST law allows electronic records. But entries must not be overwritten and edits must be traceable, so lock past months and fix mistakes with a new row.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.