# 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, the refunds of all three, and the cancellation of any of them. 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 **Inpatient → 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, refunded and cancelled, 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**, **Cancelled** (with the number of bills cancelled under it) and **Net**. ![Combined Inward Payments, Summary view, with a cancelled deposit](images/24283-combined-payments-summary.png) *A deposit of 1,000.00 and its cancellation on the same day: Received 1,000.00, Cancelled -1,000.00, Net 0.00.* ## 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 keeps its own amount on its own date, marked **Cancelled** in the Status column. - The **cancellation bill** that reverses it is listed as a separate row on the date it was made, marked **Cancellation**, with the amount negative (money handed back). It is totalled under **Cancelled**. - So when a bill and its cancellation fall in the same period they cancel out in Net. When the cancellation happens on a later day, the original counts on its own day and the reversal on the day of the cancellation, which matches the cash actually taken and handed back on each day. ## 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 or cancellation | | BHT No | The admission the bill belongs to | | Patient | Patient name | | Payment Method | Cash, card, etc. | | Amount | Signed amount: negative for refunds and cancellations | | Status | **Cancelled** on a bill that has been cancelled; **Cancellation** on the bill that cancels it | ## 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, on a sheet named **Summary**. - **Grouped** and **Details** views export every bill on a sheet named **Payments**, in the same order as on screen — all rows, not just the page currently displayed. - Every export ends with a **Period totals** block under the table: Received, Refunded, Cancelled, Net and the number of cancelled bills, the same figures as the four boxes above the results. - In a **Grouped** view the workbook opens on an extra first sheet with the group subtotals and a grand total, as shown above the rows on screen: **By Bill Type** (one line per bill type) or **By BHT** (one line per admission). The **Payments** sheet follows it. ## Related Reports - [BHT Deposit Detail Report](Inward-BHT-Deposit-Detail-Report) — one row per payment, with per-payment-method columns and admission-based filters - [Inpatient Bill Search and Reprint](Finance-Inpatient-Bill-Search-and-Reprint) — the individual Payment, Deposit and Refund search pages