Role:Owner

Excel Data Extraction & Intelligence Center

AI Powered Ingestion

Automatic sheet detection, column synonym recognition, fuzzy doctor matching & Excel-to-DB reconciliation

Drag and drop your hospital doctor payout Excel file here

Supports .xlsx, .xls, .csv with formulas, multiple sheets, and summary pivot totals

Intelligent Monthly Excel Ingestion Engine

1Structure & Synonym Detection

Recognizes "Payment To", "Dr. Share", "IPD-CASH/INSURANCE", "IPD-CGHS" across diverse formats.

2Doctor Matching & Cleaning

Normalizes "DR ADITYA BHATI" to canonical "Dr. Aditya Bhati" at 99%+ confidence score.

3Grand Total Exclusion & Reconcile

Excludes pivot summary rows from doctor records while verifying total sum balance.

Natural Language Hospital Payout Query

Ask questions on doctors, historical ledger totals, TDS, and scheme distributions

Suggested Questions: