Final Audit
📆 Revision Date:
The Final Audit Report provides detailed information on revenue, charges, surcharges & fees, taxes, payments, settlement payment information, cash deposit and cash drop, statistical counts, occupancy and revenue statistics for the end of business day. The report includes the previous night's total numbers, MTD, LY-MTD, the variance between the two, YTD, LY-YTD, and the variance between those two:
Column Name | Description |
|---|---|
Charge Type | This column categorizes the different types of financial transactions or charges that occurred during the date range. |
Actual Today | This column shows the actual amount (gross revenue) of each charge type for the current day. |
Adjusted | This column shows any adjustments made to the actual amounts, such as corrections, refunds, or reallocations. The gross revenue received on the current day |
Net Today | This column represents the net amount for each charge type on the current day, calculated by subtracting the adjusted amount from the actual amount. The net revenue received on the current day |
M-T-D | This column shows the cumulative total of each charge type from the beginning of the month until the current day. |
LY-M-T-D | This column shows the cumulative total of each charge type for the same period in the previous year, providing a basis for comparison. |
Variance | This column calculates the difference between the M-T-D and LY-M-T-D amounts, showing whether the current year's charges have increased or decreased compared to the previous year. |
Y-T-D | This column shows the cumulative total of each charge type from the beginning of the year until the current day. |
LY-T-D | This column shows the cumulative total of each charge type for the same period in the previous year, providing a basis for comparison. |
Variance | This column calculates the difference between the Y-T-D and LY-T-D amounts, showing whether the current year's charges have increased or decreased compared to the previous year. |
For each section of the Final Audit report, supporting reports can be found in the PMS Reports module
Section | Supporting Report located under Reports in the PMS |
|---|---|
Revenue | •Additional Room Rent - |
Charges | Information can be found in the "Ledger" section of reports, in the Balance Details Report. |
Payments | Information can be found in the "Operations" section of reports, in the Clerk Shift report filtering by the correct date. |
Taxes | Information can be found in the "Tax" section of reports, in the Tax Report filtering by correct date |
Cash Deposit and Cash Drops | Information can be found in the "Operations" section of reports, in the Clerk Shift report filtering by the correct date |
Statistical Counts | •Information can be found in the "Housekeeping" section of reports, the Room Status History report will provide room status of all rooms. |
Occupancy | Information can be found in the "Operations" section of reports, in the Occupancy Summary report filtering by the correct date |
Revenue Statistics | Information can be found in the "Operations" section of reports, in the Occupancy Summary report filtering by the correct date |
Statistics by Market Segment | Information can be found in the "Revenue" section of reports, in the Market Segment Summary report filtering by the correct date |
Revenue by Market Segment | Information can be found in the "Revenue" section of reports, in the Market Segment Summary report filtering by the correct date |
Balance Information | Information can be found in "Ledger" section section of reports, the Ledger Summary Report will provide all information |
Turn Away Information | Information can be found in the "Operations" section of reports, in the Turn Away Reason Code report filtering by the correct date |