📽️ Video Split Formulas

For property managers who need to divide income or fees between owners and management, Clearing's Split Formula makes it easy to automate percentage-based financial splits directly within your rules sequence. Whether you're sharing a cleaning fee, splitting a channel commission markup, or distributing a custom fee for a specific owner, Split Formulas give you precise control without manual adjustments on every booking.

Login to your Clearing account and navigate to the Rules section in the side menu. Click on On Booking Financials, then Rules Sequence, and navigate to 4. Custom Formulas. Select the + next to the Split option to create a new split formula.

Required:

First, select the incoming category you want to split. This is the source line from the booking that will be divided.

Next, review and confirm when to apply the split rule relative to your other rules. The rule sequence order has a real impact on how financials are calculated. Always verify where your new rule lands in the sequence, especially if you have complex or layered rules already in place. For example, if you are splitting a category after the default allocation, the default position is likely appropriate. If your split depends on a fee created by another rule, ensure this rule falls after it in the sequence.

Optional:

Use the other filters on the left to set the formula to apply to specific bookings such as by homeowner, asset, channel, date range, or guest name. If this split should apply to all bookings, then these additional filters can be left unset.

Define how the incoming category gets divided by configuring each output row. Click the + button to add as many rows as needed, as long as they equal up to 100%. For each row, set the new outgoing category, the percentage allocated to that row, the destination (To Owner, To Management, Exclude, etc).

Give the rule a clear, descriptive name and optionally add a note to document its purpose.

Navigate to the Bookings section and find a booking that falls within your formula's criteria. Open the booking and click Refresh Reservation to apply the current rules. Verify that the incoming category is divided into the expected output lines with the correct allocations. The rule name will be visible below each line it has applied to.

You can update a formula's status at any time from the formula settings.

Ongoing — The formula will automatically apply to all new bookings that meet the criteria. Use the "Apply to existing bookings" button to also apply it to current unlocked bookings.

Paused — The formula will stop applying to new bookings but remains saved. Useful when you need to temporarily disable a rule without deleting it.

Cancelled — The formula is permanently inactive. Use this when a rule is no longer needed.

Manual — The formula only applies when you manually trigger it on a specific booking. Useful for one-off scenarios or testing before setting a formula to Ongoing.

Have questions? Reach out to us in the chat, we are happy to help!