FHV Trip Records

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 businessunit@tlc.nyc.gov

For example:

• September Trip Records will be due 
• October 31st October Trip Records will be due November 30th and so on 

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 triprecords@tlc.nyc.gov.

The TLC has defined two formats that bases may use to submit trip records. 

1. CSV: Bases that use electronic dispatching software may submit a standardized comma-separated value (CSV) file. CSV files can be created by many database applications. If your base uses electronic dispatching software, ask your software company if your software can export trip records into a CSV file that follows the specifications defined by the TLC, which can be found in detail below (Visit Upload Process Options) below.            
2. Excel: If your base does not use electronic dispatching software or is not able to create a CSV, you may instead enter trip information in standardized Excel spreadsheet(s) created by the TLC. The spreadsheet(s) created by the TLC are designed to allow a dispatcher to record a trip as they are taking the call. You can use the spreadsheet to record, organize, and look up trips more easily than if you were to report trip records on paper. Detailed descriptions on Excel requirements can be found below.

All submitted file names have to be in the correct format: baselicense_yyyymmdd-yyyymmdd

Ex. B00001_20180101-20180107.csv or
B00001_20180101-20180107.xlsx

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 New Trip Record CSV Spec (Effective January 2019) (csv)– Main trip record specification (Proposed). 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)

---

Download Current 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 Current Trip Record CSV Example (xls).

Download Excel Instruction Guide (pdf) - Detailed explanation of general file requirements for for submitting Excel files to the TLC.

Bases submitting Excel spreadsheets must use the TLC provided templates that can be found below.

As outlined in the Excel 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.

Excel Trip Record File
Download New Trip Record Excel Spreadsheet (Effective January 2019) (xls) – The Trip Record Template (Proposed) must be used to submit trip records if submitting Excel files.

Example: Download Trip Record Excel Example (xls)

---

Download Current Trip Record Excel Spreadsheet (xls) – The Trip Record Template must be used to submit trip records if submitting Excel files.

Example: Current Trip Record Excel Example (xls)

Bases are no longer required to submit an additional document for their shared rides. All bases that provide shared rides must include these rides in the Main Trip Record spreadsheet. For more information, visit the CSV Trip Records 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:

TLC UP: Bases can upload their trip records through TLC UP. On instruction on what is TLC UP and using the service, visit TLC Up.

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 businessunit@tlc.nyc.gov.

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.

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: 

1. Submitted a true and accurate trip record report; or 
2. That the base didn’t dispatch any trips during the reporting period. 

How to Electronically Sign and Submit the Required Affidavit  

1. Visit TLC Trip Record Affidavit 
2. Click “Get Started,” and you will be taken to the form you must fill out and sign. 
3. Fill in the information required in the 9 Blue Boxes including: 
   1. Date 
   2. Base Name 
   3. Base Address 
   4. Base Number 
   5. Reporting Period Start Date – (MM/DD/YYYY) 
   6. Reporting Period End Date – (MM//DD/YYYY) 
   7. Check if you sent us either an accurate Trip Record report, or your base had no dispatched trips during the reporting period 
4. Signature: when you click “Signature,” the following box will appear: 
5. Click on the top tab that says, “Draw” and use your mouse to sign your name 
6. Click “Add” 
7. Click the box that “Full Name” and print your name there 
8. Click “Done” on the upper right corner 

FOIL Requests and Public Disclosure  

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:

• File format
  • New Excel (Effective January 2019). For current format visit Excel File Specifications.
    • Excel Instruction Guide (pdf)
    • Trip Record Excel Spreadsheet (xls)
    • Trip Record Excel Example (xls)
  • New CSV Format (Effective January 2019). For current format visit CSV Specifications.
    • CSV Instruction Guide (pdf)
    • Trip Record CSV Spec (csv)
    • Trip Record CSV Example (xls)
• FTP Documentation:

Resources: The New York City Department of Small Business Services, in partnership with Union Settlement, makes a number of Free or Low-Cost training resources available for small businesses, including the courses listed below. 

Interested bases can learn more and sign up for courses directly by viewing their calendar or calling (646) 545-5204. Read each section of this website thoroughly. If you still have questions about how to submit trip records contact the TLC Call Center by phone at (718) 391-5501 or by emailing us at triprecords@tlc.nyc.gov.

Downloadable FAQs

• Trip Record Submission Process (PDF)