GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 7) - Free Printable
Educational worksheet: GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 7). Download and print for classroom or home learning activities.
JPG
736×942
95 KB
Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #1943278
⭐
Show Answer Key & Explanations
Step-by-step solution for: GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 7)
▼
Show Answer Key & Explanations
Step-by-step solution for: GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 7)
The image you've uploaded is a blank tax invoice template used in India, specifically formatted according to the Goods and Services Tax (GST) guidelines. It's designed for businesses to issue invoices to customers, detailing the goods or services provided, along with applicable taxes.
However, since this is a blank form with no data filled in, there is no specific problem or task visible in the image that needs solving.
---
Let’s break down the components of the invoice:
#### 1. Company Information
- Company Name: Placeholder for the seller’s name.
- Address: NO - 00, ABC Road, ABC PURAM, Chennai, Tamil Nadu, PIN: 600000
- Contact: Tel +91 1234567890
- GSTIN: 33AAAA0000A1Z5 (This indicates the company is registered under GST in Tamil Nadu)
#### 2. Invoice Header
- Invoice No.: To be filled by the seller.
- Invoice Date: Date of issuance.
- Reverse Charge (Y/N): Indicates if reverse charge applies (i.e., buyer pays tax).
- State & State Code: Tamil Nadu (Code: 33)
- Buyer Details: Name, Address, GSTIN
#### 3. Itemized Table
| S.No | Product Description | HSN Code | Qty | Rate | Amount | Discount | Taxable Value |
|------|---------------------|----------|-----|------|--------|----------|----------------|
| | | | | | | | |
- HSN Code: Harmonized System Nomenclature code for classification of goods.
- Taxable Value: Calculated as (Qty × Rate) – Discount
#### 4. Totals Section
- Total Invoice amount in words: For legal clarity.
- Total Amount before Tax: Sum of taxable values.
- Add: CGST % and Add: SGST %: Central and State GST rates (e.g., 9% each for 18% total GST).
- Grand Total: Final amount including taxes.
#### 5. Bank Details
- Bank A/C No., Bank Name, Branch Name, IFSC Code — for payment reference.
#### 6. Terms & Conditions
- Custom terms agreed upon between buyer and seller.
#### 7. Certification & Signature
- "Certified that the particulars given above are true and correct"
- Authorized signatory section.
---
Since the form is blank, here are common tasks related to such an invoice:
#### 1. How to Fill Out This Invoice?
- Fill in:
- Invoice Number and Date
- Buyer’s Name, Address, GSTIN
- Product details (Description, HSN, Qty, Rate)
- Calculate Amount = Qty × Rate
- Apply Discount (if any)
- Taxable Value = Amount – Discount
- Total Taxable Value → Add CGST & SGST
- Grand Total = Taxable Value + CGST + SGST
- Write total in words
- Add bank details and terms
- Sign and certify
#### 2. Example Calculation
Suppose:
- Product: Pen
- HSN: 4016
- Qty: 10
- Rate: ₹100
- Discount: ₹50
- CGST: 9%, SGST: 9%
Then:
- Amount = 10 × 100 = ₹1000
- Taxable Value = 1000 – 50 = ₹950
- CGST = 9% of 950 = ₹85.50
- SGST = 9% of 950 = ₹85.50
- Grand Total = 950 + 85.50 + 85.50 = ₹1121
> Write: "One Thousand One Hundred Twenty-One Only"
---
Please clarify what you'd like me to do with this invoice, such as:
- Fill it out with sample data?
- Explain GST calculations?
- Convert it into a digital format?
- Identify missing fields?
Let me know your goal, and I’ll help step-by-step!
However, since this is a blank form with no data filled in, there is no specific problem or task visible in the image that needs solving.
---
🔍 What This Template Includes:
Let’s break down the components of the invoice:
#### 1. Company Information
- Company Name: Placeholder for the seller’s name.
- Address: NO - 00, ABC Road, ABC PURAM, Chennai, Tamil Nadu, PIN: 600000
- Contact: Tel +91 1234567890
- GSTIN: 33AAAA0000A1Z5 (This indicates the company is registered under GST in Tamil Nadu)
#### 2. Invoice Header
- Invoice No.: To be filled by the seller.
- Invoice Date: Date of issuance.
- Reverse Charge (Y/N): Indicates if reverse charge applies (i.e., buyer pays tax).
- State & State Code: Tamil Nadu (Code: 33)
- Buyer Details: Name, Address, GSTIN
#### 3. Itemized Table
| S.No | Product Description | HSN Code | Qty | Rate | Amount | Discount | Taxable Value |
|------|---------------------|----------|-----|------|--------|----------|----------------|
| | | | | | | | |
- HSN Code: Harmonized System Nomenclature code for classification of goods.
- Taxable Value: Calculated as (Qty × Rate) – Discount
#### 4. Totals Section
- Total Invoice amount in words: For legal clarity.
- Total Amount before Tax: Sum of taxable values.
- Add: CGST % and Add: SGST %: Central and State GST rates (e.g., 9% each for 18% total GST).
- Grand Total: Final amount including taxes.
#### 5. Bank Details
- Bank A/C No., Bank Name, Branch Name, IFSC Code — for payment reference.
#### 6. Terms & Conditions
- Custom terms agreed upon between buyer and seller.
#### 7. Certification & Signature
- "Certified that the particulars given above are true and correct"
- Authorized signatory section.
---
✔ Possible Tasks You Might Want Help With:
Since the form is blank, here are common tasks related to such an invoice:
#### 1. How to Fill Out This Invoice?
- Fill in:
- Invoice Number and Date
- Buyer’s Name, Address, GSTIN
- Product details (Description, HSN, Qty, Rate)
- Calculate Amount = Qty × Rate
- Apply Discount (if any)
- Taxable Value = Amount – Discount
- Total Taxable Value → Add CGST & SGST
- Grand Total = Taxable Value + CGST + SGST
- Write total in words
- Add bank details and terms
- Sign and certify
#### 2. Example Calculation
Suppose:
- Product: Pen
- HSN: 4016
- Qty: 10
- Rate: ₹100
- Discount: ₹50
- CGST: 9%, SGST: 9%
Then:
- Amount = 10 × 100 = ₹1000
- Taxable Value = 1000 – 50 = ₹950
- CGST = 9% of 950 = ₹85.50
- SGST = 9% of 950 = ₹85.50
- Grand Total = 950 + 85.50 + 85.50 = ₹1121
> Write: "One Thousand One Hundred Twenty-One Only"
---
🛠️ If You Have a Specific Task...
Please clarify what you'd like me to do with this invoice, such as:
- Fill it out with sample data?
- Explain GST calculations?
- Convert it into a digital format?
- Identify missing fields?
Let me know your goal, and I’ll help step-by-step!
Parent Tip: Review the logic above to help your child master the concept of printable invoice with gst template.