Skip to main content
Mitratech Success Center

The Timekeeper Upload File Explained

A guide to walk you step by step through the upload file and its fields. The Timekeeper upload file CollaboratiTimekeepers-3.0 is a Comma Separated Values (CSV) formatted file.  Includes field selections where available.

The Timekeeper upload file CollaboratiTimekeepers-3.0 is a Comma Separated Values (CSV) formatted file. CSV files can be opened and edited easily with Excel.


The first line of the file should be the header. It should read CollaboratiTimekeepers-3.0 (as seen below)

Timekeeper Upload file Header.jpg


There are 25 fields in the Timekeeper upload file. Only 7 are required by all of our clients. These six are Email, First Name, Last Name, Home Office, Display Code, Timekeeper ID, and Classification. Please see your client’s billing guidelines to determine if any other fields are required for that specific Client.


The displayCode is a unique identifier for the timekeeper. In Collaborati this field is used and displayed whenever there is a drop down list of the timekeepers. This value should be unique to the timekeeper and easily associated with the timekeeper as to quickly choose from a drop down menu. The displayCode can be the same as your Timekeeper ID.


The classification of the timekeeper can be one of the following (use the 2 letter Code):

PT - Partner

AS - Associate

OC - Of Counsel

LA - Legal Assistant

OT - Other Timekeeper


Collaborati requires that each timekeeper have a unique email address assigned to them. No emails are ever sent to the timekeeper, this field is used just as an identifier in the database for the timekeeper. This means that if your timekeepers do not have unique emails you can use fake emails for each timekeeper as long as they are unique. Example,, and so on.

eb-timekeeper upload.png

firstName, middleName, lastName

These are text fields and only First and Last name are required.


Assigning a Home Office to a Timekeeper allows attorneys and billing analysts to consolidate and standardize billing rates for Timekeepers on matters. Learn more about adding and managing Home Offices hereTroubleshooting Note: If the home office name in the csv file does not match any of the selected offices or if it’s not populated then the timekeeper row will display the status as an error in the Status column.


Also a text field as to allow multiple formats for telephone numbers.


The Timekeeper ID should match your Timekeeper ID in your own billing software. This code is matched with the Timekeeper ID field in any LEDES formatted invoices you submit. This is also unique to each timekeeper.


These are text fields and neither is required.

EB - The Timekeeper Upload File Explained (image 4).PNG


This field is optional and should be in the YYYY format.


Field is not required. However if used, the field must match exactly one of the following selections:

EB - The Timekeeper Upload File Explained (image 5).PNG


This field is a text field and has a character limit of 40 characters.

EB - The Timekeeper Upload File Explained (image 6).PNG


Optional fields, city is a text field, State should be two-letter code for state, and postal/zip code is a text field.


Not required but if used, you must use the 2-letter country code. You can find a list of all 2-letter country codes at the end of this document. You can also find an updated list of 2-letter country code by searching for “2 letter country codes” in your favorite internet search engine.

EB - The Timekeeper Upload File Explained (image 9).PNG


Not required also allows multiple phone formats for international numbers.

EB - The Timekeeper Upload File Explained (image 7).PNG


Not required needs to be the name of the state spelled out, multiple selections can be selected using a comma to separate. Can be one of the 50 US states, 13 Canadian Provinces, or the full country name except US and Canada.


Not required, needs to be one of the following selections. You can also have multiple selections, separated by commas.

EB - The Timekeeper Upload File Explained (image 8).PNG


Not required field. Utilizes the YYYY format.


Would match the Client Code (Internal Client Code) for the client ; only used when there is a need for a client specific timekeeper, otherwise, leave this field blank (click here for more information about Client Specific Timekeepers).

  • Was this article helpful?