Operating worksheet and calculator
Reservation Change Cash-Difference Calculator
AI-assisted editorial guide and tool · Published November 20, 2026
A reservation amendment changes the price agreement, but the cash still due also depends on prior payments and approved credits. Use this calculator to keep those two questions separate. Enter original and revised components in the same currency, then record payments already received and credits that are genuinely approved. It does not apply a platform cancellation policy or initiate a charge.
Enter your assumptions
The starting values are a hypothetical worked example, not your property data. Calculations run in your browser; entries are not submitted or saved after a reload. Use one consistent currency where money is involved.
Positive net due is a modeled balance, not payment authorization. Verify the accepted change and provider rules before acting.
Document the accepted amendment
Use the actual reservation and proposed or accepted change record. Distinguish an estimate sent in a message from a change confirmed through the applicable booking process. Identify which fees or taxes change and which remain fixed. The calculator accepts your figures; it does not establish that a guest owes an amount merely because you enter it.
Read the two differences
Original total and revised total each sum lodging, fees and taxes. The booking-price change is revised total minus original total. Net due is revised total less additional approved credit and payments already received. A negative net due indicates that the entered payments and credit exceed the revised charge, rather than instructing you to issue a refund automatically.
Worked example
The original example totals 750 currency units and the revised components total 960. The booking price increases by 210. Because 750 has already been received and an additional 20 credit is approved, the remaining modeled balance is 190. The distinction matters: charging another 210 would ignore the separate approved credit in this example.
Use payment records consistently
Enter payments on the same basis as the revised price. If a prior refund has already reduced payments retained, use the net amount still held and document that treatment. Do not both net the refund from payments and enter it again as a credit. Do not mix the guest’s total with the owner’s net payout after platform fees.
Confirm the actual transaction
Review the platform or payment provider’s final calculation before charging or refunding. Timing, policy, taxes and fees may produce a different actual result. Keep the accepted amendment, transaction confirmation and worksheet together. An unresolved discrepancy should remain an open item for the responsible operator or adviser rather than being disguised with an unexplained balancing entry.