using gps data for ifta and irp
DESCRIPTION
Using GPS data for IFTA and IRP. Objective. Controls in an IT Environment GPS – How it Works? Applying Knowledge Gained to Future Audits. . IT Controls. Subset of enterprise’s internal controls. Objective is confidentiality, integrity, availability of the data. General Controls - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/1.jpg)
1
Using GPS datafor
IFTA and IRP
![Page 2: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/2.jpg)
2
Objective
• Controls in an IT Environment
• GPS – How it Works?
• Applying Knowledge Gained to Future Audits.
![Page 3: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/3.jpg)
3
IT Controls
• Subset of enterprise’s internal controls.• Objective is confidentiality, integrity,
availability of the data.
a) General Controlsb) Application Controls
![Page 4: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/4.jpg)
4
General Controls:
1. Change management procedures
2. Security Policies, Standards and Processes
3. Disaster Recover
Application Controls:
1. Completeness Checks.
2. Validity Checks3. Authorization4. Input Controls
![Page 5: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/5.jpg)
5
IRP 502 & IFTA P620(Printed Reports)
• Printed reports must be produced which replace handwritten trip reports.
• Retained for audit
• Vehicle and fleet summaries.
![Page 6: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/6.jpg)
6
IRP 504 & IFTA P660(Minimum Device Requirements)
• Manufacturer certification.• Security – tamperproof and prevent
altering of information.• Functionality – warnings if devices quits.• Date and time stamping.• Automatic update a life-to-date odometer
or operator enters odometer.
![Page 7: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/7.jpg)
7
IRP 505 & IFTA P640(Data Collection Requirements)
• Distance (IFTA and IRP)
• Fuel (IFTA)
![Page 8: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/8.jpg)
8
IRP 506 & IFTA P650(Reporting Requirements)
• Trip Reports• Individual Vehicle Reports• Summary Reports (Monthly, Quarterly,
Annual)• Exception Reports• Calibration Reports
![Page 9: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/9.jpg)
9
How does GPS work?
• 24 + satellites orbit the earth searching for GPS receivers
• When a receiver is in contact with three or more satellites, the location of the receiver is determined
• This location is expressed in Latitude and Longitude and is stored along with the precise time of its calculation
![Page 10: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/10.jpg)
10
How does GPS work?
• The GPS receiver is attached to a micro computer which takes the information, interprets it, then stores it or passes it on to a communications device
![Page 11: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/11.jpg)
11
How does GPS work?
GPSReceiver
MicroComputer
GPS satellites
![Page 12: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/12.jpg)
12
How does GPS work?
• The GPS data is sent to a computer (perhaps a server) and is available for calculating distance reports for use in Tax and Licensing
![Page 13: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/13.jpg)
13
How does GPS work?
GPSReceiver
MicroComputer
Communication Modem
Internet
GPS satellites
![Page 14: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/14.jpg)
14
NOTE
• GPS satellites are “one-way” – Satellite to ground
• GPS satellites are free!!• For wireless communication we use
different satellites or cellular systems
![Page 15: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/15.jpg)
15
How does GPS work?• These GPS points can be calculated as frequently as
once per second which allows a precise calculation of speed and direction of travel
• In most systems, not all of these points are stored. The recording interval could be from two minutes up to an hour.
• The shorter the interval, the larger the number of points and the greater the accuracy.
![Page 16: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/16.jpg)
16
Accuracy of GPS• Can be accurate to within a few inches but only
with sophisticated / expensive receivers• For our purposes – within 20 feet is reasonable• Filters and algorithms have been developed to
minimize distortions in the data • Accuracy in measuring routes of travel increases
with the frequency of recording• For example, if points are recorded every 5
minutes it is more accurate than every 30 minutes
![Page 17: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/17.jpg)
17
Sample GPS track
![Page 18: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/18.jpg)
18
Summary Report
![Page 19: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/19.jpg)
19
Sample data
![Page 20: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/20.jpg)
20
• Use the continuous distance calculation (every second) and accumulate distance which can be added to recorded points.
• Calculate straight-line distances between recorded points.
• Get distances from an external source such as an odometer or a “Miler” program
Methods of calculating distance
![Page 21: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/21.jpg)
21
Distance Calculation
• If straight-line calculations are used with infrequent data records, the distance may be under reported
• If continuous calculations are used (every second), then the frequency of recording is less important.
FrequentData Records
InfrequentData
![Page 22: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/22.jpg)
22
Sample data
![Page 23: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/23.jpg)
23
Distance Calculation - Map
![Page 24: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/24.jpg)
24
Distance Calculation – Continuous (by second)
![Page 25: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/25.jpg)
25
Distance Calculation – 5 minute interval
![Page 26: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/26.jpg)
26
Distance Calculation – 45 minute interval
![Page 27: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/27.jpg)
27
Distance Calculation - Comparison
![Page 28: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/28.jpg)
28
Assigning Distances to Jurisdictions
![Page 29: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/29.jpg)
29
Summary Report
![Page 30: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/30.jpg)
30
Assigning distance to Jurisdictions
• Data could be run through a Miler program which assigns the distance to each jurisdiction.
• Distribution of distances can be done by the use of “Geofencing”.
![Page 31: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/31.jpg)
31
Use of geofencing
• Describe a polygon using Lat and Long• Use an algorithm to determine when a
truck enters or leaves a polygon• Set up all states and provinces as
contiguous polygons• Calculate the distance traveled in each
jurisdiction (polygon)
![Page 32: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/32.jpg)
32
Use of geofencing
![Page 33: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/33.jpg)
33
Border crossing
![Page 34: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/34.jpg)
34
Border crossing data
![Page 35: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/35.jpg)
35
What about Vicinity Distances?
![Page 36: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/36.jpg)
36
Vicinity distance
![Page 37: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/37.jpg)
37
Vicinity distance data
![Page 38: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/38.jpg)
38
Routing Problem
![Page 39: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/39.jpg)
39
Routing Problem
Actual Travel
Routed by Miler
![Page 40: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/40.jpg)
40
GPS data auditors might ask for
• Minimum for all recorded data points– Latitude– Longitude– Date/time
• Additional – Method used for distance calculations– Odometer to check reasonableness – Method used to distribute distances
![Page 41: Using GPS data for IFTA and IRP](https://reader030.vdocuments.us/reader030/viewer/2022033103/56815d29550346895dcb1fa5/html5/thumbnails/41.jpg)
41
Using GPS datafor
IFTA and IRP