The URL can be used to link to this page

Home My Public Portal AboutMWBE Involvement Reporting - Construction & Professional Services 3-12-2018Metropolitan St. Louis Sewer District Electronic M/WBE Involvement Reporting Construction & Professional Services Contracts Revision Date: March 12, 2018 (Revisions from previous version are marked in red.) 2 TABLE OF CONTENTS Logging into MSD Diversity Reporting (MWBE USA) .........................................................................................3 Review of the “Manage Sub Payment” Module ......................................................................................................4 Submitting Monthly M/WBE Involvement Reports (Prime Payment to Sub) ........................................................6 Automated M/WBE Subcontractor Payment Verification Process .......................................................................10 Payment Audit Module (Read Only) .....................................................................................................................11 Additional Notes ....................................................................................................................................................13 Revisions Made ......................................................................................................................................................13 3 Logging into MSD Diversity Reporting (MDR) for the First Time Your Username and Password will be supplied to you by MSD Diversity. If you do not have a Username and Password, or to request an additional Username and Password, please contact Katlynn Woodruff at kwoodruff@stlmsd.com or Amanda Copper at acooper@stlmsd.com.  Go to www.msddiversityreporting.com.  Enter your E-mail ID and Password, and then click the “Login” button.  You will then be directed to the Dashboard for your company. The Dashboard will provide a “quick view” of your contract information. MSD will update the Dashboard view to best fit contractor/consultant needs.  Please note the Change Password tab above. Please click this tab to update your user password. To request additional User IDs, please contact Katlynn Woodruff at kwoodruff@stlmsd.com or Amanda Cooper at acooper@stlmsd.com. 4 Review of the Manage Sub Payment Module The Manage Sub Payment module houses all subcontractor/sub -consultant payment information. Through this module, the user may submit, view, and print monthly M/WBE Involvement Reports.  Login to the MSD Diversity Reporting (MDR) system.  From the Dashboard, hover the mouse over the Involvement tab and click the Sub Payments link.  The user will be directed to the Manage Sub Payment module. If any M/WBE Involvement Reports have been submitted previously, those reports will be listed on this page.  The user may sort those reports using the column headings using the arrow icon to the right of the column heading – Contract #, Month, Year, Payment Type, Date Submitted. 5  Refresh: Clicking this button will refresh the M/WBE Involvement Reports to their pre-configured sorting method.  Search: Clicking this button will allow the user to search for M/WBE Involvement Reports based on desired criteria. o The user may enter the Project Number, which is different from the Contract Number, in the Contract Name box below to search for a contract by Project Number.  Download: Clicking this button will download the information from the user’s search results in an Excel Spreadsheet.  Add: Clicking this button will lead the user to the Monthly M/WBE Involvement Reporting form where the user may enter actual payments made to all subcontractors/sub-consultants for the specified reporting period.  Magnifying Glass Icon: By clicking this icon, the user may view the submitted M/WBE Involvement Report.  Printer Button: By clicking this icon, the user may print the Monthly M/WBE Involvement Report. 6 Submitting Monthly M/WBE Involvement Reports (Prime Payment to Sub) By the tenth calendar day of each month, MSD requires all Prime Contractors/Consultants/Suppliers to report the payments made to their subcontractors in the previous month even if no payments were made. Below are step-by-step instructions for completing the monthly M/WBE Involvement Reporting:  Login to the MSD Diversity Reporting (MWBE USA) system.  From the Dashboard, hover the mouse over the Involvement tab and click the Sub Payments link.  Click the Add button.  Contract #: Select the Contract Number from the dropdown list.  Payment Type: Select either “Monthly” or “Final.” Only select “Final” if the report is the last M/WBE Involvement Report that will be submitted.  Month: Select the reporting period Month from the dropdown list.  Year: Select the reporting period Year from the dropdown list.  Click the Check for Duplication button.  If the system determines that the Involvement Report for this Contract & Period is not a duplicate, the form will expand so that the user may enter the actual payments made to the subcontractors listed within the reporting period. 7  When the Involvement Reporting form first expands, the Subcontractor/Sub-consultant Payment section will display as seen below.  If no payments were made during the reporting period, the user must check the “No Data to Report” checkbox, check the “I hearby certify…” checkbox, enter the User’s name in the Submitted By field, and click the Submit button.  To add payments, the User must click the Invoice Details button for the appropriate sub(s). This will expand the section for that sub(s) and allow the User to enter invoice and payment details. Please see the next page for further details.  PLEASE NOTE: At the bottom left hand corner of the Involvement Reporting screen, a box appears to notify the user of the time left for data entry before the session expires. The user will have 20 minutes for data entry before the system will prompt the user to save their work to prevent data loss. Clicking the Save as Draft button will allow the user to save their work and continue with data entry. The user will receive confirmation that their work was saved as seen above.  Once the user clicks the Save as Draft button, they can either continue with data entry or they can cancel out of the form to return at a later time to complete their entries and submit the Involvement Report.  Sub-Payment Verification e-mails will only be sent once an Involvement Report is submitted. Any changes needed after Involvement Report submission must be performed by an MSD Administrator. 8  Payment Made: This field will automatically populate once all payment information is entered for each subcontractor/sub-consultant.  Payment Invoice(s) Details: Clicking this button allows the user to enter the payment information for each subcontractor/sub-consultant. o Sub Invoice #: Enter the subcontractor’s/sub-consultant’s Invoice Number. o Sub Invoice Date: Enter the date listed on the subcontractor’s/sub-consultant’s Invoice. o Amount Paid: Enter the amount paid to the subcontractor/sub-consultant for that Invoice. o Multiplier: This field is automatically populated based on the participation percentage listed on the MSD Form A. o Amount Towards Goal: This amount is automatically calculated based on the Amount Paid and Multiplier percentage. o Date of Payment: Select the date payment was made for the listed Invoice (date listed on the check). o Eligible for Advance Payment: This checkbox will be automatically checked if the Prime Contractor listed Advance Payment amounts for subcontractors via the Subcontractor Verification form. This field is only for Construction contracts. o Advance Payment?: If applicable, select yes if the payment reported is for Advance Payment to a subcontractor. If a subcontractor is not eligible for Advanced Payment, this field cannot be changed from “no.”  PLEASE NOTE: When entering Non-Certified payment data under the “Non-MWBE” dummy sub, you may enter ficticious data under the Sub Invoice #, Sub Invoice Date, and Date of Payment fields so that you can report the total spend to Non-Certified subs for the reporting period. Further instructions follow on the next page. 9  Attachment (Choose File): This button allows the user to upload copies of the subcontractor/sub- consultant invoices for the payments reported for that period. Uploading this supporting documentation is mandatory.  New Comments: Add any necessary comments.  Click the checkbox after reading the prompt.  Submitted By: Enter the user’s name.  By clicking the Save as Draft button, the user may save their work and continue with data entry. The user may also save their work, cancel out of the form, and return at a later time to complete and submit the form by clicking the Pencil icon for that report (see below screenshot).  Click the Submit button. Clicking this button submits and locks the M/WBE Involvement Report. The user will be directed back to the Manage Sub Payment page.  To print a copy of the Monthly M/WBE Involvement Report, click the Print button as shown below. 10 Automated M/WBE Subcontractor/Sub-Consultant Payment Verification Process The MSD Diversity Reporting system will send out automatic Payment Verification e-mails to M/WBE subcontractors/sub-consultants when a Prime Contractor/Prime Consultant reports a payment made to an MWBE. This process is detailed below. 11 PAYMENT AUDIT MODULE (READ ONLY) Prime Contractors/Consultants will have “read only” access to the Payment Audit Module. This module houses the results of all automated Payment Verifications sent to M/WBE subcontractor/sub-consultants with a reported payment. Below are step-by-step instructions for reviewing Payment Verification results in this module:  From the Dashboard, hover the mouse over the Involvement tab and click on the Payment Audit Module link.  The user may search for Payment Verification results by clicking the Search button.  Each time an Involvement Report is submitted with payments reported to an M/WBE sub(s), the automated Payment Verification e-mail is sent to the sub(s) with a reported payment(s). At that time, the record for that Payment Verification will appear in the Payment Audit Module. The statuses for Payment Verification results are as follows: o Pending: This status will appear once the automated Payment Verification e-mail is sent from the MDR system. The status will remain as Pending until the subcontractor/sub-consultant completes the Payment Verification Survey or until the Payment Verification Survey link expires seven (7) calendar days after being sent. o Confirmed: This status will appear when the subcontractor/sub-consultant completes the Payment Verification Survey confirming all payment information reported by the Prime. o Disputed: This status will appear when the subcontractor/sub-consultant completes the Payment Verification Survey, but disputes any payment information reported by the Prime. When a Payment Verification Survey results in a dispute, the MSD Diversity Reporting system will send an e-mail notification to MSD Diversity as well as the Prime Contractor/Consultant. All 12 disputes will require an investigation by the MWBE Compliance Inspector assigned to the contract. o Under Investigation: This status will appear when the MWBE Compliance Inspector has reviewed the disputed Payment Verification Survey submitted by the subcontractor/sub- consultant and begins working to resolve the dispute. o Resolved: This status will appear when the MWBE Compliance Inspector has resolved the Payment Verification dispute. The MWBE Compliance Inspector may require that the Prime Contractor/Consultant provide further proof to verify a reported payment that has been disputed; for example, copies of cancelled checks. MSD Diversity will make corrections as necessary and change the status of the Payment Verification to Resolved. o Auto: This status will appear when the subcontractor/sub-consultant has not completed the Payment Verification Survey within the allotted seven (7) calendar days. Any payment verifications with the status of Auto are subject to manual payment verification by MSD Diversity.  By clicking the Magnifying Glass or Printer icon, the user may review the Payment Verification Survey information for that record. PLEASE NOTE: If the Payment Verification record for a subcontractor/sub-consultant does not appear in the Payment Audit Module after the Prime submits an Involvement Report with a payment reported to that subcontractor/sub-consultant, the MSD Diversity Reporting System does not have an e-mail on file for that subcontractor/sub-consultant. Please contact MSD Diversity in this event so that MSD Diversity can ensure that the appropriate e-mail information is added to the MSD Diversity Reporting system. 13 Additional Notes  The web address for the MSD Diversity Reporting (MWBE USA) system is www.msddiversityreporting.com.  This reporting system can be accessed from any computer that has internet connection.  This manual will be updated as necessary, and the new version will be posted directly to MSD Diversity’s web page. Please submit enhancement requests to Katlynn Woodruff at kwoodruff@stlmsd.com.  An M/WBE Involvement Report must be submitted by the 10th of each month to report payments made in the previous month. If an M/WBE Involvement Report is missing from the previous month, the user cannot submit a M/WBE Involvement Report for the current month. Failure to complete the monthly reporting may lead to delay in payment from the District.  MSD will audit M/WBE Involvement Report submission to ensure all reporting is up-to-date. Users will also begin receiving e-mail reminders for late reporting.  Please direct all questions to Katlynn Woodruff via email (kwoodruff@stlmsd.com) or via telephone (314-768-6216). Revisions Made  The M/WBE Involvement Report form was revised to gather more detailed information in order to send out automated Payment Verification request e-mails to M/WBE subcontractors/sub-consultants when a payment is reported.  The Add/Update button on the Involvement Reporting form has been changed to Submit. Once an Involvement Report is submitted, only MSD administrators may make changes to the report.  The Save as Draft button has been added to the Involvement Reporting form to allow users to save their work to prevent data loss as well as to be able to return to the report at a later time to complete and submit the report.  Prime Contractors/Prime Consultants now have the capability to attach the invoice copies for all reported payments to M/WBE subcontractors/sub-consultants. Attaching this supporting documentation is mandatory.  The MSD Diversity Reporting system will now send out Payment Verification emails to subcontractors/sub-consultants with a reported payment. Any disputed payment information submitted by the subcontractor/sub-consultant will be investigated by MSD Diversity.  Prime Contractors/Consultants have “read only” access to the Payment Audit Module as a tool for monitoring the results of subcontractor/sub-consultant Payment Verification Requests.