Date : {!! formatedDate(date('Y-m-d')) !!}

{!! $company->name !!}

CONSOLIDATE STATEMENT

DATE {!! formatedDate(date('Y-m-d', strtotime($from_date))) ?? '' !!}

Time : {!! formatedTime(now()) !!}

@if(isset($accountReceipt) && count($accountReceipt) > 0) @php $i = 1; $totalByTransactionMode = []; @endphp @php $grand_total = 0; $totalCash = $totalNeft = $totalCheque = $totalUPI = $totalPaymentGateway = $totalOther = 0; @endphp @foreach($accountReceipt as $receipt) @if(isset($receipt->accountReceiptTransaction)&&count($receipt->accountReceiptTransaction)>0) @foreach($receipt->accountReceiptTransaction as $key => $transactions) @if($transactions->transaction_type == 'CREDIT') @php continue; @endphp @endif @php $totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] = ($totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] ?? 0) + $transactions->amount; @endphp @if($key == 1) @php $count = @count($receipt->accountReceiptTransaction->where('transaction_type','<>','CREDIT')) ?? 0; @endphp @php $i += 1; @endphp @endif @php $grand_total = $grand_total + $transactions->amount; $i + 1; @endphp @endforeach @endif @endforeach @foreach ($totalByTransactionMode as $transactionMode => $paymentModes) @foreach ($paymentModes as $paymentMode => $total) @endforeach @endforeach @else @endif
Sl no Receipt No Date Account Name Voucher Type Prepared By Ref. Voucher No. Voucher Date Transaction Mode Payment Mode Amount
{{ $i }} {!! $receipt->receipt_no !!} {!! ($receipt->receipt_date ? formatedDateTime($receipt->receipt_date . ' ' . $receipt->receipt_time) : '') !!} {!! $receipt->accountReceiptDetail->account->account_title->name??null !!} {!! $receipt->accountReceiptDetail->account->name ?? '' !!} {!! $receipt->accountReceiptDetail->voucherType->name ?? '' !!} @if(isset($receipt->prepared_by)) By: {{ $receipt->prepared_by ?? '' }} @endif @if($receipt->accountReceiptDetail->voucherType->name=="OPD Booking") {{ $receipt->opdBooking->booking_no ?? '' }} @else {!! $receipt->salesVoucher->main_invoice_no??'' !!} @endif @if($receipt->accountReceiptDetail->voucherType->name=="OPD Booking") {{ isset($receipt->opdBooking->booking_date_time)?formatedDate($receipt->opdBooking->booking_date_time) : '' }} @else {{ formatedDate(@$receipt->salesVoucher->created_at) ?? '' }} @endif {{ $transactions->account->name ?? '' }} @if(isset($transactions->payment_mode->mode)) {{ $transactions->payment_mode->mode ?? '' }} @endif {{ isset($transactions->amount) && $transactions->amount > 0 ? convertDecimelPoint($transactions->amount) : "0" }}
{{ $transactionMode }} SUMMARY
TOTAL {{ $paymentMode }} {{$total}}
Grand TOTAL {!! convertDecimelPoint($grand_total) !!}
No Records Found

*** End Of Statement ***

OLD DUES COLLECTION STATEMENT

DATE {!! formatedDate(date('Y-m-d', strtotime($from_date))) ?? '' !!}

@if(isset($accountReceiptOld) && count($accountReceiptOld) > 0) @php $i = 1; $totalByTransactionMode = []; @endphp @php $grand_total = 0; $totalCash = $totalNeft = $totalCheque = $totalUPI = $totalPaymentGateway = $totalOther = 0; @endphp @foreach($accountReceiptOld as $receipt) @if(isset($receipt->accountReceiptTransaction)&&count($receipt->accountReceiptTransaction)>0) @foreach($receipt->accountReceiptTransaction as $key => $transactions) @if($transactions->transaction_type == 'CREDIT') @php continue; @endphp @endif @php $totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] = ($totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] ?? 0) + $transactions->amount; @endphp @if($key == 1) @php $count = @count($receipt->accountReceiptTransaction->where('transaction_type','<>','CREDIT')) ?? 0; @endphp @php $i += 1; @endphp @endif @php $grand_total = $grand_total + $transactions->amount; $i + 1; @endphp @endforeach @endif @endforeach @foreach ($totalByTransactionMode as $transactionMode => $paymentModes) @foreach ($paymentModes as $paymentMode => $total) @endforeach @endforeach @else @endif
Sl no Receipt No Date Account Name Voucher Type Prepared By Ref. Voucher No. Voucher Date Transaction Mode Payment Mode Amount
{{ $i }} {!! $receipt->receipt_no !!} {!! ($receipt->receipt_date ? formatedDateTime($receipt->receipt_date . ' ' . $receipt->receipt_time) : '') !!} {!! $receipt->accountReceiptDetail->account->account_title->name??null !!} {!! $receipt->accountReceiptDetail->account->name ?? '' !!} {!! $receipt->accountReceiptDetail->voucherType->name ?? '' !!} @if(isset($receipt->prepared_by)) By: {{ $receipt->prepared_by ?? '' }} @endif @if($receipt->accountReceiptDetail->voucherType->name=="OPD Booking") {{ $receipt->opdBooking->booking_no ?? '' }} @else {!! $receipt->salesVoucher->main_invoice_no??'' !!} @endif @if($receipt->accountReceiptDetail->voucherType->name=="OPD Booking") {{ isset($receipt->opdBooking->booking_date_time)?formatedDate($receipt->opdBooking->booking_date_time) : '' }} @else {{ formatedDate(@$receipt->salesVoucher->created_at) ?? '' }} @endif {{ $transactions->account->name ?? '' }} @if(isset($transactions->payment_mode->mode)) {{ $transactions->payment_mode->mode ?? '' }} @endif {{ isset($transactions->amount) && $transactions->amount > 0 ? convertDecimelPoint($transactions->amount) : "0" }}
{{ $transactionMode }} SUMMARY
TOTAL {{ $paymentMode }} {{$total}}
Grand TOTAL {!! convertDecimelPoint($grand_total) !!}
No Records Found

*** End Of Statement ***

PAYMENT / EXPENDITURE STATEMENT

DATE {!! formatedDate(date('Y-m-d', strtotime($from_date))) ?? '' !!}

@if(isset($accountReceiptOld) && count($accountReceiptOld) > 0) @php $i = 1; $totalByTransactionMode = []; @endphp @php $grand_total = 0; $totalCash = $totalNeft = $totalCheque = $totalUPI = $totalPaymentGateway = $totalOther = 0; @endphp @foreach($accountReceiptOld as $receipt) @if(isset($receipt->accountReceiptTransaction)&&count($receipt->accountReceiptTransaction)>0) @foreach($receipt->accountReceiptTransaction as $key => $transactions) @if($transactions->transaction_type == 'CREDIT') @php continue; @endphp @endif @php $totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] = ($totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] ?? 0) + $transactions->amount; @endphp @if($key == 1) @php $count = @count($receipt->accountReceiptTransaction->where('transaction_type','<>','CREDIT')) ?? 0; @endphp @php $i += 1; @endphp @endif @php $grand_total = $grand_total + $transactions->amount; $i + 1; @endphp @endforeach @endif @endforeach @foreach ($totalByTransactionMode as $transactionMode => $paymentModes) @foreach ($paymentModes as $paymentMode => $total) @endforeach @endforeach @else @endif
Sl no Receipt No Date Account Name Voucher Type Prepared By Ref. Voucher No. Voucher Date Transaction Mode Payment Mode Amount
{{ $i }} {!! $receipt->receipt_no !!} {!! ($receipt->receipt_date ? formatedDateTime($receipt->receipt_date . ' ' . $receipt->receipt_time) : '') !!} {!! $receipt->accountReceiptDetail->account->account_title->name??null !!} {!! $receipt->accountReceiptDetail->account->name ?? '' !!} {!! $receipt->accountReceiptDetail->voucherType->name ?? '' !!} @if(isset($receipt->prepared_by)) By: {{ $receipt->prepared_by ?? '' }} @endif @if($receipt->accountReceiptDetail->voucherType->name=="OPD Booking") {{ $receipt->opdBooking->booking_no ?? '' }} @else {!! $receipt->salesVoucher->main_invoice_no??'' !!} @endif @if($receipt->accountReceiptDetail->voucherType->name=="OPD Booking") {{ isset($receipt->opdBooking->booking_date_time)?formatedDate($receipt->opdBooking->booking_date_time) : '' }} @else {{ formatedDate(@$receipt->salesVoucher->created_at) ?? '' }} @endif {{ $transactions->account->name ?? '' }} @if(isset($transactions->payment_mode->mode)) {{ $transactions->payment_mode->mode ?? '' }} @endif {{ isset($transactions->amount) && $transactions->amount > 0 ? convertDecimelPoint($transactions->amount) : "0" }}
{{ $transactionMode }} SUMMARY
TOTAL {{ $paymentMode }} {{$total}}
Grand TOTAL {!! convertDecimelPoint($grand_total) !!}
No Records Found

*** End Of Statement ***

PAYMENT VOUCHER STATEMENT

DATE {!! formatedDate(date('Y-m-d', strtotime($from_date))) ?? '' !!}

@if(isset($paymentVoucher) && count($paymentVoucher) > 0) @php $i = 1; $totalByTransactionMode = []; @endphp @php $grand_total = 0; $totalCash = $totalNeft = $totalCheque = $totalUPI = $totalPaymentGateway = $totalOther = 0; @endphp @foreach($paymentVoucher as $payment) @if(isset($payment->paymentVoucherDetails)&&count($payment->paymentVoucherDetails)>0) @foreach($payment->paymentVoucherDetails as $key => $transactions) @php if($transactions->transaction_type == 'DEBIT') { continue; } $totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] = ($totalByTransactionMode[$transactions->account->name??''][$transactions->payment_mode->mode??''] ?? 0) + $transactions->amount; if($transactions->amount < 1) { continue; } @endphp @if($key == 1) @php $count = @count($payment->paymentVoucherDetails) ?? 0; @endphp @endif @php $i += 1; $grand_total = $grand_total + $transactions->amount; @endphp @endforeach @endif @endforeach @foreach ($totalByTransactionMode as $transactionMode => $paymentModes) @foreach ($paymentModes as $paymentMode => $total) @endforeach @endforeach @else @endif
Sl.No Date Account Name Voucher Type Transaction Reff. Voucher Date Transaction Mode Payment Mode Amount
{{ $i }} {{ formatedDate($transactions->transaction_date) ?? '' }} {!! $payment->paymentVoucherDetail->account->account_title->name??null !!} {!! $payment->paymentVoucherDetail->account->name ?? '' !!} {{ $payment->paymentVoucherDetail->voucher_type ?? '' }} {{ $transactions->transaction_referrence ?? '' }} {!!formatedDate ($payment->accountReceiptDetail->receipt_date ) ?? 'N/A' !!}) {{ $transactions->account->name ?? '' }} {{ $transactions->payment_mode->mode ?? '' }} {{ isset($transactions->amount) && $transactions->amount > 0 ? convertDecimelPoint($transactions->amount) : "0" }}
{{ $transactionMode }} SUMMARY
TOTAL {{ $paymentMode }} {{$total}}
Grand Total {!! convertDecimelPoint($grand_total) !!}
No Data Found
@if(isset($accountReceipt) && count($accountReceipt) > 0)
Export
@endif