Finance Professional Other Fee Summary Report - hmislk/hmis GitHub Wiki
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 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
Main Menu → Inward → Inpatient Analytics → BHT Summary Reports tab → Professional & Other Fee Summary
(See Inpatient Analytics for the full report index this lives in.)
Generating the Report
- Navigate to
inward/inward_report_professional_fee_summary.xhtml. - Set the From / To date range.
- Choose the Date Basis — Admission Date or Discharge Date — depending on whether you want admissions that started or ended in the date range.
- Choose the Admission Status filter:
- Admitted but not discharged
- Discharged but final bill not completed
- Discharged and final bill completed (default)
- Any status
- Optionally narrow by Admission Type, Payment Method, Institution, Site, or Department.
- Click Generate.
- 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 | Consultant charges only, net of any discount/service charge applied specifically to those charges |
| Other Fee Total | Everything else on the bill (admission fee, room charges, nursing, medicine, lab, assisting-staff/nursing fees, 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 |
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 consultant 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: Professional Fee Total is Consultant fees only. Assisting staff (nurses, junior doctors, etc.) fees are not counted as professional fees here — they fall under Other Fee Total instead, alongside room charges, medicine, lab, and everything else.
This matches how the report is meant to be read: "professional fee" means specifically what's owed to/charged for the consultant, not the whole clinical staff cost.
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, 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.
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 |