custom reports: timesheet reports (Excel) (condensed)

Modified on Tue, 20 Aug at 9:56 AM


Custom Reports: Timesheet Reports (Excel) (Condensed)

  1. On the left, in your Mission Control, click Timesheets.

  2. On the right, select either View program-wide data or View site data.

  3. On the next page, select the Timesheet Template at issue.

  4. At the bottom of the page, select Build Custom Reports.

  5. On the next page, choose which type of report you would like to build.

  6. If you have chosen View site data, you will have the option to select the site or sites you are assigned to.
    For Program-wide date, please go to the next step.

  7. On the next page, Select Data to Export. You can choose as many data points as you’d like.

  8. Then, use the Select Site Breakout Options, to tell the system what site data (if any) you would like on your report.

  9. Next, Select One or More Reporters by choosing either:
    1. Include all relevant reporters.

    2. Select specific reporters.

  10. Next, decide if you will Add Reporter Profile Data to the Report, by choosing either:
    1. Do not add profile data.
      .
    2. Add profile data.

  11. Use the Select a Time Period section to select the time period that the report should include.

    For the Totals, Timesheet Period and Daily reports, each date range in the drop-down menu (e.g., May 9, 2019 – May 15, 2019) represents a single timesheet period.

    For the Monthly Report you will only see each month listed.

  12. Choose your report format by clicking View Data or Export Excel.
    Note: View Data will only be available for the Totals Report.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article