NSP Data Clean-Up Reports Guidance

Description

These reports were first released in September 2018. Revised versions and revised guidance were released in December 2019. A revised Performance Report and associated guidance was released in June 2020.

HUD's Office of Block Grant Assistance (OBGA) Neighborhood Stabilization Program (NSP) team has developed two data clean-up reports in the Disaster Recovery Grant Reporting (DRGR) Reports Module, MicroStrategy, for Field Office (FO) representatives and NSP grantees to use to identify and correct data errors. These reports are focused on two of the three priorities for final Quarterly Performance Reports (QPRs): National Objective compliance, and financial data accuracy. The third priority is activity locations. To verify accuracy field offices should use MicroStrategy reports Perf Rept 03 and 03b.

In order to expedite grant closeout, grantees should correct DRGR data errors and reconcile DRGR data to local records. This involves two reconciliation processes:

• Financial reconciliation: Grantees ensure that all expenditures and program income have been recorded in DRGR at the activity level and that all other financial data is consistent with the grantee's records.
   
• Performance reconciliation: Accomplishment and beneficiary data for each activity should be entered and double-checked for any errors. Corrections should be made in the grantee's QPR or Action Plan, whichever is appropriate. Note: HUD will not open past QPRs that contain errors. All errors must be corrected in the current QPR through a process called "Prior Period Corrections."

In order to assist reconciliation, these reports identify conditions that indicate inconsistent or incomplete data in DRGR. In addition, they provide cumulative values at the activity level. HUD has provided guidance to accompany each report that describes the flagged conditions and the actions the grantee and field office can take to correct the condition. The reports flag conditions that require correction or merit investigation for possible correction. Please see the guidance and the Fact Sheet below for detailed instructions on accessing and working with reports.

Grantees should not wait until their final QPR to make these corrections and are advised to start this process early, because what appears to be a small correction can sometimes require reconciliation across multiple fields in DRGR.

Instructions for Accessing the Reports

The reports are accessed in the DRGR Reports Module, MicroStrategy, under the Utilities tab. The NSP Data Clean-Up Reports are located in the following MicroStrategy folders:

• Grantee Users: Utilities → Reports (MicroStrategy) → DRGR OLAP → Shared Reports → Grantee User Reports → Additional NSP Reports → NSP Data Clean-Up Reports
   
• HUD Field Office Users: Utilities → Reports (MicroStrategy) → DRGR OLAP → Shared Reports → HUD Field Office User Reports → Additional NSP Reports → NSP Data Clean-Up Reports

Questions

Please see the “Prepare” section of the NSP Closeout Process and Guidance for resources on preparing for closeout and making corrections in DRGR.

If you have comments or questions about using the NSP Data Cleanup Reports, please email DRGRteam@cloudburstgroup.com.

If you are having trouble accessing DRGR or accessing the MicroStrategy reporting module, please submit a question through the HUD Exchange Ask A Question (AAQ) portal. Under “My question is related to,” select “DRGR: Disaster Recovery Grant Reporting System.”

Resource Links

• NSP Data Clean-Up Release Notes (PDF)
• NSP Data Clean-Up Fact Sheet (PDF)
• NSP Data Clean-Up Financial Report Guidance (PDF)
• NSP Data Clean-Up Performance Report Guidance (PDF)
• NSP Closeout Process and Guidance (HTML)

---