Appendix 3 - Report Template.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Statewide Accounting, Auditing, and Consulting Services - Formerly Temporary Professional Services
Contract number
505ENT-O26-ACCTCONSULT-00
Issued by
Wisconsin

About this file

This document is a reporting template and instructions for a statewide contract for Accounting, Auditing, and Consulting Services issued by the State of Wisconsin (RFB #28453-KH). The contract involves reporting requirements for contractors serving state agencies, including the University of Wisconsin system, and municipalities such as counties, cities, villages, towns, school districts, and other public or quasi-public bodies with contract-awarding authority.

The reporting template mandates quarterly spend reporting due by the 15th of the month following each calendar quarter, with comprehensive details required for each invoice. Contractors must document specific information including invoice dates, purchase orders, agency contacts, contracted employee details (job title, name, hours worked), hourly billing rates, mileage rates (if applicable), total billing amounts, and assignment start and end dates. Reports must be submitted electronically to doaescontractusagereporting@wisconsin.gov, with each report covering only spend specific to this statewide contract and following precise formatting guidelines.

View the file

Other files

File Type Posted
03 Job Title Descriptions.docx DOCX document
RFB 28453-KH Statewide Accounting Auditing and Consulting Services.docx DOCX document
Accounting Auditing Constuling Cost Sheet.xlsx XLSX spreadsheet
01 User Guide 1-14-26.docx DOCX document

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

APPENDIX 3 - SPEND REPORT
Statewide Accounting, Auditing, and Consulting Services - RFB #28453-KH
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.
→Do not change the formatting in any cells - dates and dollar amounds must be entered as formatted. DO NOT USE FORMULAS IN ANY CELL IN THIS REPORT.
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.

mailto:kristina.harris@wisconsin.govmailto:doaescontractusagereporting@wisconsin.gov Column Descriptions

Column Descriptions
Statewide Accounting, Auditing, and Consulting Services - RFB 28453-KH
Report header fields:Description
REPORT DATEThe date the report was prepared
REPORTING PERIODThe period the report covers - please specify the year and quarter (i.e. 2025 Q1)
CONTRACTOR NAMEThe name of your company must be included in all reporting
Report columns:Description
CONTRACTOR NAMEThe name of your company
INVOICE DATEThe date of the invoice (MM/DD/YYYY)
INVOICE NUMBERYour invoice number
PURCHASE ORDER DATEThe date on the purchase order (MM/DD/YYYY) if a purchase order was provided by the Authorized User
PURCHASE ORDER NUMBERThe purchase order number if a purchase order was provided by the Authorized User
AGENCY/MUNICIPALITY/UNIVERSITYThe name of the Agency, UW Campus, or Municipality placing the order (Such as the Department of Administration)
AGENCY/MUNICIPALITY CONTACT NAMEThe name of the person at the Agency, UW Campus, or Municipality who placed the order
DIVISION/BUREAU (Optional)The Division or Bureau within the Agency if provided (such as the Division of Enterprise Operations or the State Bureau of Procurement)
CONTRACTED EMPLOYEE JOB TITLEThe job title of the Contracted Employee
CONTRACTED EMPLOYEE NAMEThe name of the Contracted Employee
NUMBER OF HOURS WORKEDThe total number of hours the Contracted Emplyoee worked for the invoice being reported
HOURLY BILL RATEThe hourly Bill Rate for the job title
MILEAGE RATE (if applicable)IF APPLICABLE, the mileage rate that is being billed. The mileage rate for Wisconsin is not the same as the federal mileage rate and can be found below - click on Pocket Travel guide for the applicable date:
https://dpm.wi.gov/Pages/HR_Admin/Class-and-Comp-HR-Admin.aspx
NUMBER OF MILES (if applicable)IF APPLICABLE, the number of miles billed
TOTAL BILLEDThe total billed for the invoice being reported, including any applicable mileage
START DATE OF ASSIGNMENTThe date the assignenment started
END DATE OF ASSIGNMENTThe date the assigment ends - enter UNKNOWN if there is no scheduled end date

https://dpm.wi.gov/Pages/HR_Admin/Class-and-Comp-HR-Admin.aspx Report

QUARTERLY REPORT

Statewide Accounting, Auditing, and Consulting Services - RFB 28453-KH
REPORT DATE:
REPORTING PERIOD:
CONTRACTOR NAME:
CONTRACTOR NAMEINVOICE DATEINVOICE NUMBERPURCHASE ORDER DATEPURCHASE ORDER NUMBERAGENCY/MUNICIPALITY/UNIVERSITYAGENCY/MUNICIPALITY CONTACT NAMEDIVISION/BUREAU (Optional)CONTRACTED EMPLOYEE JOB TITLECONTRACTED EMPLOYEE NAMENUMBER OF HOURS WORKEDHOURLY BILL RATEMILEAGE RATE (if applicable)NUMBER OF MILES (if applicable)TOTAL BILLEDSTART DATE OF ASSIGNMENTEND DATE OF ASSIGNMENT

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