Deposit Report (rep_deposit.rep with rep_deposit.fmx)

The Deposit Report provides an overview of business block deposits requested and received. Room and Catering deposits can be listed separately if they are requested that way. Otherwise, the combined ALL deposit type will print.

You can organize the report by deposit due date or by business block arrival date range.

Selection Criteria

Property: Enter or select the property. You can select multiple properties from a hub location. 

Start Date Range: Allows entry of an arrival date range. All business blocks with an arrival date within the selected range will print on the report.

Deposit Date Range: Allows entry of a date range for which deposits are requested. All business blocks that have deposit requests with a due date within this date range print on the report.

Block Name: Filter the report parameters by the Block Name.

Block Status: Use this option to filter the report by specific Block Status.

Catering Status: Use this option to filter the report by specific Catering Status.

Block Type: Select Rooms, Catering, or All. Allows the selection of Block Room Type only deposits to print (type 'R'), Catering Only Business Block Type deposits (type 'C'), or both Business Block Room Types and Catering Business Block Types (R, C and All) deposits.

Deposit Type: Select one of the following three options:

• Paid – If arrival dates are defined, all paid deposits for business blocks during that period will be printed. If deposit due dates are defined, all paid business block deposits made in that period and any unallocated payments for any period will be printed.

• Unpaid – Unpaid deposit requests due during the defined period will be printed.

• Both – Both the paid and unpaid deposit information will be printed.

Report Data

The report prints a separate section for each business block in booking ID order. The business block details printed include rooms status, catering status, business block name, booking ID, arrival date, departure date, company account name, company contact name, agent or source account name, and agent or source contact name. The deposit data contains the deposit type, percentage of the total that the deposit represents (if it was entered that way), deposit requested amount, due date of the deposit, deposit comments, total amount paid, and the total amount unpaid for each specific request.

Deposit types can be Room, Catering, or All. If a deposit payment is posted without a deposit request being present or the payment is not been offset against an existing request when posting it, the deposit record will be listed on this report as Unallocated, and only the total amount paid shows a figure.

The Total Unpaid figure is calculated for each requested record by deducting the paid amount from the request to which it is allocated.

A report grand total is printed as a summary of all details listed in the Total Paid and Total Unpaid columns.