Finance Service Department Revenue Report

Service Department Revenue Report

Introduction

The service department revenue report shows revenue broken down by the department that performed or ordered each service — Radiology, Laboratory, OPD Consultations, Surgery, Pharmacy, Physiotherapy, etc. It is used by department heads and finance managers to track departmental income, compare periods, and feed into budget review discussions.

Navigation

Main Menu → Financial Reports → Department Income OR Main Menu → Reports → Finance → Service Department Revenue

Generating the Report

1. Navigate to the department revenue report page.
2. Set the date range.
3. Select filters:
   • Department — all departments, or select one or more
   • Bill type — OPD, Inpatient, Pharmacy, All
   • Service category — optional further filter (Investigation, Procedures, etc.)
4. Click Generate.

Report Structure

Summary View (by Department)

Column	Description
Department	Department name
No. of Bills	Count of bills with services from this department
Gross Revenue	Total billed amount before discounts
Discounts	Discount amounts applied
Net Revenue	Gross − Discounts
Cash	Revenue collected in cash
Credit	Revenue billed to credit companies
Other	Other payment methods

Detail View (by Service within Department)

When you expand a department row or switch to detail view:

Column	Description
Service Name	Individual service or item
Quantity	Number of times the service was billed
Unit Price	Standard fee
Gross Amount	Quantity × Unit Price
Discount	Discount applied
Net Amount	Amount after discount

Inpatient Service Revenue

For inpatient billing, revenue is attributed to departments based on the InwardChargeType assigned to each service bill:

Charge Type	Department
InvestigationCharges	Laboratory / Radiology
NursingCharges	Nursing
PharmacyCharges	Pharmacy
SurgeryCharges	Theatre / Surgery
RoomCharges	Ward Administration

Exporting

Click Export to Excel to download the full report. The Excel format includes both summary and detail rows.

Comparing Periods

To compare departments across months:

1. Generate the report for the current month.
2. Generate again for the prior month.
3. Export both and compare in Excel, or use the built-in comparison view if available.

Technical Reference

Item	Detail
Data source	BillItem joined to Item (service master) and department
Charge type model	InwardChargeType enum for inpatient; item category for OPD
Related	Cashier Summary Reports, Inpatient Invoice Journal