Finance Cashier Breakdown by Payment Method - hmislk/hmis GitHub Wiki
Cashier Breakdown by Payment Method
Introduction
The cashier breakdown by payment method report provides a detailed view of all collections for a cashier, shift, or department, split by each payment method. It is used by finance managers and supervisors to verify that collection totals match the physical cash and non-cash instruments on hand, and to identify the composition of daily revenue.
Navigation
Main Menu → Financial Transaction Manager → Reports → Payment Method Breakdown OR Main Menu → Financial Reports → Cashier Payment Method Summary
Generating the Report
- Navigate to the payment method breakdown report page.
- Set the filters:
- Date range (From Date, To Date)
- Cashier — specific cashier or all
- Department / Cashier Point — filter by location
- Shift — specific shift number or all shifts in the date range
- Click Generate.
Report Columns
| Column | Description |
|---|---|
| Cashier | Name of the cashier |
| Shift | Shift reference |
| Date | Billing date |
| Cash | Total cash collected |
| Card | Total card collected |
| Credit | Total billed to credit companies |
| Cheque | Total cheque payments received |
| eWallet | Total e-wallet collections |
| PatientDeposit | Total drawn from patient deposit balances |
| PatientPoints | Total redeemed as loyalty points |
| Other | Any other payment methods |
| Grand Total | Sum of all methods |
Totals Row
The report footer shows column totals across all cashiers/shifts in the filter period. This grand total should match the cashier's collection totals in the shift summary and the day-end cash book entry.
Reconciliation Use
Finance staff use this report to:
- Match the Cash column against the physical cash counted in the safe.
- Match the Card column against the POS terminal batch settlement report.
- Match the Cheque column against the cheque register.
- Match the Credit column against the credit company receivable ledger.
- Identify any unexplained differences.
Comparing with the Daily Return Report
The payment method breakdown counts payment records (from the payment table). The Daily Return report counts bills. A discrepancy between the two indicates bills with no matching payment records — a data integrity issue. See Day-End Report for the reconciliation process.
Exporting
Click Export to Excel to download the full report for offline reconciliation or accounting entry.
Technical Reference
| Item | Detail |
|---|---|
| Data source | Payment table, joined to Bill |
| Controller | FinancialTransactionController or cashier summary controller |
| Related | Cashier Summary Reports, Day-End Report |