{{ $settings['company_name'] ?? 'Company Name' }}

{{ $settings['company_address'] ?? '' }}

Phone: {{ $settings['company_phone'] ?? '' }} | Email: {{ $settings['company_email'] ?? '' }}

Party Ledger Report

{{ $selectedCustomer ? $selectedCustomer->name : 'All Customers' }} | {{ $startDate }} to {{ $endDate }}

@php $balance = 0; $totalSales = 0; $totalDiscount = 0; $totalTDS = 0; $totalVDS = 0; $totalSalesReturn = 0; $totalPayment = 0; @endphp @forelse($ledgers as $entry) @php $salesAmount = 0; $discount = 0; $tds = 0; $vds = 0; $salesReturnAmount = 0; $paymentAmount = 0; if($entry->reference_type == 'Sale') { $debit = (float)$entry->debit; $sale = $sales[$entry->reference_id] ?? null; if($debit > 0 && $sale) { $salesAmount = (float)$sale->subtotal; $balance += $salesAmount; $totalSales += $salesAmount; } elseif($sale) { $paymentAmount = (float)$entry->credit; $balance -= $paymentAmount; $totalPayment += $paymentAmount; } } elseif($entry->reference_type == 'SaleReturn') { $salesReturnAmount = (float)$entry->credit; $balance -= $salesReturnAmount; $totalSalesReturn += $salesReturnAmount; } else { $paymentAmount = (float)$entry->credit; $balance -= $paymentAmount; $totalPayment += $paymentAmount; $voucher = $vouchers[$entry->reference_id] ?? null; if($voucher) { $discount = (float)($voucher->discount ?? 0); $tds = (float)($voucher->tds ?? 0); $vds = (float)($voucher->vds ?? 0); } $balance -= $discount + $tds + $vds; } $totalDiscount += $discount; $totalTDS += $tds; $totalVDS += $vds; @endphp @php $_pm = '-'; $_voucher = $vouchers[$entry->reference_id] ?? null; if($entry->reference_type == 'Voucher' && $_voucher) { if(preg_match('/\(([^)]+)\)/', $_voucher->description ?? '', $_m)) { $_pm = $_m[1]; } } else { $_pd = $entry->description ?? ''; if(preg_match('/Method:\s*([^,]+)/', $_pd, $_m)) { $_pm = trim($_m[1]); } elseif(preg_match_all('/\(([^)]+)\)/', $_pd, $_ms)) { $_last = end($_ms[1]); if(!preg_match('/^(Disc|TDS|VDS)/', $_last)) { $_pm = $_last; } } } @endphp @empty @endforelse
Date Invoice No Customer Sales Discount TDS VDS Sales Return Payment Balance Payment Method
{{ date('d-m-Y', strtotime($entry->date)) }} {{ $entry->invoice_no ?: $entry->reference_id }} {{ $entry->customer->name ?? 'N/A' }} {{ number_format($salesAmount, 2) }} {{ number_format($discount, 2) }} {{ number_format($tds, 2) }} {{ number_format($vds, 2) }} {{ number_format($salesReturnAmount, 2) }} {{ number_format($paymentAmount, 2) }}{{ number_format($balance, 2) }} {{ $_pm }}
No records found
Total: {{ number_format($totalSales, 2) }} {{ number_format($totalDiscount, 2) }} {{ number_format($totalTDS, 2) }} {{ number_format($totalVDS, 2) }} {{ number_format($totalSalesReturn, 2) }} {{ number_format($totalPayment, 2) }} {{ number_format($balance, 2) }}