The Master Report can be found on the HB Intranet > HB InForm > InForm Reports > Financial Management or Production Analytics Reports.
Utilize the Master Report to collect booking data that pertains to Cancelled Bookings and Advancement Payments Received. This instructions are referred to a "Refund Liability Report". This is for unprocessed refunds due to a cancelled booking. For processed refunds use the Associate Distribution Report system view this HB Help article for instructions.
1. Clear out all dates, select click Apply
2. Select these Column Filters
- Under Booking Details table under Other Details select AR Comments
- Select/check boxes for: Hide Closed Bookings and Include Cancelled
- Under Finance Details table under Accounts Receivable select Teamed % Commission Received and Teamed % Commissions Remaining - this may be pre-checked and Teamed % Checks Received
3. Click APPLY COLUMNS
4. Filter Booking Status to only select/view Cancelled bookings
5. Click OK
6. The filtered results will now show the Teamed % Commission Received and Remaining and Teamed % Check Received details of the refund that has been paid back to the property due to the Cancellation.
- Teamed % Commission Received: This shows checks received on the booking minus any deductions. So if Associate Fees Received equal zero (0), HB has not received a payment for the booking OR the refund has been processed. If the number is greater than zero (0) then funds have been received for this booking and will be deducted when Accounting processes an invoice from the property.
- Teamed % Commission Remaining: These bookings are in Cancelled status and will not be invoiced so all should have $0.00 fees due.
- Teamed % Checks Received: Shows the history of Associate Fees received. It will show when checks were originally received and any deductions from processed refunds. This might lag slightly as it updates weekly from the Distribution Report.
NOTE: The sum of Teamed % Commission Received at the bottom of the report times 50% is the amount of cancellation fees the Associate will need to be aware of for repayment.
NOTE: You can click the column header/tile at the top of the report to sort by Teamed % Commission Received. Click twice to show the largest amounts on top.
TECH NOTE: Use the Excel icon button located in the far right side under the report table to download the data into an Excel spreadsheet.