1 / 17

Financial Research Compliance Dashboard: Online Status by Department

Financial Research Compliance Dashboard: Online Status by Department. Mike Amey Steve Hinnenkamp Johns Hopkins University. Overview and Purpose Implemented 2010 Improve compliance Identify areas for training Identify where increased staffing required. Metrics Overview

ipo
Download Presentation

Financial Research Compliance Dashboard: Online Status by Department

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related