The URL can be used to link to this page

Home My Public Portal AboutMWBE Involvement Reporting - Construction & Professional Services 8-6-21 Metropolitan St. Louis Sewer District Electronic M/WBE Involvement Reporting Construction & Professional Services Contracts Revision Date: August 6, 2021 (Revisions from previous version are highlighted in yellow.) 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 .......................................................................11 Payment Audit Module (Read Only) .....................................................................................................................12 Additional Notes ....................................................................................................................................................14 Revisions Made......................................................................................................................................................14 3 Logging into MSD Diversity Reporting (MDR) for the First Time Your Username and Password will be provided to you by MSD Diversity. If you do not have a Username and Password, or to request an additional Username and Password, please contact MSD Diversity at diversity@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 MSD Diversity at diversity@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.  Pencil Icon: By clicking this icon, the user may access and submit a “draft” 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 that the system does not recognize special characters or spaces. Please only enter numerical values when adding payments.  PLEASE NOTE: All Subcontractors are REQUIRED to have an active and verified Payment Audit Contact email saved in the MDR Reporting System. If there is no active email address on file, the Prime Contractor will receive an error message preventing you from saving or submitting the monthly Involvement report. This message will display all subs without a verified Payment Audit Contact. The Involvement Report will remain in draft status until MDR is updated with a verified Payment Audit Contact. Please contact Diversity at diversity@stlmsd.com to update this information.  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. 8  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.   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. 9 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.  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 Prime receives an error that verified PAC(s) needed – must provide to Diversity before they can submit report. Prime creates and tries to submit subpayment report Do all subs except NDTR subs have verified PACs? Sub clicks on link in email notification & reviews payment info reported by prime Does the sub respond to email notification within 5 days? Yes Does sub confirm payment info reported by prime? Yes Sub submits the SubVendor Payment Audit Form Status in PAM changes to “Confirmed” Diversity updates PAC in MDR and sends verification link to subs No All subs verify PAC email addresses Prime is able to submit subpayment report Yes System sends notification to PAC for confirmation of payment. Record created in payment audit module (PAM) with status of “Pending” for any subs paid.. If no payment to any subs, PAM record created for each sub with a status of “NDTR”. If payment to at least 1 sub, PAM record has status of “No Payment” for any sub not paid. No Reminder notification sent to sub with copy to prime – sub must respond in 5 days. Status in PAM is still “Pending”. No Email regarding dispute sent to diversity@stlmsd.com Record in PAM changes to status of “Disputed” Inspector notified of disputed payment Inspector changes On the 11th day from submission of subpayment report (if no response received from sub), a notification is sent to prime with a link – full payment verification (PV) must be submitted for the sub payment or prime won’t be able to submit next month’s subpayment report. A No copy of the email without the link is sent to sub & Diversity Link expires by 15th of the next month. Status in PAM changes to “Non‐ Compliant”. Does the sub respond to email notification within 5 days? Inspector researches & resolves, then changes status in PAM to “Resolved”. status in PAM to “Under Investigation”. Prime unable to submit next month’s subpayment report and must contact Diversity NO and manually send full PV information. Diversity manually attaches the full PV to the PAM record and changes the status to “Compliant”. Does the prime respond by the 15th of the following month? Yes PV attached to the record in PAM and a notification is sent to Diversity who manually changes the status to “Compliant”. Revised Prompt Payment Audit Process (from submission of the SubPayment Report) – January 2020 Blue: Prime Vendor Grey: System Green: Decision Purple: Sub Orange: Diversity System manually unlocks the next month for prime to submit subpayment report. REV Aug 19, 2020 14 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 five (5) calendar days after being sent . If the subcontractor does not respond to the Payment Verification Survey link within the five (5)calendar days,a reminder notification will automatically be sent to the Subcontractor on the 6th day allowing the sub an additional five (5) days to respond to the link. A copy of this reminder notification will also be sent to the prime. The status in the PAM will remain Pending. 15 o Confirmed: This status will appear when the subcontractor/sub-consultant completes the Payment Verification Survey confirming all payment information reported by the Prime within the allotted timeframe. 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 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 Non-Compliant: If the subcontractor does not respond to the Payment Survey link after the additional five (5) calendar days, the link will then expire. On the 11th day the Subcontractor will be sent a notification that the link has expired, and the Prime is now required to submit a full payment verification. The prime will also be sent an email stating that they are now Non- Compliant and will not be able to submit future payments until a full payment verification has been uploaded. The email will include a link for the Prime to upload a full payment verification within the Payment Audit Module. The status in PAM will change to “Non-Compliant”. The link will expire by the 15th of the next month. Once the link expires the Prime will be required to directly contact Diversity staff with their full PV and Diversity will manually attach it. o Compliant: Once the full payment verification has been uploaded, Diversity staff will review the documents and either contact the Prime for more information or manually change the status in PAM to “Compliant” An email will be sent to the Prime once their status in PAM has been changed to “Compliant” notifying them that they are now Compliant and can resume submitting their monthly payments.  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. 16 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 MSD Diversity at diversity@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 MSD Diversity at diversity@stlmsd.com. 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.  The Automated M/WBE Subcontractor/Subconsultant Payment Verification Process.