8._TNC_Report

INTERNAL AUDIT REPORT 

Operational Audit 
TNC (Lyft, Inc. & Rasier, LLC.) 

April 2017  March 2021 

Issue Date: August 26, 2021 
Report No. 2021-10 & 11

Transportation Network Companies 

TABLE OF CONTENTS 

Executive Summary ........................................................................................................................................... 3 
Background ....................................................................................................................................................... 4 
Audit Scope and Methodology .......................................................................................................................... 5 
Schedule of Findings and Recommendations ................................................................................................... 6 
Appendix A: Risk Ratings ................................................................................................................................... 9 













2

Transportation Network Companies 
Executive Summary 
Internal Audit (IA) has completed an audit of Lyft, Inc. and Rasier LLC., referred to as Transportation
Network Company (TNC), for the period April 2017 through March 2021. The audit was performed to
evaluate current processes, systems, and related internal controls to assure compliance with policies,
procedures and contractual obligations governing the TNC's operations. This audit was performed using
both operational and contract compliance procedures. 
On March 31, 2016, the Port entered into a Pilot Program Operating Agreement (Pilot Agreement) with
TNCs. The Pilot Agreement initially required the TNCs to pay a $5 (five) pick-up fee. On November 1,
2017, the fee was changed to $6 (six). Effective January 1, 2021, a new Operating Agreement replaced
the Pilot Agreement and introduced a $2 (two) drop-off fee, in addition to the $6 pick-up fee. 
The Pilot Agreement provided an opportunity for the program to mature into a more permanent system.
Consistent with this evolution, we identified an opportunity that will enhance the internal control
environment related to revenue reporting and the associated payments: 
(Low) A control to assess the accuracy of TNC reported trip data, when it drops below a defined
match rate or threshold, needs to be enhanced. The Port performs observations, traces them to
reports provided by the TNCs and compares the trend month over month. However, no research is
performed to determine the reason for variances. 
This issue is discussed in more detail on page six. 
We extend our appreciation to management and staff of Aviation Business Development, Airport
Landside Operations and Accounting and Financial Reporting teams for their assistance and
cooperation during this audit. 


Glenn Fernandes, CPA 
Director, Internal Audit 



Responsible Management Team 
Jeffrey Brown, Chief Operating Officer, Aviation 
Laurel Dunphy, Director, Airport Operations 
Dawn Hunter, Director, Aviation Commercial Management 
Lance Lyttle, Managing Director, Aviation 
Linda Nelson, Senior Manager, Aviation Finance and Budget 

3

Transportation Network Companies 
Background 
The Port entered into a Pilot Program Operating Agreement with TNCs on March 31, 2016 to facilitate
the operation of one or more vehicles to pick-up and deliver passengers at the airport. Under this
Agreement, TNCs were required to pay the Port $5 (five) for every pick-up activity. This rate was
applicable until October 31, 2017. On November 1, 2017, the pick-up trip fee increased to $6 (six). 
On January 1, 2021, a new Operating Agreement was signed and a drop-off fee of $2 (two) was
introduced, in addition to the $6 (six) pick-up fee. It also introduced a drop-off fee reduction if the TNC
can meet electric vehicle (EV) utilization metrics designed to improve the overall environmental
performance. 
During a quality review, Port management identified a drop in the January 2021 EV utilization when
compared to the previous quarter and contacted the affected TNC to review the data more closely. Upon
investigation, they determined that a correction was made to the vehicle make and model (hybrid vs.
hybrid plug-in) and the lower EV utilization was accurate. The TNC revised their fourth quarter 2020 
report, which lowered the EV percentage below the requirement. As a result, this TNC did not qualify for
the reduced drop-off fee they had received. The TNC was immediately invoiced and confirmed they will
be remitting payment.
TNCs connect passengers (riders) and drivers through a mobile application (App). The App has the
functionality to provide the requestor (passenger) with an estimated pick-up time and trip duration and 
manages the payment process. It also provides customers with an opportunity to evaluate the driver.
Drivers can obtain real time trip data to determine how much they have earned. 
A geo-fence has been established around the perimeter of the airport. The geo-fence interacts with the
General Positioning System (GPS) and the TNC App to capture the trip activity. 
To track and review the TNC activity, the Port utilizes two reports: 
A monthly activity report that is submitted by the TNCs and contains information such as vehicle
registration, time stamp, vehicle model, driver ID, vehicle ID, etc. This report is used by the Port for
billing and payments. 
Ground Transportation staff collect observations of vehicles entering the designated pick-up area.
These observations are compared to the TNC monthly reports to establish completeness and
accuracy of the TNCs self-reported monthly trip activity. This could serve as a primary control to
assess the accuracy of self-reported trip data. 
Combined TNC revenues, for the period audited, are reflected below1: 

2017 (Apr - Dec)      2018              2019                 2020              2021 (Jan - Jul) 
$914,987            $4,031,466       $12,973,434         $10,280,640      $8,079,650 


1 Source: Accounting and Financial Reporting 

4

Transportation Network Companies 
Audit Scope and Methodology 
We conducted this engagement in accordance with Generally Accepted Government Auditing Standards
and the International Standards for the Professional Practice of Internal Auditing. Those standards
require that we plan and conduct an engagement to obtain sufficient, appropriate evidence to provide a
reasonable basis for our findings and conclusions based on our engagement objectives. We believe that
the evidence obtained provides a reasonable basis for our findings and conclusions based on our
engagement objectives. 
The period audited was April 1, 2017 through March 31, 2021 and included the following audit
procedures: 
Internal controls and compliance with significant terms of the Agreement 
Assessed the operators' compliance with contractual/commercial terms of the agreement
including vehicle inspections, credentialling, and trade dress(Uber / Lyft Signage). 
Evaluated operators' compliance with environmental requirements and reviewed any credits
awarded for meeting the environmental key performance indicators (EKPIs). 
Reviewed the TNCs' insurance for compliance with the Operating Agreements. 
Completeness and accuracy of self-reported trip data 
Obtained TNC activity trip data through observations for a sample of dates (total of 126
observations collected on 3 different dates) and established completeness of the data by
comparing operators' monthly reports to the observed data. 
Reconciled the trip activity reported to the Port, to the Port's quality assurance process
conducted by the Business Intelligence team. Determined whether the correct rate was applied. 
Internal billing 
Traced TNC self-reported monthly trip data to internal billing and payment records to validate
timeliness and completeness. 







5

Transportation Network Companies 
Schedule of Findings and Recommendations 
1) Rating: Low 

A control to assess the accuracy of TNC reported trip data, when it drops below a defined match
rate or threshold, needs to be enhanced. The Port performs observations, traces them to reports 
provided by the TNCs and compares the trend month over month. However, no research is
performed to determine the reason for variances. 
The Port receives a $6 pick-up fee and a $2 drop-off fee which is tracked by the TNC App that the driver
uses to charge passengers. When the customer is charged using the App, it is captured in a report that
the TNCs then provide to the Port, reflecting the prior months' activity. 
Each month 40 hours of observations are performed by the Ground Transportation (GT) team. The GT
staff observes the customer pick-ups and uses an in-house developed TNC application to capture
information such as the license plate number and time of pick-up. The information is then provided to
the Business Intelligence team who compares the observations to the monthly reports provided by the
TNCs the following month. The following table reflects the match rates between the Port's monthly
counts and those provided by the TNC. 
Date                     Match Rate 
December 2020              90.60% 
January 2021                 92.80% 
February 2021                88.30% 
March 2021                  89.70% 
April 2021                       89.40% 
May 2021                   88.60% 
Our testing included 126 observations of TNC pick-up activity. We matched 121 of these observations. 
We were unable to trace five observations to the TNC report. Three of which, could likely be attributed
to data capture errors on our part. 
The 40 hours of manual observations and identification of variances have the potential to add value and
can be important. However, when no additional efforts are performed to determine the root cause for
the differences and whether corrective measures are necessary, some of the benefits from the manual
observations are diminished. 
Recommendations: 
Internal Audit recognizes the high volume of transactions and the need to rely on technology. However,
we also recognize that technology can sometimes fail and therefore, we recommend that management
should: 
understand the reasons for the variances and adapt processes to minimize these exceptions 
establish a tolerance threshold that would trigger when additional research is needed 
Without researching the variances, technology and manual errors are unknown and could result in
inaccurate reporting and payment. Furthermore, the program relies on external "self-reporting", 
highlighting the need to implement a procedure to determine whether an error has occurred. 

6

Transportation Network Companies 
Management Response/Action Plan: 
Aviation Commercial Management staff agrees that implementation of a tolerance threshold, as well as
a procedure to research discrepancies when the threshold is triggered, will further enhance the review
process of the self-reported TNC trip activity. A threshold and process will be developed with a targeted
completion date of the end of October 2021. 
In reference to match rates for vehicles, as identified in the 2017/2018 TNC audit (see Report No. 2017-
22), there are three main reasons explaining why hourly match rates may not be 100%: 
1)  Turnover of TNC vehicles/drivers is very high. New drivers/vehicles are continuously getting
permitted and accessing the Airport for pick-up trips. Many of these new entrants have vehicles
with temporary license plates. When permanent plates arrive and drivers replace the temporary
plates  with  permanent  plates,  TNC  companies  are  often  delayed  in  updating  their
database/systems with the new plate information. When Port GT staff collects real-time trip info
with permanent plate info, yet TNCs report at month-end the temporary plate info, the result is a
"non-match." 
2)  As mentioned, GT staff collects data at random times, and for certain time increments (e.g.- one
hour). Due to the potential time delays associated with GPS data and the real-time systems, data
collected close to the start and finish of time increments can lead to non-matches. An example
would be GT staff collecting data associated with a pick-up at 11:59am, and due to slight data
transfer delays with the TNC systems, at month-end the TNC reports the pick-up time at
12:01pm, leading to a non-match when analyzed by Business Intelligence. 
3)  TNC drivers utilize their application to indicate when they have picked up a passenger. This
information is then sent to the TNCs. Often, drivers will send notification before or after the actual
pick-up (e.g.- a TNC driver may pick up his/her passenger and then several minutes later send
the notification while en-route to the destination). When this occurs, typically it results in a nonmatch.

If vehicle matches are viewed on a daily basis instead of hourly (as presented in this audit report above
for December 2020 through May 2021), a much higher match rate is achieved as shown below: 
DATE            HOURLY MATCH RATE   DAILY MATCH RATE 
December 2020    90.6%                  95.9% 
January 2021      92.8%                    96.9% 
February 2021     88.3%                    96.6% 
March 2021        89.7%                   97.1% 
April 2021           89.4%                      97.5% 
May 2021         88.6%                   99.2% 
In regards to the Audit team's testing of 126 vehicles with five vehicles unable to be matched, Aviation
Commercial Management staff performed additional research on the five and was able to establish
likely matches for three of the five based on the following: 

7

Transportation Network Companies 

Two vehicles during the observation time periods had license plates that matched 6 of 7 characters with
the one unmatched character being a character that could easily resemble the reported license plate for
a moving vehicle in a parking garage. 
One vehicle during the observation time period had a license plate not yet in the TNC system.
Only one TNC reported unknown license plate vehicle made an appearance during the
observation period. This is likely explained by the first description of observation rate limitations
discussed in this response. 
Two remaining vehicles were not matched, resulting in a likely observation rate of 98.4% (124 of
126) 

DUE DATE: 10/31/2021 














8

Transportation Network Companies 
Appendix A: Risk Ratings 
Findings identified during the audit are assigned a risk rating, as outlined in the table below. Only one
of the criteria needs to be met for a finding to be rated High, Medium, or Low. Findings rated Low will be
evaluated and may or may not be reflected in the final report. 
Financial      Internal                                               Commission/
Rating                                   Compliance      Public 
Stewardship  Controls                                         Management 
High probability
Non-compliance
Missing or not                       for external audit   Requires
with Laws, Port
High       Significant     followed                          issues and / or     immediate
Policies, 
negative public     attention 
Contracts 
perception 
Partial              Potential for
Partial controls 
compliance with   external audit
Requires
Medium   Moderate                  Laws, Port       issues and / or
Not functioning                                          attention 
Policies             negative public
effectively 
Contracts          perception 
Functioning as
Low probability
intended but     Mostly complies                       Does not
for external audit
could be        with Laws, Port                       require
Low      Minimal                                   issues and/or
enhanced to    Policies,                            immediate
negative public
improve        Contracts                          attention 
perception 
efficiency 










9

Limitations of Translatable Documents

PDF files are created with text and images are placed at an exact position on a page of a fixed size.
Web pages are fluid in nature, and the exact positioning of PDF text creates presentation problems.
PDFs that are full page graphics, or scanned pages are generally unable to be made accessible, In these cases, viewing whatever plain text could be extracted is the only alternative.