A bill of entry Excel template is the most practical format for importers handling multiple line items, because spreadsheet formulas automatically calculate duty amounts, IGST, and totals as you enter values. This eliminates manual arithmetic errors that can cause customs queries. This guide covers the field structure, formula setup, and how to use Excel format for both Indian (ICEGATE) and international customs declarations.
Why Excel Is the Best Format for Multi-Item Shipments
When a shipment contains more than 2–3 different product types — each with its own HS code and duty rate — manually calculating total duty in a Word document or PDF is error-prone. Excel solves this with:
- Auto-calculated duty per line — enter CIF value and BCD rate; formula computes duty amount
- Running totals — SUM formulas aggregate total BCD, SWS, IGST, and overall tax
- Data validation — dropdown lists for common HS chapters or Incoterms reduce keying errors
- Multiple sheet tabs — separate tabs for header, item lines, documents list, and duty summary
- Sorting and filtering — useful for large shipments to check entries by HS code, value, or origin
Excel Bill of Entry — Recommended Sheet Structure
| Sheet Tab | Contents |
|---|---|
| Header | Importer, IEC, GSTIN, port, vessel, BL/AWB, IGM, invoice details, Incoterms, insurance |
| Items | Line-by-line: HS code, description, quantity, unit, FOB/CIF per unit, CIF total, BCD%, BCD amount, SWS (10% of BCD), IGST base, IGST%, IGST amount, total tax per line |
| Duty Summary | Auto-summed: total CIF, total BCD, total SWS, total IGST base, total IGST, grand total tax |
| Documents | List of supporting documents: type, reference number, e-Sanchit document code, status (attached/pending) |
| Reference | HS code lookup, port codes, country codes for quick reference while filling |
Key Excel Formulas for Duty Calculation (India)
For an Indian bill of entry, set up the following formulas in the Items sheet (assuming CIF value is in column G, BCD rate in column H):
| Field | Formula (example, row 2) | What It Calculates |
|---|---|---|
| BCD Amount | =G2*H2 | Basic Customs Duty |
| SWS Amount | =I2*0.10 | Social Welfare Surcharge (10% of BCD) |
| IGST Base | =G2+I2+J2 | CIF + BCD + SWS |
| IGST Amount | =K2*L2 | IGST% × IGST Base |
| Total Tax/Line | =I2+J2+M2 | BCD + SWS + IGST |
The duty summary tab should use =SUM(Items!I:I) style cross-sheet formulas to pull totals automatically.
India Duty Formula — Worked Example in Excel
Suppose you import industrial pumps (HS 8413.70) worth CIF ₹10,00,000. BCD = 7.5%, SWS = 10% of BCD, IGST = 18%:
| Field | Formula | Amount (₹) |
|---|---|---|
| CIF Value | Given | 10,00,000 |
| BCD (7.5%) | =10,00,000 × 7.5% | 75,000 |
| SWS (10% of BCD) | =75,000 × 10% | 7,500 |
| IGST Base | =10,00,000 + 75,000 + 7,500 | 10,82,500 |
| IGST (18%) | =10,82,500 × 18% | 1,94,850 |
| Total Tax | =BCD + SWS + IGST | 2,77,350 |
Bangladesh Duty Formula in Excel
For Bangladesh imports via ASYCUDA World, the duty stack is more complex. For a CIF value of BDT 5,00,000 and a garment machinery item (CD=1%, RD=0%, SD=0%, VAT=15%, AIT=5%):
| Duty Component | Calculation | Amount (BDT) |
|---|---|---|
| Customs Duty (CD 1%) | =5,00,000 × 1% | 5,000 |
| Regulatory Duty (RD 0%) | =5,00,000 × 0% | 0 |
| VAT Base | =CIF + CD + RD | 5,05,000 |
| VAT (15%) | =5,05,000 × 15% | 75,750 |
| AIT (5%) | =5,05,000 × 5% | 25,250 |
| Total | 1,06,000 |
Exporting Excel to Other Formats
- To PDF: File → Save As → PDF for bank submission or signed copy
- To CSV: Save As → CSV (comma delimited) for ERP upload or customs software import
- To Google Sheets: Upload .xlsx to Google Drive → Open with Sheets for cloud collaboration
Frequently Asked Questions
Can I use a bill of entry Excel template for multiple shipments?
Yes — save a clean master copy and use "Save As" for each shipment. Alternatively, add a new sheet tab per shipment in a running workbook for the same supplier or product category.
Does Indian customs (ICEGATE) accept Excel for filing?
No — ICEGATE requires electronic filing through the portal. The Excel template is for internal preparation and handing data to your CHA. Some CHAs also accept data in Excel format to copy into their filing software.
How do I handle multi-currency in the Excel template?
Keep invoice values in the original currency (USD, EUR, etc.) in one column, add the customs exchange rate declared by CBIC/NBR, and multiply to get the local currency value for duty calculation. CBIC publishes exchange rates fortnightly; NBR publishes them weekly.
Free template download
Open HTML or Word in any editor. For PDF, use Print → Save as PDF in your browser. Import CSV into Excel or Google Sheets.
Prepare your import documentation
Use free templates, country guides, and step-by-step customs topics — no account required.