Reports and Detail Information
This report prints during the dayend close, or can be reprinted by selecting Dayend Close Reprints in the Reports Menu. To eliminate or reduce the number of reports that print during the dayend close, select Setup > Configuration > Guest Ledger > Dayend Close Options.
The Dayend Close Report gives an overview of the previous days financial and occupancy statistics. The chart shows where different information is included in the report:
| Room Sales Posted | Room Sold Summary | In-house at Audit | Posting Summary | Rate Type Rooms Sold | |
|---|---|---|---|---|---|
| Normal Stays | X | X | X | X | X |
| Same Day Stays | X | X | X | X | |
| No Shows | X | X | X | X | |
| Shares | X | X | X | X | X |
| Split Folio Postings | X | X | X | X | X |
| Desk Folios | X | ||||
| Adjustments/Voids | X |
Note: For Shares in the Room Sold Summary section, only the master folio is counted as one room for checkins or rooms sold. However, the total number of adults and children for each share are included in the number of guests. For example, if there are two share folios in a room, one with one adult and one child and the other with two adults and one child, one room would be counted with three adults and two children.
Room Sales Posted
Taxable The total monetary amount posted for taxable room sales calculated as the total of all postings for account codes with Room Revenue as the category, Use as Room Revenue Account checked, and Room Taxable as the type. The second column is the total number of postings made for taxable account codes including normal stays, same day stays, no shows, desk folios, and history folios. Any voided postings from a previous day would subtract a posting from this total.
Non-taxable The total monetary amount posted for non-taxable room sales calculated as the total of all postings for account codes with Room Revenue as the category, Use as Room Revenue Account checked, and Room Non-Taxable as the type. The second column is the total number of postings made made for non-taxable account codes including normal stays, same day stays, no shows, desk folios, and history folios. Any voided postings from a previous day would subtract a posting from this total.
Adjustments The total monetary amount posted for room sales calculated as the total of all postings for account codes with Room Revenue as the category and Use as Room Revenue Account is not checked.
Total Posted The total monetary amount of taxable room sales, non-taxable room sales and room adjustments. The second column is the total number of postings made including normal stays, same day stays, no shows, desk folios, and history folios. Any voided postings from a previous day would subtract a posting from this total.
Avg Post/ADR Average Post is the average of all posted room revenue transactions regardless of whether they were done through City Ledger, Guest Ledger, Deposit Ledger, Desk Folios, regular folios, etc. ADR(Average Daily rate) is the Total Posted for the day divided by the number of guest rooms sold for the day including same day stays and no-shows. The two will be different when adjustments are made against previous days postings or special room revenue postings or late/early checkouts. For a detailed list of all rooms sold for the day, go to reports and run the "Rooms Sold Detail by Date" report if there are any questions.
RevPar This is the Revenue Per Available Room. The formula is Total Room Sales divided by Total Rooms Available, even if they were not occupied.
Room Sold Summary
Rooms Sold The total number of room nights sold for the date. Normal stay, no shows and same days stays are all included. Shares only count as one regardless of how many shares there are. Rooms posted to desk folios or rooms posted because of Late Checkouts or Voids done to history folios or room post transactions done on a previous day are not included. For a detailed list of all rooms sold for the day, go to reports and run the Rooms Sold Detail by Date report if there are any questions.
To compare Rooms Sold to Rooms Posted (to find posting differences), Reprint the Journal by Type report for only for Room Accounts (100 and 101 for example) and compare the results to the Rooms Sold Detail by Date report. Usually, the difference would be voids or postings to history folios.
CheckIns The total number of checkins for the audit date. Normal stay, no shows and same days stays are all included. Only the Share Master is counted as a checkin regardless of the when the remaining shares are checked in.
Occupancy The percentage of rooms sold of the total number of rooms available. The formula is Total Rooms Sold divided by Total Rooms Available.
Adults/Child The total number of adults and children registered for the previous day. Normal stay, no shows and same days stays are all included. All adults and children on all checked in share folios are also included.
Ledger Summary
The first line figures reflect the ending balance for the Guest, City, and Deposit ledgers from the previous business date. The next line is the total number of new Debits (charges) for each ledger and the following line is the total number of new Credits (payments) for each ledger. The closing ledger balances for the business date are listed on the next line. The total of the Guest, City, and Deposit ledgers, both debit and credit, is the final "Total" figure. Note: All voids are added to the + (Debits) and - (Credits) amounts. For the actual net (Debit) and (Credit) amounts, go to reports and run the "General Journal" report for the desired date(s). Use the General Journal to enter ledger balances into any external accounting system.
In-house at time of Audit
Unavailable Rooms The total number of rooms in unavailable status, usually because of maintenance or repair issues. These rooms are not included in room availability figures.
Occupied Rooms The total number of rooms occupied when Dayend Close is run.
Vacant Rooms The total number of available rooms not occupied when Dayend Close is run.
Posting Summary
Total group rooms posted The total number of occupied rooms attached to a group block when Dayend Close is run.
Total room post skipped The total number of occupied rooms with NO room account posting for the date (Account Codes 100 or 101). Rooms with weekly or monthly rates are included in this count on the days the rate does not post.
Total rooms posted as 0.00 The total number of occupied rooms with $0.00 as the posting rate. This total will only display if the Include zero room rate in ADR is checked in the Defaults and Warnings of the Room Revenue account codes.
Rate Types Rooms Sold
Total COMP Rooms The total number of occupied rooms with "COMP" as the rate type. Normal Stay, No-Shows and Same Day Stays are included. This total will only display if the Include zero room rate in ADR is checked in the Defaults and Warnings of the Room Revenue account codes.
Total RACK Rooms The total number of occupied rooms with "RACK" as the rate type. Normal Stay, No-Shows and Same Day Stays are included.
Total Other Rooms The total number of occupied rooms with a rate type other than "COMP" or "RACK". Normal Stay, No-Shows and Same Day Stays are included.
Note: Each part of a share is included in the three counts above, since each share could have a different rate or rate code. For this reason, the total of these counts could be different from the Rooms Sold total since it only includes the Share Master.