Daily Collection Report
Daily Collection Report (/reports/daily-collection) rolls up patient collection payments for a payment date range—cash, check, card, and split—with staff performance, receive → deposit → reconcile for cash/check, and PDF/CSV/XLS export. Data comes from patient transaction logs (same family as Billing Log → Patient Payments), grouped by appointment and collection day—not the Billing claim Transactions grid or ERA remittance.
Daily Collection Report
Date of Service
Time Frame
Staff Members
Payment Methods
Practice Location
Payment Details
| Patient | Date of Service | Payment Method | Amount | Staff | Location |
|---|---|---|---|---|---|
| No payment records found for this date. | |||||
Daily Collection Report Screen
Open from Reports sidebar → Daily Collection Report. Needs Daily Collection Report Tab (+ View Reports). Header practice required to load; locations from header filter the set. Layout: filter bar, summary cards (Total / Cash / Check / Card / Split), optional Performance Summary by staff, Payment Details table, and export buttons when permitted.
How This Relates to Billing and Appointments
Source: patient_transaction_logs (check-in payments, payment plans, subscriptions, payment links, split checkout, etc.)—related to Billing Log → Patient Payments. Not Billing → Transactions (claim billed/paid/adj) and not Remittance Reports (ERA 835). Self-pay Total on rows aligns with visit fee ideas on Daily Appointment Details; Collected is what was paid. Refunds adjust collection rows.
Time Frame, Payment Dates, Staff, Method, Location
Time Frame: Today · Last 7 / 30 / 60 / 90 Days · Custom Range. Payment Date / Through Date (or Custom From–To) set the collection datetime window—not a separate DOS claim filter (state may be named date of service internally; UI is payment/through dates). Staff Members: multi-select clinic staff plus Patient and System. Payment Methods: Cash · Check · Credit/Debit Card · Split. Location: header locations. Clinic: header selected practice.
Refresh and Clear Filters
Refresh reloads with current filters. Clear Filters resets when selections differ from defaults. Custom range without both start and end: Select both start and end dates…
Summary Cards and Performance
Cards show Total Collected, Cash, Check, Card, and Split (amounts and counts). Performance Summary by staff appears when data exists—use it to see who collected what in the period.
Payment Details Table
Columns: Patient Name · Total · Collected Amount · Location · Reason · Method · Collected By · Received By · Deposit By · Reconcile By · Actions (plus checkbox for cash/check workflow). Multi-tender or multi-log visits expand in an accordion. Type may appear in exports even if hidden in the on-screen table.
Receive, Deposit, and Reconcile (Cash / Check)
For Cash and Check rows, staff can mark Received → Deposited → Reconciled (in order) from Actions / checkboxes. Card and Split follow payment-processor paths and do not use the same cash-drawer steps. Anyone who can open the Daily Collection tab can use these actions (no separate receive/deposit ops).
Export PDF, CSV, and XLS
Needs Export Report (or Super Admin). Buttons disabled when there are no rows. Filename pattern daily-collection-{period}. Exports include Type plus receive/deposit/reconcile fields for offline audit or accounting.
No Payment Records Found
No payment records found for this date—no logs in the payment window for the practice. No payment records match the selected filters—widen staff/method/time frame or clear filters. No clinic selected yields an empty load (select practice in the header). Staff dropdown empty: No staff for this practice / selected locations.
Permissions
Reports + View Reports + Daily Collection Report Tab. Export: Export Report. Super Admin bypasses. Receive/deposit/reconcile share tab access.
Common Issues
(1) Empty report—no practice selected or payment date window has no logs. (2) Expected claim ERA money missing—wrong module; use Billing Remittance. (3) Export greyed out—no rows or missing Export Report. (4) Cash stuck—complete Receive before Deposit before Reconcile. (5) Filters too tight—staff/method/location. (6) Confused “Date of Service” with payment date—this report filters collection datetime. (7) Tab missing—grant Daily Collection Report Tab.