Examples
Examples
Try the starting example
- Booking ledger [gross currency,commission currency,taxes withheld currency,refund currency]; enter JSON (USD)
- [[200,30,10,0],[150,20,5,20]]
- Actual OTA payout (USD)
- 265
- Expected payout (USD)
- $265.00
- Payout discrepancy (USD)
- $0.00
Try another scenario
- Booking ledger [gross currency,commission currency,taxes withheld currency,refund currency]; enter JSON (USD)
- [[250,35,12,10],[180,25,8,0]]
- Actual OTA payout (USD)
- 330
- Expected payout (USD)
- $340.00
- Payout discrepancy (USD)
- -$10.00
Calculation method
Calculation method
Expected payout (USD)
Sum gross−commission−withheld taxes−refund.
Payout discrepancy (USD)
Actual−expected.
Symbols and units
- a
- Booking ledger [gross currency,commission currency,taxes withheld currency,refund currency]; enter JSON (USD)
- b
- Actual OTA payout (USD)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- Ledger supplied in one currency with fees/taxes already assigned their signs; no tax law determination. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. All numeric values must be finite. Lists contain at most 100 records; required lists must be nonempty. Rates, probabilities and fractions are entered as fractions, not percentages; fractions must be between 0 and 1. Use a single consistent user-selected currency for all amounts; no exchange-rate conversion.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.