Laserfiche WebLink
6.F. - Page 40 of 180 <br />method of reports that must be developed in Phase 1 ERP. It is the expectation of the City and <br />CherryRoad that reports which are provided to outside agencies will be developed using Oracle <br />Cloud report development tools. For those reports that are provided to City employees, <br />departments, etc., it is the expectation of the City and CherryRoad that this data will be made <br />available in dashboard and/or query format using the Oracle Cloud delivered tools. <br />Cash/Bank reconciliation <br />• Cash detail report - monthly <br />• Stale dated accounts payable check listing <br />• Stale dated payroll check listing <br />• Voided accounts payable check listing <br />• Utility system returned bank items - monthly <br />• Checks written report - monthly <br />• Outstanding check listing - monthly <br />• Cancelled check listing by check number - monthly <br />• Project report by fund <br />• Housing and Community Development Act (HCDA) of 1974 loan status report <br />• HCDA transactions -monthly <br />Payroll/Labor/Benefits <br />• Automatic check deposit register <br />• Listing of checks to be issued with net >$5,000 <br />• Listing of disability hours by pay period <br />• Disability hours and dollars paid during the payroll year <br />• Report of new employees <br />• History of active - non represented employees not on California Public Employees Retirement System <br />(PERS or CaIPERS) <br />• Labor distribution by department and project <br />• Labor posting report <br />• Leave report by department <br />• Leave status for the pay period <br />• Listing of no pay hours for the pay period <br />• Employees with missing benefits elections <br />• Overtime hours worked by pay period <br />• Payroll check register and wire register <br />• Payroll listing for CalPERS <br />• Position control changes since last pay period <br />• Terminated employees with leave balance <br />• Time card listing for all departments <br />• Auto allowances added to payroll <br />• Additional amounts automatically loaded to timecards <br />• Deduction status report (for charities) <br />• Deduction status report (for benefits) <br />• Association/unions deduction listing <br />EXHIBIT STATEMENT OF WORK <br />ATTY/AGR/2019.118/CHERRYROAD ERP IMPLEMENTATION SERVICES <br />REV: 05-13-19 PR Page 32 of 172 <br />A-18 <br />147 <br />