Microsoft Excel Macro-based Automation of Accounts Receivables Process for Business Office (BO)
Care Process & Redesign
Technology
Singapore Healthcare Management Congress
SingHealth
31 December 2021
Automate a 19-step manual process for Accounts Receivables using Excel Macro. Excel Macro provides a robust and scalable solution for process automation in BO tasks.
Year Submitted: 2021
Published Date: 31 December 2021
Tags: Technology, Care Process ＆ Redesign, Digitisation, Automation, Quality Improvement, Productivity, Operational Management, Financial Management, Time Saving
About this Content
Aims
Automate a 19-step manual process for Accounts Receivables using Excel Macro.
Background
Manual processes in BO were time-intensive, error-prone, and involved multiple Excel sheets.
Methods
Created Excel Macro to replace manual tasks, tested retrospective data, and rolled out the final version.
Results
Reduced task completion time from 31.4 minutes to 0.5 minutes; revealed manual errors, saving significant time.
Conclusion
Excel Macro provides a robust and scalable solution for process automation in BO tasks.
Lessons Learnt
Automation boosts productivity, reduces errors, and can be shared department-wide for consistency.
Additional Information
SHM 2021 – Shortlisted Project (Finance Category)
Keywords
Microsoft Excel Macro, Automation, Accounts Receivables
Innovators' Details
Innovators' Details
Healthcare Cluster(s) | SingHealth |
Organization(s) Involved | Changi General Hospital |
Platform(s) | Singapore Healthcare Management Congress |
Healthcare Professional Group(s) | Healthcare Administration |
Applicable Specialty or Discipline | Healthcare Administrators |
Project Lead(s) | Srinath Sridharan |
Project Member(s) | Winnie Lau Wai King |
Connect with this contributor!
Srinath Sridharan / Winnie Lau Wai King - singaporehealthcaremanagement@singhealth.com.sg
Project Attachment
C535_CGH_SHM_2021_Microsoft_Excel_Macro_based_Automation_of_Accounts_Receivables.pdf