The URL can be used to link to this page

Home My WebLink AboutAnnual Audit Plan FY 2022-2023 County of Hawaii Office of the County Auditor . County Auditor � 120 Pauahi St., 309 County of Hawaii • Hilo, HI 96720 *:• `* Office of the County Auditor F 808.961.8905 Ph 808.961.8386 • •+� h VV i '�% www.hawaiicounty.gov June 30, 2022 Honorable Maile Medeiros David, Council Chair and Members of the Hawaii County Council Hawaii County Council 25 Aupuni Street Hilo, Hawaii 96720 Dear Chair David and Council Members, In accordance with Hawaii County Charter Section 3-18(d)(2), attached is the Office of the County Auditor's Fiscal Year 2022-2023 Annual Audit Plan. This provision requires our office to transmit an annual audit plan to the Hawaii County Council and the Mayor. Our plan includes: • Annual Comprehensive Financial Report for Fiscal Year Ending 2022 • Audit of the Financial Statements of the Department of Water Supply for the Fiscal Year Ending 2022 • Single Audit of Federal Financial Assistance Programs for Fiscal Year Ending 2022 • Concluding on several engagements/projects currently in process • Two self-initiated audits • Monitoring purchasing card and travel expenditures • Surprise cash counts • Unplanned engagements and special projects We would like to take this opportunity to share our appreciation with the entire organization as we look forward to pursuing the upcoming audit engagements and projects for the County of Hawaii. Respectfully, C X � County Auditor County of Hawaii 0 County of Hawaii Annual Audit Plan Fiscal Year 2022 - 2023 0 b 0 IL County of Hawaii Office of the County Auditor 120 Pauahi St., 309 Hilo, HI 96720 F,4 County of Hawaii �,.r•T ::'' F Office of the County Auditor 120 Pauahi St., 309 *; • F Hilo, HI 96720 +� Itis i '�� 4 ��. � Date: July 1, 2022 To: Honorable Maile Medeiros David, Council Chair and Members of the Hawaii County Council From: Tyler J. Benner, County Auditor Subject: Annual Audit Plan Fiscal Year 2022-2023 Executive Summary In accordance with Hawaii County Charter Section 3-18(d)(2), The Office of the County Auditor respectfully submits its Fiscal Year 2022 — 2023 Annual Audit Plan. The provision requires our office to provide an annual audit plan to the Hawaii County Council and the Mayor. An audit plan is used to identify specific agencies, departments, divisions, funds, programs, and activities that may be considered for examination with the goal of achieving one or more of the audit objectives. After considerable discussion, we designed the work plan to focus on priorities that ensure network reliability, safety, security, and enhances the end-user experience. Finally, to increase transparency, we've developed a remediation tracker to be deployed in July 2022 to allow stakeholders and decision-makers to track the status of recommendations made. Respectfully, C 66P/�n er County Auditor County of Hawaii cc. Honorable Mitchell D. Roth, Mayor Lee Lord, Managing Director Jon Henricks, County Clerk 1 Vision Statement Our vision is to enhance County government by leveraging new and emerging technology, evolving the control environment at the speed of business, to provide reasonable assurance that public resources and services are receiving the adequate stewardship they deserve. Mission Statement It is our mission to serve the Council and citizens of Hawaii County by promoting accountability, fiscal integrity, and openness in local government. Through performance and/or financial audits of County agencies and programs, the Office of the County Auditor examines the use of public funds, evaluates operations and activities, and provides findings and recommendations to elected officials and citizens in an objective manner. Our work is intended to assist the County government in its management of public resources, delivery of public services, and stewardship of public trust. Audit Objectives We achieve our mission by pursuing the following audit objectives: • Determine the effectiveness and efficiency of organizations accomplishing their mission and identify opportunities for cost savings and revenue enhancements. • Evaluate adequacy and compliance of internal controls, policies and procedures, systems, and processes. • Evaluate proper accounting and safeguarding of County-owned assets. • Cause to conduct reviews of the accuracy of financial and operating transactions. • Confirm compliance with local, state, and federal laws and regulations. • Proactively identify and investigate reported fraud, theft, waste, abuse, etc. and recommend controls to prevent and detect such occurrences. • Determine the effectiveness and efficiency of County programs being administered and resources being utilized. • Follow-up, review, and evaluate previously conducted audits to ensure management actions are achieving satisfactory solutions of all significant issues. 2 Fiscal Year 2022- 2023 Planned Audits (Order yet to be determined) Mandated by Charter ➢ Annual Comprehensive Financial Audit of the County of Hawaii ➢ Audit of the Financial Statements of the Department of Water Supply ➢ Single Audit of Federal Financial Assistance Programs In accordance with Hawaii County Charter Section 10-13, our office will monitor the contract with the external auditor, N&K CPA's Inc. (RFP#3544), to complete the following: ➢ Conduct audits of the accounts and other evidence of financial transactions of the County of Hawaii for the Fiscal Year Ending June 30, 2022 ➢ Financial Audit of the Department of Water Supply for Fiscal Year Ended June 3012022 ➢ Single Audit* of Federal Financial Assistance Programs for Fiscal Year Ended June 30, 2022 ➢ Report for Landfill Financial Assurance; and ➢ Financial Assessment Electronic Submission of Section 8 — Housing choice vouchers *Additional programs may be added as determined by the Schedule of Expenditures of Federal Awards (SEFA). 3 Audits In Process 0 Engagement -�r Mass Transit Cash Handling Follow-Up JUIN Department of Public Works, Contracts,Change Orders, and Supplements 100 1 60 1Gct Real Property Tax P1 I Revenue Cycle Management, 100 T Ju 12022 Department of Mater Supply Contingency Plans 1 100 1001 I L50%1 Aug2022 Department of Mater Supply ash Handling Follow up I 109=1 10% 50 Aug�� Refl ec is sta to s o f engagem€n is a s o f Estimated completion subject to change ➢ Additions to Audit Work Plan We continuously evaluate risk. Risk can be inherent, dynamic, and can evolve rapidly. Our audit plan may be modified at any time. Modifications should in no way be considered a failure of the plan and should instead reflect the changing environment and the need to adapt to new and unanticipated threats. 4 Self-Initiated Audits ➢ Information Technology — Network Security Group Our audit will explore compliance with and adherence to network security, data management, backup, and other best practices. Our audit may require the use of a subject matter expert (SME). Due to the extensive nature of the subject matter, this audit may be released as a multi-part series. ➢ Information Technology — User Group Our audit will explore desktop support, specifically, the process by which information is received, cataloged, prioritized, resolved, and dispositioned. Due to the sensitive nature of the subject matter, the release of information may be limited. Special Projects Projects currently underway and are scheduled to be completed in FY2022-23: ➢ Association of Local Government Auditors (ALGA) Peer Review ➢ Request For Proposal for Annual Comprehensive Financial Audit 6-Year Contract ➢ Remediation tracker ➢ Surprise cash counts ➢ Continuous monitoring of purchasing card and travel expenditures ➢ Tips requiring further research from Fraud and Whistleblower Hotlines 5 Remediation Tracker To increase government transparency and accountability, we have developed a remediation tracker. We will continuously monitor the status of new and applicable recommendations until they are completed. We intend to make this tool available for public access in July 2022 and will add previous engagements over time and current engagements as they are conducted. Office of The County Auditor-Rernediation Last Updated: 3 51 234.88 Reports Being Tracked Count of Recommendations Average Days Outstanding ReportEntity Sum of • za o .. • . 7 20 o �• 1 1s 13 o . 7 10 s e g � 5 c� 5 3 2 a Fully Implemented Pending Not Applicable Partially Resolved Not Implemented Implemented Audit Entity Status Days Outstanding Recommendationn 1.0 Mass Transit Agency Partially 1507 "We recommend Mass Transit management equip each County bus and Implemented van with an updated electronic fare box to collect passengerfares and track ridership." 2.0 Mass Transit Agency Partially 1507 "We recommend Mass Transit management prioritize cash handling Implemented internal controls.Management should be responsible for an effective internal control system and internal controls increase the likelihood that the organization will achieve their objectives." 3.0 Mass Transit Agency Not 1507 "We further recommend Mass Transit change lock or safe combinations Implemented once an employee who had access leaves the organization or is reassigned to another position." 3.0 Mass Transit Agency Partially 1507 "We recommend Mass Transit management ensure physical security over Implemented manual receipts,cash,and cash equivalents(e.g.,bus tickets,bus passes, taxi coupons)." v t 7 > ------------- Office of -County Auditor -• • - Recommendation Details ,. Departments Recommendation Response: What was asked of the department What the department said they would do 7 Ll .. Entity Report Number No# Recommendation Department Response A Department of Human Resources 1 1.0 "We further recommend Mass Transit remove or alter the •MTA stated that in 2018 they began removing ticket stubs Hawaii Fire Department 1 perforated stub at the top of the bus ticket sheets to ensure at the point of sale. Mass Transit Agency 1 passengers pay the full fare.° •MTA discontinued selling Hele-on Bus Tickets in January 2022. •On March 1,2022,MTA announced they are fare-free for bus and paratransit fares. 1.0 "We recommend Mass Transit management equip each Management explained that a plan for fireboxes will be County bus and van with an updated electronic fare box to implemented by 2024 and will be used primarily to track collect passenger fares and track ridership." ridership in the fare free system.Bus drivers are continuing to track ridership using a manual tally sheet process 3.0 "We further recommend Mass Transit change lock or safe Management needs to create and enforce procedures for combinations once an employee who had access leaves the managing how their keys are tracked and maintained. organization or reassigned to another position." 3.0 "We further recommend Mass Transit staff restrictively MTA updated cash handling procedures to include endorse checks immediately upon receipt." endorsing checks immediately upon receipt. 10.0 "Vile further recommend Mass Transit complete treasury No actions are needed at this time. v { > 6 Next Steps Carry-over audit engagements will continue until completed. New audit engagements will commence as scheduling permits. Completed audits will be shared with those charged with governance and responsible parties will have the opportunity to provide comments. Completed reports will be transmitted to the county council and the mayor and filed with the county clerk as a public record. We would like to take this opportunity to thank the County Council and the Administration for their support. We look forward to conducting our work this coming year. Respectfully, eJ�G�>X� �12?2P/IX County Auditor County of Hawaii 7