How to Import Timesheets in CosmoLex


If your firm has of-counsel or timekeepers who do not have access to CosmoLex and you wish to import their time entries, you can consider using our WIPs-Time Import functions.


Prerequisites:

  • Ensure that the corresponding Client-Matter records already exist in CosmoLex prior to importing data. 

  • Excel template to fill-in the Timesheet entries is located HERE


Filling-in the Excel file

  • Go to the Time tab to fill-in your data.

  • Column name headers and Sheet name should Not be changed for the import to work successfully.

  • Carefully fill-in the Matter Identifier values for each row. This is the Matter ID# assigned by CosmoLex (Not Matter File # which is user assigned.

  • All fields except Card Date, Tax and Description ones are Required to be filled-in. If Card Date value is left blank, current date will be used for the import.

  • Billing Type value should be one of these: Billable, Unbillable and NoCharge

  • You have the choice to enter time values either as Hour-and-Minute (e.g. 1 in Hours & 30 in Minutes) -OR- as Total Billing Hours in decimals (e.g. 1.50).

  • For any additional information such as max allowed characters, refer to the “1. Data Entry Instructions” sheet in the file.



Import Steps

  1. In the top menu, click the ‘+’ icon and go to Other > Import Data. This should open the first screen for Import.




  1. Select the first option and click “Continue”.



  1. Click “Choose File” to locate the file and then click “Upload”. Keep the “File has headers” checkbox as ticked.



  1. Tick the “Match Matter Identifier” checkbox so that the time cards are linked correctly to the existing corresponding matters in CosmoLex. 




  1. Verify at least 5-10 records to confirm that Client-Matter are correctly matched.

  2. Verify that the total counts shown in the lower left area match with the spreadsheet data counts.

  3. Confirm that the import has 0 errors listed in the top area.

  4. For any errors found, click “Remove All” and “Close”; make changes to the spreadsheet and upload the file again.

  5. If everything looks fine, click “Complete Import” and wait for the success message to appear.


Frequently Occurring Errors and Resolution

  • Referenced client matter does not exist

This indicates that the Matter Identifier entered is invalid and not matching with an existing client-matter in CosmoLex. 

  • Timekeeper name does not match

If the spreadsheet has a timekeeper value that’s not in CosmoLex; go to Setup > Timekeeper to create a new timekeeper.

  • Invalid values for Time
    Identify and update spreadsheet records that have non-numeric or invalid values for Time.