Import Timesheets

If your firm has of-counsel or timekeepers without CosmoLex access and you want to import their time entries, you can use our WIPs-Time Import functions.

Complete the Excel Import File

1. Open the Excel file’s Time tab.
   Important

   To ensure a successful import, do not change the column or sheet names.

2. Complete all applicable fields. (For field character limits and field descriptions,  see the Data Entry Instructions sheet)

Some helpful tips:

• • For Matter-Key you can use either the CosmoLex-assigned Matter ID# or the Matter File #. Whichever you use must apply to all imported items to ensure the import will match data already in CosmoLex.
  • If the date field is left blank, the date of import will pre-populate
  • For Billing-Type column, choose one of these values: Billable, Non-billable, or No Charge.
  • If using the Billed-Hours and Billed-Minutes fields, enter in full numbers such as 1 hr 30 min equals Billed-Hours = 1 in Hours and Billed-Minutes = 30,
  • If using Total-Billed-Hours instead,  enter as decimals, such as 1.50.

Import a Timesheet

To import a timesheet:

1. Toward the upper right corner of the screen, click the ‘+’ icon.
2. From the drop-down, click Other > Import Data. 

The Operations screen opens, displaying: Please select your operation.

3. Click the radio button for Import Time/Expense (Work in Progress).
4. In the lower right corner, click Continue.
5. On the Select the file you want to import screen, click Choose File.
6. In the browser window, browse to locate the file you want to upload.
7. Single-click the file.
8. Click Open.
   The browser window closes, returning you to the previous screen. Your import file’s name populates the Choose File field.

9. In the lower right corner, click Upload.
10. Confirm the File has headers checkbox is checked.
11. Resolve any errors associated with the upload.
12. Click Complete Import.
    A message displays: Import data has been completed successfully.
13. In the lower right corner, click Close.

Common Error Resolutions

Use these resolutions to assist with common errors:

Referenced client matter does not exist	Compare the spreadsheet’s Matter Identifier to the matter identifier listed in CosmoLex. Correct the spreadsheet’s Matter Identifier.
Timekeeper name does not match	Compare the spreadsheet’s Timekeeper value to the Timekeeper values in CosmoLex. Either correct the spreadsheet, or add the new timekeeper.
Invalid values for time	Correct any spreadsheet Time records with non-numeric or invalid values.