Timesheet (WMS Configuration)

Timesheet shows time worked records for warehouse employees. This view allows you to see user clock-ins and clock-outs, calculate total hours worked per day, and manage time records.

This functionality is essential to maintain accurate control of hours worked by warehouse employees and generate time worked reports.

What is Timesheet?

Timesheet is a consolidated view of time records (punchcard) that shows hours worked by warehouse employees. Records are grouped by user and date, showing total hours worked per day.

Each record represents a clock-in (in) or clock-out (out) in the system, and the system automatically calculates total hours worked based on clock-in and clock-out pairs.

Why use Timesheet?

Time worked control

Keep accurate records of hours worked by each warehouse employee for payroll and resource management.

Attendance visibility

See who is working and when, facilitating shift management and task assignment.

Automatic calculation

The system automatically calculates total hours worked per day based on clock-in and clock-out records.

Reports and export

Export data to CSV and generate time worked summaries for analysis and payroll.

Record management

Add, edit, or delete time records when necessary to correct errors or adjust hours.

Filtering and search

Search records by user, day, date, or time to quickly find the information you need.

How to access Timesheet

Log in to ShipEdge Core as a user with WMS permissions (level 2) or Admin (level 3).
Navigate to Warehouse menu in the main navigation bar.
Select “System Config” from the Warehouse menu.
Click “Timesheet” from the System Config submenu.

Table columns

The table shows the following columns:

Column	Description
No.	Row number in the list
User Name	User full name (FirstName LastName)
Day	Day of the week (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
Date	Record date (format: YYYY-MM-DD)
hour	Total hours worked in the day (in decimal format, maximum 10 hours per day). Click the number to see clock-in and clock-out details.

Main features

View hours worked details

View details by day:

Click the hours number in the hour column to open a popup window with details
The window shows all clock-in (in) and clock-out (out) records for that user and date
Shows total hours worked in the day
Allows editing or deleting individual records (Admin only)

Information in details window:

ID: Unique record identifier
User Name: User name
Date: Record date
Type: Record type (in for clock-in, out for clock-out)
hour: Specific time of the record (format HH:MM:SS)
TOTAL HRS: Total hours worked in the day

Search and filtering

Advanced search:

User Name: Filter by specific user (only visible for Admin level 3)
Day: Filter by day of the week (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
Date: Filter by date range using calendar selector
hour: Search by specific time

Basic search:

Search all fields using keywords
Search options:
- Exact phrase: Search exact phrase
- All words: Search records containing all words
- Any word: Search records containing any of the words

Sorting:

Click any column header to sort by that field
Arrow icons indicate sort direction (ascending or descending)
By default, records are sorted by date descending (most recent first)

Add time records

Only available for Admin (level 3):

Click “Inline Add” at the top of the table
Complete required fields:
- User Name: Select the user (required)
- Day: Select day of the week (required)
- Date: Select date using calendar (required, format: YYYY/MM/DD)
- hour: Enter time in HH:MM:SS format (required, defaults to current time)
Click “Insert” to save or “Cancel” to cancel

Export data

Export to CSV:

Click “Export to CSV” at the top of the page
A CSV file will download with all visible records according to applied filters
File includes columns: No, User Name, Day, Date, hour

Last 7 days summary:

Click “Last 7 days Summary” to generate a CSV summary of the last 7 days
Summary shows total hours worked per user in the period
Useful for weekly reports and payroll

Totals

Total hours:

Table shows a total in the footer with sum of all visible hours
Total updates automatically according to applied filters
Shown in decimal format (for example, 8.5 hours)

Daily hours limit:

System limits hours calculation to a maximum of 10 hours per day
If an employee works more than 10 hours, system will show 10 hours maximum

Pagination

Records per page: Select how many records to show (10, 20, 50, 100, 200, 500, or All Records)
Navigation: Use First, Previous, Next, and Last buttons to navigate between pages
Information: Table shows current record range (for example, “Records 1 to 20 of 50”)

Record management in details window

When you click on hours worked, a popup window opens with day details:

View records:

Lists all clock-in and clock-out records for that user and date
Shows chronological order of records

Add record (Admin level 3 or 4 only):

Click “Add” to add a new record
System automatically alternates between in and out based on last record
Time is automatically set to current time

Edit record (Admin level 3 or 4 only):

Click “Edit” next to the record you want to edit
Modify record time
Click “Update” to save changes

Delete record (Admin level 3 or 4 only):

Click “Delete” next to the last record in the list
You can only delete the last record (most recent)
Confirm deletion to complete the action

Hours worked calculation

The system calculates hours worked as follows:

Clock-in and clock-out pairs: System searches for consecutive in and out record pairs
Difference calculation: Calculates time difference between each clock-in and clock-out pair
Total sum: Sums all differences to get total hours worked in the day
Decimal conversion: Converts total time to decimal format (hours with decimals)
Maximum limit: Applies maximum limit of 10 hours per day

Example:

Clock-in: 08:00:00
Clock-out: 12:00:00
Clock-in: 13:00:00
Clock-out: 17:00:00
Total: 8 hours (4 hours + 4 hours)

Best practices

Record clock-in and clock-out correctly

Make sure to record both clock-in and clock-out so the system calculates hours worked correctly.

Review totals regularly

Review hours worked totals regularly to detect discrepancies or errors in records.

Export data for payroll

Export data to CSV regularly to facilitate payroll processing and reports.

Correct errors quickly

If you find an error in a record, correct it as soon as possible to maintain data accuracy.

Use filters for analysis

Use search filters to analyze time worked patterns by user or period.

Verify details before editing

Review hours worked details before editing or deleting records to avoid errors.

Troubleshooting

I can’t see the “Timesheet” option in the menu:

Verify you have WMS permissions (level 2) or Admin (level 3)
Confirm you’re logged in with an account that has appropriate permissions

I can’t see all records:

Level 2 users can only view their own time records
Only level 3 users (Admin) can view all records

I can’t add records:

Only level 3 users (Admin) can add records
Verify you have add permissions in the punchcard table

Total hours are not correct:

Verify there are clock-in and clock-out pairs for each worked period
Make sure there are no missing clock-in or clock-out records
Review details by clicking on hours to see all records for the day

I can’t edit or delete records:

Only level 3 or 4 users (Admin) can edit or delete records
You can only delete the last record (most recent) in the list
Verify you have edit permissions in the punchcard table

Calculation shows 10 hours maximum:

System limits calculation to a maximum of 10 hours per day
If an employee works more than 10 hours, system will show 10 hours maximum
This is a system limitation to prevent calculation errors

I can’t export to CSV:

Verify you have export permissions
Make sure there are visible records according to applied filters
Review your browser settings to allow downloads

Next step: Preferences - Configure warehouse preferences

Related:

Change Password - Change your access password
Server Status - Server status