E-Commerce Business Management Excel Template India | Inventory, Orders, GST, P&L Dashboard for Online Sellers (INR)

Run your whole online store from ONE Excel file. No extra software, no monthly subscription.

Stop juggling five different sheets for orders, stock, suppliers and GST. This ready-made E-Commerce Business Management Excel Template is built for Indian online sellers. Every amount is in Indian Rupees (₹), with lakh and crore formatting on Indian regional settings. Record your orders and stock, and the dashboard, profit & loss and GST summary update automatically.

Who is this for?

• Sellers on Amazon India, Flipkart, Meesho or your own Shopify / WooCommerce store
• Instagram and WhatsApp sellers
• D2C brands, resellers, dropshippers and small wholesalers
• Anyone who wants to know their real profit after commission, shipping, returns and expenses

What’s inside (13 linked sheets)

1. Start Here: a quick guide, colour legend and rules.
2. Dashboard: 18 KPI cards covering net sales, gross profit, net profit, orders, average order value, return rate, cancellation rate, repeat customer %, inventory value, out-of-stock SKUs, reorder alerts and supplier dues. It also has a monthly sales vs profit chart, channel and category charts, and a top-10 products table.
3. Orders: a sales register with 6,000 pre-formulated rows. Enter 10 basic fields and it calculates GST, taxable value, cost of goods, platform fees and net profit per order.
4. Products & Inventory: live stock (opening + purchased − sold + returned), stock value, margin %, stock status (In Stock / Reorder Now / Out of Stock), suggested reorder quantity and profit ranking per SKU.
5. Customers (CRM): order count, lifetime spend, last order date, average order value and VIP / Repeat / New segments.
6. Suppliers: total purchased, paid and outstanding payable per vendor.
7. Purchases: stock inward entries with GST input credit and Paid / Part Paid / Unpaid status.
8. Returns & RTO: log returns, choose whether to restock, and track return losses.
9. Expenses: rent, salaries, ads, packaging, software and more, with GST.
10. Profit & Loss: a 12-month statement from net sales to gross profit, contribution profit and net profit.
11. GST Summary: output GST vs input tax credit, GST rate-wise sales and an HSN-wise summary.
12. Sales Analysis: profit by sales channel, product category and payment mode, including COD and return analysis.
13. Settings: your business details, financial year, channel commission %, categories, payment modes and drop-down lists.

Key features

• Works with current GST slabs (0%, 5%, 18%, 40%)
• Drop-down lists on key fields to reduce typing errors
• Colour-coded status alerts for stock, orders and payments
• Cancelled and returned orders are automatically excluded from revenue and profit
• Change the financial year in one cell and the whole workbook updates
• No macros, no add-ins and no coding needed
• Fully editable, with all formulas unlocked
• Includes realistic demo data (₹38+ lakh net sales, 3,800 orders, 238 SKUs, 3,800 customers, 25 suppliers) so you can see it working, then clear the blue input cells and start fresh

Requirements

• Microsoft Excel 2019, 2021 or Microsoft 365 (Windows or Mac)

What you receive

• 1 Excel file (.xlsx) as an instant digital download
• Demo data included
• Built-in instructions on the “Start Here” sheet

Please note

• All names, GSTINs, phone numbers and emails in the demo are fictional.
• Commission rates, HSN codes and GST rates in the demo are illustrative. Please confirm them with your CA and your seller account.
• This is a business tracking tool. It does not file GST returns and is not tax or legal advice.
• This is a digital product. No physical item will be shipped.