@extends('layouts.app') @section('title', 'Reports') @section('content')

Reports

Financial, clinical, pharmacy, and statutory MOH reports.

{{-- ─── FINANCIAL REPORTS ──────────────────────────────────────── --}}

Financial

Daily Cash Collections

Day & night shift cash, M-Pesa, insurance and net position.

Revenue by Item Department

Income breakdown across consultation, lab, pharmacy, imaging.

Services Charged

Itemised list of services billed grouped by category.

Patient Transactions

Per-patient invoice and payment history.

Open Balances

Outstanding patient balances and unpaid invoices.

Expenses

Operational expenses and payment records.

Profit & Loss

Revenue versus expenses summary for the period.

Revenue Trend

Revenue trend over time with month-over-month change.

Insurance Claims Aging

Outstanding claims grouped by age bucket (0-30, 31-60, 60+ days).

{{-- M-Pesa channel verification (Issue #4) — single entry; tabs on the destination page switch between All / KCB / Bingwa. Default landing tab is 'all' so admins see both rails at once for end-of-day reconciliation. --}}

M-Pesa Deposits

Verify KCB Paybill and Bingwa Sacco M-Pesa deposits against bank statements.

{{-- ─── PHARMACY & STOCK ──────────────────────────────────────── --}}

Pharmacy & Stock

Pharmacy Sales

Drug sales by quantity and revenue.

Stock Status

Current drug inventory levels and reorder alerts.

Stock Movement

Stock in/out movements over the period.

Expiry Report

Drug batches expiring soon or already expired.

{{-- ─── CLINICAL & OPERATIONAL ──────────────────────────────────────── --}}

Clinical & Operational

Daily Visits

Patient visits per day with trend.

Visit Summary

OPD vs IPD, paying vs insurance breakdown.

Top Diagnoses

Most common diagnoses ranked by frequency.

New vs Revisit

First-time vs returning patient ratio.

Inpatient

Admissions, discharges, length of stay.

Bed Occupancy

Ward-level bed utilisation.

Lab Summary

Tests ordered and validated by test type.

Pending Lab Tests

Lab orders still awaiting results.

Lab Volumes

Daily lab test volume trends.

Imaging Summary

Imaging requests and completion status.

Maternity

Deliveries and maternal outcomes.

Appointments

Scheduled, attended and missed appointments.

Feedback

Patient satisfaction and complaints summary.

Locum Activity

Locum staff shifts and earnings.

{{-- ─── MOH STATUTORY ──────────────────────────────────────── --}}

MOH Statutory Reports

MOH 717 — Workload Summary

OPD/IPD visits, admissions, discharges, deaths.

MOH 706 — Lab Summary

Laboratory tests done by type and outcome.

MOH 711 — ANC Summary

Antenatal visits, IPT, TT, HIV testing.

MOH 333 — Delivery Summary

Deliveries, mode, outcomes and complications.

MOH 705A — Under 5 Diagnoses

Diagnoses for children under 5 years.

MOH 705B — Over 5 Diagnoses

Diagnoses for patients aged 5 and over.

@endsection