Report of Deputy Chief Executive

Report of Deputy Chief Executive

AGENDA NO.

REPORT TO

AUDIT COMMITTEE

26February 2018

REPORT OF DEPUTY CHIEF EXECUTIVE

INTERNAL AUDIT PROGRESS REPORT

SUMMARY

This report provides members with an update of the work carried out by the Internal Audit Section and the progress made against the Audit Plan 2017/18.

RECOMMENDATIONS

It is recommended that:-

  1. The current position as identified in the attached update report is noted.

DETAIL

Background

  1. Internal Audit is an independent appraisal function established by the Council to objectively examine, evaluate and report on the adequacy of internal controls. This role ensures that there is proper economic, efficient and effective use of resources. It also ensures that the Council has adequate accounting records and control systems.
  1. Committee Members are reminded that the list of audit assignments undertaken in the current year to date has been circulated to all Councillors prior to the meeting. The intention is to give Councillors the opportunity to raise questions on issues that affect their ward or other areas of responsibility and for answers to be provided at the meeting.

Current Position

  1. The attached update report shows the current position in respect of the progress against the 2017/18 audit plan and the results of the work that has been undertaken.
  2. As reported at previous meetings significant time has been spent on training and team building. This has delayed the start of some of the audit work. The officer who was on maternity leave has now returned and the primary focus now is completing the audit plan. Vacancy
  3. Members may recall an updated approach which included setting up a system of continuous audit. Significant progress continues to be made towards this with testing now being automated on a monthly basis in a number of areas. Because testing is undertaken continuously there will be a number of audits shown as on-going that will be finalised at the year end.

FINANCIAL AND LEGAL IMPLICATIONS

None

RISK ASSESSMENT

The results of the work undertaken by Internal Audit can be used by managers to assess their risk exposure, recommendations are made where there is perceived to be unacceptable risk.

COMMUNITY STRATEGY IMPLICATIONS

None

CONSULTATION

N/A

Name of Contact Officer:Andrew Barber, Audit & Risk Manager

Telephone No:01642 526176

Email Address:

Background Papers: / Internal Audit Charter
Audit Plan 2017/2018
Counter Fraud Strategy
Ward(s) and Ward Councillors: / None
Property Implications: / None

INTERNAL AUDIT

AUDIT COMMITTEE UPDATE REPORT

2017/18

Internal Audit – Audit Committee Update

Report 2017/18

1AUDIT PROGRESS

1

2

3

1.1The plan,approved on 20February 2017,was based on an audit assessment of risk which uses a number of factors to determine the likelihood of issues occurring including an understanding of the full scope of systems in operation, major change, concerns/external interest and results of previous audit work. It then assesses the impact any issues may have on the council’s strategic objectives, reputation, financial plans, assets and also the potential impact on individuals and/or the environment.

Audit Progress by Service Group

Department / Planned Audits / Cancelled Audits / Unplanned Audits / Revised Audits / Completed / In Progress / Drafts Issued
Children's Services / 8 / 0 / 0 / 8 / 0 / 5 / 0
Adults & Health / 5 / 0 / 0 / 5 / 0 / 3 / 0
Finance & Business Services / 19 / 1 / 0 / 18 / 2 / 10 / 3
Xentrall / 13 / 0 / 0 / 13 / 1 / 9 / 0
HR, Legal & Communications / 1 / 1 / 0 / 0 / 0 / 0 / 0
Economic Growth & Development / 7 / 1 / 1 / 7 / 2 / 1 / 1
Culture, Leisure & Events / 3 / 0 / 0 / 3 / 0 / 1 / 0
Community Services / 5 / 2 / 0 / 3 / 1 / 2 / 0
Democratic & Licensing / 1 / 1 / 0 / 0 / 0 / 0 / 0
Corporate / 5 / 0 / 0 / 5 / 2 / 2 / 1
Schools / N/A / 1 / 0 / 1 / 0
ICT Systems / N/A / 0 / 0 / 0 / 0
Totals / 67 / 6 / 1 / 63 / 8 / 34 / 5

Actual Days Compared to Planned Days

1.2The tables below show an alternative view of the number of planned days v actual days and the projected available resources to complete the plan.

Budget / Actual / Remaining / Comments
Planned Started / 723 / 204 / 519
Unplanned / 0 / 0 / 0
Cancelled / 0 / 0 / 0
Not Started / 222 / 4 / 218
Balance / 945 / 208 / 737 / Of this 230 days are in the "Contingencies", advice & guidance etc
Planned Auditor Time / 1315 / 651 / 664
Planned Non-Audit / 559 / 657 / -98
Non-Audit Requirement / 132 / -132
Auditor Total / 1874 / 1439 / 435
Variance / -302

1.3The Audit Plan is constantly revised during the year to take account of changing requirements. Amendments to the Plan agreed on 20February 2017 can be summarised as follows:

2017/18 Planned Audits Amalgamated/Cancelled/Deferred

Name / Comments
Security & Surveillance / Reduced resources, low risk audit.
Enforcement / Reduced resources, low risk audit.
Business Support & Development / Reduced resources, low risk audit.
Members Payments and Allowances/Travel and Subsistence / Reduced resources, low risk audit.
Land Charges / Reduced resources, low risk audit.
PCI Compliance / Reduced resources, low risk audit. Advice & Guidance has still been provided but main assessment submission now completed by Xentrall

2017/18 Unplanned Audits Added to the Plan

Name / Comments
Markets Management / Close down for DBC Covered Market.

1.4Counter Fraud

Work is continuing to complete the revisions to the Council’s Anti-Fraud and corruption strategy. Revised strategy is being presented at this meeting.

2AUDIT OUTPUT

Engagement Opinions

1

2

2.1For each audit carried out Internal Audit provides an overall conclusion as to whether a sound system of internal control is being maintained. Each opinion is either “Full”, “Substantial”, “Moderate”, “Limited”, or “No” assurance depending on the conclusions reached and the evidence to support those conclusions. “Full” and “substantial” assurance normally indicates that the area under review has a reliable system of internal control.

2.2These individual opinions are summarised below:-

Opinion / Definition / No. / %
Full / A sound system of internal controls is currently being applied which will ensure the system achieves its objectives. Whilst not essential there may still be scope for these controls to be enhanced in some areas. / 4 / 50
Substantial / Overall there is a sound system of internal controls that are operating effectively. The system should achieve its objectives but there are areas where internal controls need to be improved. / 3 / 38
Moderate / A reasonably sound system of internal controls is being applied, however, there are weaknesses which may put some of the system objectives at risk. / 0 / 0
Limited / There is either a limited system of internal controls being applied, or there are significant weaknesses in the controls in place, which are posing a substantial risk to the achievement of system objectives. / 0 / 0
None / The system of internal controls in place is failing and system objectives are not being met. Urgent management attention is required. / 0 / 0
N/A / This classification covers audit work within a small part of a system. Providing an opinion on this work would misrepresent the system as a whole. / 1 / 13
Total / 8

2.3An analysis of the recommendations supporting these opinions by priority is shown below:-

Priority / Definition / No. / %
Critical / Actions that must be taken immediately to manage significant risks that are likely to prevent the Authority achieving one or more of its corporate objectives. / 0 / 0
High / Actions that should be taken as a matter of priority due to the issues identified posing a substantial risk to the achievement of service/system objectives. / 0 / 0
Medium / Required actions to reduce the risk of systems failing to achieve their objectives. / 8 / 62
Low / Beneficial to the improvement of internal controls, which will support the achievement of objectives. / 5 / 38
Total / 13

1 | Page

Internal Audit – Audit Committee Update

Report 2017/18

DetailsofAuditsby Service Group

2017/18

Department / No. of Audits Issued / Opinions / No. of Recs Made / Previous Recommendations
Full / Sub / Mod / Lim / None / N/A / Tested / Passed / Failed / N/A
Children's Services / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Adults & Health Care / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Finance & Business Services / 2 / 1 / 1 / 0 / 0 / 0 / 0 / 5 / 6 / 3 / 0 / 3
Xentrall / 1 / 1 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
HR, Legal & Communications / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Economic Growth & Development / 2 / 1 / 0 / 0 / 0 / 0 / 1 / 1 / 3 / 3 / 0 / 0
Culture, Leisure & Events / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Community Services / 1 / 0 / 1 / 0 / 0 / 0 / 0 / 3 / 4 / 3 / 0 / 1
Democratic & Licensing / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Corporate / 2 / 1 / 1 / 0 / 0 / 0 / 0 / 4 / 0 / 0 / 0 / 0
Schools / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
ICT Systems / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Total / 8 / 4 / 3 / 0 / 0 / 0 / 1 / 13 / 13 / 9 / 0 / 4

2016/17

Audit Area / No. of Audits Issued / Opinions / No. of Recs Made / Previous Recommendations
Full / Substantial / Moderate / Limited / None / N/A / Tested / Passed / Failed / N/A
Children's Services / 3 / 2 / 1 / 0 / 0 / 0 / 0 / 4 / 16 / 10 / 6 / 0
Adults & Health Care / 3 / 0 / 1 / 0 / 0 / 0 / 2 / 4 / 10 / 2 / 0 / 8
Finance & Business Services / 11 / 5 / 4 / 0 / 0 / 0 / 2 / 2 / 3 / 0 / 3 / 0
Xentrall Shared Services / 9 / 5 / 4 / 0 / 0 / 0 / 0 / 2 / 1 / 1 / 0 / 0
HR, Legal & Communications / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Economic Growth & Development / 4 / 2 / 0 / 0 / 0 / 0 / 2 / 1 / 1 / 0 / 0 / 1
Culture, Leisure & Events / 1 / 0 / 1 / 0 / 0 / 0 / 0 / 7 / 0 / 0 / 0 / 0
Community Services / 2 / 0 / 2 / 0 / 0 / 0 / 0 / 18 / 15 / 9 / 3 / 3
Democratic & Licensing / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0 / 0
Schools / 11 / 8 / 3 / 0 / 0 / 0 / 0 / 20 / 7 / 6 / 0 / 1
ICT Systems / 7 / 5 / 2 / 0 / 0 / 0 / 0 / 2 / 0 / 0 / 0 / 0
Total / 51 / 27 / 18 / 0 / 0 / 0 / 6 / 60 / 53 / 28 / 12 / 13

1 | Page

Internal Audit – Audit Committee Update

Report 2017/18

2.4Shown below is a list of all the audit engagements undertaken during the year together with their assurance opinion. An explanation of any High priorityrecommendations is provided.

2017/18 Audit Plan Current Position as at 2February 2018

Department / Audit ID / Name / Status / Assurance / Recommendations / F'work Comp On-Time? / Bud / Rem / Final Var / Final Issue On-Time?
L / M / H / C / 83% / -7.6 / 55%
Finance & Business Services / 2520 / Housing Benefits / Not Started / 18.0 / 18.0
Economic Growth & Development / 2521 / Highways Maintenance Operational / Not Started / 13.0 / 13.0
Culture, Leisure & Events / 2522 / Visitor Information Services 2017/18 / Not Started / 10.0 / 10.0
Economic Growth & Development / 2523 / Highways Maintenance Management / Not Started / 10.0 / 7.1
Xentrall / 2524 / Virtualisation / On-Going / 6.0 / 5.9
Economic Growth & Development / 2525 / Highways Inspection / Not Started / 7.0 / 7.0
Finance & Business Services / 2526 / VAT / Not Started / 6.0 / 2.9
Finance & Business Services / 2527 / Taxation / Not Started / 11.9 / 11.7
Xentrall / 2528 / Server Operating Systems / Not Started / 5.0 / 5.0
Xentrall / 2529 / Website & Intranet / Not Started / 10.0 / 10.0
Community Services / 2530 / Security & Surveillance / Cancelled / 20.0 / 20.0
Community Services / 2531 / Trading Standards / Complete / Substantial Assurance / 1 / 2 / 0 / 0 / Yes / 30.0 / -17.0 / No
Corporate / 2532 / Section 17 Payments / On-Going / Yes / 4.0 / -19.3
Finance & Business Services / 2533 / Stockton Collections / Complete / Full Assurance / 0 / 1 / 0 / 0 / Yes / 5.0 / -5.2 / No
Children's Services / 2534 / Safeguarding Children / Not Started / 15.0 / 15.0
Xentrall / 2535 / Payroll & Absence Recording / On-Going / 26.0 / 8.2
Xentrall / 2536 / Environmental Controls / Complete / Full Assurance / 0 / 0 / 0 / 0 / Yes / 10.0 / 0.9 / Yes
Corporate / 2537 / Troubled Families Initiative / On-Going / 15.9 / -1.7
Community Services / 2538 / Enforcement / Cancelled / 6.9 / 6.9
Finance & Business Services / 2539 / Treasury Management / Complete / Full Assurance / 0 / 0 / 0 / 0 / No / 10.0 / -10.8 / No
Children's Services / 2540 / Emergency Duty Team 2017/18 / Not Started / 3.0 / 3.0
Children's Services / 2541 / Early Years & Complex Needs / Not Started / 8.0 / 8.0
Xentrall / 2542 / Debtors / On-Going / 18.0 / -12.6
Finance & Business Services / 2543 / Data Protection / On-Going / 10.0 / 3.7
Xentrall / 2544 / Creditors / On-Going / 20.0 / 11.2
Xentrall / 2545 / Cloud Computing / On-Going / 5.0 / 3.6
Adults & Health / 2546 / Client Financial Services / On-Going / 12.0 / 6.5
Children's Services / 2547 / Referral & Assessment - Childrens / On-Going / 15.0 / 10.4
Economic Growth & Development / 2548 / Building Control / On-Going / Yes / 19.1 / -8.1
Corporate / 2549 / Recruitment Services / On-Going / Yes / 6.0 / -5.2
Finance & Business Services / 2550 / Anti-Fraud Management / On-Going / 35.0 / 26.4
Finance & Business Services / 2551 / Asset Register/Asset Management / On-Going / 7.0 / 7.0
Xentrall / 2552 / Active Directory / On-Going / 6.0 / 3.6
Children's Services / 2553 / Childrens Anti Social Behaviour & Preventions / On-Going / No / 8.0 / 1.4
Finance & Business Services / 2554 / Council Plans / On-Going / 5.0 / 4.9
Adults & Health / 2555 / Referral & Assessment - Adults / On-Going / 12.0 / 11.6
Economic Growth & Development / 2556 / Business Support & Development / Cancelled / 25.0 / 25.0
Adults & Health / 2557 / Personal Budgets & Direct Payments / Not Started / 11.0 / 11.0
Finance & Business Services / 2558 / Business Continuity & Disaster Recovery / On-Going / 10.0 / 9.7
Corporate / 2559 / Officer Payments - Mileage / Complete / Substantial Assurance / 0 / 2 / 0 / 0 / Yes / 8.0 / -27.3 / No
Finance & Business Services / 2560 / Officer's Travel & Subsistence / On-Going / No / 10.0 / 3.6
Culture, Leisure & Events / 2561 / Libraries / On-Going / 25.0 / 20.9
Economic Growth & Development / 2562 / Private Sector Housing / Complete / Full Assurance / 0 / 1 / 0 / 0 / Yes / 10.0 / -12.5 / Yes
Finance & Business Services / 2563 / Cash Offices & Cash Holdings - Section 17 Payments / On-Going / No / 25.0 / 23.2
Finance & Business Services / 2564 / Freedom of Information / On-Going / 15.0 / 1.4
Community Services / 2565 / Waste Management / On-Going / 30.0 / 24.9
Democratic & Licensing / 2566 / Members Payments and Allowances/Travel and Subsistence / Cancelled / 20.0 / 10.9
Children's Services / 2567 / Leaving Care / Not Started / 7.0 / 7.0
Xentrall / 2568 / ICT Backup & Recovery / Disaster Recovery / Not Started / 15.0 / 14.7
Xentrall / 2569 / Outlook/Email / Not Started / 10.0 / 5.3
Finance & Business Services / 2570 / Information Management / On-Going / 10.0 / 10.0
2571 / Housing Maintenance / Not Started / 20.0 / 20.0
Finance & Business Services / 2572 / Financial Management / On-Going / 5.0 / 4.3
Adults & Health / 2573 / First Contact / Not Started / 3.0 / 3.0
Culture, Leisure & Events / 2574 / Museums, Theatres & Arts Venues / Not Started / 30.0 / 29.7
HR, Legal & Communications / 2575 / Land Charges / Cancelled / 5.9 / 5.9
Children's Services / 2576 / Looked After Children / On-Going / 12.0 / 3.0
Finance & Business Services / 2577 / Performance Management Framework / On-Going / 15.0 / 14.8
Xentrall / 2578 / Internet / On-Going / 10.0 / 1.1
Finance & Business Services / 2579 / PCI Compliance / Cancelled / 10.0 / 10.0
Community Services / 2580 / Environmental Health / On-Going / 6.0 / -8.7
Corporate / 2581 / Absence Management / Complete / Full Assurance / 2 / 0 / 0 / 0 / Yes / 10.0 / -17.3 / Yes
2582 / Mayor's Charity Fund / Complete / N/A / 0 / 0 / 0 / 0 / Yes / 2.0 / 0.2 / Yes
2583 / Housing Rents / Complete / N/A / 0 / 0 / 0 / 0 / Yes / 15.0 / -1.3 / Yes
Xentrall / 2584 / Bank Reconciliation / Not Started / 10.0 / 9.9
Adults & Health / 2585 / Better Care Fund / Not Started / 20.0 / 20.0
Finance & Business Services / 2586 / Welfare Rights / Complete / Substantial Assurance / 2 / 3 / 0 / 0 / Yes / 7.0 / -2.5 / No
Children's Services / 2587 / Planning & Partnerships Team / Not Started / 15.0 / 15.0
Finance & Business Services / 2588 / Environmental Information Regulations (EIR) / On-Going / 5.0 / 2.9
Economic Growth & Development / 2589 / Flooding Risk Management / Not Started / 5.0 / 5.0
Contingency / 2590 / Grant Audit Work 2017/2018 / On-Going / 25.0 / -18.1
Economic Growth & Development / 2591 / Markets Management / Complete / N/A / 0 / 0 / 0 / 0 / Yes / 0.0 / 0.0 / Yes
Contingency / 2592 / Advice and Guidance 2017/2018 / On-Going / Yes / 50.0 / 33.3
Contingency / 2593 / Audit Liaison and Planning 2017/2018 / On-Going / Yes / 20.0 / 17.5
Contingency / 2594 / Recommendations Follow Up 2017/2018 / On-Going / Yes / 40.0 / 40.0
Contingency / 2595 / Continuous Monitoring Contingency / On-Going / Yes / 25.0 / 10.6
2596 / TVCA / Not Started / 30.0 / 30.0
Contingency / 2597 / Risk Management / On-Going / Yes / 35.0 / 24.7
Contingency / 2598 / ICT Individual Systems / On-Going / Yes / 66.0 / 60.5
Contingency / 2599 / Procurement/Contract Management / On-Going / 62.0 / 30.1
Contingency / 2600 / Schools / On-Going / Yes / 15.0 / 15.0
Schools / 2601 / Barleyfields Primary / On-Going / 0.0 / -18.1

1 | Page