The Property Management Statement Views provide users with significant flexibility in configuring their Owner Statements, including the option for custom formulas. As you create your statement view for your customized Owner Statements, you use the pre-built OwnerRez fields or formulas or create your own custom formulas.
Before you start creating custom formulas, check out the Built-in Formula Columns support article. Some OwnerRez built-in formulas may be enough to suit your needs. Custom formulas are for PMs who find that the OwnerRez built-in formulas just aren't enough for their needs or have specific calculations that they have developed as a part of their vacation rental business operations.
Create Custom Formulas
The option to create a custom formula is at the bottom of both the Booking and Expense column dropdown lists.
When you select Custom Formula from either dropdown list, you can click on the formula calculator icon to open the Custom Formula pop-up.
When creating your custom formula, you can select dollar sign ($), no dollar sign (0.00), or rounding (0) from the right dropdown menu. Remember that you can include all math operators: addition (+), subtraction (-), multiplication (*), division (/), and percentages as a multiplier (i.e., * .5 for 50% off).
After you've entered your custom formula from the available variables, click on Done.
When using custom formulas, while not required, it is best practice to add text to the Help Text field.
Below is a list of all the variables available for users to create their own custom formulas.
Custom Formula Examples
- Net:
[Gross] - [HiddenExpenses] - Net For Commission:
[Gross] - [NonCommission] - Net Prorated:
[Gross] * [PercentInPeriod] - [HiddenExpenses] - Owner Amount :
[Gross] * [PercentInPeriod] - [Expenses] - Owner Revenue:
[Gross] - [FullCommissionCharges] - [Expenses] + [ExpenseCategory_Commission] + [ExpenseCategory_DamageProtection] - Owner Amount minus Expenses, Taxes and Damage Protection:
[Gross] - [Expenses] - [ExpenseCategory_Tax] - [ExpenseCategory_DamageProtection] - Previous Received:
[AlreadyRemitted] + [AlreadyRemittedDirectly]
Custom Formula Variables
[AlreadyRemitted][AlreadyRemittedDirectly][CanRemit][CategorizedAsRentCharges]
[ChargeCategory_AdditionalBed][ChargeCategory_AdditionalGuestFee][ChargeCategory_AdministrativeFee][ChargeCategory_AirConditioningFee][ChargeCategory_BabyBed][ChargeCategory_BathLinens][ChargeCategory_BedLinens][ChargeCategory_BookingFee][ChargeCategory_CancellationFee][ChargeCategory_CityTax][ChargeCategory_Class][ChargeCategory_CleaningFee][ChargeCategory_CleaningUtensils][ChargeCategory_Club][ChargeCategory_Concierge][ChargeCategory_ConsumptionFee][ChargeCategory_DailyCleaningFee][ChargeCategory_DamageWaiver][ChargeCategory_Discount][ChargeCategory_DrinkingWater][ChargeCategory_EarlyArrival][ChargeCategory_EarlyBooking][ChargeCategory_EarlyDepartureFee][ChargeCategory_ElectricityFee][ChargeCategory_Energy][ChargeCategory_Equipment][ChargeCategory_FinalCleaningFee][ChargeCategory_FoodFee][ChargeCategory_FoodUtensils][ChargeCategory_Gardening][ChargeCategory_Gas][ChargeCategory_HeatingFee][ChargeCategory_HighChair][ChargeCategory_HotTub][ChargeCategory_InternetUsageFee][ChargeCategory_Labor][ChargeCategory_LateArrival][ChargeCategory_LateBooking][ChargeCategory_LateDepartureFee][ChargeCategory_LaundryFee][ChargeCategory_LinenFee][ChargeCategory_Management][ChargeCategory_Oil][ChargeCategory_OnSitePaymentMethod][ChargeCategory_Other][ChargeCategory_ParkingFee][ChargeCategory_PetFee][ChargeCategory_Phone][ChargeCategory_Pool][ChargeCategory_PoolHeating][ChargeCategory_PropertyAssociation][ChargeCategory_PropertyFee][ChargeCategory_RefundableDamageDeposit][ChargeCategory_RentOnly][ChargeCategory_ReservationFee][ChargeCategory_ResortFee][ChargeCategory_ServiceFee][ChargeCategory_Spa][ChargeCategory_Tax][ChargeCategory_Toiletries][ChargeCategory_Tour][ChargeCategory_TouristTax][ChargeCategory_Transportation][ChargeCategory_VehicleUsageFee][ChargeCategory_Water][ChargeCategory_WaterCraft][ChargeCategory_WaterCraftMooring][ChargeCategory_Wood]
[ExpenseCategory_Accounting][ExpenseCategory_Advertising][ExpenseCategory_Channel][ExpenseCategory_Cleaning][ExpenseCategory_Commission][ExpenseCategory_CreditCardProcessing][ExpenseCategory_DamageProtection][ExpenseCategory_HOA][ExpenseCategory_Insurance][ExpenseCategory_Lawncare][ExpenseCategory_Legal][ExpenseCategory_Linens][ExpenseCategory_Maintenance][ExpenseCategory_Management][ExpenseCategory_Membership][ExpenseCategory_Other][ExpenseCategory_Rent][ExpenseCategory_Repairs][ExpenseCategory_Resort][ExpenseCategory_Storage][ExpenseCategory_Supplies][ExpenseCategory_Tax][ExpenseCategory_Trash][ExpenseCategory_Utilities]
[Expenses][FullCommissionCharges][Gross][GuestCount][GuestFees][HiddenExpenses][HostFees][Nights][NonCommission][NonStandardCommissionCharges][PercentBeforeStatementDate][PercentInPeriod][RemittingNow][Tax_CountyTax_1509][Tax_StateTax_1508][Taxes][UndepositedPayments][UndepositedRefunds][ZeroCommissionCharges]