Financial Research Compliance Dashboard: Online Status by Department

1. Financial Research Compliance Dashboard: Online Status by Department Mike Amey Steve Hinnenkamp Johns Hopkins University

2. Overview and Purpose • Implemented 2010 • Improve compliance • Identify areas for training • Identify where increased staffing required

3. Metrics Overview • Financial Status Reports • Deficit and Cash Balances • Unbilled Revenue/Stale Unbilled Revenue • Payroll and Non-Payroll Cost Transfers • Effort Reporting • Research Base and Effective Recovery Rates • Sponsored Funding • Score Cards/Report Cards

4. Financial Status Reports • Total outstanding at month-end • Completed on-time current month (%) • Completed on-time past 12 months (%) • Total outstanding by month due • Grants with outstanding FSRs, by due date • 50% reduction in outstanding FSRs

5. Deficit Balance • current balances • rolling twelve month average • Total expense less total revenue • Cash Balance • Cash collected calculated as: • Revenue – Unbilled Revenue – Open Invoices • Cash Balance = Total Expense - Cash Collected

6. Unbilled Revenue • Grant amount that needs to be invoiced. • As of month-end. • Revenue capped at the lesser of ITD expense or the absolute value of revenue budget. • Stale Unbilled Revenue • Amount of grant’s unbilled revenue that should have been billed • Dependent upon award billing schedule

7. Payroll Cost Transfers • Sponsored accounts only • Total and federal transfers fiscal year to date • Number and percent exceeding 90 days • Dollars transferred to sponsored accounts • Dollars transferred from sponsored accounts

8. Non-Payroll Cost Transfers • Sponsored accounts only • Total and federal transfers fiscal year to date • Number and percent exceeding 90 days • Dollars transferred to sponsored accounts • Dollars transferred from sponsored accounts

9. Effort Reporting • Faculty certify effort every 6 months • Non-Faculty certify effort quarterly • Metrics for three most recent periods • Percent of forms completed • Outstanding federal dollars on outstanding forms.

10. Research Base • Organized research, other sponsored activities and instruction • Increase/(Decrease) over prior fiscal year • F&A Effective Recovery • Current Fiscal Year • Increase/(Decrease) over prior fiscal year

11. Sponsored Funding • Remaining Awarded Balance • Remaining Future Year Support • Total Remaining Balance • Rolling Twelve Month Expenditures • Months Available • Remaining Awarded Balance/Rolling 12 month expenditure • Total Months Available • Total Remaining Balance/Rolling 12 month expenditures

12. Scorecards • Composite • Sponsored Funding • Cost Transfers • Payroll • Non-Payroll

13. Report Cards • Composite Report Card • Detailed Report Card

14. Detailed Report Card • Financial Status Reports • % completed on time • Payroll and Non-Payroll Cost Transfers • % completed within 90 days • Effort Reporting • % completed in 120 days • Deficit Balance • Quarterly deficit total / running 12 month expenditures

15. Office Overview • Java Programmer • Database Administrator • Systems Engineer • Other Initiatives • Salary and Headcount • Sr Management Dashboards

16. Architecture • JasperReports • Java Based Open Source BI Tool • Apache/Tomcat • Oracle

17. Data Sources and Load Schedule • SAP Extract • DMG Effort Reporting