How Do I Import Time Records?
Overview
Matters.Cloud provides a simple to use facility to import existing time data when migrating from third party applications.
Import Formats
The following file formats are supported:
- Microsoft Excel (.xlsx)
- Comma Separated (.csv)
Import Process
Step 1: Download Import Format
To download the import format, select Time > All time and locate the Import button:
Download the appropriate Template using the links provided:
Step 2: Populate File Content
Populate the template with time entries exported from your third-party application.
The time import template includes fields such as:
| Column | Description |
|---|---|
| date | Time entry date |
| client_code | Client code from the source system |
| related_to | Record type the time entry is linked to (e.g. Matter or Opportunity) |
| related_id | Matter or Opportunity reference from the source system |
| activity_code | Activity code from source system |
| owner | Time entry owner |
| rate | Hourly rate |
| currency | Currency of the time entry |
| hours | Number of hours recorded |
| billable_status | Billable status (e.g. Billable / Non-billable) |
| narrative | Description of the work performed |
| billed_amount | Amount billed |
| bill_status | Billing status |
Step 3: Import File
Select the file to import using the Choose File button and then click the Import button.
Related Articles
How to Delete Time Entries
Introduction Time management is crucial for ensuring accurate billing and reporting. There may be instances where you need to delete a time entry due to errors or adjustments. This guide outlines the steps for deleting time entries within ...Understanding the Time Write Off Process
Introduction Matters.Cloud offers two primary methods for effectively managing the time write-off process, supporting accurate financial reporting and operational transparency. This guide outlines the available options for writing off time, along ...What Data Can I Migrate From ESILaw To Matters.Cloud?
Overview Matters.Cloud provides a simple to use facility to import data when migrating from third party applications. Before attempting to migrate data into Matters.Cloud you should ensure that it is consistently formatted and backed up. Answer ...What Data Can I Migrate From Rocket Matter To Matters.Cloud?
Overview Matters.Cloud provides a simple to use facility to import data when migrating from third party applications. Before attempting to migrate data into Matters.Cloud you should ensure that it is consistently formatted and backed up. Answer ...How Do I Import Clients?
Overview Matters.Cloud provides a simple to use facility to import existing client data when migrating from third party applications. Import Formats The following file formats are supported: Microsoft Excel (.xlsx) Comma Separated (.csv) Import ...