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
| Column | What to enter | Example |
|---|---|---|
| Date | Date of the invoice or note | 03-11-2026 |
| Doc no. | Number as printed; unique in the year, max 16 characters | INV/26-27/101 |
| Customer | Legal name, as on their GSTIN | Buyer A Pvt Ltd |
| GSTIN | 15 characters; blank if the buyer is unregistered | 27AAAAA1111A1Z1 |
| Place of supply | State code and name where the goods go | 27-Maharashtra |
| Supply type | B2B, B2CL, B2CS or Export | B2B |
| HSN | At least 4 digits if turnover is up to ₹5 Cr; 6 digits above ₹5 Cr | 7307 |
| Qty | Quantity on this line; minus for returns | 200 |
| Taxable value (₹) | Qty × rate − discount | 90,000 |
| CGST (₹) | Same state: half the GST | 8,100 |
| SGST/UTGST (₹) | Same state: the other half | 8,100 |
| IGST (₹) | Other state: the full GST | 0 |
Not sure of a state code? Check our GST state code list.
Optional columns to add
| Column | What to enter | When you need it |
|---|---|---|
| Invoice total | Taxable value + all tax | For the invoice value in GSTR-1 |
| GST rate and UQC | Rate for the HSN; GST unit code such as NOS or KGS | For the GSTR-1 HSN summary |
| Reverse charge | Y if the buyer pays the tax, else N | If any sale is under reverse charge |
| Cess | Cess amount | If items attract cess |
| Doc type and original invoice no. | Invoice, credit note or debit note; for a note, the invoice it corrects | If you issue notes |
| Item, rate, discount | Item name, price per unit, discount in rupees | To check lines against the invoice |
| E-invoice IRN and e-way bill no. | The 64-character IRN; the e-way bill number | If you issue them |
| Due date, received, balance | Payment due date, amount received, amount still due | To follow up on payments |
How to fill the sales register, step by step
- Set up the header. Type your company GSTIN and state code at the top.
- One row per invoice line. Add rows on the invoice date. Repeat the invoice number on every line.
- Pick the place of supply. Same state as yours: fill CGST and SGST. Different state: fill IGST.
- Enter quantity and taxable value. Taxable value is quantity × rate − discount. Tax is taxable value × GST rate.
- Add notes as minus rows. Put the original invoice number in its own column, never inside Doc no.
- Never overwrite. To cancel or fix an entry, add a new row.
- 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 item | Customer and supply | Taxable value | Tax and total |
|---|---|---|---|
| INV/26-27/101, line 1: 200 flanges × ₹450 | Buyer A, Maharashtra, B2B | ₹90,000 | CGST ₹8,100 + SGST ₹8,100 = ₹1,06,200 |
| INV/26-27/101, line 2: 200 gasket sets × ₹60 | Buyer A, Maharashtra, B2B | ₹12,000 | CGST ₹1,080 + SGST ₹1,080 = ₹14,160 |
| INV/26-27/102: 50 shafts × ₹1,800 | Buyer B, Karnataka, B2B | ₹90,000 | IGST ₹16,200 = ₹1,06,200 |
| INV/26-27/103: 100 couplings × ₹1,550, less ₹5,000 discount | Buyer C, unregistered, Gujarat, B2CL | ₹1,50,000 | IGST ₹27,000 = ₹1,77,000 |
| CN/26-27/007 against INV/26-27/101: 10 flanges returned | Buyer A, Maharashtra, B2B | −₹4,500 | CGST −₹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 register | GSTR-1 table |
|---|---|
| B2B (registered buyer) | 4A, 4B, 6B, 6C |
| B2C Large | 5 |
| Exports | 6A |
| B2C Others | 7 |
| Credit and debit notes | 9B |
| HSN-wise summary | 12 |
| Documents issued | 13 |
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.
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.