Using an Interactive Dashboard to identify Revenue Leaks
Care Process & Redesign
Technology
Singapore Healthcare Management Congress
SingHealth
31 December 2022
To analyze service consumption and revenue for abnormalities by leveraging charts from SAP reports to identify potential. Interactive dashboards facilitate continuous monitoring, revealing anomalies in service consumption and charges that can guide process.
Year Submitted: 2022
Published Date: 31 December 2022
Tags: Technology, Care Process ＆ Redesign, Digital Health, Data Management, Data Analytics, Data Visualization, Quality Improvement, Workflow Redesign, Lean Methodology, Job Effectiveness, Operational Management, Financial Management
About this Content
Aims
To analyze service consumption and revenue for abnormalities by leveraging charts from SAP reports to identify potential revenue leakage in community hospitals, including Sengkang Community Hospital (SKCH) and Outram Community Hospital (OCH).
Background
Monitoring is vital for detecting anomalies in billing due to system failures or oversights, e.g., a 2020 interface failure caused revenue leakage in radiology services.
Methods
Data reconciliation using SAP-ISH and FICO reports; consolidating into interactive dashboards; anomaly detection; fishbone analysis to identify root causes of revenue leaks; use of PDSA Cycle for continuous improvement.
Results
An interactive dashboard was developed for visualizing service charges and consumption patterns. Detected and addressed revenue anomalies such as trends in radiology service charges.
Conclusion
Interactive dashboards facilitate continuous monitoring, revealing anomalies in service consumption and charges that can guide process improvement.
Lessons Learnt
Visualization tools are effective detective measures, but timely detection remains challenging. Ensuring system integration and training minimizes revenue leaks.
Keywords
Interactive Dashboard, Revenue Leaks, Billing System
Innovators' Details
Innovators' Details
Healthcare Cluster(s) | SingHealth |
Organization(s) Involved | SingHealth Community Hospital |
Platform(s) | Singapore Healthcare Management Congress |
Healthcare Professional Group(s) | Healthcare Administration |
Applicable Specialty or Discipline | Healthcare Administrators |
Project Lead(s) | Adrian Ng |
Project Member(s) | Adrian Ng |
Connect with this contributor!
Adrian Ng - singaporehealthcaremanagement@singhealth.com.sg
Project Attachment
C_767_SCH_SHM_2022_Using_an_Interactive_Dashboard_to_Identify_Revenue_Leaks.pdf