Finance Professional Other Fee Summary Report

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

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	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

Back to Inpatient Analytics