Free to use, no sign-up, no email asked.
The columns
| Column | What goes in it |
|---|---|
| Item | What you are buying, as the supplier names it: hotel and room type with meal plan, vehicle, activity. |
| Unit | How the supplier charges: per room per night, per vehicle per day or per km, per person. |
| Quantity | Nights times rooms, days, or travellers. The step where most mistakes happen. |
| Cost | Your rate per unit, from the supplier's latest rate, with the date you got it. |
| Markup | What you add on this line, as rupees or a percentage. Yours to decide, line by line. |
| Sell | Cost plus markup, times quantity. What this line earns from the customer. |
A costing sheet, filled in
The sample as it prints. Every number is made up for the example, and the markups are there to show the arithmetic, not to suggest what you should add.
Saffron Route Holidays
Costing sheet, for the agency only. Not for the customer.
Udaipur and Jaipur, 4 nights
12-16 Dec 2026, 2 adults, 1 child
Ticket T-0142
| Item | Days | Quantity | Cost | Markup | Sell |
|---|---|---|---|---|---|
| Lakeview Haveli, deluxe, CP | Day 1-2 | 2 nights | ₹6,200 | +₹800 | ₹14,000 |
| Pink City Courtyard, premium, MAP | Day 3-4 | 2 nights | ₹7,400 | +10% | ₹16,280 |
| Innova Crysta with driver | Day 1-5 | 5 days | ₹3,800 | +₹400 | ₹21,000 |
| Lake Pichola sunset boat | Day 1 | 3 persons | ₹700 | at cost | ₹2,100 |
| Amber Fort jeep and entry | Day 4 | 3 persons | ₹900 | +₹100 | ₹3,000 |
| Total cost | ₹51,000 | ||||
| Total sell, before GST | ₹56,380 | ||||
| Margin | ₹5,380, 9.5% | ||||
Cost is per unit. Sell is cost plus markup, times quantity. Margin is total sell less total cost, and its percentage is of the sell total.
Sample costing sheet: the agency, trip, rates and markups are an example. Free costing sheet from triplli.com/guides/tour-package-costing-sheet
Five checks before you quote
- Quantities match the trip. Four nights is four room nights per room, not five; five days of car is pick-up day to drop day.
- Children are costed on what they use. An extra bed, a child rate on the activity, nothing on a room they share.
- Every rate has a date. A hotel rate from last season can wipe out the margin on a whole trip.
- The margin is worth the work. Look at it in rupees as well as percent. A small percentage on a big trip can be good money; a good percentage on a small one may not be.
- GST and TCS are handled once. Decide whether the sell total includes GST, and for an overseas trip add TCS on top. The pricing guide works through both.
Keep the costing away from the customer
The costing sheet and the quotation are two documents for two readers. Copy prices from one to the other, never the sheet itself: a customer who sees a hotel's rate next to your total will ask why they should not book it themselves. The workbook keeps them on separate sheets for that reason. The quotation format covers what the customer's side holds.
Costing in Triplli
In Triplli the costing sheet is the estimate on the ticket. Each line is an item from your catalogue with its unit, quantity, your cost and your markup, as rupees or a percentage, and the total, your margin in rupees and percent, update as you type. Each remembered rate shows how old it is. The estimate PDF the customer gets shows prices at the level of detail you choose and never your cost or margin. See quotations in Triplli.
