Itinerary Pricing in Tourwriter

After you set up your Supplier rates, the pricing page will populate pricing for all bookable items added via the Build tab in any of your Tourwriter itineraries. To learn how to add rates to a Supplier, see Supplier Pricing on Tourwriter.

Itinerary pricing overview

The itinerary you create will have a complete itemised pricing table. The itemised prices are fetched from the supplier rates that you associate with each itinerary product and it’s associated options

Days: The days field displays the appropriate Day number or numbers the item is booked for. The Pricing display defaults to Order by Day.

Item: The Item field summarizes the Supplier Product details as per the itinerary builder. It includes the Product name, the Option and the Quantity, as well as the Supplier name and the Duration. To Order by Item, click the Item header.

Type: The Type field lists the Product Type as listed on the Supplier. To Order by Type click the Type header.

Net: The Net price indicates the price payable to the Supplier. The price is brought across from the Supplier setup. 

Markup: The default Markup % listed is as per the Supplier set up. The Markup % can also be edited. The Pricing display defaults to Markup %. A User can also display Commission % or Margin $ by selecting an option by clicking the cog icon.

Gross: The Gross amount is the price payable by the Traveler. The gross price is brought across from the Supplier. The Gross price is adjusted by adjusting the Net price or the Markup.

Itinerary pricing lines warnings

You may come across a warning message on an empty pricing line. This warning message relates to the absence of an associated Supplier rate for the duration of the Booking. To resolve this:

  • Add a pricing rate for the Supplier for that particular period.
  • Click Refresh to fetch the relative Supplier prices.
    • Note: You may also see a warning message on an empty pricing line when there is a Supplier Blackout period. Supplier Blackout period indicates the Supplier is closed for business during that period.

Note: If you’d like to secure specific prices or markup percentages from changing, lock those prices through the options menu before you refresh. To access Options, click on the 3 vertical dots at the end of each pricing row.

Editing booking prices

Even though your Supplier prices are brought across to the Itinerary automatically, you can overwrite prices at the itinerary level.

  1. Edit the price for each booking by accessing the Options menu (three vertical dots at the end of each row)
  2. Select Edit pricing.
  3. When editing the price of an item, you can edit the per person per day/night price, and the total price will be automatically updated.
  4. Change either the Net, Markup percent or the Gross price. As the Markup field is linked, adjusting the value of either one of Net or Gross will automatically adjust the other. Once the User selects the required field/column from Markup %, Margin $, Commission % or Sales tax %, the view will be saved for that User until he changes to other field/column in the same or other Itinerary.

Quantity

When we update quantity from the Build tab for an Item with Edited pricing, System refresh’s and fetches the Supplier rate, deleting the edited rates from the Itinerary in the process.

Users can now update the quantity directly from the Itinerary-> Pricing-> Edit pricing screen. System will use edited item prices for recalculating and will not fetch Supplier rates.

Locking booking prices

You can lock certain booking prices to prevent them from being overridden during a rate refresh or after changing the Supplier pricing once it has been added to the itinerary. The following are the Lock Rate options:

  • Lock net: Prevents the system from fetching updated Supplier net rates. Also, prevents Supplier level changes from reflecting in the itinerary.
  • Lock markup: Locks the Markup percentage. Changes to the Net rate at the Supplier level adjusts the gross price automatically.
  • Lock gross: Locks the Gross price. Changes to the Net rate at the Supplier level adjusts the markup automatically.
  • Lock all: None of the prices for this Product changes when prices are refreshed.

Note:

  1. It is recommended to lock all prices that are confirmed/set for the specific itinerary.
  2. If the Prices are locked, User will see a warning Quantity can’t be amended for services that are locked on the Pricing tab if they try to change the Quantity from the Build tab.

Adjusting the sale currency

Since each supplier can be set up with its own currency, some itineraries may contain line items displaying different currencies. The Itinerary pricing page displays a summary of each currency used in the itinerary at the bottom. Tourwriter lets you choose from two options for your currency conversion.

  1. To convert the currency, click the edit icon just above the total price.
  2. You can either refresh the conversion rate to fetch the online daily rate.
  3. Or you can manually overwrite the conversion rate by overtyping the value.

Adjusting the total price

You can display either the Total price or the Price per traveller. The Price per traveller divides the total itinerary price between all the travellers on the itinerary. To change the itinerary pricing to Price per traveller:

  1. Click on the drop-down at the bottom of the Pricing information. The two options presented are Total price and Price per traveller.
  2. Select Price per traveller.

The traveller also has an option to pay a deposit price. To enter a deposit amount:

  • Enter an Amount under Deposit information.
  • Select the Due date by when the traveller can make a deposit payment.

Create price history log

Users can keep a record of the itinerary Total price for future reference. The Price history records total for all the pricing columns along with the date/time the history was pinned and which User pinned the price. When adjusting products the final gross price for an itinerary may change. The Price history log allows a User to reference a historical price and restore this if required.

  • You can add the price to history by clicking the ‘pin’ button.
  • By clicking on more, you can see the price history.
  • When the last pinned price is equal to the current price, then the pin button is disabled.

Pricing display options

There are many options to set the way pricing appears on the Proposal or the Final Itinerary.

  1. Navigate to the Itinerary Pricing display options dropdown at the top of the Pricing Information page.
  2. Select one or more display options. The options you can choose to display are:
    • The total itinerary price.
    • Itemised pricing that displays the price per booking.
    • Price per traveller displaying the total price each traveller should pay.
    • Split Pricing
  3. You can select multiple options to display a combination of these pricing. But you can only choose one from Price per Traveller and Split Pricing.
  4. To send the itinerary to the traveller without adding a price, ensure none of the options are selected.

Update items

Update items feature allows Users to select multiple bookings and either refresh pricing or lock/unlock booking items. User needs to tick/untick the checkbox besides the item and then perform either Refresh pricing or lock/unlock. If none of the booking item is selected, the Update items button will be disabled.

Note: When performing Refresh pricing, only unlocked items will be refreshed.

Exporting pricing

After finalising the itinerary pricing you can download the pricing to a spreadsheet and upload it to your accounting tool. To download the pricing:

  1. Finalise the pricing by confirming the itinerary.
  2. Head to the Pricing tab.
  3. Click Export pricing to Export the Pricing information.

Following fields/columns will be exported in the Pricing export file.

  • Product
  • Option
  • Supplier
  • Supplier address
  • Product code
  • Inclusions
  • Duration
  • Quantity
  • Type
  • Day number
  • Start date
  • End date
  • Currency
  • Net
  • Net item
  • Markup
  • Gross
  • Gross item
  • Agent commission
  • Agent price
  • Agent price item

Note:

  1. If the itinerary is not confirmed, the Export pricing button will be disabled on the pricing page. Refer to this article to know more about confirming an itinerary.
  2. Agent commission, Agent price and Agent price item will only be exported if an Agent is added to the Itinerary.
  3. Clients on Premium plan can Export Pricing without having to Confirm the Itinerary.
  4. The Total Sales Tax % is the average of the individual bookings Sales Tax and is indicated by the prefix Avg.
  5. User can now set negative Markup, i.e. Gross can be less than the Net price.