Organization Settings - Timesheet

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

You can manage a member's time entry settings, enable or disable the Timesheets feature, and import time entries directly from this view.

Enable/ Disable Timesheets

Mosaic's Timesheets can be turned off for using your ERP or a third-party Timesheet tool will disable Timesheets. Time-tracking tools can still be used.

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, link each column on the left from the spreadsheet (Your Columns) to its corresponding value on the right (Our Field).

  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.

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.

Did this answer your question?
😞
😐
😁