Laserfiche WebLink
(9) <br />b. The master spreadsheet is also used as a reconciliation tool to be matched up against <br />revenue reported to Lawson as it contains the raw data as reported by the hotel operator <br />or tax preparer. <br />4. In addition to the master spreadsheet, the HVT system also has the capability of generating <br />financial reports: <br />a. The `Monthly Audit Report' is a report that provides detailed payment information for all <br />hotels, including reporting period, due date, amount paid, date payment was received and <br />can be generated for any period entering specific parameters (Start Date and End Date). <br />b. The `Payment Summary' report is less detailed; however, it will give a cumulative total of <br />the payments received from each hotel based on the parameters entered (Start Date and <br />End Date). This differs from the `Monthly Audit Report' in that it does not give a breakdown <br />of each payment received by a single hotel, for what reporting period and when the <br />payment was received. <br />c. Both of these reports are also used as a reconciliation tool in concert with the master <br />spreadsheet. <br />City of Santa Ana RFP No. 23-165 Page 57 of 196 <br />