Free GST Invoice in Excel for Dadra & Nagar Haveli and Daman & Diu
An Excel-based GST invoice template with auto-calculated tax columns. Perfect for businesses that manage invoices in spreadsheets alongside their accounts. Pre-configured for Dadra & Nagar Haveli and Daman & Diu businesses with GST state code 26. GSTIN format: 26ABCDE1234F1Z5.
GST Invoice Generator
Fill in the details below to create your GST-compliant invoice instantly.
Upload Logo
240 x 240 pixels @ 72 DPI,
Maximum size of 1MB.
TAX INVOICE
Your Company
Add UPI ID to show QR code on shared invoice
Invoice Details
Bill To
Place of Supply
| Item Description | Qty | Rate | Tax % | Amount | |
|---|---|---|---|---|---|
Notes
Terms & Conditions
Visit gstinvoices.in to create professional GST invoices.
Generate your invoice to get a shareable link, WhatsApp sharing, and UPI QR code. Sign up for unlimited invoices.
Limit reached
5 invoices created
Guest users can create up to 5 invoices. Sign up free to create unlimited invoices with extra features.
GST Invoice in Excel — Dadra & Nagar Haveli and Daman & Diu GST Details
| Detail | Information |
|---|---|
| State | Dadra & Nagar Haveli and Daman & Diu |
| GST State Code | 26 |
| GSTIN Format | 26ABCDE1234F1Z5 |
| Capital City | Daman |
| Key Industries | manufacturing, chemicals, plastics, textiles, tourism |
| Template | GST Invoice Excel Template |
| Best For | Accountants, businesses using Excel-based bookkeeping |
| Intra-state Tax | CGST + SGST (buyer GSTIN starts with 26) |
| Inter-state Tax | IGST (buyer GSTIN starts with any code ≠ 26) |
Who Uses the GST Invoice in Excel in Dadra & Nagar Haveli and Daman & Diu?
This template is best suited for: Accountants, businesses using Excel-based bookkeeping. In Dadra & Nagar Haveli and Daman & Diu, businesses operating in the manufacturing, chemicals, plastics, textiles, tourism sectors frequently use this format. Companies based in Daman and other major cities including Silvassa, Daman, Diu rely on the GST Invoice Excel Template for day-to-day invoicing.
An Excel-based GST invoice template with auto-calculated tax columns. Perfect for businesses that manage invoices in spreadsheets alongside their accounts. Because Dadra & Nagar Haveli and Daman & Diu's GST state code is 26, all invoices raised by Dadra & Nagar Haveli and Daman & Diu-registered businesses must include a GSTIN starting with 26. This template pre-fills and validates this automatically.
Key features of this template:
- Auto-calculated CGST/SGST/IGST
- Multiple item rows
- HSN/SAC code column
- Compatible with Google Sheets
- Printable layout
How GST Works for Dadra & Nagar Haveli and Daman & Diu Businesses
Businesses registered in Dadra & Nagar Haveli and Daman & Diu (GST state code 26) follow standard CGST/SGST/IGST rules under the Goods and Services Tax Act. Here is how tax splits work when using this template:
| Sale Type | Tax Applied | Example (18% GST) |
|---|---|---|
| Intra-state (buyer in Dadra & Nagar Haveli and Daman & Diu) | CGST 9% + SGST 9% | ₹1,00,000 + ₹9,000 CGST + ₹9,000 SGST = ₹1,18,000 |
| Inter-state (buyer in another state) | IGST 18% | ₹1,00,000 + ₹18,000 IGST = ₹1,18,000 |
| Export (outside India) | Zero-rated (0% with LUT) | ₹1,00,000 + ₹0 GST = ₹1,00,000 |
The invoice generator auto-detects intra vs inter-state from the buyer's GSTIN. Dadra & Nagar Haveli and Daman & Diu-registered buyers have GSTINs starting with 26.
Common Mistakes to Avoid in Dadra & Nagar Haveli and Daman & Diu
When using the GST Invoice Excel Template in Dadra & Nagar Haveli and Daman & Diu, businesses often make these avoidable errors. Each mistake can result in a rejected invoice, ITC denial for your buyer, or a GST notice.
-
Hardcoding tax amounts instead of using formulas
-
Not locking formula cells to prevent accidental edits
-
Using the wrong GST state code — Dadra & Nagar Haveli and Daman & Diu businesses must use state code 26 in their GSTIN, not another state's code.
Frequently Asked Questions
What is the GSTIN format for Dadra & Nagar Haveli and Daman & Diu?
Dadra & Nagar Haveli and Daman & Diu has GST state code 26. Your GSTIN starts with 26 followed by your 10-digit PAN, for example: 26ABCDE1234F1Z5. The 13th character is your entity number (1 for the first registration), 14th is always Z, and 15th is a check digit.
Who should use the GST Invoice Excel Template in Dadra & Nagar Haveli and Daman & Diu?
This template is ideal for: Accountants, businesses using Excel-based bookkeeping. In Dadra & Nagar Haveli and Daman & Diu, it is especially relevant for businesses in manufacturing, chemicals, plastics, textiles, tourism — the state's dominant industries. Businesses in Daman and across Dadra & Nagar Haveli and Daman & Diu use this format for compliant GST invoicing.
Does a Dadra & Nagar Haveli and Daman & Diu business use CGST+SGST or IGST?
CGST + SGST for sales within Dadra & Nagar Haveli and Daman & Diu — when the buyer's GSTIN also starts with 26. IGST for sales to buyers in other states or union territories. The generator auto-detects this from the buyer's GSTIN, so you do not need to manually select the tax type.
Is the GST Invoice Excel Template free for Dadra & Nagar Haveli and Daman & Diu businesses?
Yes, completely free — no account, no subscription, no watermark. Generate a GST-compliant PDF invoice in the GST Invoice Excel Template format with Dadra & Nagar Haveli and Daman & Diu GST state code 26 pre-applied. Download and send to your client in under 60 seconds.
What is the GST registration threshold for businesses in Dadra & Nagar Haveli and Daman & Diu?
The standard GST registration threshold is ₹40 lakh annual turnover for goods-only businesses and ₹20 lakh for service businesses. Dadra & Nagar Haveli and Daman & Diu follows the standard thresholds. Once registered, every invoice must carry your GSTIN (starting with 26) and a proper CGST/SGST or IGST breakdown.
GST Invoice in Excel for Other States
Same template, pre-configured for every Indian state's GST code.
Create Your Free GST Invoice in Excel Now
Free GST Invoice Excel Template for Dadra & Nagar Haveli and Daman & Diu businesses. GST state code 26 auto-applied. CGST/SGST/IGST calculated instantly. No signup, no watermark.