Which Completed Guesty Stays Are Missing From a Payout?
A guest checked out last week. The booking shows revenue. The deposit is smaller than expected. Before chasing the difference, find out which record needs checking.
Use the booking and payout references
If you work in Excel, bring a reservations sheet, itemized payout or processor statement, and bank deposits. Keep reservation ID, payout ID, amount, and payout date where available.
If you use Guesty, bring your reservations CSV and itemized GuestyPay payout reconciliation report. Use files for the same processor and booking scope. Add the bank extract.
Reconcile in two passes
Match reservations to the payout detail using the available IDs. Account for fees, refunds, and stays still within their payout window. Then match each total payout to the bank deposit. One deposit can cover several bookings.
In this example, stay R-204 has an expected $620 net payout and no matching item after the expected payout date. Put it on the follow-up list with the reservation ID and processor reference.
What to ask Jolene.pro
Which completed reservations are past their expected payout date with no matching payout line? Show the expected amount and source rows.
Use the list to investigate the affected bookings.