Formulas are calculations. We have created some default ones for you that you cannot delete but you can edit them.

If you wish to edit the existing formulas or create new formula please navigate to Dashboard > Financial reporting > Financial settings

Note:

• They can be created on an account level (Dashboard > Financial reporting > Financial settings) or listing level and can be modified at any level. Modifications are done at the Account level propagate to the Listing but not vice versa.
• We support +, -, *, (), /
• Default Formulas values can be reset to their original ones after modification by just clicking on the cross (x) next to it

How to create your own formulas?

1. Click on Add Custom Financial Field
2. Give it a name (Space is not allowed nor punctuation)
   
3. The system will prompt you with any Standard Fields available or other custom formulas. When typing, it will show suggestions.
   When creating formulas you can use any operand (*, +, -, /) and even () to determine the order of the operations
   
   4. You can now build your own calculations for some specific channels:
   
   
   
   5. You can also build your own calculations to apply for a specific reservation status:
   
   
   
   6. Click on Save. The formula will be available on the Listings Financials as a new column.

Note: When a new custom formula is created, it will propagate to all listings as well. But you can modify it on a listing level. It will not update other listings.
When editing a formula on a Settings level, it will edit all unmodified formulas on a listing level. IF you have modified it manually, you will need to update it manually.

When the formula is saved it also becomes available in the Listings Financials table as a new column. The value of the column will show the result of the formula calculation as it has been set up. In our example: (baseRate+Sales Tax) -20:

Using formulas within formulas

We allow the creation of formulas within formulas for up to 7 levels. This means that formula A can contain formula B and formula B can contain formula C and so on until G.

A validation will still appear if the system identifies a loop scenario or an error will be generated if you try to create a formula within a formulator of more than 7 levels.

Set up a formula per channel

In some cases, you want to have a different formula only for specific channels. For example, if you want to create a formula to reflect the Reservation Total. Every channel is in this case different.

To do so, go to Settings > Financial and Coupons > Add Custom Financial Field

Create your formula and select "Apply only to specific channels". You will be able to select channels that you want this formula to apply to.

What about if you want to combine the results of these formulas?

So let's say, now that you have created your formula per channel, to reflect Total Reservation, you want to add them together.

You only need to create one general formula within Value, the different formulas per channel you have created earlier.

Default Formulas

See below some tables with the default formulas content:

You can find a list of all Financial Fields