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 listed below or create your own custom formulas.
Booking Columns
Booking
Already Remitted
Already Remitted Directly
Arrival
Booked On
Booking #
By Statement Date: % of nights that occurred on or before the statement date
Can Remit: Amount (prorated by Guest Paid, or In Period)
Categorized "As Rent" Charges
Departure
Expenses: Total of all booking expenses
Full Commission Charges
Future Security Deposits
Gross
Guest Count
Guest Fees
Guest First Name
Guest Last Name
Guest Name
Guest Paid: How much the guest has actually paid on the booking.
Hidden Expenses: Total of hidden booking expenses
Host Fees
In Period: % of nights that occurred within the statement period
Listing Site
Nights
Non-Commission: Amount excluded from commission
Non-Standard Commission Charges
Property #
Property Name
Remitting Now
Status
Taxes
Undeposited Payments
Undeposited Refunds
Undeposited Charges
Charge Categories
Rent Only
Tax
Cancellation Fee
Cleaning Fee
Discount
Pet Fee
[No Category]: Blank column that allows you to enter descriptive text.
Expense Categories
Accounting
Commissions
Credit Card Processing
Damage Protection
Tax
[No Category]: Blank column that allows you to enter descriptive text.
Taxes
County Tax
State Tax
Expense Columns
Already Reimbursed
Amount (Voided)
Arrival
Attachment Count
Attachments
Booked On
Booking #
By Statement Date: % of expense that occurred on or before the statement date
Can Reimburse: Amount (prorated for booking expenses by booking Guest Paid, or In Period)
Category
Departure
Description
Description With Attachments
Gross
Guest First Name
Guest Last Name
Guest Name
Guest Paid: How much the guest has actually paid on the expense
In Period: % of expense that occurred within the statement period
Nights
Owner Name
Paid On
PM Account
Property #
Property Name
Recorded
Reimbursing Now: The amount to be reimbursed. This column is added as a default column and is required.
Voided
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.
Below is a list of the variables available for users to create their own custom formulas.
Custom Formula Examples
Net = [Gross] - [HiddenExpenses]
Net Prorated = [Gross] * [PercentInPeriod] - [HiddenExpenses]
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]