Delinquent Deposits Report (Cloud) 🎥

Delinquent Deposits Report (Cloud) 🎥

Group reservations often require advance deposits to secure the block and protect the property from lost revenue. The Delinquent Deposits Report identifies reservations within group blocks that do not have a deposit posted, even when deposits may exist on the group master. This gives staff early insight into missing payments, helps ensure compliance with group contracts, and prevents check-in issues on busy arrival days.
Path: Front Office > Supervisor > Reports > Advance/Delinquent Deposits

Generating the Report

This report is accessed from the shared Advance/Delinquent Deposits screen. You must select Delinquent Deposits from the Reports dropdown before generating results. Filters allow you to narrow the list of missing deposits by arrival date, reservation creation date, CRS origin, or group block.

1. Select Delinquent Deposits from the Reports dropdown.



2. Use the filters along the top to refine your results.
- Set an Arrival Date range.
- Set a MadeBy date range to filter by reservation creation date.
- Select a Group (ALL or a specific group).

Notes
The CRS Prepaid Deposits Only option does not meaningfully affect results in the Delinquent Deposits Report, as this report focuses on reservations missing deposits. This filter is primarily applicable when reviewing the Advance Deposits Report.

3. Click Refresh to display results.


Understanding the Report

The Delinquent Deposits Report lists reservations within group blocks that should have an advance deposit but currently do not have a deposit posted.

Guest, Contact & Arrival Details
- Guest Name: Guest lacking a required deposit.
- Phone: The contact number recorded on the reservation.
- Arrive: Scheduled arrival date.

Group & Reservation Creation
- Group: Name of the group block associated with the reservation.
- Made: The date the reservation was created.

Room & Payment Information
- Room Type: The room category booked.
- MOP: The Method of Payment stored on the reservation (not necessarily the method a deposit would use).

Reservation Reference
- Conf#: Confirmation number for quick lookup.



How Deposits Apply in Group Reservations

Deposits for group blocks can be posted to the group master reservation or to the individual picked-up rooms. While the Guarantee Type (All Charges, Room & Tax, None) determines where charges are routed at checkout, it does not determine how deposits are tracked.
Deposits in Visual Matrix attach to individual reservations, not to the block itself.
Because of this, even when a full deposit has been posted at the group master level, the Delinquent Deposits Report evaluates each picked-up room individually. Rooms without their own deposit entry will appear on the report until their deposit coverage is entered or reconciled.

Reconciling Master-Posted Deposits With Room-Level Reporting

If a deposit is posted only to the group master, the individual reservations will not automatically reflect that deposit. This can cause rooms to appear “delinquent” even when the hotel considers the group deposit complete.
To reconcile this:
- Clearly document that the group master deposit covers all associated rooms.
- Communicate internally so the front desk and night audit teams understand why rooms may appear delinquent.
- If more detailed tracking is needed, manually assign or note deposit amounts on individual reservations.
- Use the Delinquent Deposits Report as a checklist to confirm every room is accounted for before arrival.
This ensures accurate financial tracking and smooth group check-in operations.


Tips & Use Cases

- Quickly identify group reservations missing deposits before arrival.
- Use group and date filters to focus on specific contracts or periods.
- Follow up with guests or group coordinators on missing payments.
- Support night audit and revenue control by ensuring expected deposits are present.


Still Need Help With This Topic?

Ask Yourself:
- Am I reviewing the correct arrival date range?
- Was a deposit posted at the group master level but not on individual rooms?
- Does the Guarantee Type affect billing but not deposit tracking?

Support May Ask You:
- Which filters were applied?
- What group and dates are involved?
- Is the deposit posted on the master reservation or intended for individuals?

    • Related Articles

    • Advance Deposits Report (Cloud) 🎥

      ? Watch Video Advance deposits can significantly impact your hotel’s financial picture, especially when taken well before a guest’s arrival. The Advance Deposits Report helps you track all deposits collected for future stays, along with their ...
    • Night Audit Daily Report (Cloud) 🎥

      ? Watch Video The Daily report recaps all the activity within the last audit. This daily report includes hotel statistics, like the total earnings from hotels revenue centers. Numbers from each revenue centres will display for the day, MTD (month to ...
    • Understanding the Group Estimated Balance (Cloud)

      The Group Estimated Balance provides a financial snapshot of a group reservation — showing the projected balance based on room revenue, taxes, and payments or deposits applied to the group. Understanding how this value is calculated helps ensure ...
    • Mgmt Operator Deposits Summary Report (Cloud) 🎥

      ? Watch Video The Operator Deposit Summary History report displays the total by method of payment by day. Path: Management > Reports > History > Operator Deposits Generate report 1. Narrow down the report by period: choose one day or a date range. ...
    • FO Departures Report (Cloud) 🎥

      ? Watch Video The Front Office Departures Report helps your front desk manage guest check-outs efficiently. It lists every guest scheduled to depart — showing room assignments, folio balances, and payment methods — so your team can verify charges, ...