# Professional & Other Fee Summary Report ## Introduction The **Professional & Other Fee Summary** report gives finance and admin staff a quick, per-admission answer to one specific question: *how much of this bill was the doctor's (consultant's) professional fee, and how much was everything else?* The [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal) already contains this data, but it's spread across a 16-column table (one column per charge type — Admission Fee, Room Charges, Medicine, Laboratory, and so on), which makes it slow to scan for just the professional-fee split. This report pulls that one comparison out into its own focused, three-column view: **Professional Fee Total**, **Other Fee Total**, and **Net Total**. ## Navigation Inward → **Inpatient Analytics** → **BHT Summary Reports** tab → **Professional & Other Fee Summary** (See [Inpatient Analytics](Inpatient-Analytics) for the full report index this lives in.) ## Generating the Report 1. Navigate to `inward/inward_report_professional_fee_summary.xhtml`. 2. Set the **From** / **To** date range. 3. Choose the **Date Basis** — Admission Date or Discharge Date — depending on whether you want admissions that started or ended in the date range. 4. Choose the **Admission Status** filter: - *Admitted but not discharged* - *Discharged but final bill not completed* - *Discharged and final bill completed* (default) - *Any status* 5. Optionally narrow by **Admission Type**, **Payment Method**, **Institution**, **Site**, or **Department**. 6. Click **Generate**. 7. Use **Print**, **Excel**, or **PDF** to export the results. The table can be wider than your screen — scroll horizontally within the results panel to see every column, or use Excel/PDF export for a full printable copy. ## Report Columns | Column | Description | |---|---| | BHT No | Bed Head Ticket / admission reference | | Patient Name | Admitted patient | | Admitted | Date of admission | | Discharged | Date of discharge | | Final Bill No | Reference of the confirmed final bill, if one exists yet | | Admission Type | e.g. BHT, OPD Card | | **Professional Fee Total** | Doctor's fees, net of any discount/service charge applied specifically to those charges. Whether assisting-staff fees are included depends on a hospital setting — see [What Counts as "Professional Fee"?](#what-counts-as-professional-fee) | | **Other Fee Total** | Everything else on the bill (admission fee, room charges, nursing, medicine, lab, etc.), net of any discount/service charge applied to those charges | | **Net Total** | Professional Fee Total + Other Fee Total — always equal to the admission's total net bill amount, and to the Net Total of the same admission in the [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal). A baby's or surgery's charges are included in the mother's row, and a still-admitted patient's room charges are calculated up to the moment you generate the report | A footer row totals every column, and a summary line below the table repeats the three grand totals. ## Sample Output Illustrative example — actual figures will reflect your own admissions: | BHT No | Patient Name | Admitted | Discharged | Final Bill No | Admission Type | Professional Fee Total | Other Fee Total | Net Total | |---|---|---|---|---|---|---:|---:|---:| | BHT/10234 | J. Perera | 02 Aug 26 | 04 Aug 26 | 1002345 | BHT | 8,000.00 | 22,500.00 | 30,500.00 | | BHT/10241 | S. Fernando | 05 Aug 26 | 06 Aug 26 | 1002378 | BHT | 0.00 | 6,250.00 | 6,250.00 | | OPDCARD/512 | N. Silva | 07 Aug 26 | 07 Aug 26 | 1002401 | OPD Card | 3,500.00 | 4,100.00 | 7,600.00 | | **Grand Total** | | | | | | **11,500.00** | **32,850.00** | **44,350.00** | The second row (S. Fernando) shows an admission with no doctor's fee at all — Professional Fee Total is 0.00 and the whole bill falls under Other Fee Total, which is expected for admission types that don't carry a separate consultant charge. ## What Counts as "Professional Fee"? This is the one thing worth understanding before relying on the report, and it depends on how your hospital is configured. **By default, Professional Fee Total is Consultant fees only.** Assisting staff (nurses, junior doctors, etc.) fees are *not* counted as professional fees — they fall under Other Fee Total instead, alongside room charges, medicine, lab, and everything else. Read this way, "professional fee" means specifically what's owed to/charged for the consultant, not the whole clinical staff cost. **If your hospital bills professional and assisting fees as a single charge, Professional Fee Total includes both.** Hospitals that do not separate the two enable the setting *"Professional Fee and Assisting Fees are shown as one charge type on the final bill."*, and the whole system then treats every inpatient doctor's fee as a professional charge: the Assisting Charge column disappears from the [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal), the final bill shows a single doctors' section, and this report counts assisting fees in Professional Fee Total rather than Other Fee Total. To tell which applies to you, check whether the Invoice Journal shows a separate Assisting Charge column for an admission that has assisting fees. If it does, the setting is off and the default above applies. ![Professional & Other Fee Summary for a hospital that merges professional and assisting fees, showing Professional Fee Total, Other Fee Total and Net Total per admission](images/23543-professional-fee-summary-merged.png) *With the merge setting enabled, the second row's Professional Fee Total of 13,000.00 includes a 6,000.00 assisting fee that would otherwise have fallen under Other Fee Total. Patient names redacted.* ## Use Cases ### Quick doctor-fee vs. hospital-fee split Finance staff reviewing a batch of admissions for revenue reporting can see at a glance what portion of each bill was the consultant's fee vs. the hospital's own charges, without opening the full Invoice Journal or the individual bill. ### Cross-checking against the Invoice Journal Because Net Total on this report is always Professional Fee Total + Other Fee Total, and both are built from the same underlying billing data as the [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal), the Net Total for a given admission should always match that admission's Net Total on the Invoice Journal. If the two ever disagree for the same admission and filters, that's worth reporting as a bug. ### Cancelled fees count as zero A cancelled professional fee or a cancelled service bill adds nothing to this report, so it never shows as a negative amount. Before issue [#24548](https://github.com/hmislk/hmis/issues/24548), a cancelled consultant fee made Professional Fee Total negative (for example −1,000.00). It now shows 0.00, the same as the Invoice Journal and the Interim Bill. ## Filtering Tips - Leave Admission Status on the default ("Discharged and final bill completed") for finalized-bill reporting; switch to "Any status" if you also want to see admissions still in progress. - Use a narrow date range for a single day's discharges when reconciling daily doctor-fee totals. - Export to Excel or PDF before sharing with someone who needs to scroll through many columns comfortably. ## Technical Reference | Item | Detail | |---|---| | Page | `inward/inward_report_professional_fee_summary.xhtml` | | Controller | `InwardProfessionalFeeSummaryController` | | Shared data service | `InwardBhtChargeAggregationService` (also used internally by the Inpatient Invoice Journal report) | | Export formats | Print, Excel, PDF | | Related report | [Inpatient Invoice Journal](Finance-Inpatient-Invoice-Journal) | [Back to Inpatient Analytics](Inpatient-Analytics)