---
title: "Reports and MIS"
description: "Reference for all MIS reports — financial status, debtors, creditors, current assets, patient statistics, consultant activity, stock and GST, cloud functions, and payable dues."
date: 2026-07-19
lastModified: 2026-10-21
category: "reports"
author: "Dr. Umesh Bilagi"
beta: false
---

## Overview

All MIS reports are accessed from a single landing page. There are no individual report links in the sidebar.

**Sidebar → MIS Reports** (`/admin/mis-reports`)

The landing page organizes reports into cards by category. Each link opens the report in a new browser tab, pre-filtered to today's date or the current month where applicable. Dates and months are taken from the hospital's IST calendar, so the links stay on today's date even just after midnight IST. Most reports are paginated tables; some include Google Charts visualizations.

## Beta reports

A new beta MIS section is available alongside these reports. It contains a revenue cockpit, Financial Status, Debitors, Daily Collection, Leakage audit, Profitability, Item sub-head revenue, a Month-end accounting pack and Admission/OPD Month Wise, with exact totals, aging, IST-aware dates and full-result CSV exports. Opening **MIS Reports** offers a choice between the old reports and the beta section. See [MIS Reports (Beta)](/docs/mis-reports-beta) for what each figure means and which figures differ from the old pages.

The **clinical department** chosen when an OPD visit or admission is registered appears only in the beta section — Month wise and Daily Collection show it and let you filter by it. The reports listed on this page do not group by it. Do not confuse it with an **item sub-head**, which is the category and sub-head on the item master.

## Status

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Financial Status** | Overall financial health — receivables, payables, and cash position with pie/bar charts and tables | Current snapshot |

## Current Assets

Reports on cash, digital, and bank positions plus daily collection and transaction breakdowns.

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Cash In Hand** | Cash account balance and transaction list | Current balance, paginated |
| **Digital** | Digital payment account balances and transactions | Current balance, paginated |
| **Bank** | Bank account balances and transactions | Current balance, paginated |
| **Patient Item SubHead Wise Daily OPD Report** | OPD revenue broken down by item subhead for the day | Date (default: today) |
| **Patient Item SubHead Wise Daily IPD Report** | IPD revenue broken down by item subhead for the day | Date (default: today) |
| **Patient Wise Daily Collection** | Collections received per patient for the day | Date (default: today) |
| **OPD Daily Collection** | Collections from OPD encounters specifically | Date (default: today) |
| **Admission Daily Collection** | Collections from IPD admissions specifically | Date (default: today) |
| **Daily Collection** | All collections across all encounter types for the day | Date (default: today) |

## Creditors

Revenue and transaction reports grouped by consignee, item, and patient.

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Consignee Month Wise report** | Revenue share payable to consignees by month | Month and year |
| **PRM Doc Month Wise report** | Doctor-wise revenue from PRM referrals by month | Month and year |
| **Primary Consultant Revenue Insights: OPD and IPD Encounters** | Revenue attributed to each primary consultant across OPD and IPD. The invoice's Consultant wins when it is set; a cleared Consultant counts as **Hospital / direct**, otherwise the encounter's attending doctor is used | Year |
| **Itemwise Revenue Comparison Report** | Revenue comparison across billable items | Month and year |
| **Item SubHead report** | Revenue grouped by item subhead category | Start date, end date |
| **Item SubHead Month Wise Pivot report** | Pivot table of item subhead revenue per month | Month and year |
| **Item wise report** | Revenue for individual items | Start date, end date |
| **Patient Wise Daily Transaction** | All transactions per patient for the day | Date (default: today) |
| **OPD Daily Transaction** | OPD encounter transactions specifically | Date (default: today) |
| **Admission Daily Transaction** | Admission encounter transactions specifically | Date (default: today) |

## Debitors

Outstanding receivables.

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Patients** | Outstanding dues from patients — who owes money and how much | Paginated |
| **Payors** | Outstanding dues by insurance payor | Paginated |

## By Date (Patient Statistics)

Patient census and encounter counts.

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **OPD** | OPD patients for the selected date (ambulatory encounters) | Date (default: today) |
| **IPD in progress** | Currently admitted patients — in-progress inpatient encounters | None (live list) |
| **IPD by Event Date** | IPD patients by admission event date | Date (default: today) |
| **Virtual** | Virtual/teleconsultation encounters — listed separately from OPD, which shows ambulatory encounters only | Date (default: today) |
| **Admissions Month Wise** | Per-admission revenue, collection and balance for admissions active in the month — see [Admission & OPD Month Wise Reports](/docs/encounter-month-wise-reports) | Month and year |
| **OPD Month Wise** | Per-visit revenue, collection and balance for OPD visits active in the month | Month and year |

## Clinical Activity

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Consultant Activity** | Per-consultant OPD visits, admissions, and documents recorded for the period, alongside organisation-wide patient registrations and their ABHA-linkage — used to spot consultants who are not entering their work into NICE HMS | Period (daily / weekly / monthly / yearly) and date; top-N chart |

The report ranks consultants by recorded activity and adds an **Unattributed** row for activity not tied to any consultant, plus a daily OPD / admissions / documents trend. The selected **period** and **date** define a window (for example, monthly gives the whole month the date falls in); the page prints the exact dates covered. Choose how many consultants the chart shows (top 10, 20, 50, 100, or all).

## Stock and GST Reports

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Sale Detail Month Wise** | GST sales register with tax breakdown for the month (pharmacy invoices and credit notes) | Month and year — opening the card defaults to the current month in IST |
| **Hospital Stock** | Current hospital inventory stock levels per item with batch-wise breakdown | Category = Hospital |
| **Pharmacy Stock** | Current pharmacy inventory stock levels per item with batch-wise breakdown | Category = Pharmacy |
| **Expiry Stock** | Items approaching expiry within a configurable window | Interval in days (default: 90) |

## Cloud Functions

Usage and billing data from Google Cloud Functions.

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Month Wise** | Cloud function invocations aggregated by month | Year |
| **Year Wise** | Cloud function invocations aggregated by year | Year |
| **Patient Details** | Patient-level detail from cloud function logs | Start date, end date |

**Month Wise** and **Year Wise** load only after you pick a **year** from the dropdown — nothing is shown until then, and the page says so when the chosen year has no recorded data.

## Payable Dues

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Vendor Dues** | Outstanding payables to vendors — purchase invoices not yet paid | Paginated |

## Doctor Accounts

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Doctor Dues** | Outstanding dues payable to doctors — journal entries not yet settled | Paginated |

## Downloads

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Patients** | Downloadable patient list | From date, to date |

## PRM

Practice Relationship Management reports for referral tracking.

| Report | What It Shows | Filter |
|--------|--------------|--------|
| **Contact Visits By Days** | PRM contacts grouped by days-since-last-visit interval | Configurable days |
| **Receive Patient** | Patients received through PRM referrals | Paginated |

## FAQ

**Q: Is there a Day Book or Ledger report?**
A: Not in MIS Reports. Individual account ledgers are accessed through the Accounts module. See [Accounts Master](/docs/accounts-master).

**Q: Can I export reports to Excel?**
A: Reports are viewable as on-screen tables with print capability. Reports that offer a table download option (for example, **Admissions Month Wise**) can be saved as a CSV file that opens in Excel; there is no native `.xlsx` export.

**Q: How far back can I pull reports?**
A: All historical data is available. Use the date pickers or month/year filters on each report to select the period.

**Q: Who can access MIS reports?**
A: Access is controlled by role permissions. Admin and director roles typically have access to all reports. Accountants have access to financial reports.

**Q: How do I see pharmacy dispensing or lab test counts?**
A: Use **Item SubHead report** or **Item wise report** with the appropriate date range. For stock levels, use **Pharmacy Stock** or **Hospital Stock**. There are no separate pharmacy or lab-specific report pages.

**Q: Where do I find the IPD Console (current admissions)?**
A: Use the **IPD in progress** link under the By Date card. This shows all in-progress inpatient encounters with patient name, bed, and admission date.

## Related guides

- [Admission & OPD Month Wise Reports](/docs/encounter-month-wise-reports) — per-encounter revenue, collection and balance for the month
- [Accounts Master](/docs/accounts-master) — account ledgers behind the financial reports
- [Bill Transaction](/docs/bill-transaction) — invoices, receipts and credit notes