The Timesheet menu includes the ability to manually create new timesheets as well as view, edit, or recall existing timesheets. If your user account has been granted additional roles (other than the Standard User role), you may have additional options under the Timesheet menu.


My Timesheets

Role: Users with User role

note

The user’s position must have the ‘Timesheet Required' selected in USPS>Positions for one or more positions a user needs to create a timesheet for in ESS. Also in order for the employee’s timesheet to process through the approval workflow, their position record(s) must have a supervisor defined.

The user’s position must have the ‘Timesheet Required' selected in USPS>Positions for one or more positions a user needs to create a timesheet for in ESS. Also in order for the employee’s timesheet to process through the approval workflow, their position record(s) must have a supervisor defined.

note

If positions were entered in the Automatic Period Generator, once the period is automatically generated, it will also automatically create a timesheet for the specified positions. The employee can then view, edit (if needed), and submit their automatically created timesheet for approval.

If positions were entered in the Automatic Period Generator, once the period is automatically generated, it will also automatically create a timesheet for the specified positions. The employee can then view, edit (if needed), and submit their automatically created timesheet for approval.

Create a Timesheet

The steps provided below are for employees who need to create a timesheet manually:

NOTE: A period and shift must be created for the employee’s position(s) prior to the employee creating their timesheet.

  1. Under My Timesheets, click ‘Create’

  2. Select the timesheet period and position you are creating your timesheet for and click ‘Create Timesheet’. NOTE: If a timesheet already exists for the employee, an alert notification will display on the screen and the employee will be redirected to their existing timesheet.

image-20240827-170533.png
  1. The timesheet will be pre-filled with the information from the corresponding period and shift set up.

    1. Click on a line item in order to edit the pre-filled information. You may overwrite any columns shaded gray. Once the timesheet has been exported, the exported column will display a checkmark.

      1. Please refer to Flexible Shift for more information on shifts enabled with the ‘flexible shift’ option.

image-20241120-155353.png

b. By default, timesheets will not include weekend days. Select ‘+' to add additional line items to your timesheet (i.e. weekend work). To remove any items, check the box to the left of the item(s) and select '-'.

image-20241120-151035.png
  1. If the employee has an approved leave request inclusive of the timesheet period, the leave request line item is added to the employee's timesheet automatically after clicking Create.

    1. Leave request items are not editable in the timesheet. After creating your timesheet, it will automatically adjust the times on the REG line item (or removes entirely if the entire time is taken up by the leave request line item) to accommodate the leave request items. Depending on what leave types are configured for the district, the leave request items may include Calamity, Comp Time, Dock, Holiday, Jury Duty, Military, Other, Personal, Professional, Sick, Unknown, Vacation

    2. If there is an exported Leave Request within the timesheet period; it will be displayed on the timesheet and will not be editable.

  2. Click 'Create’ to add your timesheet to your timesheet grid. Your timesheet is currently at a status of Initiated. The employee can review the timesheet after creation to confirm leave request(s) inclusive of the timesheet period are included.

The creation of the timesheet does not submit the timesheet to the workflow process. You must submit the timesheet for approval. See below.

Submit a Timesheet for Approval

You may submit your timesheet for approval one of two ways:

  1. On your timesheet grid, click image-20241120-152540.png icon to submit your timesheet for approval. A pop-up notification will be displayed indicating the timesheet has been submitted.

image-20241120-152621.png
  1. Or click image-20240827-172408.png to view your newly created timesheet. Click ‘Submit for Approval’ to submit your timesheet to the approval workflow. Again, a pop-up notification will be displayed indicating the timesheet has been submitted.

image-20241120-152854.png

Timesheet Grid

Displays a user’s existing timesheets in a grid format.

image-20250226-163316.png

Approval Status indicates where in the approval workflow the timesheet is currently at:

Grid Options

Viewing a timesheet

image-20241120-161551.pngimage-20250301-165109.png


Supervisor Timesheet

Role: For users with Timesheet Approver, District Manager or Admin role.

To approve a timesheet, the supervisor must have the Timesheet Approve role. Supervisor can approve timesheets via the Home screen (under Pending Workflow Tasks - Timesheet Approval or the Timesheet Approval menu option.

image-20240828-205438.png

image-20240523-023424.png Allows supervisors the ability to view their staff’s timesheet information regardless of approval status.

Approval Status indicates where in the approval workflow the timesheet is currently at:


District Timesheet

Role: For users with Timesheet Manager, District Manager or Admin role

image-20250226-213439.png

Approval Status indicates where in the approval workflow the timesheet is currently at:


Timesheet Export

Role: For users with Timesheet Manager, District Manager, or Admin role

Allows users the ability to export timesheets with a status of ‘approved’ in order to post timesheet information into USPS

image-20250206-180102.png

User may filter approved timesheets by:

Once all items on a timesheet are marked exported, the status of the timesheet will change from ‘Approved’ to ‘Exported’ and the timesheet will no longer appear in the Timesheet Export grid.

Export Timesheets Options

This section is in draft mode. ESS-1274 (2025.6.0 release) will improve the timesheet export options.

Once your grid displays the desired timesheets you would like to export, click on ‘Export Timesheets.' Selecting one or more of the options (in the image below) will generate a spreadsheet (CSV format) of the timesheet data included in the filtered grid. The default filename is called timesheet-export.csv. The file can then be imported into USPS manually using the USPS Utilities> Attendance/Absence Import option. Please refer to the USPS Attendance/Absence Import specs for more information on the format of the CSV file.

image-20241015-022110.png

Post attendance

Use Case

CSV Export File

USPS Importing

  1. Go to Utilities>Attendance/Absence Import.

    1. Attendance Import File - Click Choose File and browse to find the saved CSV file.

    2. Location Code - None.

    3. Post to Payroll Processing Options - Any payment information included in the CSV file can be posted to either Payroll Payments - Current or Payroll Payments - Future. Select the appropriate option from the drop down. If None is selected, no payment entries will be created.

    4. Combine Attendance Entries - If posting payment information to Payroll Payments - Future or Payroll Payments - Current, should multiple attendance entries for the same day be combined into one entry when the payment is created?

      1. If yes, mark the checkbox. This will combine multiple attendance entries for the same day into one entry in Payroll Payments - Future or Payroll Payments - Current. Keep in mind, in order for entries to be combined in Payroll Payments - Future or Payroll Payments - Current, the Employee ID, position number, pay type, tracking unit, and unit amount must be the same on all entries.

      2. If no, unmark the checkbox. This will not combine multiple attendance entries for the same day into one entry in Payroll Payments - Future or Payroll Payments - Current - leaving multiple line entries for the same day.

    5. Allow Negative Leave Balances - Leave unchecked.

    6. Payroll Account to Charge - Defined Payroll Account for Position.

  2. Click Import. The Records Loaded, Errors, Total Records, Future Pays Loaded (if applicable), Current Pays Loaded (if applicable) will be displayed. Verify for accuracy.

  3. Any errors will be generated in the ATTERR.TXT report. Verify for accuracy.

  4. Will create Attendance records. The SSDT Attendance Journal Report can be run for verification purposes.

Only export exceptions

Use Case

CSV Export file

USPS Importing

When posting the CSV export file via USPS Attendance/Absence Import:

Mark all timesheets as exported

Use Case

CSV Export File

USPS Importing

Combining Export Options

Select ‘Post attendance’ and ‘Only export exceptions’ simultaneously

Select ‘Post attendance’ and ‘Mark all timesheets as exported’ simultaneously

Select ‘Only export exceptions’ and ‘Mark all timesheets as exported’ simultaneously

Select ‘Post Attendance’, ‘Only export exceptions’ and ‘Mark all timesheets as exported’ simultaneously


Timesheet Overview Report

This option provides the ability to generate a CSV file of summarized timesheet data. All timesheets will be automatically included in the report unless you filter by entering a specified period and/or employee(s) located in the filter area in the top half of the screen. On the bottom half of the screen, by default, it will display all existing timesheets unless filtering has been applied, in which case it will only include the timesheets inclusive of the selected filters. You can sort by period start/end dates or employee.

For example, to review all existing timesheets for the 11/1/24-11/15/24 pay period, select the pay period and click ‘Generate Overview Report’. The resulting CSV file includes all timesheet data (regardless of status) inclusive of that period.

image-20241114-155138.png

More Information on Timesheets

The timesheet-export.csv file is formatted to be imported via USPS Attendance/Absence Import. Please refer to the import specs for further details. NOTE: Column Q on the CSV file is mapped to the following Pay Types in USPS: REG = REG; OV = OT; EXC = MIS