Operating worksheet and calculator

Rental Payout Reconciliation Bridge

AI-assisted editorial guide and tool · Published November 20, 2026

Use this worksheet when a bank deposit differs from the booking receipts you expected. Enter one reporting currency and one clearly defined payout group. The calculator bridges gross receipts to an expected bank transfer; it does not retrieve transactions, interpret a platform dispute or determine tax treatment. All starting figures are illustrative and must be replaced with your records.

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.

An arithmetic match does not prove every transaction is valid or correctly classified. Use actual payout and bank records.

Use one transaction group

Start with a payout reference or a documented group of transfers. Record the report date and whether the gross figure includes taxes, cleaning or other guest charges. Do not combine bookings from one period with bank receipts from another without identifying the timing difference. The same currency must apply to every amount entered in this bridge.

Understand the calculation

Expected transfer equals gross receipts minus the four deduction categories. Other deductions can be negative when the documented item is an addition. The difference equals the actual bank receipt minus that expected amount. A positive difference means more money arrived than the model explains; a negative result means less arrived. Neither sign alone identifies the cause.

Worked example

The example starts with 1,000 currency units of receipts. Deductions are 100 in fees, 50 in refunds, 200 for a co-host and 25 in other adjustments. The expected transfer is 625. An actual receipt of 625 leaves no numerical difference. Replace every category before applying this structure to a real payout; the example does not represent a standard platform fee.

Avoid double counting

A refund already removed from the gross input must not be deducted again. Likewise, a manager fee paid separately from another bank account does not belong in this transfer bridge unless it actually reduced this payout. Keep each source entry beside the field it supports. If one deduction relates to an earlier booking, preserve that booking reference rather than forcing it into the current stay.

Resolve the difference

Compare the result with payment-provider statements and bank records. Investigate processing dates, currency conversion, withheld balances and routing before describing money as missing. Do not change a payout method simply to make the worksheet balance. Record the identified explanation or an open support case, then send the reconciled evidence to the person responsible for the books.

Grab A Time To Speak To See If We Can Help!

Step 1 of 2: Enter your contact details. Next, choose a time for your call.

Having trouble? Use our on-site scheduling page.