# 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](Finance-Cashier-Summary-Reports.md), [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal.md) |