220 likes | 393 Views
Bureau of Medicine and Surgery. Financial Spotlight Review Update M8 Portal / Quick links / Financial Spotlight Review: https://www.navmedfinancial.org. June 2012. Financial Spotlight Review (FSR).
E N D
Bureau of Medicine and Surgery Financial Spotlight Review Update M8 Portal / Quick links / Financial Spotlight Review: https://www.navmedfinancial.org June 2012
FinancialSpotlight Review (FSR) • Context - DoD is required to assert audit readiness for the Statement of Budgetary Resources (SBR) by the end of Fiscal Year 2014. As part of Navy Medicine’s audit readiness effort, the FSR Review was developed to quantify and measure significant business processes. • Purpose - To discuss the FSR metrics. • Outcome – An understanding of the FSR Metrics sources including standard operating procedure cross references to illustrate what can be done now at the field level to optimize the available resources and financial condition. FSR application is an online tool which provides command spotlights metric scorecard and helps to monitor regional and activity financial and business execution. FOR OFFICIAL USE ONLY
Financial Spotlight Review (FSR) • Metric Structures • Categories • Budgetary Resources • Accounts Receivable • Accounts Payable • Civilian Payroll • Contracting & Acquisitions • Purchase Card • Travel • Equipment Management • Command Level Testing (CLT)
Financial Spotlight Review (FSR) • Metrics Structures (Cont’d) METRIC INFO
Financial Spotlight Review (FSR) • Metric Views • Regional View • CUIC View • Metrics View – Scoring Details • Enterprise Trend Reports
Financial Spotlight Review (FSR) Metric Views (Cont’d) View page has the following features:
Financial Spotlight Review (FSR) Metric Views (Cont’d) - Regional View
Financial Spotlight Review (FSR) Metric Views (Cont’d) - CUIC View
Financial Spotlight Review (FSR) Metric Views (Cont’d) - CUIC View
Financial Spotlight Review (FSR) Metric Views (Cont’d) - Scoring Details
FSR Processing • Data Load and Update • Receiving data from source • Parsing • Validation • Load to Spotlight database • Update • Twice a week: • Tuesday: 4:00pm ~ 4:30pm • Friday: 4:00pm ~ 4:30pm
Financial Spotlight Review (FSR) • Access FSR • BUMED M8 Portal / Quick links / Financial Spotlight Review: • https://www.navmedfinancial.org • MONTH USER COUNT USER VISITS • OCT11 184 • NOV11 180 • DEC11 79 190 • JAN12 157 642 • FEB12 134 568 • MAR12 134 471 • APR12 167 594 • MAY12 131 531
Metrics – Audit Readiness • “Green” result demonstrates that the Activity/ Region is meeting the DoD / Navy / BUMED Standard • “Yellow” / “Red” indicate improvement is needed • Color indicates degree of work needed • Metrics relate directly to performance and audit readiness • “Green” represents financial audit health FOR OFFICIAL USE ONLY
Areas Needing Major Improvement • Top 5 Issues • Liquidated Obs > $25K • Unable to Locate Equipment • Equipment Maintenance • Timesheet • Travel Debt Uncollected • Other Issues • Per Serv Contr Fill Rate • Purchase Card Trans Acct Errors • Purchase Card Usg Rate • Delinquent A/R FOR OFFICIAL USE ONLY
Areas Needing Some Improvement • Issue • Current FY Execution to Annual Plan • OCOOblg Rates • Current FY WII/TBI&PH/PDHRAOblg Rates • Deobligations: Deoblg/Oblg • Liquidated Obligations • Third Party Collections • Data Quality • Unmatched Cash Trans • Contract Recording Errors • Appr Assignment of Acq Priorities • Non-DTS Orders Issued • Split Disbt Rate for the Last Billing Cycle FOR OFFICIAL USE ONLY
Areas Going Well • Issue • Interest Penalties • Undelivered Orders • Delinquent Purchase Card Accts • Inappropriate use of the Purchase Card • Delinquent Travel Card Accts FOR OFFICIAL USE ONLY
Improvements • New Addition: • Enterprise Trend Reports and Charts • Proposed Improvement: • Addition of a Q&A Section FOR OFFICIAL USE ONLY
Q&A • Questions FOR OFFICIAL USE ONLY