[NEW] REPORT – Deposit Ledger report

Aim: The accounting and finance department staff want to compile a summary and detailed list of unused and non-refundable deposits that the hotel has received from customers with bookings on the current audit date, in order to properly track and process financial transactions related to deposits.

1. Add permission on Deposit ledger report in Access control 

2. Add Deposit ledger report in Cashier report group 

3. Describe the defintion of components in report

Reservation code: Display the droplist of bookings that have deposit with amount not 0 on audit date

Confirmation code: Display the droplist of bookings that have deposit with amount not 0 on audit date

Room number: Display whole room on system including physical room, dummy room, active room, inactive room and select multi types

Type: Check in, Tentative, Waiting, No show, Definite, Dummy and select multi types

Guest name

Arrival date

Departure date

Company, Travel agent: Display whole room on system including active items, inactive items and select multi types

Invoice number

Deposit method

Transaction page

Last paid on: The latest deposit date. Display the deposit date closest to the current audit date on the corresponding transaction page.

Deposit balance: Display Deposit amount that hotel is keeping and not refund to customer.