01
Fields a GST tax invoice should show
A tax invoice under GST usually carries these details. Your CA can confirm what applies to your business.
- ✓Seller name, address and GSTIN
- ✓Invoice number and date
- ✓Buyer name, address and GSTIN (if registered)
- ✓Place of supply and state code
- ✓HSN or SAC code for each item
- ✓Quantity, unit, rate and taxable value
- ✓GST rate and CGST + SGST or IGST amount
- ✓Total, amount in words and signature
02
CGST + SGST or IGST?
If the buyer is in the same state as you, split GST equally into CGST and SGST. If the buyer is in another state, charge the full GST as IGST. In the Excel template, set "Same state?" to Y or N.
03
When Excel stops being enough
Excel is fine for a few invoices. As bills grow, numbering, stock and dues get hard to track. A free app like MyInvoiceDB keeps invoice numbers, customers, stock and payments linked for you.