The quick answer
An Excel invoice works best when input cells, calculations and the final document are easy to distinguish. Use one consistent record of quantity, price, discount and applicable tax instead of typing the total independently in several places.
The downloadable English workbook is an editable example, not a government submission tool. Adapt its document type and particulars to your registration and supply. Spreadsheet formulas can reduce arithmetic work but do not determine GST classification or legal eligibility.
Before you begin
- Seller identity, document type, number and date.
- Customer and supply details appropriate to the transaction.
- Item quantities, prices, discounts and verified tax treatment.
See how the pieces connect
Inputs
Enter seller, buyer and line information.
Calculation
Derive taxable value and tax from inputs.
Review
Check formulas, particulars and balances.
Document
Save an issued copy and maintain the register.
Work through the steps
Download and preserve the starter
Keep an untouched copy, then save a working version with a meaningful name. Check the workbook’s sample notes. Replace sample identities before considering the file an actual business document.
Complete the document header
Enter the appropriate bill or invoice type, seller and buyer particulars, date and number. Verify registration information and place of supply where applicable. Do not reuse a sample GSTIN or number.
Enter the line inputs
Use description, classification where needed, unit, quantity, price and discount. Keep rates numeric so formulas can calculate. Check whether the price is GST-inclusive or exclusive before applying tax formulas.
Review the calculated amounts
Trace line value, taxable value, components and total back to inputs. Test one simple line independently. If you insert rows, verify that formulas and totals include the new rows and do not duplicate old ones.
Check formatting and issue requirements
Preview the print area, column widths and page breaks. Confirm every required particular is visible. A well-formatted workbook does not replace separate e-invoice or e-way obligations.
Save a fixed issued copy
Retain the editable working file and an issued PDF or print copy. Track the invoice in a register and connect actual payments. Avoid overwriting an issued file with the next customer’s details.
A worked example
Use inputs once and calculate the result
Illustrative tax-exclusive line with a hypothetical 18% tax rate and a valid ₹50 adjustment.
| Calculation | Formula idea | Amount |
|---|---|---|
| Line value | Quantity 2 × price ₹500 | ₹1,000 |
| Taxable value | Line value − ₹50 | ₹950 |
| Illustrative GST | ₹950 × 18% | ₹171 |
| Total | Taxable value + GST | ₹1,121 |
Changing quantity or price should update the calculated values. If a total remains unchanged, inspect whether it was typed manually or its formula range is incomplete.
Download the Excel templateEditable English template (.xlsx). Replace the sample details and verify the tax treatment before issuing a document.
Common mistakes to avoid
- Typing totals manually while leaving contradictory line formulas.
- Issuing sample identities or an incorrect document type.
- Inserting lines outside the summation range.
- Overwriting the only copy of an issued invoice.
Questions you might have
Is the Excel template a substitute for stock software?
It is a document starter. A connected billing application can also link supported sales to stock, balances and payments; a standalone workbook does not automatically maintain those records.
Can I save an invoice as PDF?
Use Excel’s print or PDF export after checking the full print area. Verify that required particulars are not clipped or moved onto an unexplained second page.
Dukanam
A smart, low-cost choice for small-business GST billing
Dukanam brings billing, purchases, stock, customer balances, payments and reports together. It is built for Indian small businesses that want clear records without a complicated setup.
Best suited to shops that want connected everyday billing and bookkeeping, web and mobile access, and nine product languages. Choose the plan that includes the features you need.
GST-aware billing and preparation depend on your plan. Review records before filing on the GST portal; Dukanam does not directly submit GST returns, government e-invoices or e-way bills.
Current plans with GST preparation
- Advanced Plan₹299.00 per month
Check annual prices, limits, applicable taxes and checkout terms. Paid plans do not include a free trial.
Sources and further reading
Official rules and portal screens can change. Use the linked authority for the current requirements; the figures in our worked examples are illustrative.