To improve safety, accountability, and policymaking, the TLC now requires all FHV bases to electronically submit their trip records. The purpose of this webpage is to provide bases with the information they need in order to submit trip records to the TLC. A number of reference guides are provided, including detailed instructions about what information is being collected, how to comply, and resources available for bases to learn more about this process.
TLC passed rules to prevent fatigued driving (see Driver Fatigue) that will require the submission of drop-off data. TLC will reach out to bases to provide deadlines and instructions for data submission updates.
Trip Record Submission Deadlines
Trip records for the current month are due to the TLC at the end of the following month. If a base submits their trip records in the first 14 days of that the month, they can get an email notification if their records were rejected and have another opportunity to resubmit by the end of that same month. The email will only be sent to the valid email the TLC has for that base. If you need to change your email contact Licensing Department at firstname.lastname@example.org
If your base receives information on a trip after submitting records for that month, you must include that trip in the next trip record file. For more information email email@example.com.
IMPORTANT: Effective February 28, 2021, all TLC-licensed bases must submit trip records using the CSV format. Files submitted in the Excel format will not be accepted. Bases entering data in Excel files should “Save As” those files as .csv files.
Read CSV Instruction Guide (PDF)— Detailed explanation of general file requirements for submitting CSV files to the TLC.
Bases submitting CSV files must follow the exact specifications described in the CSV Instruction Guide above and should use the specifications provided below.
As outlined in the CSV instruction guide, bases must identify the driver and the vehicle that serviced each trip by including the driver and vehicle TLC license numbers in the main trip record file.
Please note that bases are no longer allowed to include the base’s internal IDs for drivers and vehicles.
Files are comma-delimited and use double quotations as escape characters. For more information about the required format for trip records submitted as CSV, please use the references below. Bases submitting CSV file(s) must submit via SFTP (visit Upload Process Options below).
CSV Trip Record File
Download Trip Record CSV Spec (csv) – Main trip record specification. Files are comma-delimited and use double quotations as escape characters.
File naming convention: baselicense_yyyymmdd-yyyymmdd.csv
Example: Download Trip Record CSV Example (xls)
Shared Ride Specifications
Bases can submit trip records by directly uploading files to the TLC. Bases who submit additional trip record files during this submission period using TLC UP or FTP, TLC will only process the last file submitted. Bases may not send trip records by mail, e-mail, or any method other than the following described here:
FTP: Bases can use submit their trip records using an FTP (File Transfer Protocol) client. All bases are required to submit their trip records using an FTP (File Transfer Protocol) client, effective March 2017. Bases that submitted trip records previously using the FireFTP method will no longer be able to do so if their Mozilla Firefox Web Browser has been updated to Firefox Quantum. Bases that have updated their browser to Firefox Quantum will need to utilize alternative FTP clients to submit their trip records, effective November 2017. There are a number of free FTP clients available for download online, including Core FTP, FileZilla and others. When using a FTP client, bases will use the same username and password that they use for scheduling vehicle appointments.
Trip Records Submission Email Notification: Once bases have submitted their trip records with the proper file format name: baselicense_yyyymmdd-yyyymmdd. They will receive an email notifying them that the TLC has received their trip records. The email will only be sent to the valid email the TLC has for that base. If you need to change your email contact Licensing Department at firstname.lastname@example.org.
If a base submits their trip records files within the first 14 days of the month they are due, they will receive an email notifying them if part or all their trip records have been rejected without penalty. However, they will have until the end of the same month to resubmit the corrected trip records.
Electronic Affidavit Process
Beginning June 30, 2015, when bases submit their trip records, they must also submit an affidavit electronically to the TLC that verifies that they have either:
The TLC takes its fiduciary responsibility seriously as the guardian of all the data it collects. TLC will maintain these records, and disclose these records pursuant to the Freedom of Information Law, in the same careful and considered manner it currently maintains and discloses the numerous other types of sensitive records it currently collects. .
Documents and Resources
Frequently Asked Questions