Inpatient Professional Payment Report
An admission-grouped report showing every doctor/speciality professional fee charged on an inpatient admission, alongside how much of it has been paid — used to see at a glance which consultants are still owed money on which BHTs, filtered by date range or by a BHT-number range.
Page: Inward → Inpatient Analytics → Professional Payment Reports tab → Inpatient Professional Payment Report
XHTML: /inward/reports/inward_professional_payment_report_dto.xhtml
Controller: InwardReportControllerBht
Favorite key: inpatientAnalytics_professionalPaymentReport (star it from the Inpatient Analytics tab to also pin it to the ⭐ Favorites tab)
- Summary — one row per admission, per doctor+speciality combination: total fee added, total paid, and balance still owing.
- Detailed — the same grouping, but broken out one row per individual added-fee/paid-fee entry, with dates and payment bill numbers, plus a running total and balance per doctor.
Admissions with no professional fees at all still appear in the report (their fee columns show -), so a doctor's-fee gap on an admission isn't silently hidden — unless you tick List admissions without any professional fees, which flips the report to show only those admissions.
- Date Range — filter admissions using Date Basis (see below) plus From Date / To Date.
- BHT Range — filter by picking a From BHT and To BHT admission (autocomplete by BHT number); every admission with an internal ID between the two, inclusive, is included. Date Basis and Admission Type still narrow the results in this mode where applicable (Admission Type still applies; Date Basis fields are hidden and not used).
Controls which date on the admission the From Date/To Date range is matched against:
| Date Basis | What it filters on |
|---|---|
| Admission Date (default) |
PatientEncounter.dateOfAdmission — the original behavior before this filter existed |
| Discharge Date | PatientEncounter.dateOfDischarge |
| Final Bill Created Date | The admission's confirmed Final Bill's createdAt. Admissions with no final bill yet are excluded from the results under this basis — there's no bill-creation date to compare against. |
| Professional Fee Added Date |
BillFee.createdAt on the charge-side professional fee. Only admissions with at least one professional fee added inside the date range appear — an admission with fees but none added in that window won't show, even if the admission itself falls in range. |
Use Discharge Date to match the same date used on the interim-bill discharge calendar. Use Final Bill Created Date to reconcile against when the final bill was actually issued rather than when the patient was admitted or discharged. Use Professional Fee Added Date to find fees entered during a specific period regardless of when the underlying admission happened.
A dropdown to restrict the report to one admission type — BHT, OPD Card, or any other admission type configured for the hospital (e.g. CT Card) — or leave it on All to include every type. Useful for hospitals like Galle Co-Operative that admit patients under both a physical BHT and an OPD-card-based short admission, where the two need to be reported on separately.
| Column | Notes |
|---|---|
| BHT Number | The admission's BHT/OPD-card number |
| Admitted / Discharged | From the admission record |
| Final Bill Number | The admission's first confirmed final bill, if any |
| Consultant / Speciality | One row per doctor+speciality combination on the admission |
| Sum Added Fee | Total professional fee charged to this doctor+speciality on this admission |
| Sum Paid Fee | Total already paid against those charges |
| Balance to Pay | Added minus Paid |
The Detailed view adds per-entry Added Fee Date, Paid Date, Paid Bill Number, and per-line fee/paid values underneath each doctor+speciality block, with a Total and Balance to Pay row per doctor.
(Issue #23515) Some hospitals don't need every column on this report. Each of the Summary and Detailed views has its own Configure Columns panel — a collapsible "Configure Columns" bar directly above its table — with one checkbox per column. Unchecking a column hides it from that table immediately; the choice is saved automatically per user (no separate "Save" step) and is remembered the next time you open the report.
Detailed view with every column visible — the default state.
Same report with the "Comments" column unchecked via Configure Columns — the column disappears from the table and the remaining columns shift left.
Whichever columns you uncheck are omitted consistently from the on-screen table, Print, Excel, and PDF — all four surfaces always agree. The Summary and Detailed views remember their column choices separately, since they have different column sets.
Both Summary and Detailed views can be exported to Excel or PDF, or sent to Print, using the buttons above each table — these respect whichever filters (report type, date basis, admission type, etc.) were used for the on-screen results.
- Inpatient — Professional Payments Report — a different, per-admission page for holding/releasing individual professional fee payments, not to be confused with this analytics report despite the similar name