Trial Demo
OwnerRez
Property Management » PMv2 » Statement Views
Updated 1 week ago

Built-in Formula Columns

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, 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: The total of remittances for this booking that have been remitted on previous statements.

  • Already Remitted Directly: The amount of remittance the guest paid directly to the owner (entered on each booking under the PM tab).

  • Arrival: Date of booking arrival

  • Booked On: Date the reservation was booked

  • Booking #: The OwnerRez booking ID number preceded by ORB, e.g., ORB12345678

  • 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: Date of booking departure

  • Expenses: Total of all booking expenses

  • Full Commission Charges: Total of line items which have 100% commission

  • 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: Number of guests for a booking

  • Guest Fees: Listing channel (e.g., Airbnb, Booking.com, Vrbo, etc.) fees paid by the guest

  • Guest First Name: First name of guest

  • Guest Last Name: Last name of guest

  • Guest Name: Full guest name

  • Guest Paid: How much has the guest has currently paid for the booking as a percentage of the total

  • Hidden Expenses: For a complete explanation, see the Hide Booking Expense Categories section of the Statement Views Setup & Configuration support article.

  • Host Fees: Fees paid by the host such as channel commission, or credit card fees charged by your payment processor

  • In Period: % of nights that occurred within the statement period

  • Listing Site: Listing channels (e.g., Airbnb, Booking.com, Vrbo, etc.) 

  • Nights: Number of nights

  • Non-Commission: The amount excluded from commission. This is the sum of zero commission surcharges and host fees with commission "given back."

  • Non-Standard Commission Charges: The total of line items (other than taxes) that have a commission different from the owner's standard commission.

  • 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. (unavailable on Standard statement views)

  • 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). (unavailable on Standard statement views)

  • Property #: The OwnerRez property ID number preceded by ORP, e.g., ORP1234567

  • Property Name: Name of the property

  • Remitting Now: The booking amount 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.

  • Status: Booking status (e.g., Pre-stay, Mid-stay, Post-stay, Canceled)

  • Taxes: Taxes charged to guests for the booking

  • Undeposited Payments: The total of payments that have not yet been deposited.

  • Undeposited Refunds: The total of refunds that have not yet been withdrawn.

  • Zero Commission Charges: All surcharge line items with zero commission

Charge Categories

  • Rent Only: Nightly rent charged to guest, often displayed as the total booking rent

  • Tax: Taxes charged to guest

  • Cancellation Fee: Cancellation fee charged to guest upon cancellation

  • Cleaning Fee: Cleaning fee charged to guest

  • Discount: Discount applied to booking

  • Pet Fee: Pet fee charged to guest

  • [No Category]: Blank column that allows you to enter descriptive text.

Expense Categories

  • Accounting: Account fees (e.g., office or QuickBooks fees)

  • Commissions: Commissions charged to expenses

  • Credit Card Processing: Credit card fees charged by your payment processor

  • Damage Protection: Damage Protection policy amounts

  • Tax: Taxes charged for the booking

  • [No Category]: Blank column that allows you to enter descriptive text.

Taxes

  • County Tax: County taxes charged for the booking

  • State Tax: State taxes charged for the booking

Expense Columns

  • Already Reimbursed: Amounts reimbursed to the Property Manager on previous owner statements

  • Amount (Voided): The previous expense amount if the expense has been voided

  • Arrival: Date of booking arrival

  • Attachment Count: Number of expense files attached

  • Attachments: Attached expense files

  • Booked On: Date the reservation was booked

  • Booking #: The OwnerRez booking ID number preceded by ORB, e.g., ORB12345678

  • 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: Regular or custom expense category (e.g., cleaning fee, additional guest fee, resort fee, etc.)

  • Departure: Date of booking departure

  • Description: Expense description

  • Description With Attachments: Description with included links to attached expense files

  • Gross: The amount of the expense (or previous amount if voided)

  • Guest First Name: First name of guest

  • Guest Last Name: Last name of guest

  • Guest Name: Full guest name

  • Guest Paid: The amount of the expense that has been paid by the guest (based on the total guest paid percentage)

  • In Period: % of expense that occurred within the statement period

  • Nights: Number of nights

  • Owner Name: Property owner name

  • Paid On: The date on which the expense was paid

  • PM Account: The selected account from which this expense was paid—either Escrow or Operations

  • Property #: The OwnerRez property ID number preceded by ORP, e.g., ORP1234567

  • Property Name: Name of the property

  • Recorded: Date expense is recorded

  • Reimbursing Now: The amount to be reimbursed. This required column is added as a default column.

  • Voided: Whether the expense had been voided. Either Yes or No.

  • Custom Formula