Worksheet

OTA payout reconciliation worksheet

Every booking takes a single row, with columns for channel, confirmation number, guest name, stay dates, gross rate, agreed commission, expected net, statement amount, difference and cause code. Below the rows, a block records the bank credit reference and payout date. A dispute log with deadline and outcome sits beside it.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Matching OTA payouts to bookings without a spreadsheet”, www.gullysystem.com/blog/matching-ota-payouts-to-bookings-without-a-spreadsheet