# BHT Deposit Detail Report The **BHT Deposit Detail** report gives billing and finance staff a line-level view of individual inpatient money-in transactions — one row per payment, rather than one row per BHT. It answers "which cash/card/other payments came in for this ward/date range, and who received them", which the per-BHT [BHT Deposit and Credit Settlement Detail](Inward-BHT-Deposit-and-Credit-Settlement-Detail-Report) report doesn't show directly. > **Note (issue [#23680](https://github.com/hmislk/hmis/issues/23680)):** the > report originally covered only **Make a Deposit** transactions > (`BillTypeAtomic.INWARD_DEPOSIT`). It now has a **Report Type** filter so > the same report and column layout can also show **Make a Payment** > transactions (`INWARD_PAYMENT`) or **Post Final Payment** transactions > (`POST_FINAL_BILL_INWARD_PAYMENT`), or all three combined — and a > **Configure Columns** panel to hide columns a hospital doesn't need. > **Note (issue [#23825](https://github.com/hmislk/hmis/issues/23825)):** > **Admission Status** and **Report Type** now both default to **Any > status** / **All** on first navigation — the previous defaults > (**Discharged and final bill completed** / **Inpatient Deposits**) silently > excluded real payments belonging to admissions still awaiting a completed > final bill. **Date Basis** gained a **Payment Date** option. **Bill No** is > now the first column, and rows sort by Bill No. The results table also > shows a separate amount column per payment method actually present in the > results (e.g. **Cash**, **Credit Card**), alongside the existing single > **Payment Method** column. ## Where to Find It **Inpatient → Inpatient Analytics → Payment Reports → BHT Deposit Detail** ## Filters | Filter | Description | |---|---| | From / To | Date range for the report | | Date Basis | Filter by **Admission Date**, **Discharge Date**, or **Payment Date** (the date the payment itself was recorded) | | Admission Status | **Any status** (default), or restrict to e.g. Discharged and final bill completed, Admitted but not discharged | | Admission Type | Restrict to a specific admission type, or leave as **All** | | Payment Method | Restrict to a specific payment method, or leave as **All Methods** | | Institution | Restrict to a specific institution, or leave as **All Institutions** | | Site | Restrict to a specific site, or leave as **All Sites** | | Department | Restrict to a specific department, or leave as **All Departments** (list narrows based on the Institution/Site chosen) | | Report Type | **All** (default — all three transaction types combined), **Inpatient Deposits** (money recorded via **Make a Deposit**), **Inpatient Payment** (money recorded via **Make a Payment**), or **Post Final Bill Payments** (money recorded via **Post Final Payment** to settle the balance due after the final bill is confirmed). A deposit or deposit refund made after the final bill, such as returning an excess deposit, is still a deposit and is listed under **Inpatient Deposits**, not here | Click **Generate** to run the report. ![BHT Deposit Detail report with the default Inpatient Deposits report type, five deposit rows for a ward with recent admissions](images/23680-bht-deposit-detail-report-type-filter.png) *Default **Inpatient Deposits** report type — the Report Type filter sits at the end of the filter grid; patient names redacted.* ![BHT Deposit Detail filter panel on fresh navigation, showing Admission Status as Any status and Report Type as All, and the results header row with Bill No first followed by per-payment-method columns Cash, Credit Card, Online Settlement](images/23825-bht-deposit-detail-defaults-and-columns.png) *Fresh navigation (issue [#23825](https://github.com/hmislk/hmis/issues/23825)): **Admission Status** = Any status, **Report Type** = All by default; results header shows **Bill No** first, then per-payment-method columns.* ## Report Columns One row per individual payment transaction: - Bill No - BHT No - Patient Name - Admission Type - Admitted - Discharged - Date / Time - Payment Method - Amount - One column per payment method actually present in the results (e.g. **Cash**, **Credit Card**) — each row's amount appears only under its own method's column, blank otherwise - Reference No Rows are sorted by Bill No. The footer shows a running total per payment method plus a **Grand Total**. ## Configure Columns *(Issue [#23680](https://github.com/hmislk/hmis/issues/23680))* A collapsible **Configure Columns** panel sits directly above the results table, with one checkbox per column above. Unchecking a column hides it immediately — on the screen table and in **Print**, **Excel**, and **PDF** alike; the choice is saved automatically per user (no "Save" button) and remembered the next time this report is opened. At least one column must always stay visible. ![BHT Deposit Detail report with the Configure Columns panel expanded, all ten column checkboxes checked](images/23680-bht-deposit-detail-configure-columns.png) *Configure Columns expanded — every column checked (the default state); patient names redacted.* ## Report Type Examples Switching **Report Type** re-runs the same query against a different `BillTypeAtomic`, keeping every other filter and the column layout unchanged: ![BHT Deposit Detail report with Report Type set to Inpatient Payment, showing one Make a Payment transaction](images/23680-bht-deposit-detail-inpatient-payment.png) *Report Type = **Inpatient Payment** — shows a payment recorded through the inpatient **Make a Payment** screen (Payments → Cash → Cash For Receive → Inward Deposite → Payment); patient name redacted.* ![BHT Deposit Detail report with Report Type set to Post Final Bill Payments, showing one Post Final Payment transaction](images/23680-bht-deposit-detail-post-discharge-payments.png) *Report Type = **Post Final Bill Payments** (labelled *Post Discharge Payments* before October 2026) — shows a payment recorded through the **Post Final Bill Payment** screen (Payments → Payment Management → Post Final Bill Payment → Payment) after the final bill was confirmed; patient name redacted.* Choosing **All** combines rows from all three transaction types into one list and one set of footer totals. ## Exporting Results can be exported using the buttons above the results table: - **Print** - **Excel** - **PDF** All three exports reflect only the columns currently checked in **Configure Columns**. ## Related Reports - [Combined Inward Payments Report](Inward-Combined-Payments-Report) — deposits, payments, post-final-bill payments and their refunds in one report, with Summary, Grouped and Details views - **[BHT Deposit and Credit Settlement Detail](Inward-BHT-Deposit-and-Credit-Settlement-Detail-Report)** — one row per BHT (admission), with the full deposit/payment/post-payment/credit breakdown, rather than one row per transaction. - **[BHT Deposit Detail with Credit Companies](Inward-BHT-Deposit-Detail-with-Credit-Companies-Report)** — a separate, Coop-specific sibling report with an extra Credit Companies column; this report is unaffected and unchanged by it.