Built-in Formula Columns

This support article is under construction 👷

Please pardon the incompleteness while we work on this. We have made the article visible in the meantime because the content may be useful.

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.

OwnerRez built-in formulas may be enough to suit your needs. However, some PMs may find that the OwnerRez built-in formulas listed below just aren't enough for their needs or have specific calculations that they have developed as a part of their vacation rental business operations. If that is the case, check out our Custom Formula Columns support article.

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: [ChargeCategory_RentOnly] + [CategorizedAsRentCharges]
  • Departure
  • Expenses: Total of all booking expenses
  • Full Commission Charges
  • Future Security Deposits
  • Gross: [Gross] - [HiddenExpenses] (Note that the Gross column is still available on Standard views but will display the entire Gross minus hidden expenses as a total amount.)
  • 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
  • Owner Net: Owner Amount - Taxes (if paid by owner) - Damage Protection (if paid by owner) or is the amount the owner would expect to pocket after all liabilities are paid.
  • Owner Revenue: 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).
  • 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

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 Formula