Outstanding Sales Report

Generated on {{ \Carbon\Carbon::now()->format('M d, Y H:i') }}

Total Outstanding
Overdue Amount
Total Invoices
Average Days Overdue
${{ number_format($outstandingInvoices->sum('balance_due'), 2) }}
${{ number_format($outstandingInvoices->where('days_overdue', '>', 0)->sum('balance_due'), 2) }}
{{ $outstandingInvoices->count() }}
{{ $outstandingInvoices->where('days_overdue', '>', 0)->avg('days_overdue') ? round($outstandingInvoices->where('days_overdue', '>', 0)->avg('days_overdue')) : 0 }}
@foreach($outstandingInvoices as $invoice) @endforeach
Client Name Invoice # Invoice Date Due Date Total Amount Paid Amount Balance Due Status Days Overdue Currency
{{ $invoice['client_name'] }} {{ $invoice['invoice_number'] }} {{ \Carbon\Carbon::parse($invoice['invoice_date'])->format('M d, Y') }} {{ $invoice['due_date'] ? \Carbon\Carbon::parse($invoice['due_date'])->format('M d, Y') : 'N/A' }} ${{ number_format($invoice['total_amount'], 2) }} ${{ number_format($invoice['paid_amount'], 2) }} ${{ number_format($invoice['balance_due'], 2) }} {{ ucfirst(str_replace('_', ' ', $invoice['status'])) }} @if($invoice['days_overdue'] > 0) {{ $invoice['days_overdue'] }} days @else Not overdue @endif {{ $invoice['currency'] }}
@if($outstandingInvoices->isEmpty())

No outstanding sales found.

@endif