Cash Flow Report

Period: {{ $export_data['period'] }}

Location: {{ $export_data['location'] }}

Generated: {{ date('Y-m-d H:i:s') }}

Executive Summary
Metric Amount
Opening Balance ${{ $export_data['summary']['opening_balance'] }}
Cash Inflows ${{ $export_data['summary']['cash_inflows'] }}
Cash Outflows ${{ $export_data['summary']['cash_outflows'] }}
Net Cash Flow ${{ $export_data['summary']['net_cash_flow'] }}
Closing Balance ${{ $export_data['summary']['closing_balance'] }}
Outstanding Receivables ${{ $export_data['summary']['total_receivables'] }}
Outstanding Payables ${{ $export_data['summary']['total_payables'] }}
@if(!empty($export_data['payment_methods']))
Payment Method Breakdown
@foreach($export_data['payment_methods'] as $method) @endforeach
Payment Method Transactions Total Amount Inflows Outflows
{{ ucfirst(str_replace('_', ' ', $method['method'])) }} {{ $method['transaction_count'] }} ${{ number_format($method['total_amount'], 2) }} ${{ number_format($method['inflow_amount'], 2) }} ${{ number_format($method['outflow_amount'], 2) }}
@endif @if(!empty($export_data['daily_flows']))
Daily Cash Flow (Last {{ count($export_data['daily_flows']) }} Days)
@php $displayLimit = 15; @endphp @foreach(array_slice($export_data['daily_flows'], -$displayLimit) as $day) @endforeach
Date Inflows Outflows Net Flow Running Balance
{{ \Carbon\Carbon::parse($day['date'])->format('M d, Y') }} ${{ number_format($day['cash_inflow'], 2) }} ${{ number_format($day['cash_outflow'], 2) }} ${{ number_format($day['net_flow'], 2) }} ${{ number_format($day['running_balance'], 2) }}
@endif @if(!empty($export_data['receivables']))
Outstanding Receivables (Top 20)
@foreach(array_slice($export_data['receivables'], 0, 20) as $receivable) @endforeach
Invoice No Customer Date Total Due Amount Days Overdue
{{ $receivable['invoice_no'] }} {{ $receivable['customer_name'] ?: 'Walk-in Customer' }} {{ \Carbon\Carbon::parse($receivable['transaction_date'])->format('M d, Y') }} ${{ number_format($receivable['final_total'], 2) }} ${{ number_format($receivable['due_amount'], 2) }} {{ $receivable['days_overdue'] }}
@endif @if(!empty($export_data['payables']))
Outstanding Payables (Top 20)
@foreach(array_slice($export_data['payables'], 0, 20) as $payable) @endforeach
Reference Supplier Date Type Total Due Amount Days Overdue
{{ $payable['ref_no'] }} {{ $payable['supplier_name'] ?: 'Unknown' }} {{ \Carbon\Carbon::parse($payable['transaction_date'])->format('M d, Y') }} {{ ucfirst($payable['type']) }} ${{ number_format($payable['final_total'], 2) }} ${{ number_format($payable['due_amount'], 2) }} {{ $payable['days_overdue'] }}
@endif

Generated by Advanced Reports Module - {{ date('Y-m-d H:i:s') }}