Repo porting Requ quirements 1 Upload and Download Links Do not - PowerPoint PPT Presentation

Repo porting Requ quirements 1

Upload and Download Links Do not send information via email; send using the secure link provided in your invitation email 2

Upload and Download Links Do not send information via email; send using the secure link provided in your invitation email Send Email to: Lisa.Outlaw@osbm.nc.gov Subject: Need Upload and Download Link Name of Agency or Institution 3

NCPRO Expenditure Reporting Process Step 1 Receive Application from NCPRO STEPS 1- 4 Submit Attachments A-1, A-2, D, E, W-9, and Vendor Electronic Payment forms with letters from your bank or a voided check to through secure portal Step 2 Applicable to Nonprofits Step 3 NCPRO processes documents, sends back contract for electronic signature and Hospitals Only Step 4 Sign contract electronically. Executed contract is routed back to NCPRO Step 5 NCP CPRO t transfers f funds to to En Enti tities Step 6 Submit Proof of f Use o of f fu funds t to N NCPRO m monthly Submit A Attachment F, the f final report, Use A ALL f funds or R Return u unspent f funds b by De December 30, 30, 202 2020 to N o NCPR PRO Step 7 Step 8 Comply with NCPRO Audit Requests (before or after 12/30/2020) 4

Agreement Contract & Attachments Do not send information via email; send using the secure link provided in your invitation email NCPRO Documentation 1) Agreement Contract 2) Attachment A-1 Scope 3) Attachment A-2 Budget 4) Attachment B 09 NCAC 03M 5) Attachment C-1 Status Report 6) Attachment C-2 Proof of Use of Funds 7) Attachment D No tax delinquencies 8) Attachment E FFATA Requirements 9) Attachment F Outcomes and Accomplishments Report 10) Vendor Electronic Payment Form 11) W-9 NC Form 12) Conflict of Interest 5

Agreement Number Provided for tracking Purposes Agreement # Recipient Name 01-05 National Guard & Highway Patrol 03-00 Office of State Budget and Management 03-01 Department of Enviromental Quality 03-02 Department of Health and Human Services 03-03 Department of Information Technology 03-04 Department of Insurance 03-05 Department of Justice 03-06 Department of Labor 03-07 Department of Labor 03-08 Department of Military and Veterans Affairs 03-09 Department of Natural and Cultural Resources 03-10 Department of Public Instruction 03-11 Department of Public Safety 03-12 Department of Public Safety 03-13 Department of the Secretary of State 03-14 Department of Transportation 03-15 Deptment of State Treasurer 03-16 Governor's Office 6

Subrecipient vs. Contractor 2 C.F.R. § 200.330 through 200.332 regarding subrecipient monitoring and management Contractor Subrecipient VS. (1) Provides the goods and services within (1) Determines Eligibility normal business operations; (2) Performance is measured based on (2) Provides similar goods or services to program objectives; many different purchasers; (3) Normally operates in a competitive (3) Responsible for making decisions environment; about the program; (4) Provides goods or services that are (4) Responsible for complying with necessary to the primary activities of an program requirements; and organization. (5) Not subject to compliance requirements (5) Uses the CRF funds to carry out a program for a public purpose. 7

Subrecipient Requirement 2 C.F.R. § 200.330 through 200.332 regarding subrecipient monitoring and management • Subrecipients must follow the agreement provisions • Submit Attachments A-F • Use assigned agreement numbers to uniquely identify them for tracking purposes. See examples below: 39-01-01 Entity A Attachment C-2 39-01-02 Entity B Attachment C-2 39-01-03 Entity C Attachment C-2 8

Attachment C-1 Descriptive Summary of how CRF were used, any deliverables, progress against objectives & expected outcomes 9

Attachment C-2 Monthly report of expenditures for recipients and subrecipients by cost category Other Expenses Other Service Recipient Name Employee Expenses (e.g. related Expenses Subcontract Expenses Goods Expenses or (e.g. Payroll and benefits cost for Contracted Equipment charges not (e.g. utilities, (e.g. construction, (e.g. supplies, Subrecipient Name employee that are dedicated to Labor Expenses Expenses assigned above and telephone, data, lease maintenance) PPE). COVID-19) described by related expenses) recipient) Actual Employee Required Monthly Hours Dedicated to Employee Name Employee ID Employee Title Date of Hours Worked COVID or Number or Invoice, payroll, or or Vendor Name or or Description of Item or service, Total Invoice Invoice Quantity Contractor Invoice Number Purchased Amount or # of Patients Served If download from accounting or payroll system, it must be in this format: Excel Worksheet .xlsx or Comma delimited or tab delimited format .csv 10

State Agencies – BD701 Monthly report of expenditures for recipients and subrecipients by cost category 11

State Agencies – BD701 Monthly report of expenditures for recipients and subrecipients by cost category Run Statements The run statement member name is C-U-GL- BD701-CERT-REPORT-RUN 000100 OPTION LIBRARY(GLPUBLIC) 000200 RUN C-U-GL-BD701-CERT-REPORT ; 000300 INTO LIBRARY XXXXXXXX ; 000400 VARIABLE PERIOD ; 000500 00 ; 000600 VARIABLE PRIOR-YEAR-IND ; 000700 'N' ; 000800 SELECT GL-COMPANY-ID ; 000900 ('XXXX' 'XXXX') 001000 *SELECT GL-CENTER-ID ; 001100 * 'XXXXXXXXXXXX' ; 001200 *SELECT GL-INTER-LVL-3-RPT-CENTER- ID ; 001300 * 'XXXXXXXXXXXX' 12

Budget Procedures for COVID-19 Appropriations Provided for Information Purposes 13

Attachment F Grant Outcomes and Accomplishments Report, submitted as a Final Report 14

Questions Questions from the Chat 15

Questions Submit Form and Question to: NCPRO@OSBM.NC.GOV Documents and Presentation Located at https://ncpro.nc.gov 16