Quarterly+Reports

=Quarterly Reports =

REMC Vendor Toolkit Home | District and Building Code Tips | Quarterly Report Data Checking

REMC SAVE vendors are required to submit detailed sales reports quarterly. Reports are to be uploaded via the Vendor Center, and are due 30 days (NOT 1 month) after the end of each quarter:


 * //All Bids __Except__ Paper Bids: //**
 * < **Quarter** ||< **Quarter Begin** ||< **Quarter End** ||< **Report Due** ||
 * < 1 ||< January 1 ||< March 31 ||< April 30 ||
 * < 2 ||< April 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">June 30 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">July 30 ||
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">3 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">July 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">September 30 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">October 30 ||
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">4 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">October 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">December 31 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">January 30 ||

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif; font-size: 11pt;">//**Paper Bids __Only__:**//
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif; font-size: 11pt;">**Quarter** ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">**<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif; font-size: 11pt;">Quarter Begin ** ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif; font-size: 11pt;">**Quarter End** || <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif; font-size: 11pt;">**Report Due** ||<  ||
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">December 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">February 28/29 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">March 30 ||
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">2 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">March 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">May 31 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">June 30 ||
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">3 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">June 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">August 31 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">September 30 ||
 * < <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">4 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">September 1 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">November 30 ||< <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">December 30 ||

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">Ingham ISD generates an invoice for 1% of total sales reported by each vendor. Payment is due within 30 days of the invoice date. Please do not remit payment until you receive the invoice.

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">The reports are also used to report sales and savings to local school districts. In order to accomplish this, each report is loaded into a single database that is used to generate usage reports. It is essential that all reports adhere strictly to the standards described in this Wiki so that they load into the database properly and generate high-quality data for REMC customers. We invite you to contribute to this Wiki to share your knowledge as a REMC vendor with others.

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">Quarterly reports must follow the format shown in this spreadsheet:

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">The report format must be followed exactly so that the data can be uploaded into our database.

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">Most of the data points can be downloaded directly from your company's invoicing system, although you may need to rearrange the columns. Please do not provide any additional fields unless requested by REMC.

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">The fields that are not likely native to your invoicing system are:

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">District Code <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">Building Code <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">REMC Center Number <span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">REMC Bid Item Number

<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">The District Code and Building Code are unique identification numbers assigned by the State of Michigan to each school district and building (public, charter and private), each college or university (public or private), and a number of government agencies, including all prisons. Every school district is assigned to a particular REMC Center. All three of these numbers are provided to each vendor in the following spreadsheet:



<span style="font-family: 'Trebuchet MS',Helvetica,sans-serif;">REMC Item Numbers are assigned to all of the products that were awarded. To find your company's REMC Item Numbers, visit the Vendor List on the REMC Statewide $AVE Bid Project's web site. Scroll down to your company's name and click "View List."

<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #800000; font-family: Arial,Helvetica,sans-serif;">REMC Vendor Toolkit Home | <span style="font-family: Arial,Helvetica,sans-serif;">District and Building Code Tips |<span style="font-family: Arial,Helvetica,sans-serif;"> Quarterly Report Data Checking