Organization Settings - Timesheet

Enabling/disabling timesheet feature on Mosaic and uploading timesheets through CSV file

You can change member's time entry setting and import time entries from this view.

Time Entry Setting

There are options to use either Mosaic Timesheets or Time Entry data received from Integrations.

  • Mosaic Timesheets: Requires manual time entry.

  • Timesheets Off: Time tracking is disabled, and previous planned hours will be used as the actual Spent Time. Mosaic automatically generates timesheets at the end of each day based on the scheduled Work Plans. No variance will be displayed.

How to import Time Entries?

  1. Click Upload Time Entries

  2. For the first-time upload of time entries, an initialize button will be displayed. Initialization is required only once.

  3. The fields for Data to Import, Max Phase Levels, and Import Reference Number are also visible. A different data type, such as Employees, Work Plans, Projects, and more, can be selected from this modal. The Max Phase Levels field will only appear when subphases are enabled for the team and the selected data type supports subphases (currently Projects/Phases/Work Categories, Time Entries, and Work Plans).

  4. De-select the Automatic Field Mapping option to prevent columns from automatically mapping, thereby avoiding potential improper data imports.

  5. Click upload to open the import tool.

  6. Upload your csv or xlsx file to the timesheet import tool.

  7. Once uploaded, connect each column from the spreadsheet on the left to the corresponding value on the right. This can be done by copying the first value of a column on the left, to the corresponding column on the right. So long as there is a matching value, the remaining entries in the column will automatically populate.

  8. Once you all the columns match and any red rows have been addressed, click "Continue" in the top right corner. Review your data once more, then click submit.

  9. You will see confirmation of the submission's success.

  10. After the upload is completed, an import draft will show on Org settings > import. Follow the steps in the linked page to continue the import.

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.

  • Once columns have been linked, and any red rows have been addressed, select "Continue" in the bottom right corner to confirm your upload.

Did this answer your question?
😞
😐
😁