Bug #693
closedReports Should Break Down Collections by Payment Mode
0%
Description
Many patients pay part in UPI and part in cash. The billing report should show the UPI total and the cash total separately, so the cash in hand and the UPI can be matched at the end of the day.
On the Reports page (Day-end · GST · billing summary), “Collected today” (₹231) is shown as a single aggregate figure with no breakdown by payment mode. For front-desk/cashier reconciliation, many patients split payment across modes (part Cash, part UPI), so being able to see the day’s Cash total and UPI total separately is needed to match cash-in-hand against what was actually collected in each mode.
Impact
Without a mode-level breakdown on this page, whoever reconciles the day’s cash drawer against collections has no direct source for “how much of today’s ₹231 was cash vs UPI” from this report — they’d have to go line-by-line through Payments or Receipts instead. This matters most for mixed-mode payments (one patient paying with both cash and UPI toward a single bill), since even an aggregate Cash/UPI split only solves the problem if each portion of a split payment is correctly attributed to its own mode rather than just the dominant one.
Environment
Tenant: Vetri Vivega Medical Center. Module: Compliance > Reports (Day-end · GST · billing summary), “Today” filter. Collected today ₹231, Gross billing ₹531, GST collected ₹0, Realisation (90d) 78.1%, Refunds today ₹0, dated 2 Nov 2026.
Steps to Reproduce
Go to Compliance > Reports, “Today” filter.
Review the cards (Collected today, Gross billing, GST collected, Realisation, Refunds today) and the charts (Daily collection, Revenue mix by billing type, Payer mix, Operational KPIs).
Note none of these break collections down by payment mode (Cash, UPI, Card, etc.) — only by billing type (Laboratory/Pharmacy/OPD) and payer (Self).
Expected vs Actual
Expected: this page should show a Cash total and a UPI total (and other modes, as applicable) for the day, so cash-in-hand can be matched against the Cash figure specifically at day-end close.
Actual: no payment-mode breakdown exists anywhere on this Reports page.
Notes
A “Payment mix” widget with a Cash/UPI/Card/Bank transfer split does already exist elsewhere in this tenant — on the Billing > Dashboard page, confirmed during earlier testing this session (e.g. “Cash ₹685 100%, UPI ₹0, Card ₹0, Bank transfer ₹0” for 28 Oct). So the underlying capability to total collections by mode isn’t entirely new; it’s just missing from this specific Reports/day-end page, which is the one actually meant for day-end reconciliation. Worth either surfacing the same breakdown here, or clarifying whether Dashboard’s version is meant to serve this purpose already — if so, the ask becomes more about workflow/placement than a missing figure.
Files
RH Updated by Roshni Harish. 11 days ago
- File Screenshot 2026-11-02 at 12.47.40 PM.png Screenshot 2026-11-02 at 12.47.40 PM.png added
- Subject changed from Billing report: show UPI and cash separately for split payments to Reports Should Break Down Collections by Payment Mode
- Description updated (diff)
- Assignee set to Dilbar S.
RH Updated by Roshni Harish. 11 days ago
- Priority changed from Normal to High
RH Updated by Roshni Harish. 10 days ago
- Status changed from Resolved to Closed