Inward BHT Deposit Detail with Credit Companies Report - hmislk/hmis GitHub Wiki

BHT Deposit Detail with Credit Companies Report

The BHT Deposit Detail with Credit Companies report is a Coop-specific sibling of the BHT Deposit Detail report (issue #23770). It has the exact same filters, results table, and column layout as BHT Deposit Detail, plus one additional column — Credit Companies — that other hospitals using BHT Deposit Detail do not need, so this was built as a separate report page rather than a change to the original.

Where to Find It

Inward → Admissions → Inpatient Analytics → Payment Reports → BHT Deposit Detail with Credit Companies

What's Different From BHT Deposit Detail

Every filter, column, export button, and the Configure Columns panel work exactly as documented on the BHT Deposit Detail page. The only addition is the Credit Companies column at the end of the table.

Each row still represents a single inpatient payment transaction (Deposit, Payment, or Post Discharge Payment), same as BHT Deposit Detail. The Credit Companies column shows, for that row's admission, every credit company on the admission's confirmed Final Bill — not the payment method of the row itself. An admission can have more than one credit company (e.g. a primary insurer covering part of the bill and a secondary one covering the rest); the column lists each company on its own line within the cell:

Janashakthi Insurance: Due 28,175.05 / Paid 0.00 / Balance 28,175.05
  • Due — the amount committed to that credit company on the Final Bill.
  • Paid — the amount that credit company has actually settled so far.
  • Balance — Due minus Paid.

These figures match the same admission's row in the Credit Company Debtor Report (Inward → Admissions → Inpatient Analytics → Payment Reports → Credit Company Debtor Report) — both reports compute Paid the same way (summing settlement transactions rather than relying on a stored running total), so cancelled or superseded settlements are always reflected correctly.

If an admission has no credit company on its Final Bill (a fully self-paying patient), the column shows -.

Related Reports

  • BHT Deposit Detail — the original report this is a sibling of; used unchanged by hospitals that don't need the Credit Companies column.
  • Credit Company Debtor Report (Inward → Admissions → Inpatient Analytics → Payment Reports) — the per-company debtor view this report's Due/Paid/Balance figures are drawn from.