Attachment 10 - e-Timesheet - template.xlsx

XLSX spreadsheet 121 KB Posted

Attached to
ICE Medical Staffing Federal contract opportunity
Solicitation number
70CDCR21R00000008
Issued by
Immigration and Customs Enforcement

About this file

This document includes a template timesheet and guidance for its use under an ICE medical staffing contract. The template provides a standardized format for contractors to record employees' daily work hours over 12-month periods at various ICE and IHSC clinic sites. Contractors must submit timesheets to verify hours worked by the 15th and end of each month for invoice and hours dashboard reconciliation. The template calculates regular and overtime hours, with overtime defined as over 40 hours per normal work week or 80 hours bi-weekly. Approval is needed in advance for any overtime hours. The guidance clarifies the timesheet is solely to calculate hours for the government and not related to contractors' own timekeeping systems or pay. It also defines standard parameters like work week and overtime thresholds.

View the file

Other files for this federal contract opportunity

Other files attached to ICE Medical Staffing, newest first.
File Type Posted
70CDCR21R00000008_A0002.pdf PDF
A0002_Section B-M_Clean.pdf PDF
A0002_Section B-M_Redline.docx DOCX document
A0001_Attachment 02 - QASP_Clean.pdf PDF
A0001_Attachment 02 - QASP_Redline.docx DOCX document
70CDCR21R00000008_A0001.pdf PDF
A0001_Phase I - Questions.xlsx XLSX spreadsheet
A0001_Section B-M_Clean.pdf PDF
A0001_Section B-M_Redline.docx DOCX document
A0001_RFP ONLY - Attachment 04 - Corporate Experience Questionaire_Clean.pdf PDF
Attachment 13 - IHSC CP and PA Agreement - template.pdf PDF
A0001_Attachment 01 - Performance Work Statement_Clean.pdf PDF
A0001_Attachment 01 - Performance Work Statement_Redline.docx DOCX document
A0001_RFP ONLY - Attachment 04 - Corporate Experience Questionaire_Redline.docx DOCX document
70CDCR21R00000008.pdf PDF
Attachment 14 - Contractor Employee Separation Clearance Checklist - template.pdf PDF
RFP ONLY - Attachment 01 - Site Staffing Plan - IDIQ.xlsx XLSX spreadsheet
RFP ONLY - Attachment 03 - Shift Requirement Document - SAMPLE.xlsx XLSX spreadsheet
RFP ONLY - Attachment 04 - Corporate Experience Questionaire.docx DOCX document
Attachment 01 - Performance Work Statement.pdf PDF
Attachment 02 - QASP.pdf PDF
Attachment 03 - Pricing Schedule.xlsx XLSX spreadsheet
Attachment 04 - Position Descriptions.pdf PDF
Attachment 05 - IHSC Locations - IDIQ.xlsx XLSX spreadsheet
Attachment 07 - Schedule Submission Calendar.xlsx XLSX spreadsheet
Attachment 08 - Competency Assessment by Position Description.xlsx XLSX spreadsheet
Attachment 11 - Sites Status Report.xlsx XLSX spreadsheet
Attachment 06 - IHSC Credentialing and Privileging Directive.pdf PDF
Attachment 09 - DOL Wage Determinations.xlsx XLSX spreadsheet
Attachment 12 - Facility Orientation Checklist - template.docx DOCX document
RFP ONLY - Attachment 02 - HSA-Clinical Lead-NM-CSM Function Guide.pdf PDF
RFP ONLY - Attachment 05 - Past Performance Questionnaire.docx DOCX document
RFP ONLY - Attachment 06 - Non-Disclosure Agreement.pdf PDF
Attachment 15 - Contract Discrepancy Report - template.pdf PDF
Show all 34

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

January IHSC Contract Employee Time Sheet SITE:

Month:1/1/211/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon12/270.00
Tue12/280.00
Wed12/290.00
Thu12/300.00
Fri12/310.00
Sat1/10.00
Sun1/20.000.00
Mon1/30.00
Tue1/40.00
Wed1/50.00
Thu1/60.00
Fri1/70.00
Sat1/80.00
Sun1/90.000.00
Mon1/100.00
Tue1/110.00
Wed1/120.00
Thu1/130.00
Fri1/140.00
Sat1/150.00
Sun1/160.000.00
Mon1/170.00
Tue1/180.00
Wed1/190.00
Thu1/200.00
Fri1/210.00
Sat1/220.00
Sun1/230.000.00
Mon1/240.00
Tue1/250.00
Wed1/260.00
Thu1/270.00
Fri1/280.00
Sat1/290.00
Sun1/300.000.00
Mon1/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 01/14/2021

February IHSC Contract Employee Time Sheet SITE:

Month:2/1/212/28/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon1/310.00
Tue2/10.00
Wed2/20.00
Thu2/30.00
Fri2/40.00
Sat2/50.00
Sun2/60.000.00
Mon2/70.00
Tue2/80.00
Wed2/90.00
Thu2/100.00
Fri2/110.00
Sat2/120.00
Sun2/130.000.00
Mon2/140.00
Tue2/150.00
Wed2/160.00
Thu2/170.00
Fri2/180.00
Sat2/190.00
Sun2/200.000.00
Mon2/210.00
Tue2/220.00
Wed2/230.00
Thu2/240.00
Fri2/250.00
Sat2/260.00
Sun2/270.000.00
Mon2/280.00
ERROR:#VALUE!
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

March IHSC Contract Employee Time Sheet SITE:

Month:3/1/213/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon2/280.00
Tue3/10.00
Wed3/20.00
Thu3/30.00
Fri3/40.00
Sat3/50.00
Sun3/60.000.00
Mon3/70.00
Tue3/80.00
Wed3/90.00
Thu3/100.00
Fri3/110.00
Sat3/120.00
Sun3/130.000.00
Mon3/140.00
Tue3/150.00
Wed3/160.00
Thu3/170.00
Fri3/180.00
Sat3/190.00
Sun3/200.000.00
Mon3/210.00
Tue3/220.00
Wed3/230.00
Thu3/240.00
Fri3/250.00
Sat3/260.00
Sun3/270.000.00
Mon3/280.00
Tue3/290.00
Wed3/300.00
Thu3/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

April IHSC Contract Employee Time Sheet SITE:

Month:4/1/214/30/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon3/280.00
Tue3/290.00
Wed3/300.00
Thu3/310.00
Fri4/10.00
Sat4/20.00
Sun4/30.000.00
Mon4/40.00
Tue4/50.00
Wed4/60.00
Thu4/70.00
Fri4/80.00
Sat4/90.00
Sun4/100.000.00
Mon4/110.00
Tue4/120.00
Wed4/130.00
Thu4/140.00
Fri4/150.00
Sat4/160.00
Sun4/170.000.00
Mon4/180.00
Tue4/190.00
Wed4/200.00
Thu4/210.00
Fri4/220.00
Sat4/230.00
Sun4/240.000.00
Mon4/250.00
Tue4/260.00
Wed4/270.00
Thu4/280.00
Fri4/290.00
Sat4/300.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

May IHSC Contract Employee Time Sheet SITE:

Month:5/1/215/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon4/250.00
Tue4/260.00
Wed4/270.00
Thu4/280.00
Fri4/290.00
Sat4/300.00
Sun5/10.000.00
Mon5/20.00
Tue5/30.00
Wed5/40.00
Thu5/50.00
Fri5/60.00
Sat5/70.00
Sun5/80.000.00
Mon5/90.00
Tue5/100.00
Wed5/110.00
Thu5/120.00
Fri5/130.00
Sat5/140.00
Sun5/150.000.00
Mon5/160.00
Tue5/170.00
Wed5/180.00
Thu5/190.00
Fri5/200.00
Sat5/210.00
Sun5/220.000.00
Mon5/230.00
Tue5/240.00
Wed5/250.00
Thu5/260.00
Fri5/270.00
Sat5/280.00
Sun5/290.000.00
Mon5/300.00
Tue5/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

June IHSC Contract Employee Time Sheet SITE:

Month:6/1/216/28/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon5/300.00
Tue5/310.00
Wed6/10.00
Thu6/20.00
Fri6/30.00
Sat6/40.00
Sun6/50.000.00
Mon6/60.00
Tue6/70.00
Wed6/80.00
Thu6/90.00
Fri6/100.00
Sat6/110.00
Sun6/120.000.00
Mon6/130.00
Tue6/140.00
Wed6/150.00
Thu6/160.00
Fri6/170.00
Sat6/180.00
Sun6/190.000.00
Mon6/200.00
Tue6/210.00
Wed6/220.00
Thu6/230.00
Fri6/240.00
Sat6/250.00
Sun6/260.000.00
Mon6/270.00
Tue6/280.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

July IHSC Contract Employee Time Sheet SITE:

Month:6/29/217/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon6/270.00
Tue6/280.00
Wed6/290.00
Thu6/300.00
Fri7/10.00
Sat7/20.00
Sun7/30.000.00
Mon7/40.00
Tue7/50.00
Wed7/60.00
Thu7/70.00
Fri7/80.00
Sat7/90.00
Sun7/100.000.00
Mon7/110.00
Tue7/120.00
Wed7/130.00
Thu7/140.00
Fri7/150.00
Sat7/160.00
Sun7/170.000.00
Mon7/180.00
Tue7/190.00
Wed7/200.00
Thu7/210.00
Fri7/220.00
Sat7/230.00
Sun7/240.000.00
Mon7/250.00
Tue7/260.00
Wed7/270.00
Thu7/280.00
Fri7/290.00
Sat7/300.00
Sun7/310.000.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

August IHSC Contract Employee Time Sheet SITE:

Month:8/1/218/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon8/10.00
Tue8/20.00
Wed8/30.00
Thu8/40.00
Fri8/50.00
Sat8/60.00
Sun8/70.000.00
Mon8/80.00
Tue8/90.00
Wed8/100.00
Thu8/110.00
Fri8/120.00
Sat8/130.00
Sun8/140.000.00
Mon8/150.00
Tue8/160.00
Wed8/170.00
Thu8/180.00
Fri8/190.00
Sat8/200.00
Sun8/210.000.00
Mon8/220.00
Tue8/230.00
Wed8/240.00
Thu8/250.00
Fri8/260.00
Sat8/270.00
Sun8/280.000.00
Mon8/290.00
Tue8/300.00
Wed8/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

September IHSC Contract Employee Time Sheet SITE:

Month:9/1/219/30/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon8/290.00
Tue8/300.00
Wed8/310.00
Thu9/10.00
Fri9/20.00
Sat9/30.00
Sun9/40.000.00
Mon9/50.00
Tue9/60.00
Wed9/70.00
Thu9/80.00
Fri9/90.00
Sat9/100.00
Sun9/110.000.00
Mon9/120.00
Tue9/130.00
Wed9/140.00
Thu9/150.00
Fri9/160.00
Sat9/170.00
Sun9/180.000.00
Mon9/190.00
Tue9/200.00
Wed9/210.00
Thu9/220.00
Fri9/230.00
Sat9/240.00
Sun9/250.000.00
Mon9/260.00
Tue9/270.00
Wed9/280.00
Thu9/290.00
Fri9/300.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

October IHSC Contract Employee Time Sheet SITE:

Month:10/1/2110/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon9/260.00
Tue9/270.00
Wed9/280.00
Thu9/290.00
Fri9/300.00
Sat10/10.00
Sun10/20.000.00
Mon10/30.00
Tue10/40.00
Wed10/50.00
Thu10/60.00
Fri10/70.00
Sat10/80.00
Sun10/90.000.00
Mon10/100.00
Tue10/110.00
Wed10/120.00
Thu10/130.00
Fri10/140.00
Sat10/150.00
Sun10/160.000.00
Mon10/170.00
Tue10/180.00
Wed10/190.00
Thu10/200.00
Fri10/210.00
Sat10/220.00
Sun10/230.000.00
Mon10/240.00
Tue10/250.00
Wed10/260.00
Thu10/270.00
Fri10/280.00
Sat10/290.00
Sun10/300.000.00
Mon10/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

November IHSC Contract Employee Time Sheet SITE:

Month:11/1/2111/30/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon10/310.00
Tue11/10.00
Wed11/20.00
Thu11/30.00
Fri11/40.00
Sat11/50.00
Sun11/60.000.00
Mon11/70.00
Tue11/80.00
Wed11/90.00
Thu11/100.00
Fri11/110.00
Sat11/120.00
Sun11/130.000.00
Mon11/140.00
Tue11/150.00
Wed11/160.00
Thu11/170.00
Fri11/180.00
Sat11/190.00
Sun11/200.000.00
Mon11/210.00
Tue11/220.00
Wed11/230.00
Thu11/240.00
Fri11/250.00
Sat11/260.00
Sun11/270.000.00
Mon11/280.00
Tue11/290.00
Wed11/300.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

December IHSC Contract Employee Time Sheet SITE:

Month:12/1/2112/31/21
StartingEndingMONTHLY HOURSTotal OnsiteRegular OnsiteOT Bill to GVT*
0.000.000.00
Employee Name
*If overtime is being claimed, justification must be included under the Comments section.
Employees: complete in/out times
DayDateTime
InTime
OutTime
InTime
OutWeekly Hrs:
<40Total Hrs:
DailyWeekly Hrs:
>40OT Bill to GVT*
Mon11/280.00
Tue11/290.00
Wed11/300.00
Thu12/10.00
Fri12/20.00
Sat12/30.00
Sun12/40.000.00
Mon12/50.00
Tue12/60.00
Wed12/70.00
Thu12/80.00
Fri12/90.00
Sat12/100.00
Sun12/110.000.00
Mon12/120.00
Tue12/130.00
Wed12/140.00
Thu12/150.00
Fri12/160.00
Sat12/170.00
Sun12/180.000.00
Mon12/190.00
Tue12/200.00
Wed12/210.00
Thu12/220.00
Fri12/230.00
Sat12/240.00
Sun12/250.000.00
Mon12/260.00
Tue12/270.00
Wed12/280.00
Thu12/290.00
Fri12/300.00
Sat12/310.00
Employee Signature/DateTechnical Monitor/Date
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:
Date:Comment:

Version: 10/23/2020

Guidance e-Timesheet Guidance

Situation The purpose of this document is to answer questions regarding the use of and the embedded calculations within the e-timesheet. This document is issued to provide clarification and guidance as to the role, function and utilization of the e-timesheet.

Background The e-timesheet was created to support the administrators in the field when calculating the hours worked for contract staff each month. The contract requires hours worked to be verified by the government so that invoices may be paid accurately and timely.

Assessment Assessment The role of the e-timesheet is to meet the government’s need to accurately calculate the number of regular hours worked and OT hours worked, both billable to and not billable to the government as well as other categories of hours worked.

Operating Parameters of the e-Timesheet
1.This document is completely separate and apart from any vendor’s timekeeping system. It is designed solely for the needs of government personnel calculating the hours worked for the Hours Worked Dashboard each month.
2.The Hours Worked Dashboard must align with the monthly invoice as submitted by the vendor.
3.The e-timesheet is not meant to calculate pay in any manner.
4.The e-timesheet is not to be used to compare or contrast to other timekeeping systems used by a vendor.
5.A work week is defined as a seven day period from Sunday through the following Saturday, regardless of how any given work week may be bisected by a month. Total hours for the work week will always be calculated on Saturday.
6.Overtime is defined as any work hours over 40 hours worked in any work week regardless of how any given work week may be bisected by a month.
*Exception: Individual work schedules may incur over 40 hours in one work week if no more than 80 hours are incurred over a two-week work period.
7.Monthly approved overtime hours will be shown on row 5.
Notes (Workflow Process):
Staff should receive approval from scheduling administrator/supervisor prior to incuring any/all OT.
Staff should complete e-timesheet as hours worked are incurred.
Scheduling administrator should review/verify all vacancy OT no later than close of payroll each week.
On the 15th and at the end of the month:
Employee will print and submit this e-timesheet.
Scheduling administrator will review the e-timesheet for accuracy.
Upon completion (end of the month):
Scheduling administrator will perform a final review.
GTM will review/approve the e-timesheet and then electronically sign the document.
A copy of the e-timesheet should be saved.

Lists

IHSC Sites
Alexandria
Berks
Buffalo
Caroline
Dilley
El Paso
Elizabeth
Eloy
26 Federal
Florence
Folkston
Houston
Jena
Krome
Montgomery
Pearsall
Port Isabel
Tacoma
Taylor
Varick
York
IHSC HQ

File details come from the government source that posted it. Updated .