Attachment H - Report Template.xls
XLS spreadsheet 75 KB Posted
- Attached to
- Non-IT Temporary Help Services
- Contract number
- 505ENT-M24-TEMPHELPSV-00
- Issued by
- Wisconsin
About this file
This document is a contractor reporting template and instructions for the State of Wisconsin's Non-IT Temporary Help Services Contract 505ENT-M24-TEMPHELPSV-00, administered by the Wisconsin Department of Administration. The contract applies to all Wisconsin state agencies, University of Wisconsin campuses, and municipalities including counties, cities, villages, towns, school districts, technical college districts, and other public bodies with contracting authority. Contract management is overseen by Kristina Harris, with reports submitted to the Department of Administration's contract usage reporting email system.
The contract covers temporary staffing services for non-IT positions across eight Wisconsin regions (Madison, Waukesha, Green Bay, Wisconsin Rapids, La Crosse, Eau Claire, Rhinelander, and Superior). Covered job classifications include administrative positions (Administrative Assistant I/II, Executive Staff Assistant/Secretary), clerical roles (Clerk I/II, Fiscal Clerk I/II, Receptionist I/II), facilities positions (Custodian I/II, Maintenance Mechanic I/II, Facilities Repair Worker I-III), and specialized roles (Security Officer, Cook I/II, Financial Specialist-Confidential). Contractors must submit detailed quarterly reports by the 15th of each month following calendar quarters, including invoice data, employee information, hours worked (regular and overtime), hourly bill rates, regional assignments, and assignment dates. All state agency and municipal spending must be reported, with separate reporting required for each contract and invoice.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1 User Guide 3-1-24.docx | DOCX document | |
| Cost Sheet 3-26-25.xlsx | XLSX spreadsheet | |
| Attachment_B_-A1_-_Performance_and_Support_Reqs.docx | DOCX document | |
| Attachment F - Wisconsin Regions.docx | DOCX document | |
| NEW Request for Service Form 3-2024.docx | DOCX document | |
| RFB 28414-KH Non-IT Temporary Help Services Final.pdf | ||
| Attachment G - Job Title Descriptions Final.docx | DOCX document | |
| Vendor Contact List.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| State of Wisconsin |
| Contractor Report—Non-IT Temporary Help Services |
| Contract 505ENT-M24-TEMPHELPSV-00 |
| General Report Requirements: |
| →Reports must be received on or before the 15th of the month following each calendar year quarter. |
| →All reports are required monthly even if there is No Activity. Indicate "No Activity" on the spreadsheet. |
| →Send only one report in your e-mail. If there is more than one report due, send each one in a separate e-mail. Do not include any spend from any other State contract or other usage in this report. |
| →All data columns on the report must be completed accurately when spend data is reported. |
| Report Format: |
| →Use mm/dd/yyyy format for all date fields. |
| →Enter only invoices issued during the reporting period. (That is, reports due January 15th must only have October, November, and December invoice dates reported.) |
| →Enter only one invoice date and one invoice number per line. |
| →Total Amount Invoiced must equal the actual invoice amount. |
| →Add rows to the bottom of report as necessary. |
| →Do not modify the report template in any way - all columns must remain in the same order and filled in with the required information. |
| Due Dates and Reporting Period: |
| Quarterly: |
| →Due the 15th of the month following each calendar year quarter. |
| · Quarter 1, January 1-March 31: Due April 15 |
| · Quarter 2, April 1-June 30: Due July 15 |
| · Quarter 3, July 1-September 30: Due October 15 |
| · Quarter 4, October 1-December 31: Due January 15 |
| All Reports Should be Sent to: |
| doaescontractusagereporting@wisconsin.gov |
| For Questions Regarding the Contract: |
| Kristina Harris, Contract Manager |
| kristina.harris@wisconsin.gov |
| All State Agency spend including the University of Wisconsin is to be reported. Municipalities are also part of the Contract and are defined as any county, city, village, town, school district, board of school directors, sewer district, drainage district, technical college district, or any other public or quasi-public body having the authority to award public contracts (s. 16.70(8), Wis Stats.). Please include municipalities in the report. |
&LNon-IT Temporary Help Services Reporting—Instructions&CPage &P of &N&R&D kristina.harris@wisconsin.gov doaescontractusagereporting@wisconsin.gov
Column Description
| Description of Data Fields | ||||
| Non-IT Temporary Help Services | ||||
| Column | Name of Field | Description | ||
| B | Invoice date | Please enter the date of the invoice (mm/dd/yyyy). | ||
| C | Invoice number | Please enter the number of the invoice. | ||
| D | Purchase order date | Please enter the date of the purchase order (mm/dd/yyyy). | ||
| E | Purchase order number | Please enter the number of the purchase order. | ||
| F | Agency/University/Municipality name | Please enter the name of the agency, the UW campus, or municipal body making the purchase. | ||
| G | Job classification | Please enter the job classification of the contractor (from the rates spreadsheet). | ||
| H | Name of employee (first and last) | Please enter the first and last name of the contracted personnel. | ||
| I | Employee company (if subcontracted) | Please enter the employee company, if subcontracted. | ||
| J | Region | Please enter the number that represents the region in which the work was performed; that is, 1-Madison, 2-Waukesha, 3-Green Bay, 4-Wisconsin Rapids, 5-La Crosse, 6-Eau Claire, 7-Rhinelander, 8-Superior. | ||
| K | Total number of regular hours worked | Please enter the number of hours worked for the invoice being reported. | ||
| L | Regular bill rate (hourly) | Please enter the bill rate in an hourly format. | ||
| M | Total number of overtime hours worked | Please enter the number of hours worked for the invoice being reported. | ||
| N | Overtime bill rate (hourly) | Please enter the overall bill rate in an hourly format. | ||
| O | Invoiced amount | Please enter the invoiced amount. | ||
| P | Start date of assignment | Please enter the start date. | ||
| Q | End date of assignment (if applicable) | Please enter the end date, if applicable. |
&LState of Wisconsin Department of Administration &LNon-IT Temporary Help Services Reporting—Description of Data Fields&CPage &P of &N&R&D
Temp Help
| Full Contractor Name | Reporting Period | ||||||||||||||||
| Start Date | End Date | ||||||||||||||||
| This Form Filled Out By | Telephone Number | ||||||||||||||||
| Example | |||||||||||||||||
| Contrctor Name | Invoice Date | Invoice Number | Purchase Order Date | Purchase Order Number | Agency/University/Municipality Name | Job Classification | Name of Employee (first and last) | Employee Company (if subcontracted) | Region | Number of Regular Hours Worked (for report month) | Regular Hourly Bill Rate | Number of Overtime Hours Worked (for report month) | Overtime Hourly Bill Rate | Amount Invoiced (in current month) | Start Date of Assignment | End Date of Assignment (if applicable) | |
| ABC Company | 10/1/24 | 20320 | 10/1/24 | ADH500123 | Department of Administration | Administrative Assitant I | Jane Smith | N/A | 1 | 20.00 | $ 14.50 | 2.00 | $ 21.75 | $ 333.50 | 10/9/24 | 10/20/24 | |
| Contrctor Name | Invoice Date | Invoice Number | Purchase Order Date | Purchase Order Number | Agency/University/Municipality Name | Job Classification | Name of Employee (first and last) | Employee Company (if subcontracted) | Region | Number of Regular Hours Worked | Regular Hourly Bill Rate | Number of Overtime Hours Worked | Overtime Hourly Bill Rate | Amount Invoiced | Start Date of Assignment | End Date of Assignment (if applicable) | |
| Administrative Assistant I | |||||||||||||||||
| Administrative Assistant II | |||||||||||||||||
| Cashier | |||||||||||||||||
| Clerk I | |||||||||||||||||
| Clerk II | |||||||||||||||||
| Cook I | |||||||||||||||||
| Cook II | |||||||||||||||||
| Crowd Control Officer | |||||||||||||||||
| Custodian I | |||||||||||||||||
| Custodian II | |||||||||||||||||
| Executive Staff Assistant | |||||||||||||||||
| Executive Staff Secretary | |||||||||||||||||
| Facilities Repair Worker I | |||||||||||||||||
| Facilities Repair Worker II | |||||||||||||||||
| Facilities Repair Worker II | |||||||||||||||||
| Financial Specialist-Confidential | |||||||||||||||||
| Fiscal Clerk I | |||||||||||||||||
| Fiscal Clerk II | |||||||||||||||||
| Food Service Worker I | |||||||||||||||||
| Food Service Worker II | |||||||||||||||||
| Laborer | |||||||||||||||||
| Maintenance Mechanic I | |||||||||||||||||
| Maintenance Mechanic II | |||||||||||||||||
| Program Assistant I | |||||||||||||||||
| Program Assistant II | |||||||||||||||||
| Program Assistant III | |||||||||||||||||
| Program Assistant-Confidential | |||||||||||||||||
| Receptionist I | |||||||||||||||||
| Receptionist II | |||||||||||||||||
| Security Officer | |||||||||||||||||
| Stock Clerk | |||||||||||||||||
| Executive Staff Assistant | |||||||||||||||||
| Executive Staff Secretary | |||||||||||||||||
| Facilities Repair Worker I | |||||||||||||||||
| Facilities Repair Worker II | |||||||||||||||||
| Facilities Repair Worker II | |||||||||||||||||
| Financial Specialist-Confidential | |||||||||||||||||
| Fiscal Clerk I | |||||||||||||||||
| Fiscal Clerk II | |||||||||||||||||
| Food Service Worker I | |||||||||||||||||
| Food Service Worker II | |||||||||||||||||
| Laborer | |||||||||||||||||
| Maintenance Mechanic I | |||||||||||||||||
| Maintenance Mechanic II | |||||||||||||||||
| Program Assistant I | |||||||||||||||||
| Program Assistant II | |||||||||||||||||
| Program Assistant III | |||||||||||||||||
| Program Assistant-Confidential | |||||||||||||||||
| Receptionist I | |||||||||||||||||
| Receptionist II | |||||||||||||||||
| Security Officer | |||||||||||||||||
| Stock Clerk |
&LState of Wisconsin Department of Administration &LNon-IT Temporary Help Services Reporting—Spreadsheet&CPage &P of &N&R&D
Drop Down
| Administrative Assistant I |
| Administrative Assistant II |
| Cashier |
| Clerk I |
| Clerk II |
| Customer Service/Phone Intake Rep. |
| Executive Staff Assistant |
| Executive Staff Secretary |
| Financial Specialist-Confidential |
| Fiscal Clerk I |
| Fiscal Clerk II |
| Program Assistant I |
| Program Assistant II |
| Program Assistant III |
| Program Assistant-Confidential |
| Receptionist I |
| Receptionist II |
| Cook I |
| Cook II |
| Food Service Worker I |
| Food Service Worker II |
| Custodian I |
| Custodian II |
| Facilities Repair Worker I |
| Facilities Repair Worker II |
| Facilities Repair Worker III |
| Laborer |
| Maintenance Mechanic I |
| Maintenance Mechanic II |
| Stock Clerk |
File details come from the government source that posted it. Updated .