Report 2009-037 Recommendation 1 Responses

Report 2009-037: Department of Housing and Community Development: Housing Bond Funds Generally Have Been Awarded Promptly and in Compliance With Law, but Monitoring Continues to Need Improvement (Release Date: November 2009)

Recommendation #1 To: Housing and Community Development, Department of

To ensure that data maintained in CAPES are accurate and complete, HCD should complete its review of the accuracy of the data transferred to CAPES.

Annual Follow-Up Agency Response From October 2014

HCD developed and fully implemented its strategy to verify the data transferred to CAPES is accurate and complete. The data verification process completed during the past year, included reconciliation of financial and business relevant programmatic data to accounting records and source documents. As of June 30, 2014, the CAPES data has been reconciled successfully. The following documents (submitted via email) support the implementation of this audit finding - Attachment A "CAPES data conversion clean-up process-Oct2014", Attachment B "CBR prop 46 06-30-14 Draft 9-29-14", and Attachment C "CAPES Cumulative Prop 46 Bond Awards through 06-30-2014".

California State Auditor's Assessment of Annual Follow-Up Status: Fully Implemented

Annual Follow-Up Agency Response From November 2013

The current remediation plan continues to move forward after some unexpected redirection of staff to other HCD mission critical priorities, during 2013. Reconciliation and validation of CAPES data elements is on-going, and will continue for another 3-6 months. The expected remediation timeframe has been adjusted to April 30, 2014.

California State Auditor's Assessment of Annual Follow-Up Status: Not Fully Implemented

Annual Follow-Up Agency Response From September 2012

Complete the validation of identified critical CAPES fields, including those that converted from legacy systems and those that have been entered since conversion, by documenting business rules for comparing CAPES data to source documents and by making any needed corrections to these fields. Designate specific staff, including at least one retired annuitant, to complete the data clean up.

California State Auditor's Assessment of Annual Follow-Up Status: Not Fully Implemented

All Recommendations in 2009-037

Agency responses received after June 2013 are posted verbatim.