Import labor timecards from an Excel file
If you have previously selected Retrieve SC Project Timesheets from the Time Sheet tab in Accounting Link > Posting Preferences, the ability to import labor timecards directly will be disabled. You will not be able to add new timecards in Sage Construction Management; instead, you will only be able to import timecards from Sage Intacct.
Prepare an Excel file for import
- Open a blank Microsoft Excel spreadsheet or download the sample file.
- Label the first row with the column names shown in the table below.
Make sure that all the required fields are included. Field names do not contain any spacing within the word, or before and after.
Make sure that the sheet is labeled as Sheet1.
-
Enter your data starting from the second row.
- Save the file in Excel 97-2003 format (*.xls).
- Close the file to enable Sage Construction Management to import the data.
Import the file
- Go to Time & Expenses.
- In the Timecard and Expense Stats section, select the three-dot menu icon (
) in the Lbr. Timecards row. - Select Import Labor Timecards From Excel.
-
Select Choose File and find the file on your local drive.
The data will be imported automatically.
If the Mark Imported Timecards as Pending option is selected in Settings > Feature Settings > Time and Expenses, timecards will need to be approved after importing.
Microsoft Excel import sample
Download the labor timecards sample file.
Labor timecard file fields
| Column name / First row | Required (*) | Field type | Comments |
|---|---|---|---|
| Date | * | Date |
|
| CompanyName | Text | The company name is required when importing time for external firms. | |
| EmployeeName | * | Text | The employee display name as specified in the Employee Profile page. |
| ProjectNumber | * | Text | |
| PrimeContractNumber | * | Text | |
| ChangeOrderNumber | Text | The change order (CO) number must exist in Sage Construction Management before importing the file. | |
| LaborCode | Text | This field is optional. However, if a labor code is provided, it will be the primary factor in determining the rates along with the payroll code. | |
| PayrollCode | * | Text | The payroll code must be referenced in the Employee or Labor Items Details page. |
| CostCode | * | Text | The project job cost code. |
| WCCode | Text | The workers compensation code. | |
| Hours | * | Number | For example, 4.25, 8, 8.5, 9.0, and so on. |
| BillableStatus | * | Text |
Options: Billable, Unbillable, or On Hold. This field applies only to Cost Plus prime contracts. |
| Comments | Text |
Troubleshoot upload issues
If there is an issue when importing records from the spreadsheet, check the following:
- The ProjectNumber matches exactly the value specified in the Project # field in Sage Construction Management.
- The PrimeContractNumber matches exactly the value specified in the Prime Contract # field in Sage Construction Management.
- The CostCode matches exactly the cost code for the specified project in Sage Construction Management.
- The EmployeeName matches exactly the value specified in the Display Name field in Sage Construction Management.
- The PayrollCode matches exactly the value specified in the Payroll Code field in Sage Construction Management and is also referenced in the employee's default payroll rate table.
- The spreadsheet is closed when it is uploaded and the sheet name is labeled Sheet1.