Dashboard Reporting for Internal Audit

Dashboard Reporting for Internal Audit

Jordan Lloyd Senior Manager Deloitte & Touche LLP

CAE Dashboard

A high level summary of status of planned audits

A high level unified view showing risk ratings of the planned audits as derived from the risk assessment along with the status of the audits by completion, audit ratings, processes and location

Ryan Woodward, Sr. Manager, Global Seller Trust

Value

- Consolidated view of all planned audits - Allows drill down by risk rating, status, audit rating, process and location - Eliminates the need for multiple reports

3rd Parties Risk Assessment

Risk Score Aggregation and 3rd Parties Audit Prioritization

A set of over 80 risk metrics monitored across a portfolio of thousands of 3rd parties. Weights and scores applied and aggregated at 3rd party level to identify target 3rd parties with the highest risk for audit prioritization. Risks is further categorized to facilitate targeted review.

Value

- Audit prioritization no longer assigned based on a fixed schedule or cycle - Insights along a spectrum of risk genres (financial, operational etc.)

Location and Process Risk Assessment

Risk Score Aggregation and Site, Process Priority Identification

A summarized view of risk scores by locations and business processed derived from survey results rolled out to different stakeholders to assess the risk posture associated with business processes

Value

- Site visits are no longer assigned based on a fixed schedule or cycle - Insights along a spectrum of risk genres (cyber security, financial, etc.)

Audit Universe

Visualization to represent the audit universe

In a global set-up, majority of the organizations have entities or set-ups across countries and cities. The complicated nature of local compliance needs followed by the need to provide assurance on internal controls across all locations and at the same time have a unified view of all audits across the organization is the driving theme for this visualization. It harnesses the data from different audit schedules across different time periods and presents a unified view of the audits completed across locations, processes and time.

% of Total Revnue* (Countries Covered)

99.75%

Integrated Audit Schedule Geographical Coverage

% of Total Revenue (Countries not Covered)

0.25%

Countries Not Covered

Country

% of Total Revenue

Bangladesh

0.000%

Brunei

0.020%

Bulgaria Czech

Republic

Ecuador

0.088% 0.058% 0.018%

Ivory Coast Mozambiq..

0.048% 0.000%

Pakistan

0.000%

Sri Lanka

0.014%

Covered Not Covered

Status

Value

- Consolidated view of all planned audits across locations and processes - Provides instant identification of location not audited over an extended period of time

Audit Universe

Visualization to represent the audit universe

In a global set-up, majority of the organizations have entities or set-ups across countries and cities. The complicated nature of local compliance needs followed by the need to provide assurance on internal controls across all locations and at the same time have a unified view of all audits across the organization is the driving theme for this visualization. It harnesses the data from different audit schedules across different time periods and presents a unified view of the audits completed across locations, processes and time.

Countries Covered

66

% of Scheduled Audits

100%

Organization Type

Corporate

Org Type 1 Org Type 2 Grand Total

Integrated Audit Schedule and Audit Findings Dashboard

Compliance

Divisional

Facility Inspections

Fraud Risk Assessment

Audit Type ICFR

Location

Quality

43

Quality Health & Safe..

8

12

150

3

5

7

20

278

60

8

4

5

5

8

74

74

20

150

7

10

12

28

395

142

Grand Total

51 535 178 764

# of Findings

2,555

% of Findings

100%

Audit Schedule by Audit Type

Audit Findings Summary by Audit Type

Audit Type

Internal / External Internal

All

All

All

All

Month All

All

# of Findings 1.0

546.0

Compliance Divisional

Facility Inspections Quality - Health & Safety

Quality Fraud Risk Assessment

ICFR Location

Value

- Consolidated view of all planned audits across locations and processes - Provides instant identification of location not audited over an extended period of time

Continuous Auditing

Analytics for continuous auditing across processes

Multiple Systems

Timely Compliance

Continuous review

Transactions Processes

Continuous Audit & Monitoring

Cost - effectiveness

Process improvement

Dynamic and flexible audit plan

Assess effectiveness of controls

New Suppliers

Invoice amount

% of total amount

# of invoices

% of total invoices

New Vendors with activity in creation month

All $10,566,760.35

1.94%

1,998

1.73%

1,315

Num Inv

Spend Type 3rd Party Spend

New vendors created

200 All

# of invoices raised

100

0

Invoices with new vendors

$

$2,000K

200

$

$1,000K

$

$

$

$

$$ $

100

$

$$

$0K

0

Inv Number of in

Invoices by new vendors - by Region

5M

$4.7M

800

4M 600

3M $2.9M

400

2M

$1.4M

$1.3M

1M

200

$0.2M

0M

0

Americ.. Corpor.. Europe Middl.. Pacifi..

JanuDaercyeNo2mv0bOe1ec6rtmobS2be0rep1rtA25eu20g0m1Ju1b5usle5tyrJ2u220n001e11M555a2y0A12p5r0il1M5a2r0Fc1eh5b

JanDuearcNyeo2vmOe0bcte1mrSo6beb2epeAr0true12Jg250muu0l1bs1yJte55ru22n200eM011a2155yA05p21ri05lM1a2r5Fc0eh1b

3rd Party Spend

Stratification of invoice amount

for new vendors

411650

600

532

945,197

Invoices by vendor

406500 840,613

414462 205,516

#V

400

200 06

234

235

248

120

134

9

404576 930,945

406559 268,768

415493 253,572

418638 196,501

417438 184,949

412503 182,567

422470 162,773

Number o Num

Threshold for daily hours 16

Total hours (exceeding the threshold)

80,383

# of employees exceeding thresh-

old

631

Employee hours - Daily analysis

# of employees with more than 16 hours a day

250

231

231

229

212

212

Frequ.. 1 to 150 Employees with frequent excess hours (more than 16 hours a day)

200 190

193

150

195

198

198

176 186

157

169

100

50

All All All All

All

Employee Contractor

33

36

36

33

31

26

24

0

January Februa.. March April May June July

Total instances with more than16 hours a day

All

600

590

576

575

500 452 434

484 469

400

483

471

528

300

367

393

419 412

200

100

107

104

67

0

59

48

57

65

January February March April May June July

Tot

150

100

50 0

Jan 1

Employee Name Daily hours by employee (more than 16 hours a day)

Feb 1 Mar 1

Apr 1 May 1

Jun 1

Jul 1

Aug 1

10000-100000

>100000 5000-21000000-105000000-520000-01000 0-500 100000 5000-21000000-105000000-520000-01000

0-500 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download