Once you are happy with your itinerary pricing, this page covers how to apply bulk updates, round prices, and export the final pricing data to your accounting tool.
Updating multiple items at once
The Update items feature lets you apply actions to several bookings simultaneously, rather than row by row.
To use Update items:
- Tick the checkbox to the left of each booking you want to update.
- Click the Update items dropdown and choose an action.
NOTE: If no items are selected, the Update items button will be disabled.
Refresh pricing
Fetches the latest Supplier rates for the selected bookings. Only unlocked items will be refreshed — locked items are skipped.
Lock / Unlock
Applies or removes a price lock on the selected bookings. See the Editing & Locking Booking Prices article for details on lock types.
Rounding item prices
You can round Gross prices (or Agent Prices if an Agency is added) up to the nearest value of your choice. This is useful for presenting clean, round figures to travellers.
When an item is first added or its price is edited, Tourwriter automatically rounds to two decimal places. You can apply further rounding using the steps below.
To round item prices:
- Select the item(s) by ticking the checkbox on the left.
- From the Update items dropdown, choose Round item prices.
- In the Price type dropdown, select Gross prices or Agent prices.
- Enter the rounding increment in the Round up to the nearest field.
- Click Update.
Formula: Ceiling(price ÷ rounding factor) × rounding factor
Examples:
Price before rounding
| Round up to nearest | Price after rounding |
123.45 | 0.05 | 123.50 |
123.45 | 1 | 124.00 |
123.45 | 2 | 124.00 |
123.45 | 5 | 125.00 |
123.45 | 10 | 130.00 |
123.45 | 100 | 200.00 |
After rounding:
- When Gross prices are rounded: Markup, Margin, Commission, Agent Price, and Agent Commission/Markup recalculate using the rounded Gross and the Net.
- When Agent prices are rounded: Agent Commission/Markup recalculates using the rounded Agent Price and the Gross.
Exporting pricing
You can download the final pricing as a spreadsheet to upload into your accounting system.
To export:
- Confirm the itinerary.
- Go to the Pricing tab.
- Click Export pricing.
NOTE: The Total Tax rate % in the export is an average of the individual booking tax rates, indicated by the prefix Avg. You can also set a negative Markup, meaning Gross can be less than Net.