Dental Clinic Reports

Generated: {{ now()->format('F d, Y h:i A') }}

Period: {{ \Carbon\Carbon::parse($fromDate)->format('M d, Y') }} - {{ \Carbon\Carbon::parse($toDate)->format('M d, Y') }}

Revenue Report

Total Revenue

${{ number_format($revenueData['total_revenue'], 2) }}

{{ $revenueData['invoices_count'] }} invoices

Paid Amount

${{ number_format($revenueData['paid_amount'], 2) }}

{{ $revenueData['total_revenue'] > 0 ? number_format(($revenueData['paid_amount'] / $revenueData['total_revenue']) * 100, 1) : 0 }}% collected

Remaining

${{ number_format($revenueData['remaining_amount'], 2) }}

Pending payment

Avg Invoice

${{ $revenueData['invoices_count'] > 0 ? number_format($revenueData['total_revenue'] / $revenueData['invoices_count'], 2) : '0.00' }}

Per invoice

Appointments Report

Total

{{ number_format($appointmentsData['total_appointments']) }}

Completed

{{ number_format($appointmentsData['completed_appointments']) }}

Cancelled

{{ number_format($appointmentsData['cancelled_appointments']) }}

Pending

{{ number_format($appointmentsData['pending_appointments']) }}

Top Services by Revenue

@forelse($topServices as $index => $service) @empty @endforelse
# Service Name Quantity Revenue
{{ $index + 1 }} {{ $service->service_name }} {{ number_format($service->total_quantity) }} ${{ number_format($service->total_revenue, 2) }}
No services data available

Daily Revenue Breakdown

@forelse($dailyRevenue as $day) @empty @endforelse
Date Invoices Revenue
{{ \Carbon\Carbon::parse($day->date)->format('M d, Y') }} {{ $day->invoices_count }} ${{ number_format($day->revenue, 2) }}
No revenue data available

Patients Growth Report

New Patients

{{ number_format($patientsData['new_patients']) }}

In selected period

Total Patients

{{ number_format($patientsData['total_patients']) }}

All time

Active Patients

{{ number_format($patientsData['active_patients']) }}

Currently active

© {{ now()->year }} Dental Clinic System. All rights reserved.