jagomart
digital resources
picture1_Excel Sample Sheet 32580 | Prime Contractor Mbe Monthly Payment Report   Mbe Attachment 4a


 110x       Filetype XLSX       File size 0.02 MB       Source: purchase.umd.edu


File: Excel Sample Sheet 32580 | Prime Contractor Mbe Monthly Payment Report Mbe Attachment 4a
sheet 1 revised instructions mbe prime contractor monthly reporting instructions mbe attachment 4a distributed june 2020 all participating prime and subcontractors are required to submit their mbe monthly payment reports ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Revised Instructions
MBE Prime Contractor Monthly Reporting Instructions (MBE Attachment 4A)
Distributed June, 2020
All participating Prime and subcontractors are required to submit their MBE Monthly Payment reports to University of Maryland College Park (UMCP) for each contract by the State of Maryland and Attestation Signature. Please submit in the attached EXCEL FORMAT no later than the 15th of each month via email to mbe@umd.edu. The submission should include:
·         The signature page and detailed spreadsheet Monthly. (template attached).
·         NOTE: These worksheets are protected. All fields are required. Fields A-1, B-1, E-3, N-3 have fixed drop-down menus.
*Per COMAR 21.11.03.13, the Contractor shall submit monthly to the MBE Liaison a Prime Contractor MBE Monthly Payment Report (MBE-4A) and MBE Subcontractor Monthly Payment Report (MBE-5).
Sec. 21.07.02.05-2. Prompt Payment of Subcontractors

FY2020 MBE PRIME AND SUBCONTRACTOR REPORTING REQUIREMENTS
REQUIRED SIGNATURES:
Print the sheet, execute as requested, and submit in pdf format.

COLUMNS
Column A-1 REPORTING MONTH (required field): Select the Month you are reporting for from the drop-down menu.
Column B-1 REPORTING Year (required field): Select the Year you are reporting for from the drop-down menu. .
Column A-2 PRIME CONTRACTOR (required field): Enter prime contractor’s company name
Column B-2 Prime Contractor’s UMD Contract Number (required field): Enter prime contractor’s UMD contract number. Prime contractor will supply you with this information.
Column C-2 Project Name: Enter the project’s name.
Column D-2 MBE Subcontractor Name: Enter each Subcontractor(s) Company name(s).
Column E-3 Work/Service Performed (required Field): Select an entry from the drop down menu. You must use one of the options on the drop down menu. Attempts to enter something else will be rejected.
Column F-2 Original Subcontract Amount
Column G-2 Current Subcontract Amount
Column H-2 Payment Date
Column I-2 Amount Paid this Reporting Period (Monthly): Enter the amount paid to each subcontractor for this reporting period. If you paid multiple payments to a subcontractor this reporting period you should make an entry for each payment paid.
Column J-2 Amount of Paid this Fiscal Year: Enter the amount paid to each subcontractor for this Fiscal Year (July 1 to June 30)
Column K-2 Amount Paid to Date: Enter the amount paid to each subcontractor for all invoices on this contract to date.
Column L-2 Amount of Payments 30 Days Late: Enter payment that is more than 30 days late for each subcontractor. If you have multiple payments to the same vendor that are late, you should make an entry for each payment owed.
Column M-2 Balance to Finish (automatically calculated)
Column N-3 Minority Description: Select the appropriate description from the drop down menu. Attempts to enter values not on the drop down menu will be rejected.
Column O-2 MBE Certificate Number: Enter the subcontractor’s MDOT MBE certification number. If you do not know the certificate number it can be found herehttps://mbe.mdot.maryland.gov/directory/
Column P-2 Comments

Sheet 2: Revised Payments to Subs
May 2020 University of University of Maryland, College Park - PRIME CONTRACTOR MBE MONTHLY PAYMENT REPORT - MBE ATTACHMENT 4A
(Last revised 6/1/2020)





Prime Contractor Prime Contractor’s UMD Contract Number Project Name MBE Sub-Contractor Work Service Performed Original Sub-Contract Amount Current Sub-Contract Amount Payment Date Amount Paid by Prime for this Reporting Period (Monthly) Amount Paid this Fiscal Year (July 1 to June 30) Amount Paid to Date Amount of Payments Over 30 Days Late Balance to Finish Minority Description MBE CERT Number Comments Minority Sub-Categories Drop Down Values Work, Service Performed Drop Down Values Reporting Date Drop Down Values Fiscal Year Drop Down Values












$0.00


African American Architectural January 2020












$0.00


African American Woman Engineering February 2021












$0.00


Asian American Construction March 2022












$0.00


Asian American Woman Construction Related Services April 2023












$0.00


Hispanic American Maintenance May 2024












$0.00


Hispanic American Woman Services June












$0.00


Native American Supplies & Equipment July












$0.00


Native American Woman IT Services August












$0.00


Woman IT Supplies & Equipment September












$0.00




October












$0.00




November












$0.00




December












$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00


















$0.00







The words contained in this file might help you see if this file matches what you are looking for:

...Sheet revised instructions mbe prime contractor monthly reporting attachment a distributed june all participating and subcontractors are required to submit their payment reports university of maryland college park umcp for each contract by the state attestation signature please in attached excel format no later than th month via email umdedu submission should include middot nbsp page detailed spreadsheet template note these worksheets protected fields b e n have fixed dropdown menus per comar shall liaison report mbea subcontractor sec prompt fy requirements signatures print execute as requested pdf columns column field select you from menu year enter rsquo s company name umd number will supply with this information c project d workservice performed an entry drop down must use one options on attempts something else be rejected f original subcontract amount g current h date i paid period if multiple payments make j fiscal july k invoices l days late that is more same vendor owed m balan...

no reviews yet
Please Login to review.