Laserfiche WebLink
(9) <br />3. A master spreadsheet is also maintained to show the UUT revenue remitted for every month and <br />every utility category. This spreadsheet shows the revenues received for the current fiscal year <br />period, as well as the previous fiscal year period to allow year-to-year comparisons. <br />a. This master spreadsheet is regularly updated and saved in a shared directory (I:\UTILITY <br />USERS TAX\UUT Monthly Stats) where it can be accessed by authorized staff members <br />in the Tax & Licensing Section. <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 service provider <br />or tax preparer. <br />4. In addition to the master spreadsheet, the UUT 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 />utility service providers, including reporting period, due date, amount paid, date payment <br />was received and can be generated for any period entering specific parameters (Start <br />Date and End Date). <br />b. `Service Type Revenue Utility Users' Tax Report' which can be generated by entering <br />specific parameters (Start Date, End Date and Service Type) and will provide the total <br />payment amount(s) recorded in UUT for each individual service provider based on the <br />utility service type. This is also used as a reconciliation tool in concert with the master <br />spreadsheet. <br />5. The UUT Code provides for an exemption from the monthly UUT assessment for residents whose <br />maximum income levels fall within the following parameters: <br />Family Size Maximum Income Family Size Maximum Income <br />1 $ 14,300.00 4 $ 20,200.00 <br />2 $ 14,300.00 5 $ 23,500.00 <br />3 $ 16,900.00 6 or more $ 26,800.00 Plus $3,300.00 <br />per person in excess of six <br />Low Income Exemption applications are required to be filed by May 30t" of each year and take <br />effect for the fiscal year beginning July 1. <br />City of Santa Ana RFP No. 23-165 Page 54 of 196 <br />