# Inpatient Income Category Report

## Introduction

The **inpatient income category report** shows inward (inpatient) revenue broken down by `InwardChargeType` — Room Charges, Nursing Charges, Investigation Charges, Pharmacy Charges, Surgery Charges, and others. It gives finance managers and department heads a clear view of where inpatient revenue originates and which charge categories are driving income.

## Navigation

Main Menu → Financial Reports → **Inpatient Income by Category**
OR
Main Menu → Inward → Reports → **Income Category Report**

## Generating the Report

1. Navigate to the income category report page.
2. Set the **date range** (From Date, To Date).
3. Select optional filters:
   - **Ward** — filter to a specific ward or all
   - **Charge Category** — all categories, or select specific InwardChargeType values
   - **Bill status** — Active, Cancelled, or both
4. Click **Generate**.

## Report Columns

| Column | Description |
|---|---|
| Charge Category | InwardChargeType label (Room, Nursing, Investigation, etc.) |
| No. of Bills | Count of bills containing charges in this category |
| No. of Patients | Distinct patient admissions with charges in this category |
| Gross Amount | Total billed amount before discounts |
| Discount | Discounts and adjustments applied |
| Net Amount | Gross − Discount |

## Common Charge Categories

| InwardChargeType | Description |
|---|---|
| RoomCharges | Daily bed rate, special room fees |
| NursingCharges | Nursing procedures, care fees |
| InvestigationCharges | Lab tests, radiology, ECG |
| PharmacyCharges | Medications issued from ward pharmacy |
| SurgeryCharges | OT, anaesthesia, surgeon fees |
| PhysiotherapyCharges | Physiotherapy sessions |
| OtherCharges | Miscellaneous inpatient charges |
| OutsideCharges | External services added to BHT |

## Comparison Across Periods

To monitor trends:

1. Generate the report for the current month.
2. Generate again for the prior month.
3. Compare category totals — significant increases in specific categories may indicate higher patient acuity or new services.

## Ward-Level Breakdown

Filter by ward to see income category breakdown for a specific unit (ICU, Maternity, General Medicine, etc.). This is useful for ward-level budget reviews and staffing cost allocation.

## Exporting

Click **Export to Excel** to download the full report. The Excel file includes all category rows and the grand total.

## Technical Reference

| Item | Detail |
|---|---|
| Data source | `BillItem` joined to inward service with `InwardChargeType` |
| Charge type | `InwardChargeType` enum (~100+ values) |
| Related | [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal.md), [Service Department Revenue Report](Finance-Service-Department-Revenue-Report.md) |