drgr reports module (microstrategy) · 2019. 3. 15. · (microstrategy) march 06, 2011 . community...
TRANSCRIPT
U.S. Department of Housing and Urban Development
DRGR Reports Module (MicroStrategy)
March 06, 2011
Community Planning and Development
Speakers and Q and A Format
• Speakers – Mark Mitchell, HUD – Hunter Kurtz, HUD – Janine Cuneo, ICF
• How to ask questions
– Change status in Live Meeting from green to purple
– Press *1 to ask a question through Premiere Conference • Provide Name and Organization • If question already answered, press *2 to remove from queue
– Change status back to green after question answered
2 U.S. Department of Housing and Urban Development • Community Planning and Development
Agenda
Presentation on key topics: – Why these reports are so useful – How to access and use basic functions – Common Issues that can be resolved using
MicroStrategy
• Will do one half of presentation (approximately one hour) & take some questions, complete presentation & then take more questions
• Will do polls throughout
3 U.S. Department of Housing and Urban Development • Community Planning and Development
4
What is MSTR (aka Microstrategies)?
Why are they so useful? They tell the your story succinctly and “by the numbers.” Assist you in troubleshooting problems and identifying issues.
How have you used MSTR reports in your program?
Reports Module • Purpose:
– Reports provide a relatively quick and easy way of accessing the most up-to-date information in DRGR related to user accounts, obligations and drawdowns, report status, accomplishments, etc.
• HUD FO: – Examine financial information, accomplishments and user account info – Determine AP/QPR review status.
• Grantee: – Examine financial information, accomplishments and user account info – Determine AP/QPR status.
Which reports you can access will vary based on the type of account you have. It is an OPTIONAL module but can be a useful tool.
5 U.S. Department of Housing and Urban Development • Community Planning and Development
6 U.S. Department of Housing and Urban Development • Community Planning and Development
The Basics: DRGR Modules
Admin Assign and
certify users; add and track TA and Monitoring
Events
Action Plans Identify
activities to be funded by
organization, activity type, and project.
Drawdowns Obligate funds
for draws; create,
approve, edit vouchers;
receipt program income
QPRs
Summarize drawdowns,
expenditures, obligations, and
achievements for the quarter
Reports Look at financial, reporting,
and user account information in an easy-to-
read and exportable format
Accessing Reports
7 U.S. Department of Housing and Urban Development • Community Planning and Development
Accessing Report Options
8 U.S. Department of Housing and Urban Development • Community Planning and Development
‘My Reports’ are specific to your
account: Users can save their personal
reports here.
Accessing Reports – Public vs. Standard
9 U.S. Department of Housing and Urban Development • Community Planning and Development
1.
2.
3.
OR
Standard vs. Public Reports
10 U.S. Department of Housing and Urban Development • Community Planning and Development
• Standard Reports: Data files similar to spreadsheets used for tracking and quality control with reports containing data at the grant, project and activity level. More commonly used by grantees.
• Public Report: Interactive charts and graphs showing progress by grants, activity category or grantee projects. Contains financial dashboard reports and trend analyses that can be accessed by all users.
Standard Reports
11 U.S. Department of Housing and Urban Development • Community Planning and Development
• Administrative Reports – User information – Action Plan/QPR status
• Financial Reports – Budgets, Disbursements – Cumulative financial data – Invoice Line Items
• Performance Reports – Beneficiary data – Accomplishments
Standard Reports: Admin Admin Rept01a: GRANT - DRGR Grant Status and CPD Contact Admin Rept02a: ACTPLN - Grant and DRGR Action Plan Review Status This report shows grant status, including drawdown and obligation blocks. It also includes CPD contact for each grant. If info needs to be updated, please send to DRGR_Help mailbox.
This report shows whether grant is blocked from drawdowns as well as the date of the last DRGR AP approval and the current status of the DRGR AP.
Admin Rept02b: ACTPLN - Activity Status with Start and End Dates Admin Rept03a: QPR - Report Status Performance data in this report is aggregated measure types so the numbers are not meaningful in themselves. It is only include as an indicator of whether accomplishments were entered or not.
This report will only show the status of QPRs that have been added by grant. Grantees must add each QPR as they are due.
Admin Rept03b: QPR - Exec Summary Progress Narrative Admin Rept04a Modified: USERS - Grantee DRGR Users Account Status This report shows the overall progress narrative at the grant level by QPR
This is a fully prompted report that can be used as a template for building other reports.
Admin Rept04a: USERS - Grantee DRGR Users Account Status Admin Rept04b Modified: USERS - Grantee Users with System Role and Certification Status
This is a master list of all grantee DRGR user accounts. This is a fully prompted report that can be used as a template for building other reports.
Admin Rept04b: USERS - Grantee DRGR Users with System Role and Certification Status Admin Rept04c: USERS - Grantee DRGR Users Access by Grant This report shows system role and recertification status for grantee users. Grantee admin users must be recertified by CPD representatives and other grantee users are certified by grantee admin users. Recertifications are required every 6 months.
This report will only show users assigned to grants by grantee system administrators. This step must be done when new grantee user accounts or grants are added to DRGR.
Admin Rept05a: ADMIN - Responsible Organization List Admin Rept05b: ADMIN- Oversight Events - Event Level This organization is a master list of responsible organizations and associated data by grantee.
This is a fully prompted report that can be used as a template for building other reports.
Admin Rept05c: ADMIN- Oversight Events - Topic Level This is a fully prompted report that can be used as a template for building other reports.
Standard Reports (Admin Rept04b)
13 U.S. Department of Housing and Urban Development • Community Planning and Development
Standard Reports: Financial (Fin) Fin Rept01a: ACTPLN- Grant Budgets by National Objective - Activity Level Fin Rept01b: ACTPLN - DRGR Grant Activity Budgets by Project
This report can be used to create a master list of activities for each grant.
This report shows activities and their budgets by project. NOTE: Since this is an activity level report, project budgets will repeat on each activity row within the project.
Fin Rept01c: DRAWS- Budget and Disbursements by National Objective - Grant Level
Fin Rept02a: DRAWS- Voucher Status by Line Item and QPR Begin Date- Grant Funds
This is a summary report at the grant level. It will only show amounts budgeted and disbursed from activities entered into DRGR.
This report shows the status, approval dates, and LOCCS submit date for each voucher line item using GRANT FUNDS by project, activity, and responsible organization. The report now includes a dropdown for QPR BEGIN DATE and GRANT PROGRAM.
Fin Rept02b: DRAWS- Voucher Status by Line Item - Program Income Fin Rept02c: Voucher Revision Report - Grant Funds NP
This report shows the status and approval dates for each voucher line item using program income by project, activity, and responsible organization.
This report shows the amount of funds distributed across activities on REVISED voucher line items for activities with grant funds. It includes creation and approval users/dates.
Fin Rept03: DRAWS - Voucher Status by Line Item - Grant Funds Fin Rept04: DRAWS - Voucher Line Item Status by Project - Grant Funds
This is a report showing the status and action dates of voucher line items (note: draws before Jan.1, 2009 are simulated from QPRs). SORTED BY VOUCHER AND VOUCHER ITEM #
This is a report showing the status and action dates of voucher line items (note: draws before Jan.1, 2009 are simulated from QPRs) SORTED BY PROJECT and ACTIVITY #
Fin Rept05a: CUM - Program Income - Grant Level Fin Rept05b: CUM - Program Income - Activity Level
This is a report showing data at the grant level program income disbursements recorded in the drawdown module and program income received across all QPRs (regardless of QPR status)
This report shows data at the activity-level: a) grant funds budgeted, b) grant fund obligations and approved grant and program income disbursements recorded in the drawdown module and c) program income received across all QPRs
Standard Reports: Financial (Fin. 2) Fin Rept05c: Receipts by Project and Activity Fin Rept05d: Program Income Account Summary
This report shows Receipts in the Drawdown module recorded for Program Income and RLFs. (Note: Receipts before Dec.3, 2011 are simulated PI Received amounts recorded in QPRs from before that date)
This report shows the sum of activity budgets, obligations, program income received, and program income disbursed within each PI account. It does not include any activities not assigned to a PI account.
Fin Rept06: CUM - Fin Data - Grant Level Fin Rept06b: CUM - NSP Financial Summ - Grant Level - LH25 This report shows grant-level financial data entered or calculated by quarter. It includes grant funds and program income. Grant obligations entered from Jan 09 are updated amounts rather than incremental.
This report shows a grant-level snapshot of financial activity for activities benefiting households below 50% AMI
Fin Rept07: CUM - Grant Funds Fin Summ - Project Level Fin Rept07b: CUM - Cumulative Data - Activity Level by Resp Org, Act Type and Nat Obj
This is a report showing data at the project level from the latest DRGR Action Plan and across all QPRs (regardless of QPR status) SORTED BY STATE, GRANT # and PROJECT #.
This is a report showing financial data at the activity level from the latest DRGR Action Plan, from the drawdown module as of the date the report is pulled, and across all QPRs regardless of QPR status. W/ RESP ORG, ACT TYPE AND NAT OBJ.
Fin Rept07c: QPR - Fin Data by Activity and Quarter Fin Rept08a: CUM - Grant Funds Budget and Cumulative Data - Activity Level by Resp Org, Act Type and Nat Obj
This report shows activity-level financial data entered or calculated by quarter. This can be used to troubleshoot data entry errors across quarters. Report updated to include project # and title. QPRs only show if financial activity during quarter.
This is a report showing data at the activity level from the latest DRGR Action Plan and across all QPRs (regardless of QPR status) W/ RESP ORG, ACT TYPE AND NAT OBJ
Fin Rept08b: CUM - Grant Funds Financial Summ - Activity Level by Project Fin Rept09a: QPR - Fin Data by Quarter - Grant Level
This is a report showing data at the activity level from the latest DRGR Action Plan and across all QPRs (regardless of QPR status) SORTED BY PROJECT AND ACTIVITY #
This report shows grant-level financial data entered or calculated by quarter. Obligations entered since Jan 09 are updated amounts rather than incremental.
Fin Rept09b: QPR - Fin Data by Activity and Quarter This report shows activity-level financial data entered or calculated by quarter. This can be used to troubleshoot data entry errors across quarters. Obligations entered from Jan 09 are updated amounts rather than incremental.
Standard Reports: Financial (Fin Rept05b)
Fin Rept05b: CUM - Program Income - Activity LevelPage by:Grant Status: ActiveGrantee: Kansas City, MOGrant Number: B-08-MN-29-0001
Program Program Responsible Activity Type Activity Number Metrics Grant Funds Grant Funds Grant Funds Income Income OrganizationBudgeted Obligated Disbursed Received Disbursed
Economic Development BEDCLMMI $6,959,177.00 $6,959,177.00 $3,523,307.39 $1,372,864.91 $1,076,793.28Rehabilitation/reconstruction of Corporation
residential structures Economic Development BEDCLH25 $960,434.00 $960,434.00 $735,301.94 $325,639.07 $118,077.72CorporationAdminCity City of Kansas City $281,537.00 $281,537.00 $33,575.97 $0.00 $0.00
Administration Economic Development AdminEDC $755,000.00 $755,000.00 $246,652.56 $0.00 $114,232.66Corporation
Rehabilitation/reconstruction of BHabitatLH25 Habitat for Humanity $223,228.00 $223,228.00 $43,009.86 $0.00 $24,207.49residential structuresConstruction of new housing EHabitatLH25 Habitat for Humanity $1,186,000.00 $1,186,000.00 $288,419.99 $0.00 $69,955.66
$10,365,376.00 $10,365,376.00 $4,870,267.71 $1,698,503.98 $1,403,266.81
16 U.S. Department of Housing and Urban Development • Community Planning and Development
Standard Reports: Performance (Perf) Perf Rept01: CUM - Projected vs Cum Totals for Performance Measure Sorted by Activity Number
Perf Rept02a: CUM - Projected vs Cum Totals for Performance Measure Sorted by Resp Org and Activity Type
This reports shows data from the latest DRGR Action Plan and all QPRs (regardless of QPR status) Note: Do not add performance measures across activity types
This reports shows data from the latest DRGR Action Plan and all QPRs (regardless of QPR status) Note: Do not add performance measures across activity types
Perf Rept02b: CUM - Projected vs Cum Totals for Performance Measure Sorted by Resp Org and Activity Type - NSP Only Perf Rept02c: QPR - Actual Accomplishments by Quarter This reports shows data from the latest DRGR Action Plan and all QPRs (regardless of QPR status) Note: Do not add performance measures across activity types
This reports shows data from each QPRs (regardless of QPR status) and can be used to troubleshoot data entry problems. Note: Do not add performance measures across activity types
Perf Rept02d: QPR - Actual Accomplishments by Quarter HH and HU Only Perf Rept03: QPR - Addresses by Activity and Responsible Organization This reports shows household and housing unit data from each QPR (regardless of QPR status) and can be used to troubleshoot data entry problems. Note: Do not add performance measures across activity types
This report is intended to show addresses across activities and QPRs. Each QPR normally only shows addresses entered in that report.
Perf Rept04a: ACTPLN - Beneficiary and Hsg Measure Types Selected - Activity Level
Perf Rept04b: ACTNPLN - Area Benefit Type Selected- Census vs Survey - Activity Level
This report shows the types of beneficiary measures selected for an activity: Direct vs. Area; Census vs. Survey; Households vs. Persons; Housing Units; SF and/or MF
If Area Benefit is selected as the Benefit Type, this report lists activities by whether CENSUS data has been manually selected in DRGR or summary data has been entered using the SURVEY method
Perf Rept05: ACTPLN - Area Benefit Census Method - Low Mod Calculations and CTBGs - Activity Level
Perf Rept06: QPR - Direct Benefit Activities - Beneficiary Statistics by Household Type
If an activity has been designated as area benefit- census method, this report shows the summary calculation and a list of the census counties, places, tracts and block groups for each activity.
For direct benefit activities, this report shows the distribution of households and/or persons by race/ethnicity and Hispanic status
Perf Rept09: ACTPLN - DREF Activity Budgets and Descriptions This report shows activities under Ike only grants which have performance measures entered for DREF
Standard Reports: Performance (Perf Rept01)
18 U.S. Department of Housing and Urban Development • Community Planning and Development
Overview of Functionality Common modifications users perform: • Move and Sort Columns • Grouping Columns • Adding Filters Three ways to modify reports: 1. Use the ribbon (below) 2. Drag objects 3. Right click over the object for different options
Subscribe Export to Excel Swap Rows & Change Styles or PDF Columns
Modifying Reports: Moving Columns
Modifying Reports: Sorting Columns
21
Modifying Reports: Sorting Columns
22
Modifying Reports: Creating a Page-By
23
Modifying Reports: Creating a Page-By
24
Modifying Reports: Grouping Columns (Example: Activity #)
25
Modifying Reports: Grouping Columns (Example: Activity #)
26
Modifying Reports: Grid and/or Graph
27
Modifying Reports - Video Demo Financial Report 05b: Program Income Activity Level
1. How much PI has subrecipient B generated?
• Page By: Resp. Org: http://youtu.be/rnsBAuXHnQU
2. How can I easily see which activity generated the most PI?
• Sort Descending for PI: http://youtu.be/71yZ48dlNSY
3. How can I provide this data to my CPD rep as a nice graph to show our progress?
• View Grid and Graph: http://youtu.be/Rfw2UsZBvII
4. How can I separate the financial information by Activity Type?
• Move to columns: http://youtu.be/puTJk-XgRVA
28
Saving Reports: ‘My Reports’
Saving Reports: History List
Subscribing to Reports
1. Click on link under report title
2. Select ADD SUBSCRIPTION
3. Specify frequency for the report
31
Exporting Reports • When to Export
– When selecting the report (only access to one grant)
32
– After modifying the report
Exporting Reports to Excel
33
Accessing Public Reports
1.
2.
3.
4.
OR
Public Reports: Financial Update Dashboards
35
Public Reports: Quarterly Disbursements Analysis
36
Public Reports: How to Save
37
Resolve Common Issues with Reports
Common Problems:
1. Accomplishment Data & Corrections
• What has already been entered into the QPR?
• What do I do when I get error messages?
2. Compliance & Telling HUD your Story
3. Estimating PI & Adjusting Budgets
4. Administrative Issues
38 U.S. Department of Housing and Urban Development • Community Planning and Development
Common Issues: Accomplishment Data
• Performance Reports can be useful when a grantee is attempting to gather information that has already been entered into the QPR instead of going back through previous quarter’s QPRs.
1. What addresses have already been entered?
2. Did I already entered specific race/ethnicity information about a beneficiary?
3. How can I see all current accomplishment information for my activities?
39 U.S. Department of Housing and Urban Development • Community Planning and Development
Common Issues: Accomplishment Data What addresses have already been entered so I don’t enter
one twice?
(Perf Rept03: QPR - Addresses by Activity and Responsible Organization)
Common Issues: Accomplishment Data
Did I already entered specific race/ethnicity information for a beneficiary?
(Perf Rept06: QPR - Direct Benefit Activities - Beneficiary Statistics by Household Type)
41
Common Issues: Accomplishment Data How can I see all current accomplishment information for my
Activities?
Perf Rept06: Direct Benefit Activities - Beneficiary Statistics by Household TypePage by:Grantee: NAGrant Number: B-08-XX-00-0000Activity Type: Rehabilitation/reconstruction of residential structures
White
Black/African
American Asian
American Indian/Alaskan Native
Other multi-racial Unknown White
Black/African
AmericanActual Actual Actual Actual Actual Actual Actual Actual
Rehabilitation/Reconstruction of Residential Struc
2 0 0 0 0 0 0 0
Rehabilitation/Reconstruction 0 2 0 0 0 0 0 2
Activity Title Nat Obj
Households - TotalHouseholds - Renter
Total
NSP Only - LMMI
NSP Only - LH - 25% Set-Aside
Common Issues: Accomplishment Corrections 1. How do I make corrections to information
entered in a Prior Period?
2. I am trying to enter beneficiary information in the QPR and getting error messages.
Cumulative sum of income levels for ‘Households - Total’ must be equal to cum ulative sum of ‘Owner – Total’ <Number>
43 U.S. Department of Housing and Urban Development • Community Planning and Development
Common Issues: Accomplishment Corrections To help understand the error messages and make
corrections, refer to Performance Report 01
Projected = Action Plan Actual = QPR
Common Issues: Accomplishment Corrections If the error message relates to Race/Ethnicity
information, review Performance Report 06
Perf Rept06: Direct Benefit Activities - Beneficiary Statistics by Household TypePage by:Grantee: NAGrant Number: B-08-XX-00-0000Activity Type: Rehabilitation/reconstruction of residential structures
White
Black/African
American Asian
American Indian/Alaskan Native
Other multi-racial Unknown White
Black/African
AmericanActual Actual Actual Actual Actual Actual Actual Actual
Rehabilitation/Reconstruction of Residential Struc
2 0 0 0 0 0 0 0
Rehabilitation/Reconstruction 0 2 0 0 0 0 0 2Rehabilitation/Reconstruction of Residential Struc
0 1 0 0 0 0 0 0
Rehabilitation/Reconstruction 1 0 0 0 0 0 0 0Rehabilitation/Reconstruction LH25%
1 0 0 0 0 0 0 0
Rehabilitation/Reconstruction 1 0 0 0 0 0 0 0Rehabiliation/Reconstruction 7 4 0 0 0 0 7 4Rehabilitaiton/Reconstruction 1 2 0 0 0 0 0 0Rehabilitation/Reconstruction 0 2 0 0 0 0 0 0
Activity Title Nat Obj
Households - TotalHouseholds - Renter
Total
NSP Only - LMMI
NSP Only - LMMI
NSP Only - LH - 25% Set-Aside
NSP Only - LMMI
NSP Only - LH - 25% Set-Aside
NSP Only - LH - 25% Set-Aside
NSP Only - LMMINSP Only - LH - 25% Set-AsideNSP Only - LH - 25% Set-Aside
Common Issues: Compliance & Telling HUD Your Story
1. Are 25% of total funds are set aside for those at or below 50% AMI?
2. Are my Expenditures much lower than my Disbursements?
3. Are we using Program Income before Program Funds?
46 U.S. Department of Housing and Urban Development • Community Planning and Development
Common Issues: Compliance & Telling HUD Your Story
Page by:Grantee: NAGrant Number: B-09-XX-XX-0015
Activity Number Activity Type National Objective Metrics Activity Budget Activity Obligation Activity Disbursements Activity Expenditures
1 Administration $3,439,000.00 $3,439,000.00 $1,624,453.92 $1,621,780.331.2 Administration $555,253.00 $555,253.00 $130,874.16 $85,598.891.3 Administration $400,000.00 $400,000.00 $0.00 $0.00
2.1Rehabilitation/reconstruction of residential structures $416,250.00 $416,250.00 $393,875.55 $413,250.00
2.2Rehabilitation/reconstruction of residential structures $4,694,465.00 $4,694,465.00 $3,235,631.10 $3,762,064.05
2.3 Rehabilitation/reconstruction of residential structures
$1,891,300.00 $1,891,300.00 $1,702,001.00 $1,702,001.00
2.4Rehabilitation/reconstruction of residential structures $3,700,000.00 $2,850,000.00 $806,278.28 $2,821,267.29
3Rehabilitation/reconstruction of residential structures $11,310,953.00 $8,405,100.00 $5,556,268.06 $7,330,229.68
4 Clearance and Demolition $4,000,000.00 $2,423,000.00 $2,129,638.00 $2,129,638.00
5 Rehabilitation/reconstruction of residential structures
$508,750.00 $508,750.00 $481,403.45 $508,750.63
5.2Rehabilitation/reconstruction of residential structures $5,094,555.00 $3,774,555.00 $2,154,138.86 $2,154,138.82
5.3.a Rehabilitation/reconstruction of residential structures
$5,500,000.00 $647,125.00 $243,235.00 $423,494.00
5.4 Rehabilitation/reconstruction of residential structures
$2,005,051.00 $2,005,051.00 $1,602,807.48 $1,602,807.48
$43,515,577.00 $32,009,849.00 $20,060,604.86 $24,555,020.17
LH25% Check $15,785,765.00 50% Expenditure Check 56%[=(E10+E11+E12+E17)/E21)] 36% [=H21/E21]
NSP Only - LMMI
N/AN/A
Fin Rept07b: CUM - Cumulative Data - Activity Level by Resp Org, Act Type and Nat Obj
N/A
NSP Only - LMMI
NSP Only - LH - 25% Set-AsideNSP Only - LH - 25% Set-AsideNSP Only - LH - 25% Set-Aside
Total
NSP Only - LMMI
NSP Only - LMMI
NSP Only - LMMI
NSP Only - LH - 25% Set-Aside
NSP Only - LMMI
Common Issues: Compliance & Telling HUD Your Story
• Program income works on a first-in, first-out basis. It must be used before drawing down additional grant funds, unless the program income is in an approved revolving fund.
48 U.S. Department of Housing and Urban Development • Community Planning and Development
Project/Activity Budget = Program Funds + Estimated Program Income
Program Income in NSP Policy Alert
49 U.S. Department of Housing and Urban Development • Community Planning and Development
Common Issues: Compliance & Telling HUD Your Story Do your total funds drawn = Program Income Funds + Grant
Funds Disbursed
Is there Program Income on hand for your next draw? Fin Rept05b: CUM - Program Income - Activity LevelPage by:Grant Status: ActiveGrantee: NAGrant Number: B-08-XX-00-0000
Project Number Project Title Activity
NumberResponsible Organization
Grant Funds Budgeted
Grant Funds Obligated
Grant Funds Disbursed
Program Income Received
Program Income Disbursed
AdminCity $5,629,647.28 $5,629,647.28 $3,523,307.39 $1,372,864.91 $1,076,793.28AdminSubA $1,051,279.00 $1,051,279.00 $735,301.94 $325,639.07 $118,077.72B-SubA LH25 $462,373.00 $462,373.00 $33,575.97 $0.00 $0.00B-SubA LMMI $384,232.66 $384,232.66 $246,652.56 $0.00 $114,232.66
B-SubB LH25 $163,228.00 $163,228.00 $43,009.86 $0.00 $24,207.49
E Redevelopment E-SubB LH25 SubB $824,000.00 $824,000.00 $288,419.99 $0.00 $69,955.66Total $8,514,759.94 $8,514,759.94 $4,870,267.71 $1,698,503.98 $1,403,266.81
SubASubA
SubB
Admin Administration CitySubA
BAcquisition/Rehabilitation
Common Issues: Adjusting Budgets 1. I want to combine two Activities in DRGR
(Acquisition & Rehab) as I accidently set them up separately, but I’m afraid to make the changes in DRGR.
2. Since DRGR does not separate out PI and PF for Project and Activity budgets, how can I keep of record for myself?
Note: The only place DRGR breaks out estimated PI/RLF is in the Edit Action Plan page.
50 U.S. Department of Housing and Urban Development • Community Planning and Development
Common Issues: Adjusting Budgets Use Financial Reports to map out changes to vouchers, obligations,
and budgets BEFORE making any real changes in DRGR. Fin Rept05b: CUM - Program Income - Activity Level
Page by: Example: Collapsing activity B-SubA LMMI into B-SubA LH25Grant Status: ActiveGrantee: NAGrant Number: B-08-XX-00-0000 (New Column Added)
Project Number Project Title Activity Number Project Budgets
Grant Funds Budgeted
Grant Funds Obligated
Grant Funds Disbursed
Program Income Received
Program Income Disbursed
AdminCity $5,629,647.28 $5,629,647.28 $3,523,307.39 $1,372,864.91 $1,076,793.28AdminSubA $1,051,279.00 $1,051,279.00 $735,301.94 $325,639.07 $118,077.72B-SubA LH25 $462,373.00 $462,373.00 $33,575.97 $0.00 $0.00B-SubA LMMI $384,232.66 $384,232.66 $246,652.56 $0.00 $114,232.66
B-SubB LH25 $163,228.00 $163,228.00 $43,009.86 $0.00 $24,207.49
E Redevelopment E-SubB LH25 $824,000.00 $824,000.00 $824,000.00 $288,419.99 $0.00 $69,955.66Total $7,463,480.94 $8,514,759.94 $8,514,759.94 $4,870,267.71 $1,698,503.98 $1,403,266.81
B-SubA LH25 $462,373.00 $462,373.00 $33,575.97 $0.00 $0.00$114,232.66$246,652.56$394,461.19
B-SubA LMMI $384,232.66 $384,232.66 $246,652.56 $0.00 $114,232.66
Step 1: Check to make sure the LH25 budget is large enough Step 2: Revise PI Voucher and move to LH25Step 3: Revise PF Vouchers and move to LH25Step 3: Decrease ObligationStep 4: Decrease BudgetStep 5: …..
B Acquisition/Rehabilitation
$5,629,647.28Admin Administration
$846,605.66
$1,009,833.66
Common Issues: Adjusting Budgets
52 U.S. Department of Housing and Urban Development • Community Planning and Development
Track Program Funds vs. Program Income for activity and project budgets using a MODIFIED Financial Report.
Fin Rept05b: CUM - Program Income - Activity LevelPage by: Total Grant Funds $7,323,734.00Grant Status: Active Projected PI/RL Funds $75,000.00Grantee: NA Total Budget Amount $7,398,734.00Grant Number: B-08-XX-00-0000
Project Number Project Title Activity
Number Activity Title MetricsProjected PI by Project Original Project Budget
Total Project Budget
Projected PI by Activity
Original Activity Budget
Total Activity Budget
AdminCity $462,373.00 $462,373.00
AdminSubA $270,000.00 $270,000.00
B-SubA LH25 $75,000.00 $1,051,279.00 $1,126,279.00
B-SubA LMMI $4,552,854.00 $4,552,854.00
B-SubB LH25 $163,228.00 $163,228.00
E Redevelopment E-SubB LH25 $0.00 $824,000.00 $824,000.00 $824,000.00 $824,000.00
$75,000.00 $7,323,734.00 $7,398,734.00 $75,000.00 $7,323,734.00 $7,398,734.00
Enter Projected PI by Activity Here
Project Budgets Activity Budgets
Action Plan Page
Total
$5,767,361.00
$732,373.00
$5,842,361.00
$732,373.00
Sub B Redevelopment LH25
Admin AdministrationCity Administration
Sub A Administration
$75,000.00
$0.00
B Acquisition/Rehabilitation
Sub A Acq/Rehab LH25
Sub A Acq/Reb LMMI
Sub B Acq/Rehab LH25
Common Issues: Administrative Issues
1. Our voucher creator is going to be out of the office and the I need to know if there is a back up and if so, who?
2. I would like to check the user access and certification status before a big draw to make sure we don’t get locked out again.
53 U.S. Department of Housing and Urban Development • Community Planning and Development
(Admin Rept04b Modified: USERS - Grantee Users with System Role and Certification Status)
Common Issues: Administrative Issues
54
Yes, there is a backup Drawdown Requestor and an additional Approver.
All users have been Recertified and are Active.
55 U.S. Department of Housing and Urban Development • Community Planning and Development
NSP Resource Exchange Links NSP Resource Exchange http://hudnsphelp.info
Search the Resource Library http://hudnsphelp.info/resources
Search the FAQs http://hudnsphelp.info/faqs
View All Training Materials on the Learning Center http://hudnsphelp.info/learning
Submit a Policy Question via Ask A Question http://hudnsphelp.info/question
Request Technical Assistance http://hudnsphelp.info/RequestTA
Connect with NSP
Join the Listserv http://hudnsphelp.info/listserv
Visit the NSP Flickr Gallery http://www.flickr.com/photos/nspresourceexchange
Visit the NSP YouTube Channel http://www.youtube.com/user/NSPResourceExchange
Please Give Us Your Feedback
• Answer a few short questions • Link: http://www.surveymonkey.com/s/ReportsModule
56 U.S. Department of Housing and Urban Development • Community Planning and Development