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 Columns support article. Some OwnerRez built-in columns may be enough to suit your needs. Custom formulas are for PMs who find that the OwnerRez built-in columns 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).
- Within the body of a formula, you may use all arithmetical operators: addition (+), subtraction (-), multiplication (*), and division (/). In addition, you may use parentheses around portions of the formula to control the order of operations.
- Each formula is configured with a format specifier. You can select dollar sign ($), no dollar sign (0.00), or rounding (0) from the right dropdown menu.
- Formulas do not allow the use of the "Prorate (PR)" checkbox. This is because you can easily prorate your formula by multiplying your equation by [PercentInPeriod] to achieve the same effect.
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]Amount received after hidden expenses - 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 + Commission - Non-Owner Charges (charges where the entire amount is kept by the PM) or is the amount received by the PM for the owner (which includes the commission the owner owes to the PM). (unavailable on Standard statement views) - Owner Amount minus Expenses, Taxes and Damage Protection:
[Gross] - [Expenses] - [ExpenseCategory_Tax] - [ExpenseCategory_DamageProtection] - Previous Received:
[AlreadyRemitted] + [AlreadyRemittedDirectly]The total of remittances for this booking that have been remitted on previous statements + the amount of remittance the guest paid directly to the owner (entered on each booking under the PM tab).
Custom Formula Variables
[AlreadyRemitted]The total of remittances for this booking that have been remitted on previous statements.[AlreadyRemittedDirectly]The amount of remittance the guest paid directly to the owner (entered on each booking under the PM tab).[CanRemit]Amount (prorated by Guest Paid, or In Period)[CategorizedAsRentCharges]=[ChargeCategory_RentOnly] + [CategorizedAsRentCharges][Expenses]Total of all booking expenses[FullCommissionCharges]Total of line items that have 100% commission[Gross]Total amount received[GuestCount]Number of guests for a booking[GuestFees]Listing channel (e.g., Airbnb, Booking.com, Vrbo, etc.) fees paid by the guest[HiddenExpenses]For a complete explanation, see the Hide Booking Expense Categories section of the Statement Views Setup & Configuration support article.[HostFees]Fees paid by the host, such as channel commission or credit card fees charged by your payment processor.[Nights]Number of nights[NightsInPeriod]Number of nights within the statement period[NonCommission]The amount excluded from commission. This is the sum of zero commission surcharges and host fees with commission "given back."[NonStandardCommissionCharges]The total of line items (other than taxes) that have a commission different from the owner's standard commission.[PercentBeforeStatementDate][PercentInPeriod][RemittingNow]The booking amount is to be remitted on this statement. This required column is added as a default column. The Remitting Now PMv2 calculation is (Total Amount (paid so far by guest, with prorations applied) - Already Paid to Owner - Hidden Expenses). So if PMs want to subtract commission or other expenses from that, like in PMv1, they would need a new view where those expense categories are hidden. Columns can also be added based on expense categories if the PM wants all that information in the booking columns.[Tax_CountyTax_1509][Tax_StateTax_1508][Taxes]Taxes charged to guests for the booking.[UndepositedPayments]The total of payments that have not yet been deposited.[UndepositedRefunds]The total of refunds that have not yet been withdrawn.[ZeroCommissionCharges]All surcharge line items with zero commission
Income categories reflect the total of charges on the booking in the selected category. Only categories used on configured surcharges are displayed in the column list; however, any category can be used in a formula. An unused category will be equal to zero (0) when the formula is evaluated.
[IncomeCategory_AdditionalBed][IncomeCategory_AdditionalGuestFee][IncomeCategory_AdministrativeFee][IncomeCategory_AirConditioningFee][IncomeCategory_BabyBed][IncomeCategory_BathLinens][IncomeCategory_BedLinens][IncomeCategory_BookingFee][IncomeCategory_CancellationFee][IncomeCategory_CityTax][IncomeCategory_Class][IncomeCategory_CleaningFee][IncomeCategory_CleaningUtensils][IncomeCategory_Club][IncomeCategory_Concierge][IncomeCategory_ConsumptionFee][IncomeCategory_DailyCleaningFee][IncomeCategory_DamageWaiver][IncomeCategory_Discount][IncomeCategory_DrinkingWater][IncomeCategory_EarlyArrival][IncomeCategory_EarlyBooking][IncomeCategory_EarlyDepartureFee][IncomeCategory_ElectricityFee][IncomeCategory_Energy][IncomeCategory_Equipment][IncomeCategory_FinalCleaningFee][IncomeCategory_FoodFee][IncomeCategory_FoodUtensils][IncomeCategory_Gardening][IncomeCategory_Gas][IncomeCategory_HeatingFee][IncomeCategory_HighChair][IncomeCategory_HotTub][IncomeCategory_InternetUsageFee][IncomeCategory_Labor][IncomeCategory_LateArrival][IncomeCategory_LateBooking][IncomeCategory_LateDepartureFee][IncomeCategory_LaundryFee][IncomeCategory_LinenFee][IncomeCategory_Management][IncomeCategory_Oil][IncomeCategory_OnSitePaymentMethod][IncomeCategory_Other][IncomeCategory_ParkingFee][IncomeCategory_PetFee][IncomeCategory_Phone][IncomeCategory_Pool][IncomeCategory_PoolHeating][IncomeCategory_PropertyAssociation][IncomeCategory_PropertyFee][IncomeCategory_RefundableDamageDeposit][IncomeCategory_RentOnly][IncomeCategory_ReservationFee][IncomeCategory_ResortFee][IncomeCategory_ServiceFee][IncomeCategory_Spa][IncomeCategory_Tax][IncomeCategory_Toiletries][IncomeCategory_Tour][IncomeCategory_TouristTax][IncomeCategory_Transportation][IncomeCategory_VehicleUsageFee][IncomeCategory_Water][IncomeCategory_WaterCraft][IncomeCategory_WaterCraftMooring][IncomeCategory_Wood]
Discount categories reflect the total of discounts on the booking in the selected category. Only categories used in configured discounts are shown in the column list; however, any category can be used in a formula. An unused category will be equal to zero (0) when the formula is evaluated.
[DiscountCategory_AdditionalBed][DiscountCategory_AdditionalGuestFee][DiscountCategory_AdministrativeFee][DiscountCategory_AirConditioningFee][DiscountCategory_BabyBed][DiscountCategory_BathLinens][DiscountCategory_BedLinens][DiscountCategory_BookingFee][DiscountCategory_CancellationFee][DiscountCategory_CityTax][DiscountCategory_Class][DiscountCategory_CleaningFee][DiscountCategory_CleaningUtensils][DiscountCategory_Club][DiscountCategory_CommunityPropertyAssociation][DiscountCategory_Concierge][DiscountCategory_ConsumptionFee][DiscountCategory_DailyCleaningFee][DiscountCategory_DamageWaiver][DiscountCategory_Discount][DiscountCategory_DrinkingWater][DiscountCategory_EarlyArrival][DiscountCategory_EarlyBooking][DiscountCategory_EarlyDepartureFee][DiscountCategory_ElectricityFee][DiscountCategory_Energy][DiscountCategory_Equipment][DiscountCategory_FinalCleaningFee][DiscountCategory_FoodFee][DiscountCategory_FoodUtensils][DiscountCategory_Gardening][DiscountCategory_Gas][DiscountCategory_HeatingFee][DiscountCategory_HighChair][DiscountCategory_HotTub][DiscountCategory_InternetUsageFee][DiscountCategory_Labor][DiscountCategory_LateArrival][DiscountCategory_LateBooking][DiscountCategory_LateDepartureFee][DiscountCategory_LaundryFee][DiscountCategory_LinenFee][DiscountCategory_Management][DiscountCategory_None][DiscountCategory_Oil][DiscountCategory_Other]Airbnb New Listing 20% Off Discounts are included as an 'Other Discount'.[DiscountCategory_OnSitePaymentMethod][DiscountCategory_ParkingFee][DiscountCategory_PetFee][DiscountCategory_Phone][DiscountCategory_Pool][DiscountCategory_PoolHeating][DiscountCategory_PropertyFee][DiscountCategory_RefundableDamageDeposit][DiscountCategory_RentOnly][DiscountCategory_ReservationFee][DiscountCategory_ResortFee][DiscountCategory_ServiceFee][DiscountCategory_Spa][DiscountCategory_Tax][DiscountCategory_Toiletries][DiscountCategory_Tour][DiscountCategory_TouristTax][DiscountCategory_Transportation][DiscountCategory_VehicleUsageFee][DiscountCategory_Water][DiscountCategory_WaterCraft][DiscountCategory_WaterCraftMooring][DiscountCategory_Wood]
Expense categories reflect the total of expenses on the booking in the selected category. Only categories you have used on expenses are shown in the column list, but any category may be used in a formula. An unused category will be equal to zero (0) when the formula is evaluated.
[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]