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 report doesn't show directly.

Note (issue #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): 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

Inward → Admissions → 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 Discharge Payments (money recorded via Post Final Payment, after the final bill is confirmed)

Click Generate to run the report.

Default Inpatient Deposits report type — the Report Type filter sits at the end of the filter grid; patient names redacted.

Fresh navigation (issue #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) 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.

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:

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.

Report Type = Post Discharge Payments — 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 — deposits, payments, post-final-bill payments and their refunds in one report, with Summary, Grouped and Details views

• BHT Deposit and Credit Settlement Detail — 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 — a separate, Coop-specific sibling report with an extra Credit Companies column; this report is unaffected and unchanged by it.