Dealer Price List Template in Excel
SKU, HSN, pack size, MRP and GST in one list, with three dealer tiers priced from a single discount each. Free, no sign-up.
Download the dealer price list template
A filled-in example
The sample in the file, a building materials distributor's list. Tier prices are the list price less each tier's discount.
| SKU code | Product | HSN | Unit | Pack | MRP | List price | Tier A (−12%) | Tier B (−8%) | Tier C (−5%) | GST | List price incl. GST | MOQ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CEM-OPC53-50 | Cement, OPC 53 grade | 2523 | Bag | 50 kg | 420.00 | 330.00 | 290.40 | 303.60 | 313.50 | 18% | 389.40 | 50 |
| CEM-PPC-50 | Cement, PPC | 2523 | Bag | 50 kg | 400.00 | 315.00 | 277.20 | 289.80 | 299.25 | 18% | 371.70 | 50 |
| TMT-500D-08 | TMT bar Fe 500D, 8 mm | 7214 | MT | Bundle | – | 54,000.00 | 47,520.00 | 49,680.00 | 51,300.00 | 18% | 63,720.00 | 1 |
| TMT-500D-12 | TMT bar Fe 500D, 12 mm | 7214 | MT | Bundle | – | 52,000.00 | 45,760.00 | 47,840.00 | 49,400.00 | 18% | 61,360.00 | 1 |
| BW-25 | Binding wire | 7217 | Coil | 25 kg | 2,100.00 | 1,650.00 | 1,452.00 | 1,518.00 | 1,567.50 | 18% | 1,947.00 | 10 |
What each column means
- SKU code
- Your code for each product and pack, so orders and price changes refer to one exact item.
- Product name and category
- The name your dealers know it by, and a category to filter on.
- HSN code
- The product's HSN code, which sets its GST rate and goes on every invoice.
- Unit and pack size
- How it's sold (bag, box, carton, MT) and what one unit contains.
- MRP
- The maximum retail price printed on the pack, if there is one.
- List price
- Your base price for dealers, excluding GST, before any tier discount.
- Tier prices
- The list price less each tier's discount. They calculate themselves.
- GST rate and price including GST
- The rate for the HSN code, and the list price with GST added, for reference.
- MOQ
- The minimum quantity per order.
- Effective from and valid until
- The dates the list applies. Keep old versions for reference.
Keep price lists under control
- Date every version
- An order can then always be checked against the prices that applied on its date.
- Quote prices before GST
- Give the GST rate beside each price; the invoice adds CGST and SGST, or IGST, depending on the place of supply.
- Keep schemes separate
- Quarter-end or target-based scheme discounts given after the sale don't change list prices. How they're taxed depends on how they're agreed and settled, so check with your chartered accountant.
Tired of sending price lists every month?
In ZunderFlow's dealer ordering app each dealer sees only their own price list, and every order is priced from it automatically. Your catalogue and price lists are set up for you in the first 72 hours.
See how ZunderFlow handles dealer pricingDealer Price List Questions
Everything you need to know about ZunderFlow. Can't find what you're looking for? Reach out to our team.
Ready to Structure Your Dealer Commerce Network?
Centralize dealer ordering, delivery workflows, inventory sync, pricing control and operational visibility in one unified infrastructure platform. Most businesses are live within 72 hours.
Trusted by growing dealer networks managing structured order workflows across distribution driven businesses. Operating continuously since 2022.