About the Client
C.C. Shroff Memorial Hospital is a renowned charitable, multi-specialty tertiary care center in Hyderabad. Established in 1976, the institution has served the community for over four decades, handling a complex mix of Critical Care, General Medicine, Nephrology, and Surgical departments.
With high daily footfall across Out-Patient Departments (OPD) and In-Patient Departments (IPD), the hospital processes thousands of transactions daily-ranging from pharmacy sales and diagnostic billing to complex insurance claims and government scheme (Aarogyasri) settlements.
The Challenge: The "Tally Trap"
Like many healthcare institutions in India, C.C. Shroff Hospital was relying on Tally Prime for its core accounting, while using a separate, legacy Hospital Management System (HMS) for patient billing. This operational disconnect created a "data silo" problem that threatened financial integrity.
Key Pain Points:
-
01.
Revenue Leakage & Reconciliation Nightmares
Every bill generated in the HMS had to be manually re-entered into Tally as a Journal Voucher. This manual process led to data entry errors, missed transactions, and significant delays in month-end closing.
-
02.
The Insurance Receivable Black Hole
Managing receivables from TPAs (Third Party Administrators) and Government schemes was chaotic. The finance team lacked real-time visibility into which claims were approved, rejected, or pending, leading to cash flow uncertainty.
-
03.
Audit & Compliance Risks
Statutory audits and GST filings were stressful, marathon events requiring weeks of manual data scrubbing to match the clinical data with the financial data.
The Solution: Unified ERP Architecture
Exalix Tech, in collaboration with HMS provider Techunison, architected a unified solution using ERPNext. We moved beyond simple data syncing; we integrated the financial nervous system of the hospital directly into the clinical workflows.
🧾
Automated Revenue Recognition
When a patient is billed in the HMS module, ERPNext automatically posts the corresponding Sales Invoice and Journal Entry in the General Ledger. No manual vouchers required.
🏢
Cost Center Accounting
Every department (Cardiology, Nephrology, Pharmacy) is mapped as a Cost Center. This allows the management to view a real-time Profit & Loss statement per specialty.
🚑
Insurance Lifecycle Mgmt
A dedicated workflow for TPA claims. Finance can track a bill from "Submission" to "Query Raised" to "Settlement" or "Write-off," ensuring accurate Accounts Receivable (AR) aging.
💊
Pharmacy Inventory & COGS
Unified stock valuation. Medicine consumption in wards is instantly reflected in the Cost of Goods Sold (COGS) and inventory valuation reports.
The Migration: Leaving Tally Behind
Migrating historical financial data from Tally to ERPNext is a precision task. Our team executed a "Zero Data Loss" migration strategy:
- Master Data Cleaning: We sanitized the Chart of Accounts, merging duplicate ledgers and standardizing Cost Center names.
- Opening Balance Import: We froze the Tally books on March 31st and imported verified Closing Balances as Opening Balances in ERPNext.
- Parallel Run: For 30 days, the finance team operated both systems. We wrote automated scripts to compare Trial Balances daily, ensuring ₹0.00 difference before going live.