Getting Started

Core Concepts

Channel Management

Integrations

Messaging

Overview

Communication History

OwnerRez APIs

Payment Processing

Property Management

Reporting

Websites

Updates & Archives

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

County Tax

State Tax

Custom Formula

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