Module Deep-Dive: Billing & Revenue Cycle
Hands-on walkthrough of Bio Ecko's billing, insurance, and accounts modules -- from charge-sheet to settlement.
February 2026 · 18 min
Manual area
FC Training Programme
Coverage
8 sections
Operator notes
3 implementation notes
Why Billing Is the Backbone of Hospital Revenue
Every clinical activity eventually becomes a billable line-item. A Functional Consultant must understand the full revenue cycle -- from service charge capture through final settlement -- because configuration errors here directly impact hospital cash-flow.
Bio Ecko's billing engine sits at the intersection of OPD visits, IPD admissions, lab orders, radiology orders, pharmacy sales, and procedure charges. Every module writes to a shared billing_items table, and the billing module aggregates them into a final invoice.
Charge Master & Tariff Configuration
The charge master is the single source of truth for all service prices. Every billable service -- consultation, procedure, room rent, investigation, consumable -- maps to a row in the charge master.
| Concept | Bio Ecko Table | Key Fields | FC Task |
|---|---|---|---|
| Service Charges | service_charges | service_name, base_price, category, department | Configure per department |
| Room Tariff | room_types | type_name, daily_rate, icu_rate | Set up bed categories |
| Package Rates | packages | package_name, included_services, total_price | Bundle OT + room + meds |
| Doctor Fees | doctor_consultation_fees | doctor_id, fee_type, amount | Link to each practitioner |
| Discount Rules | discount_policies | policy_name, max_percent, approval_role | Define authority matrix |
Key FC tasks during implementation:
- Import the hospital's existing tariff book into
service_charges - Map each department's services to the correct category and GL code
- Validate package pricing ensures margin covers consumables and overhead
- Configure discount authority -- who can approve 5%, 10%, 20%, full waiver
Bill Generation Workflow
Understanding how a bill is assembled step-by-step:
- Charge Capture -- Each module (OPD, IPD, Lab, Radiology, Pharmacy, OT) writes line-items to
billing_itemswithencounter_id,service_code,quantity,unit_price - Bill Aggregation -- When the cashier opens the billing screen, all unbilled items for the patient are pulled and grouped by department
- Discount Application -- The cashier or billing manager applies any applicable discount (staff discount, senior citizen, package adjustment) with approval if above threshold
- Tax Calculation -- GST is auto-computed based on service category (exempt for healthcare services, applicable for cosmetic/non-medical)
- Invoice Generation -- A unique invoice number is generated, PDF is created with hospital header, GSTIN, and line-item breakdown
- Payment Collection -- Patient pays via cash, card, UPI, or insurance; payment is recorded in
paymentswith mode and reference number - Receipt Printing -- Official receipt with payment confirmation and balance due (if partial)
The FC must validate each step works correctly during SIT/UAT, especially the charge-capture accuracy from each upstream module.
Insurance & TPA Processing
Insurance billing is the most complex area and where FCs add the most value:
| Stage | Description | Bio Ecko Screen | Validation Point |
|---|---|---|---|
| Pre-Authorization | Submit patient policy + diagnosis to TPA for approval before admission | Insurance Pre-Auth form | Ensure policy number, sum insured, diagnosis code are captured |
| Claim Preparation | After discharge, compile final bill + discharge summary + investigation reports | Claim Preparation wizard | Verify all documents attached, ICD codes match |
| Claim Submission | Send to TPA via portal or manual upload | Claim Submission screen | Confirm TPA-specific format requirements met |
| Query Handling | TPA raises queries on missing documents or coding | Query Management panel | Track and resolve within SLA |
| Settlement | TPA approves partial/full amount; record settlement | Settlement Recording | Reconcile approved amount vs billed amount |
| Patient Balance | If TPA deducts, remaining balance billed to patient | Balance Bill generation | Auto-calculate co-pay and deductibles |
Common FC pitfalls:
- Not configuring TPA-specific discount agreements (each TPA has negotiated rates)
- Missing mandatory fields in pre-auth that cause rejections
- Not mapping hospital procedure codes to TPA's code list
Payment Modes & Reconciliation
Bio Ecko supports multiple concurrent payment modes on a single bill:
- Cash -- Physical currency; requires end-of-day cash drawer reconciliation
- Card (Credit/Debit) -- POS terminal integration; EDC settlement batch matching
- UPI -- QR-based payment; verify via transaction reference ID
- Insurance -- TPA-routed payment; settlement comes days/weeks later
- Advance/Deposit -- Patient pays upfront (common for IPD); adjusted against final bill at discharge
- Credit -- Corporate/government patients on credit terms; generates accounts receivable entry
Reconciliation checklist for FC validation:
- Daily cash collection report matches physical cash count
- Card settlements in ERP match POS terminal settlement report
- UPI payments have valid reference IDs captured
- Insurance receivables are tracked with aging report
- Advance adjustments deduct correctly from final bill
- Credit outstanding report shows correct patient-wise balances
Accounts Module & Financial Reports
The accounts module consumes billing data to produce financial statements:
- Daily Collection Report -- Cash, card, UPI, insurance collections broken down by department and payment mode
- Revenue Report -- Department-wise revenue, doctor-wise revenue, service-category-wise revenue
- Outstanding Report -- Unpaid bills, partial payments, insurance pending settlements
- Refund Report -- Track all refunds with approval chain audit trail
- Tax Report -- GST-exempt vs taxable services summary for filing
- MIS Dashboard -- Month-on-month trends, average revenue per patient, average bill value
FC configuration tasks:
- Map each service category to the correct GL (General Ledger) code for accounting integration
- Set up cost centers per department for P&L tracking
- Configure receipt numbering series (separate for cash, card, insurance)
- Define financial year and auto-carry-forward rules
Common Configuration Mistakes
Mistakes FCs commonly make in billing module setup:
| Mistake | Impact | Prevention |
|---|---|---|
| Duplicate services in charge master | Confusion, incorrect billing | Deduplicate during data migration, enforce unique service_code |
| Missing GST exemption flag | Tax charged on exempt healthcare services | Audit all services for correct tax category before go-live |
| Package not covering all items | Patient billed extra for included services | Cross-verify package inclusions with clinical team |
| Discount without approval workflow | Revenue leakage | Always configure approval matrix with role-based thresholds |
| Room rent not auto-charging daily | IPD patients underbilled | Verify cron job or nightly batch that auto-adds room charges |
| Advance not adjusting at discharge | Patient double-charged | Test advance-to-final-bill flow end-to-end in UAT |
Hands-On Exercise
Complete this exercise in the Bio Ecko demo environment:
- Create a new service in the charge master: "ECG -- 12 Lead" at INR 500, category Cardiology, GST exempt
- Create an OPD visit for a test patient and order the ECG
- Navigate to the billing screen and verify the ECG charge appears as an unbilled item
- Apply a 10% senior citizen discount (requires approval if above 5% threshold)
- Collect payment split: INR 225 cash + INR 225 UPI
- Print the receipt and verify both payment modes appear
- Check the daily collection report to confirm both entries
- Now create an insurance patient, submit a pre-auth, and process the claim lifecycle
Document any issues encountered and the steps to reproduce them. This forms the basis of your SIT defect log.
Notes
Warning
Never go live without a complete charge master audit. Missing or mispriced services are the #1 cause of post-go-live billing disputes and revenue leakage.
Tip
During UAT, ask the hospital's billing manager to bill 20 real-world scenarios (OPD, IPD, insurance, package, emergency, refund). Their domain expertise catches configuration gaps that test scripts miss.
Info
Bio Ecko auto-calculates GST only for non-exempt services. Healthcare services are exempt under GST, but cosmetic procedures, cafeteria, and ambulance services may be taxable -- configure the exemption flag per service.
Related topics
FC Training Programme
This training programme is designed to take a complete fresher -- someone with no prior healthcare or ERP background -- and transform them into a confident...
Module Walkthrough: IPD & Nursing
Hands-on walkthrough of Bio Ecko's inpatient modules -- Admission, Bed Management, Nursing Console, Diet Orders, OT Scheduling, and Discharge -- with...
Module Deep-Dive: Pharmacy & Inventory
Complete FC walkthrough of Bio Ecko's pharmacy dispensing, inventory management, stock control, and drug-master configuration.
Accounts Receivable
Accounts Receivable (AR) tracks all money owed to the hospital -- patient outstanding balances, insurance claim receivables, corporate credit accounts, and...
General Ledger
The General Ledger (GL) is the central accounting record for your organisation. Bio Ecko automatically posts journal entries from billing, payments...
OPD Visits
The OPD (Outpatient Department) area connects front-desk check-in to doctor review. In [Solo Doctor & Small Clinic](/solo-doctor-small-clinic), OPD starts as a...
Module Walkthrough: IPD & Nursing
Hands-on walkthrough of Bio Ecko's inpatient modules -- Admission, Bed Management, Nursing Console, Diet Orders, OT Scheduling, and Discharge -- with...
Module Deep-Dive: Pharmacy & Inventory
Complete FC walkthrough of Bio Ecko's pharmacy dispensing, inventory management, stock control, and drug-master configuration.