BHT Deposit and Credit Settlement Summary Report

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

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

Where to Find It

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

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).

Deposits — money the patient paid in during the admission, before the final bill:

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

Post-Final Payments — money the patient paid after the final bill was raised (e.g. settling a due balance):

• Post-Final Cash
• Post-Final Card
• Post-Final Other
• Total Post-Final Payments

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 Post-Final 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 are shown in the table footer, and grand totals for deposits and credit settlements are shown below the table.

Example

In the example above:

• BHT/55349 has no deposits or post-final payments, but Rs 12,000 was billed to credit companies (AIA Insurance Lanka PLC / Aitken Spence) and not yet settled. Total Balance is Rs 13,317.85 — the portion of the Rs 25,317.85 final bill not covered by deposits or credit billing.
• BHT/55351 has Rs 5,000 in post-final payments and Rs 25,100 billed to AIA Insurance Lanka PLC. Since deposits + post-final payments + credit billed (Rs 30,100) exceeds the Rs 25,100 final bill, Total Balance shows as -5,000.00 — an overpayment/credit in the patient's favor.

The Rs 5,000 post-final payment for BHT/55351 above was recorded via a Post Final Bill Payment, which prints a receipt showing the final bill total, amount paid previously, amount paid this time, and remaining balance:

Exporting

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

• Print
• Excel
• PDF

Related Reports

• BHT Deposit and Credit Settlement Detail — the line-level detail behind this summary (individual deposit, payment, and settlement transactions).

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.