BHT Deposit and Credit Settlement Detail Report

The BHT Deposit and Credit Settlement Detail report gives billing and finance staff a single-row view, per admission (BHT), of the complete money picture for an inpatient stay: money the patient paid in — split into deposits, payments, and post-final-bill payments — amounts billed and settled to credit companies (insurers), and the patient's remaining outstanding balance.

It replaces the need to check deposits, payments, post-final payments, and credit settlements separately for a single BHT.

Note (issue #23258): this is the per-BHT financial breakdown formerly documented under the "Summary" report title. The report content did not change — only which page title it's shown under, to match what users expect from a "Detail" report versus the plain payment log now shown on the Summary report.

Note (issue #23262): the inpatient Billing panel has three separate money-in buttons — Make a Deposit, Make a Payment, and Post Final Payment — and this report previously did not keep them apart: Make a Payment amounts were shown under the Deposit columns, and genuine Make a Deposit amounts were not shown at all. The report now has three distinct column groups — Deposit, Payment, and Post Payment — each broken down Cash / Card / Credit / Other, followed by a Grand Total column summing all three.

Note (issue #23262 retest): the on-screen summary line that used to appear below the table ("Grand Total Deposits: … Grand Total Payments: … Grand Total Post Payments: … Grand Total Credit Settlements: …") duplicated figures already shown in the Total Deposits, Total Payments, Total Post Payments, and Credit Settled column footers — and it broke the Excel and PDF exports, appearing as an extra unlabeled row with a single raw, unformatted number after the real data. It has been removed; all four totals remain visible via their column footers, and both exports now end cleanly at the totals row.

Note (issue #23541): a cancelled Make a Deposit or Make a Payment transaction is now correctly reflected in Total Deposits / Total Payments as a net-zero pair (the original amount plus its reversal), matching how a cancelled Post Final Payment already worked. Previously, a cancelled deposit/payment was excluded from the underlying query on both sides at once — this didn't change the totals shown here (they already excluded it), but it did mean the transaction left no trace on the line-level Summary report, which now shows it.

Where to Find It

Inward → Reports → Payment Reports → BHT Deposit and Credit Settlement Detail

Filters

Filter	Description
From / To	Date range for the report
Date Basis	Filter by Admission Date or Discharge Date
Admission Status	e.g. Discharged and final bill completed, currently admitted, etc.
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)

Click Generate to run the report.

Report Columns

The report shows one row per BHT (admission). Money the patient paid in is split into three column groups by which Billing-panel button recorded it:

Deposits — recorded via the Make a Deposit button (advance money held against the stay):

• Deposit Cash
• Deposit Card
• Deposit Other
• Total Deposits

Payments — recorded via the Make a Payment button (payment toward the bill, taken any time during the stay):

• Payment Cash
• Payment Card
• Payment Credit
• Payment Other
• Total Payments

Post Payments — recorded via the Post Final Payment button (settling a due balance after the final bill is confirmed):

• Post Payment Cash
• Post Payment Card
• Post Payment Credit
• Post Payment Other
• Total Post Payments

Grand Total — Total Deposits + Total Payments + Total Post Payments (every money-in stream for the BHT).

Credit (Insurance) — amounts billed to and settled by a credit company:

• Total Credit Billed — the amount invoiced to the credit company
• Credit Settled — the amount the credit company has actually paid so far
• Credit Balance — Total Credit Billed minus Credit Settled (what the insurer still owes)
• Credit Company — name(s) of the credit company/companies billed for this admission

Bill and Balance:

• Final Bill No

• Total Bill Value — the final bill amount for the admission

• Total Balance — what the patient still owes:

  Total Balance = Final Bill Value − (Total Deposits + Total Payments + Total Post Payments + Total Credit Billed)

  Once an amount is billed to a credit company it is treated as no longer the patient's responsibility, even if the insurer hasn't paid it yet — that outstanding amount shows up in Credit Balance, not in Total Balance.

Column totals — including the deposits/payments/post-payments/credit-settled grand totals — are shown in the table footer, one value per column.

Configure Columns

(Issue #23515) Some hospitals don't need every column above. A collapsible Configure Columns panel sits directly above the results table, with one checkbox per column. Unchecking a column hides it immediately; the choice is saved automatically per user (no "Save" button) and is remembered the next time you open this report.

Every column visible — the default state.

Same report with "Post Payment Other" and "Credit Company" unchecked via Configure Columns — both columns and their footer totals disappear, 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, including the column-footer totals.

Example

One BHT with Rs 5,000 recorded via Make a Deposit (Deposit Cash) and Rs 5,000 via Make a Payment (Payment Cash 3,000 + Payment Card 2,000). The two are shown in separate column groups; Grand Total is Rs 10,000.

Exporting

Results can be exported using the buttons above the results table:

• Print
• Excel
• PDF

Excel and PDF exports mirror the on-screen table exactly, including the column-footer totals row — there is no extra summary row beyond it.

PDF export after the fix — the last data row is followed directly by the totals row (Deposit 4,272.00 / Payment 2,500.00 / Post Payment 600.00 / Grand Total 7,372.00, etc.), matching the on-screen column footers.

Related Reports

• BHT Deposit and Credit Settlement Summary — the line-level payment log behind this report (one row per individual deposit, payment, post payment, or credit settlement transaction).
• BHT Deposit Detail — a separate, simpler line-level report (one row per transaction) filterable by deposit, payment, or post-final-payment type, without the credit-company/balance columns shown here.

Note: The older BHT Deposit Summary report has been retired, as this report now covers its use case along with post-final payments and credit billing/settlement.