Skip to main content

Find a missing timesheet

Locate a missing timesheet that has not been sent to a manager.

H
Written by Harry Ledger
Updated over 2 months ago

A timesheet should be visible in one of three places.

  1. In the employee's timesheet listing (prior to submission to a manager).

  2. In the manager's listing for approval (after being submitted).

  3. With HR to review before final submission to payroll.

In each of these three states, the timesheet will have different flags set on the record.
Once submitted to Payroll, this applies a fourth and final change to the timesheet record.
​
You can check the flag against each timesheet by following these steps.

  1. In the Admin Tool, you can create a data export.

  2. Copy the following code, ensuring the employee name is entered.

    Select Time.Timesheets.[Timesheet Number], Time.Timesheets.Submitted, Time.Timesheets.Authorised, Time.Timesheets.Workflow, Person.Details.[First Name], Person.Details.Surname From Person.Details Inner Join Time.Timesheets On Person.Details.[Person Number] = Time.Timesheets.[Person Number] Where Person.Details.[First Name] = 'Employee Firstname' And Person.Details.Surname = 'Employee Surname'
  3. Click the Data tab to review the employee's timesheet records. Be mindful of the week beginning to ensure you are reviewing the correct timesheet.

  4. Note the Submitted value, the Authorised value, and the Workflow value.

  5. Compare with the chart below to confirm where this should be visible.

Submitted

Authorise

Workflow

Visible in:

False or 0

False or 0

0

Employee created but not yet submitted.

True or 1

False or 0

0

Submitted to manager.

True or 1

True or 1

0

Approved by manager, with HR for submission to Payroll.

True or 1

True or 1

1

Approved by HR and submitted to Payroll.

Did this answer your question?