Operating worksheet and calculator
Rental Payment Installment Balance Worksheet
AI-assisted editorial guide and tool · Published November 21, 2026
Use this worksheet to review a payment schedule that the parties have already agreed. Enter the total, net payments retained, any approved reduction and the number of remaining equal installments. The tool calculates a balance and a rounding-aware split; it does not establish a debt, change a reservation or authorize collection.
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.
Two-decimal currency rounding only. This worksheet neither authorizes a charge nor applies platform-specific payment rules.
Use the accepted schedule
Match the total to the accepted reservation or written agreement and identify what it includes. Enter net payments retained after any prior refunds, and do not deduct those refunds again as a new reduction. A proposed discount is not an approved adjustment. Keep the agreement, provider payment record and any accepted change together so the arithmetic can be reviewed.
Understand the split
The remaining balance is the greater of zero and total less retained payments and the approved reduction. The tool divides the balance into the entered count, rounding the first installments down to cents and assigning the remainder to the final one. It assumes a currency with two decimal places. It does not calculate interest, late fees or a provider’s installment rules.
Worked example
An agreed total of 1,200 less 300 retained and a 25 approved reduction leaves 875. Across three installments, the first two are 291.66 each and the last is 291.68. Together they equal 875. If retained payments plus the reduction exceed the total, the balance is zero and the excess appears separately instead of creating negative installments.
Reconcile the actual collection
Confirm due dates and allowed payment methods through the relevant booking or payment system. A balance on this screen does not make a charge permissible. After each actual payment, update the retained amount and remaining count from the provider record. If a dispute or pending payment exists, identify it separately rather than treating an uncertain amount as settled cash.