If you've ever quoted a client based on last season's hotel rate and then discovered the price went up 20%, you know the pain. Rate card management isn't glamorous, but it directly protects your margins.
The cost of bad rate card management
Here's what happens when you don't have a system:
- You quote old rates → vendor charges more → you absorb the loss or renegotiate with the client (both bad)
- You quote too high → client compares with another agent who has current rates → you lose the booking
- You waste time → digging through WhatsApp chats and old emails for "that rate the hotel sent last month"
- You miss seasonal opportunities → early-bird rates expire because you didn't track validity dates
What belongs in a rate card system
For each vendor rate card, track:
| Field | Why it matters |
|---|---|
| Vendor name | Obvious |
| Destination | Quick filtering when quoting |
| Property/Service name | Specific hotel, vehicle type, activity |
| Room/Category types | Deluxe, Superior, Suite - with rates for each |
| Meal plans | CP, MAP, AP - with per-person supplement |
| Validity dates | Start and end - the most critical field |
| Child policy | Age brackets, complimentary/chargeable rules |
| Cancellation terms | Free cancellation deadline, penalty structure |
| Blackout dates | Festivals, peak periods with surcharges |
| Special inclusions | Welcome drink, spa credit, airport transfer |
| Agent commission | Your margin or commission percentage |
| Last updated | When you last verified this rate is current |
Organizing rate cards
By season
Most Indian domestic hotels have 3–4 rate seasons:
- Off-season (monsoon, low demand months)
- Regular season (standard months)
- Peak season (Diwali, Christmas, New Year, summer vacations)
- Super peak (specific festival dates, long weekends)
File rate cards by their validity period so you can quickly grab the correct season's rates.
By destination
If you specialize in 5–10 destinations, create a folder per destination with all vendor rate cards for that location - hotels, transport, guides, activities.
By vendor type
Some agents prefer organizing by:
- Hotels (sorted by city)
- Transport (sorted by city)
- DMCs (sorted by country/region)
- Activities/Experiences (sorted by city)
Choose whatever structure you'll actually maintain. The best system is one you use consistently.
Rate card lifecycle
1. Collection (start of season)
- Email/WhatsApp all regular vendors requesting updated rate cards
- Set a deadline: "Please share by [date] so I can update my quoting system"
- Follow up once if they don't respond - vendors are busy too
2. Entry
- Update your system (spreadsheet, tool, or software) with new rates
- Flag any significant price increases (more than 15%) - you may need to adjust package pricing
- Note any new inclusions or policy changes
3. Monitoring
- Set reminders 2 weeks before each rate card expires
- Track which vendors haven't sent updated rates
- Monitor if actual booking confirmations match quoted rates (catch discrepancies early)
4. Renewal
- When a rate card is about to expire, reach out to the vendor
- If they don't respond in time, mark that vendor's rates as "unverified" in your system
- Never quote unverified rates to clients without a caveat
Common rate card traps
"Rates subject to availability"
This means the vendor can charge more during high-demand periods even within the stated validity. Ask them to specify blackout dates upfront.
"Net rates" vs "Gross rates"
- Net rates: What you pay the vendor (your selling price adds your margin on top)
- Gross rates: Published rates with your commission built in (you earn X% of this)
Make sure you know which one you're looking at before quoting.
"Compulsory gala dinner supplement"
Many hotels add mandatory supplements for Christmas Eve, New Year's Eve, and Diwali. These can be ₹3,000–₹10,000 per person. Check for these before quoting holiday period packages.
Currency fluctuations
For international rate cards quoted in foreign currency, the rate you pay depends on the exchange rate at the time of payment, not at the time of quoting. Build a 3–5% forex buffer into your quotes.
Moving from spreadsheets to software
If you're managing 20+ rate cards across multiple destinations, spreadsheets start breaking:
- Formulas break when rows are added
- Multiple people can't edit simultaneously
- No automatic expiry alerts
- Searching across sheets is slow
At this scale, dedicated software saves time and prevents costly errors.
How TripDraft helps
TripDraft's rate card module stores all your vendor rates with validity dates, categories, and meal plan supplements. When you build a quote, it pulls the correct rate automatically. When a rate card is about to expire, you get an alert to request updated rates from the vendor.