Knowledgebase

Home > Knowledgebase > Cim200 > Works Orders > Processing > Operational Costs > Timesheets > Maintain Timesheet Details

Maintain Timesheet Details

When recording Works Order timesheets, use the Maintain Timesheet Details screen to record timesheet details for each employee.

The times entered are recorded against the specific employee who performed the work.

To access Timesheet Details

Before entering Timesheets, ensure the required Employee records have been setup using the Enter New Timesheet Employee screen.

Timesheets cannot be entered for Employees set as Locked.

 

Open: Works Orders > Works Order List.

  • Select the Timesheets button above the list view.

From the menu:

Open: Cim200 Works Orders > Processing > Operational Costs > Timesheets

Enter New Timesheet Details

1. To add a new Timesheet, click the Add New button. This opens the Timesheet Entry screen.

2. The Start Date defaults to the current date, but can be changed to a different date. This date will be used as a default date for each timesheet line.

3. Optionally enter a Reference for the Timesheet, for example the week number that it relates to. If you are saving multiple Timesheets before posting, or when looking back at historic Timesheets, the Reference is useful in distinguishing between them.

4. The Total Labour Time displays the total number of labour hours recorded on the timesheet.

5. Normal Working Hours is the number of hours in the employee’s working day, taken from the Employee record.

  • If the Timesheets Total Labour Hours Checking option in Works Order Settings is ticked, the Timesheet can only be posted if the total Labour hours of the timesheet lines, subtotalled for each date, is equal to or greater than the employee’s Normal Working Hours.

6. Record the Works Order reference and operation, times, costs and completed quantities for each operation in Timesheet area.

 

Chargeable : Tick this if the cost of the work should be charged to a Works Order.

  • If ticked, the Works Order Reference and Operation Reference must also be entered.
  • If this is not ticked, only the time is required.
  • Entering non-chargeable time allows for recording an employee’s non-productive time, such as cleaning up. This is a useful tool when using the Timesheets Total Labour Hours Checking option, to ensure that all of an employee’s daily hours are accounted for, even when it cannot all be charged to a specific Works Order.

Works Order : The Works Order reference. Locked, Cancelled and Closed orders are not available.

Operation Reference : The Operation reference. If the operation is not already on the order, use the Add New From Operations Register button to add it from the list of operations on the Operations Register. Alternatively, use the Add New Operation button to add a completely new operation. Adding an operation here will add the operation to the order but not to the Bill of Materials.

Operation Description : The Operation description is displayed.

Date : The date the work was done. The date defaults from the Start Date on the Timesheet header but can be overridden. This is the date that will get used for Nominal Ledger postings to Work In Progress, if Nominal Ledger Integration is enabled.

Start : The time the work started, in 24-hour clock format. Operation times can be entered using Start and End times, to calculate the duration of Labour time, or the duration can be entered directly into the Labour column.

End : The time the work ended, in 24-hour clock format.

Completed Qty : Enter the quantity of items that were completed during the work. The quantity entered here will reduce the outstanding quantity of the operation on the Works Order, giving visibility of how the order is progressing.

Setup : The duration of setup in hours, minutes and seconds.

Labour : The duration of labour time in hours, minutes and seconds. The duration is completed automatically if the Start and End times are used.

 

Time Formats

There is a specific format for recording a time down in terms of hours, minutes and seconds. You can enter a time according to the following methods:

  • Entering 5 gives 5h 0m 0s (5 hours zero minutes zero seconds).
  • Entering 5 30 gives 5h 30m 0s (5 hours 30 minutes zero seconds).
  • Entering 5 30 20 gives 5h 30m 20s (5 hours 30 minutes 20 seconds).
  • Entering 0 30 gives 0h 30m 0s (zero hours 30 minutes zero seconds).
  • Entering 0 0 45 gives 0h 0m 45m (0 hours 0 minutes 45 seconds).

Alternatively use “h”, “m” and “s” to define each time:

  • Entering 5h30m20s gives 5h 30m 20s (5 hours 30 minutes 20 seconds).
  • Entering 30m gives 0h 30m 0s (zero hours 5 minutes zero seconds).
  • Entering 20s gives 0h 0m 20s (zero hours zero minutes 20 seconds).

Entering over 59 minutes or seconds recalculates the time :

  • Entering 0 70 or 70m gives 1h 10m 0s (1hour 10 minutes zero seconds).
  • Entering 0 0 85 or 85s gives 0h 1m 25s (zero hours 1 minute 25 seconds).

 

Machine : The duration of machine time in hours, minutes and seconds.  The duration is completed automatically if Default Machine Time to Labour Time on Timesheet Bookings is enabled in Cim200 Works Order Settings.

Tooling : The duration of Tooling time in hours, minutes and seconds.

Teardown : The duration of Teardown time in hours, minutes and seconds.

Costs : This only shows when Use Employee Rates on Timesheets is not ticked in Works Order Settings. The total cost of the work being recorded, based on the time(s) recorded for labour, machine and setup, and the defaults cost rates for each.

View and Amend costs

1. As times are entered, the calculated cost is displayed in the Costs column.

2. To view a breakdown of the calculated cost, or to amend any cost rates, click in the Costs box and click on the drop-down to open the Operation Cost Entry screen.

3. The costs so far recorded against the operation are displayed, broken down over the different cost headings.

Note: If the operation is already setup on the Works Order, the cost rate will default from the Works Order operation resource details. If the operation has been manually added to the screen, the cost rate will be defaulted from the operation setup on the Operations Register.

4. To amend any rates, type the rate into the Rate column on each cost type for which time is being recorded. The Cost total will be updated to reflect the new rate.

5. Enter any notes required on this window for information purposes only.

6. To save the details, click OK.

7. Tab or click underneath the bottom timesheet line to add further timesheet lines.

8. To remove a single line, select the line and click Delete.

9. To remove all lines on the timesheet, click Clear.

10. To save the information, click Save.

11. The timesheet has now been saved but not yet posted. It can be posted from the Maintain Timesheets screen.

Edit unposted Timesheet Details

1. To amend an existing Timesheet, highlight the Timesheet line and click the Edit button. This opens the Maintain Timesheet Details screen.

2. Change any details previously entered.

3. To remove a timesheet line, select the line and click Delete.

4. To remove all lines on the timesheet, click Clear.

5. To save changes and exit, click Save. The timesheet has now been saved but not yet posted. It can be posted from the Maintain Timesheets screen.

6. To exit without saving, click Close to close the Timesheet maintenance screen.

Our Software: