Skip to content

Finance Inpatient Income Category Report

Dr M H B Ariyaratne edited this page May 22, 2026 · 1 revision

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, Service Department Revenue Report

Clone this wiki locally