Overview
These are ready-to-use formula examples for the most common financial reporting scenarios. To create any of these, go to Dashboard → Financial Reporting → Financial Settings → + Add custom formula and paste the value into the Value field.
Example 1: Owner Payout (after PM commission)
What it does: Calculates what the owner receives after your property management commission is deducted.
Value field: subTotalPrice - pmCommission
Settings:
- Display as percentage: No
- Apply to channels: All (unless your commission varies by channel — see Example 4)
Example 2: PM Commission (fixed percentage)
What it does: Calculates your management fee as a percentage of the subtotal.
Value field (for 20% commission): subTotalPrice * 0.2
Settings:
- Display as percentage: No (the result is already a currency amount)
- Name suggestion: "PM Commission 20%."
⚠️ If you want to display the commission rate (not the amount) as a percentage in reports, use value 0.2 and tick Display as percentage. This shows "20%" in your Rental Activity tab instead of a currency value.
Example 3: Total Guest Revenue (what the guest actually paid)
What it does: Combines the nightly rate, cleaning fee, and any other guest-facing fees.
Value field: totalPrice
Or if you need to separate it: nightlyRate + cleaningFee + totalGuestFees
Note: totalPrice already includes all guest-paid amounts. Use the broken-out version only if you need to report on fee components separately.
Example 4: Channel-specific revenue formula (e.g., Airbnb vs Booking.com)
What it does: Creates separate revenue columns per channel, since each OTA calculates totals differently.
Step 1 — Create an Airbnb-specific formula:
- Value: totalPrice
- Apply only to specific channels: ✅ Airbnb
- Name: "Revenue – Airbnb"
Step 2 — Create a Booking.com-specific formula:
- Value: totalPrice
- Apply only to specific channels: ✅ Booking.com
- Name: "Revenue – Booking.com"
Step 3 — Create a combined total formula:
- Value: [Revenue – Airbnb] + [Revenue – Booking.com]
- Apply to channels: All
- Name: "Total Revenue (All Channels)"
This is the recommended approach when different channels pass revenue fields differently.
Example 5: Net Revenue (after channel commission)
What it does: Shows what you receive after the OTA takes its cut.
Value field: totalPrice - channelCommission
Note: channelCommission is only populated for channels that pass this field via API (Airbnb passes it; Booking.com typically does not). For Booking.com, you may need to create a formula that estimates it: totalPrice * 0.15 (replace 0.15 with your actual Booking.com commission rate).
Important behaviour to know
- Formulas created at the account level propagate to all listings automatically
- If you manually edit a formula at the listing level, that listing will no longer inherit future account-level changes — you must update it manually
- You can nest formulas up to 7 levels deep (Formula A can reference Formula B, which references Formula C, etc.)
- Deleting a formula replaces it with 0 everywhere it is used — always check what references it before deleting