Help Center

Importing Time Entries from a CSV File

You can import time entries into Legal Accounting from a CSV file. Use this article when you need the time import template, dates come in blank or wrong after an import, or you need to undo an import.

 


Importing Time Entries

 

To do this:

  1. Download the Time Template.csv, located at the end of this article.
  2. Delete the example row.
  3. Enter your entries.
  4. Save the file as CSV.
  5. Go to Add Entry > Time/Fees.
  6. Drop the file into Drop Import File Here.
  7. Review the entries.
  8. Save the entries.

Caution: Don't use Export Visible Data as CSV from the Time/Fees screen as your template. It has different columns, and the dates won't import.

 


Fixing Import Errors

 

Dates Are Blank or Wrong After Import

Possible solutions:

  1. Make sure you used the Time Template.
  2. In Excel, widen the date column. Dates showing as ## aren't valid.
  3. Click your initials > Firm License Information > Reset Browser Cache.
  4. Import the file again.

Note: You can't undo an import in bulk. Delete wrong entries one at a time from Reports > Other > Time.

Tip: To change the rate, fee earner or task code on many unbilled entries, an admin can use Bulk Update of Time instead of re-importing.

 


Additional Resources:

Updated