Hospital Reports & Audit Registers Hub (REPOMENU)
Consolidated registers: Inpatient lists, Monthly analysis, GST tax audit, and IT Act depreciation schedules
12-Month Comparative Hospital Revenue & Cash Flow Matrix
Comprehensive breakdown of IPD, OPD, Lab tests, Operating Expenses, and Net Surplus
| Month | IPD Billing (₹) | OPD Fees (₹) | Diagnostics (₹) | Deposits Held (₹) | Operating Expenses (₹) | Net Cash Surplus (₹) |
|---|---|---|---|---|---|---|
| Apr 2025 | ₹1,10,000.00 | ₹38,000.00 | ₹24,000.00 | ₹85,000.00 | ₹92,000.00 | ₹80,000.00 |
| May 2025 | ₹1,25,000.00 | ₹42,000.00 | ₹28,000.00 | ₹92,000.00 | ₹98,000.00 | ₹97,000.00 |
| Jun 2025 | ₹98,000.00 | ₹36,000.00 | ₹22,000.00 | ₹76,000.00 | ₹88,000.00 | ₹68,000.00 |
| Jul 2025 | ₹1,40,000.00 | ₹48,000.00 | ₹32,000.00 | ₹1,10,000.00 | ₹1,05,000.00 | ₹1,15,000.00 |
| Aug 2025 | ₹1,32,000.00 | ₹45,000.00 | ₹30,000.00 | ₹1,04,000.00 | ₹1,01,000.00 | ₹1,06,000.00 |
| Sep 2025 | ₹1,15,000.00 | ₹39,000.00 | ₹26,000.00 | ₹88,000.00 | ₹94,000.00 | ₹86,000.00 |
| Oct 2025 | ₹1,20,000.00 | ₹41,000.00 | ₹27,000.00 | ₹95,000.00 | ₹96,000.00 | ₹92,000.00 |
| Nov 2025 | ₹1,05,000.00 | ₹37,000.00 | ₹25,000.00 | ₹82,000.00 | ₹90,000.00 | ₹77,000.00 |
| Dec 2025 | ₹1,28,000.00 | ₹44,000.00 | ₹29,000.00 | ₹99,000.00 | ₹99,000.00 | ₹1,02,000.00 |
| Jan 2026 | ₹1,35,000.00 | ₹46,000.00 | ₹31,000.00 | ₹1,06,000.00 | ₹1,02,000.00 | ₹1,10,000.00 |
| Feb 2026 | ₹1,18,000.00 | ₹40,000.00 | ₹26,000.00 | ₹89,000.00 | ₹95,000.00 | ₹89,000.00 |
| Mar 2026 | ₹1,45,000.00 | ₹50,000.00 | ₹34,000.00 | ₹1,15,000.00 | ₹1,08,000.00 | ₹1,21,000.00 |
| Total Year FY 25-26: | ₹14,71,000.00 | ₹5,06,000.00 | ₹3,34,000.00 | -- | ₹11,68,000.00 | ₹11,43,000.00 |