Deposit Ledger is the Report were you can find your Prepaid reservations.
It will show the specification of which reservations are accounted on the Deposit Ledger/Prepayment account and the specification of all adjustment accounts. Amount on Deposit Ledger account will correspond to total prepaid amount in a reservation, amount on revenue adjustment account will correspond to how much is revenue that you will get when the guest stays and tax adjustment account shows how much is prepaid VAT. Advance invocies will also be accounted on Deposit Ledger account and present in this report, they will not have the corresponding adjustments until they are paid.
Note that if you don't use adjustment accounts the revenue accounts will be listed in the accounts section instead of any adjustment accounts but in that case it is recommended that you use this report to get specification of Deposit Ledger account only.
How to use it:
1. Go to 'Reports>Accounting>Deposit Ledger'
2. If you want a specification of the balance on Deposit Ledger account and the Adjustment accounts for a specific date select 'To' and enter the date you are interested in. The date you select will be included in the report so if you for example select 190827 the report will include all transactions that happened before 190828 00:00.
3. Select the account you want to see, normally this will be Deposit Ledger account plus all adjustment accounts that are currently in use. So if you use adjustment accounts and have never made any account changes if will be all accounts listed.
4. Click 'Search' to see result. Result will show a list of all reservations that have a balance on any of these accounts by the selected date. They are grouped by account, so in example below first all reservations on account 2990 will be listed, then 3011 and so on. You can click the header row to sort the search result after that column.
For each reservation you can see:
Reservation: The reservation number, it links to the reservation
Customer: Company name if present, otherwise customers last name, first name
Created: The confirmation date of the reservation
Stay: Arrival and Departure date
Account: The account number
Amount: How much is accounted on the specified account for this reservation.
5. On the options menu in top right corner you can find option to print the report or export it to pdf or excel.
The Stay from and Stay to dates can be used if you are interested to see for which period of time the prepaid reservations will stay. For example how much of prepayments are for next year.