Uploading Timesheets

While Mosaic can be used to input timesheet time, timesheet time can also be uploaded from other tools to Mosaic for complete budgets and details on the progress of your projects.

To upload timesheet time:

  1. Confirm either Mosaic Support or your Customer Success Manager have enabled the timesheet upload tool on your account. To request this tool be added to your account, reach out to our team via [email protected]

  2. Next, download the timesheet time import template here

Here is an overview of the details needed for each column:

Field

Guide

Example

Required

Project Title

Name of the Project

Central Park

Yes

Project Number

Identifying Project #

1234.1

Yes

Date

Date of Time Entry

2022-01-05

Note: All dates must be in YYYY-MM-DD format.

Yes

Hours

Number of Hours

3

Yes

Phase

Phase within the project

Surveying

No

Note: Not required if there is no phase under the project.

Work Category

Type of work being completed

Planning

No

Note: Not required if there is no work category under the project + phase.

Employee Name

Full Employee Name

John Smith

Yes

Employee Email

Employee's Email Address

[email protected]

Yes

Hourly Rate

Billable Rate

250

No

Description

Details on the work being completed for the time entry

Survey planning for south park entrance

No

Billable

Are the hours billable/non-billable?

accepted values = "true", "false"

No

Note: Not required if you would like the default value for that project, phase and work category to be applied to your time entry.

The default value will be "true" if the project, phase and work category are all billable. If either project, phase or work category are non-billable, the default value will be "false".

You can override the default value by providing a different value for this field.

Porfolio

Name of the Portfolio that the Project is in

2022 Projects

No

Phase Number

The Phase Number if the Project/ Phase is imported from an integration

200

No

Please review this carefully before uploading a data file to get imported

📘

Please Note:

Ensure your data is accurate and has unique values in the fields below as duplicate time entries in an import will be skipped.

The following fields are used to determine the uniqueness of a time entry for importing:

  • Project Title
  • Project Number
  • Date
  • Phase
  • Work Category
  • Employee Name
  • Employee Email
  • Hours
  • Description

Tip: Provide a unique description for your time entry if all the above fields are identical.

  1. Export your completed timesheet import file to the .csv format. Date fields work best in .csv formats.
  2. Navigate to Company Settings -> Timesheets, and select upload time entries to upload your .csv file.
15731573
  1. Select the file you would like to import using the file selector or drag and drop the file here.
15731573
  1. Once uploaded, the software will try to auto-map the information that we need. You can also change the mapped columns by clicking the dropdown from your columns. It may take some time for the information to auto-populate in our field columns.
28222822 28332833

Red Highlighted Entries

Any boxes that appear in red indicate there is no matching value for this box on Mosaic. To correct, either skip the time entry via the checkbox to your left, or exit out of the timesheet import tool to add this value to Mosaic.

  1. Once columns have been linked, and any red rows have been addressed, select "Continue" in the top right corner and click submit data.
19871987

Note: You should see this message when it's successfully uploaded

19771977
  1. Thats it! Your newly uploaded timesheet entries have been successfully uploaded to Mosaic. Please allow up to 24 hours for all time entries to finish populating on Mosaic.

🚧

Note:

Ensure that Members are given at least Team Member Access Level to allow timesheet entries to be submitted by that member (Settings > Members > Access Level). Guests cannot have time entries.