Module: M1-R5: Information Technology Tools and Network Basics
Chapter: Ch1 Computer Intro
This spreadsheet demonstrates how to create a Sales Invoice in Excel or LibreOffice Calc with automatic GST (Goods and Services Tax) calculation, including CGST, SGST, IGST, and Total Amount.
| Invoice No. | Customer Name | Product Name | Quantity | Rate (₹) | Total (₹) | GST % | GST Amount (₹) | Final Amount (₹) |
|---|---|---|---|---|---|---|---|---|
| INV001 | Ravi Kumar | LED TV | 2 | 25000 | =D2*E2 | 18% | =F2*18% | =F2+G2 |
| INV002 | Priya Sharma | Washing Machine | 1 | 30000 | =D3*E3 | 12% | =F3*12% | =F3+G3 |
| INV003 | Neha Gupta | Air Conditioner | 1 | 45000 | =D4*E4 | 18% | =F4*18% | =F4+G4 |
| INV004 | Karan Singh | Refrigerator | 1 | 28000 | =D5*E5 | 12% | =F5*12% | =F5+G5 |
| INV005 | Pooja Mehta | Laptop | 2 | 55000 | =D6*E6 | 18% | =F6*18% | =F6+G6 |
| INV006 | Rohit Verma | Mobile Phone | 3 | 18000 | =D7*E7 | 12% | =F7*12% | =F7+G7 |
| INV007 | Arjun Das | Tablet | 1 | 25000 | =D8*E8 | 18% | =F8*18% | =F8+G8 |
=D2*E2 → Calculates the total before tax (Quantity × Rate).=F2*18% → Calculates the GST amount (18% of total value).=F2+G2 → Calculates the final invoice amount after adding GST.| Invoice No. | Total (₹) | CGST (9%) | SGST (9%) | Final Amount (₹) |
|---|---|---|---|---|
| INV001 | 50000 | =B2*9% | =B2*9% | =B2+C2+D2 |
| INV003 | 45000 | =B3*9% | =B3*9% | =B3+C3+D3 |
IGST (Integrated GST) applies for inter-state sales at a single rate (e.g., 18%).
This Sales Invoice sheet helps small businesses and retailers calculate their total, GST, and final billing amount instantly. It can also be used to maintain monthly sales data for accounting and GST filing purposes.
Login with Google