Tripwix Logo
tripwix Property Rates Tool
Property Rates Tool

Property Rates & Fees
Manager

Create a property, save it to database, open/edit it later, and export a CSV with property setup fields plus all seasonal rates.

Manage Properties
Tripwix Rates Tool
Database connected · Changes can be saved anytime
Saved

Create New Property

Add a new property to the database

Saved Properties

Search and manage your saved properties

Property Setup

No property opened
Select a Rate Type to calculate NTC.
Suggested VAT: Portugal 6% · Mexico 16%

Visible Formulas

▼
Public Display Rate = ((Public Display Rate / (1 + VAT Rate %)) * (1 - Commission Percentage %)) / (1 - (Commission Percentage % + Commission Added %))
NTC = (Rate per night * (1 - Commission Percentage %)) / (1 - (Commission Percentage % + Commission Added %))
Payout Rate = (Payout Rate / (1 + VAT Rate %)) / (1 - (Commission Percentage % + Commission Added %))
Net Payout Rate = Net Payout Rate / (1 - (Commission Percentage % + Commission Added %))
Total Seasons 0
Average Owner Rate $0
Highest Rate $0
Average Net Nightly $0

Seasonal Rates

Instructions: Fill in the dates, season, minimum nights and rate per night. The system calculates the NTC automatically based on the selected Rate Type, VAT and commission fields.

From To Season Min Night Stay Rate from Owner NTC (Value to BO) Actions

Assets & Notes

Glossary

▲
Public Display Rate

Final public rate shown to guests including VAT and Tripwix commission.

Formula: ((Public Display Rate / (1 + VAT Rate %)) * (1 - Commission Percentage %)) / (1 - (Commission Percentage % + Commission Added %))
NTC

Net rate value to insert in the BO / Hostfully.

Calculated automatically based on the selected Rate Type.
Payout Rate

Rate the owner wants to receive before Tripwix commission.

Formula: (Payout Rate / (1 + VAT Rate %)) / (1 - (Commission Percentage % + Commission Added %))
Net Payout Rate

Rate the owner wants to receive excluding VAT.

Formula: Net Payout Rate / (1 - (Commission Percentage % + Commission Added %))
Rate per night

Nightly value provided by the owner depending on the selected Rate Type.

Formula when Rate Type is NTC: (Rate per night * (1 - Commission Percentage %)) / (1 - (Commission Percentage % + Commission Added %))
VAT Rate

VAT percentage applied to the property country.

Suggested VAT: Portugal 6% · Mexico 16%
Commission Percentage

Tripwix commission percentage deducted from payout calculations.

Commission Added %

Additional commission percentage added to the calculation when applicable.

Country

Country where the property is located.

Activity Log

▼
Open a property to see activity.

Property History