![Page 1: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/1.jpg)
ANALYTICS & CONTINUOUS MONITORINGTO MANAGE PURCHASING CARDS
P-CARD SOLUTION
![Page 2: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/2.jpg)
AGENDA
Risks and controls management
Case study for analyzing p-card data
Design thinking process
![Page 3: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/3.jpg)
RISKS AND CONTROLS
Stakeholder Communication
Identify Measure Mitigate Monitor
Create Value
Manage Expectations
![Page 4: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/4.jpg)
RISK MANAGEMENT PROCESS
Understanding Controls
Identify and Assess Risk
Responding to Risks
Evaluate and Report
![Page 5: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/5.jpg)
ENGAGEMENT PROCESS
Communicate with Business
Gather Data
Scope Audit Engagement
Understand Data Story
![Page 6: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/6.jpg)
CASE STUDY
![Page 7: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/7.jpg)
CITY P-CARD DATA USED
162,495 Unique Transactions
$31.8 Million Total Spend
163,386 Transactions Duplicate Transactions
Blank Purpose Transactions
Holiday Purchases
2011–
2014
High Level Data Analytic Tests Run
![Page 8: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/8.jpg)
TEST DUPLICATE TRANSACTIONS
$
Merchant Name
Division Transaction Amount
Transaction Date
Post Date
1
Same merchant name, division, transaction amount, transaction date and post date
![Page 9: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/9.jpg)
TEST DUPLICATE TRANSACTIONS
$
Merchant Name
Division Transaction Amount
Transaction Date
Post Date
1
Same merchant name, division, transaction amount and transaction date. Different post date.
$2
![Page 10: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/10.jpg)
TEST DUPLICATE TRANSACTIONS
$
Merchant Name
Division Transaction Amount
Transaction Date
Post Date
1
Same merchant name, division, transaction amount and post date. Different transaction date.
$2
$3
![Page 11: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/11.jpg)
RESULTS: DUPLICATE TRANSACTIONS
10,471 Duplicates identified
$1,661,329.23 Spent
Potential loss of $830,664.61
![Page 12: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/12.jpg)
TOP DEPARTMENTS FOR DUPLICATES
Division Number of Transactions
Transaction Amount Summary
Legal Services 5716 104705.46
Parks, Forestry & Recreation 1413 410383.73
Emergency Medical Services 474 94635.20
Water 441 87263,53
Technical services 358 3715.00
Economic development & culture 333 80193.81
Public health 251 44998.34
Fleet services 225 520765.70
Engineering & construction services 225 4528.00
Fire services 196 58775.05
By Division and Number of Transactions
![Page 13: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/13.jpg)
ACTION: Look at the duplicate transactions and
determine reasons for duplication.
![Page 14: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/14.jpg)
RESULTS: NO DESCRIPTION TRANSACTIONS
2011 –2014
7%
Unique transactions with no description
54%
Unique transactions with no description by Parks and Recreation
![Page 15: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/15.jpg)
TOP DEPTS. WITH NO DESCRIPTION
Division Number of Transactions
Parks, Forestry & Recreation 6415
Legal services 2934
Technical services 844
Water 342
Solid Waste management 211
Transportation services 155
Emergency medical services 138
Public Health 134
Shelter, support & Housing Admin 75
![Page 16: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/16.jpg)
ACTION: Look at the reporting process and why the top departments don’t include a
description in their transactions.
![Page 17: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/17.jpg)
RESULTS: HOLIDAY PURCHASES
Canadian Statutory Holidays
49,938 Transactions in 2014
76 Holiday transactions
Totaling $12,621.73
![Page 18: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/18.jpg)
TOP DEPTS. WITH HOLIDAY PURCHASES
Division Number of Transactions
Transaction amount
Parks, Forestry & Recreation 23 4268.12
Economic development & culture 21 2872.50
Solid waste management 2 1621.55
Facilities management 5 1558.14
Long term care homes 4 1014.29
Public health 6 346.92
Fire services 5 296.03
Water 1 248.60
Emergency medical services 2 136.96
Information & technology 1 127.34
![Page 19: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/19.jpg)
ACTION: Review transactions on holidays and
determine if they are valid.
![Page 20: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/20.jpg)
A DESIGN THINKING PROCESS
Design Thinking
Define
Prototype
IdeateTest
Empathize
![Page 21: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/21.jpg)
A DESIGN THINKING PROCESS
Design Thinking
Define
Prototype
IdeateTest
EmpathizeLearn about the business
![Page 22: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/22.jpg)
A DESIGN THINKING PROCESS
Design Thinking
Define
Prototype
IdeateTest
EmpathizeFocus your analytics and actions based on insights
![Page 23: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/23.jpg)
A DESIGN THINKING PROCESS
Design Thinking
Define
Prototype
IdeateTest
Empathize
Brainstorm creative solutions. Identify gaps
![Page 24: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/24.jpg)
A DESIGN THINKING PROCESS
Design Thinking
Define
Prototype
IdeateTest
Empathize
Build an automated analytic model, company wide
![Page 25: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/25.jpg)
A DESIGN THINKING PROCESS
Design Thinking
Define
Prototype
IdeateTest
Empathize
Return to the business for feedback on results
![Page 26: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/26.jpg)
BUSINESS IMPROVEMENT
Enterprise Wide
Cross Application
Data Discovery
Actionable Insights
![Page 27: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/27.jpg)
DATA DISCOVERY
Ability to view overall program performance, spending, root causes, exceptions
![Page 28: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/28.jpg)
DATA DISCOVERY
Filter misuse, spend and exceptions, root causes
![Page 29: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/29.jpg)
DATA DISCOVERY
Employee views to review top abusers and investigate patterns of misuse
![Page 30: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/30.jpg)
ROOT CAUSE DISCOVERY
Significant spike Spike in exception amount along with the increase in number of cards
Top exceptionsEmployees in Marketing
Employee dashboardHigh amounts of personal purchases at hotels and restaurants
Identifying root causes allows companies to recoup amounts owed and address control weaknesses
![Page 31: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/31.jpg)
CONTINUOUS MONITORING
Risk based analytics, frequency, report on anomalies, visualize source, automated remediation, business improvement. Continuous monitoring
![Page 33: Analytics and Continuous Monitoring to Manage P-Cards](https://reader036.vdocuments.us/reader036/viewer/2022070520/58f161451a28abb0078b4597/html5/thumbnails/33.jpg)
ANALYTICS & CONTINUOUS MONITORINGTO MANAGE PURCHASING CARDS
P-CARD SOLUTION
Visit casewareanalytics.com Email [email protected]