Inward Combined Payments Report - hmislk/hmis GitHub Wiki
Combined Inward Payments Report
The Combined Inward Payments report lists every inpatient money movement for a period in one place: deposits, payments made during the stay, post-final-bill payments, and the refunds of all three. Each of these otherwise has its own search page; this report puts them side by side so a period can be reconciled in one view.
Where to Find It
Inward → Admissions → Inpatient Analytics → Payment Reports → Combined Inward Payments
Like every report on this page, it can be starred so it also appears on the ⭐ Favorites tab.
Filters
| Filter | Description |
|---|---|
| From / To | The date and time range. A bill is included when it was created within this range. |
| Department | Restrict to bills raised in one department, or leave as All Departments. |
| View | How the results are presented — see below. |
Click Generate Report after changing any filter, including the View.
Views
| View | What it shows |
|---|---|
| Summary | One line per bill type, with the number of bills, the amount received, the amount refunded and the net. No individual bills. |
| Grouped by Bill Type | The same per-type totals, followed by every bill listed type by type. |
| Grouped by BHT | Totals per admission (BHT), followed by every bill listed admission by admission — useful for "what did this patient pay and get back". |
| Details | Every bill in date order, with no grouping. |
Above the results, four figures summarise the whole period: Received, Refunded, Net and the number of Cancelled Bills.
How amounts are shown
- Money coming in (deposits, payments, post-final-bill payments) is shown as a positive amount.
- Refunds are shown as negative amounts on their own rows, so the Net figure and any column total are the true amount kept for the period.
- A cancelled bill is still listed, marked Cancelled in the Status column, but its amount is shown as 0.00 and it is left out of every total — a cancelled deposit or payment did not happen. Cancellation bills themselves are not listed separately.
Report Columns
| Column | Description |
|---|---|
| Date | When the bill was created |
| Bill No | The bill number |
| Type | Inward Deposit, Inward Payment, Post Final Bill Inward Payment, or the matching refund |
| BHT No | The admission the bill belongs to |
| Patient | Patient name |
| Payment Method | Cash, card, etc. |
| Amount | Signed amount — negative for refunds, 0.00 for cancelled bills |
| Status | Cancelled when the bill has been cancelled |
Exporting
Download as Excel appears once the report has been generated. It exports what the selected view shows:
- Summary exports the per-type totals table.
- Grouped and Details views export every bill, in the same order as on screen — all rows, not just the page currently displayed.
- In a Grouped view the workbook also has a second sheet, Totals, with the group subtotals and a grand total, as shown above the rows on screen.
Related Reports
- BHT Deposit Detail Report — one row per payment, with per-payment-method columns and admission-based filters
- Inpatient Bill Search and Reprint — the individual Payment, Deposit and Refund search pages