@extends('layouts.app') @section('title') Closing Balance Report @stop @section('breadcrumb')
@stop @section('css') @stop @section('content')Code | Name | Date | Num | Cheque No. | Party | Narration | Account | Debit | Credit | Balance | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
{{$account->number}} | {{$account->name}} | OPENING BALANCE | @if($balance < 0) | ({{number_format(abs($balance))}}) | @else{{number_format($balance)}} | @endif||||||||||||
@if($t->voucher_type == \App\GeneralJournalEntry::CRV) | CRV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::BRV)BRV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::CPV)CPV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::BPV)BPV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::JV)JV-{{$t->voucher_no}} | @else@endif | {{date('d/m/Y',strtotime($t->date))}} | {{$t->entry_no}} | {{$t->cheaque_no}} | {{$t->controlAccount ? $t->controlAccount->name : ''}} | {{$t->memo}} |
@foreach($accountHit[$t->entry_no] as $acc)
{{$acc->account->number}} - {{$acc->account->name}} @endforeach |
{{$t->amount > 0 ? number_format(abs($t->amount)) : ''}} | {{$t->amount < 0 ? number_format(abs($t->amount)) : ''}} | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif
CLOSING BALANCE | @if($debit < 0) ({{number_format(abs(number_format($debit)))}}) @elseif($debit > 0) {{number_format($debit)}} @else - @endif | @if($credit < 0) ({{number_format(abs(number_format($credit)))}}) @elseif($credit > 0) {{number_format($credit)}} @else - @endif | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif
Code | Name | Date | Num | Cheque No. | Party | Narration | Debit | Credit | Balance | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
{{$cA->number}} | {{$cA->name}} | OPENING BALANCE | @if($balance < 0) | ({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif|||||||||
@if($t->voucher_type == \App\GeneralJournalEntry::CRV) | CRV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::BRV)BRV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::CPV)CPV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::BPV)BPV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::JV)JV-{{$t->voucher_no}} | @else@endif | {{date('d/m/Y',strtotime($t->date))}} | {{$t->entry_no}} | {{$t->cheaque_no}} | {{$t->controlAccount ? $t->controlAccount->name : ''}} | {{$t->memo}} | {{$t->amount > 0 ? number_format(abs($t->amount)) : ''}} | {{$t->amount < 0 ? number_format(abs($t->amount)) : ''}} | @if($balance < 0)({{number_format(abs($balance))}}) | @else{{number_format($balance)}} | @endif
CLOSING BALANCE | @if($debit < 0) ({{number_format(abs(number_format($debit)))}}) @elseif($debit > 0) {{number_format($debit)}} @else - @endif | @if($credit < 0) ({{number_format(abs(number_format($credit)))}}) @elseif($credit > 0) {{number_format($credit)}} @else - @endif | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif||||||||||
TOTAL {{$account->name}} | @if($tdebit < 0) ({{number_format(abs(number_format($tdebit)))}}) @elseif($tdebit > 0) {{number_format($tdebit)}} @else - @endif | @if($tcredit < 0) ({{number_format(abs(number_format($tcredit)))}}) @elseif($tcredit > 0) {{number_format($tcredit)}} @else - @endif | @if($tbalance < 0)({{number_format(abs($tbalance))}}) | @elseif($tbalance > 0){{number_format($tbalance)}} | @else- | @endif
Code | Head Of Account | Balance | ||
---|---|---|---|---|
{{$cA->number}} | {{$cA->name}} | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif
TOTAL {{$account->name}} @if($tbalance < 0) | ({{number_format(abs($tbalance))}}) | @elseif($tbalance > 0){{number_format($tbalance)}} | @else- | @endif
Code | Account | Date | Num | Cheque No. | Party | Narration | Debit | Credit | Balance | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
{{$cA->number}} | {{$cA->name}} | |||||||||||||||
{{$sCA->number}} | {{$sCA->name}} | OPENING BALANCE | @if($balance < 0) | ({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif||||||||||
@if($t->voucher_type == \App\GeneralJournalEntry::CRV) | CRV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::BRV)BRV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::CPV)CPV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::BPV)BPV-{{$t->voucher_no}} | @elseif($t->voucher_type == \App\GeneralJournalEntry::JV)JV-{{$t->voucher_no}} | @else@endif | {{date('d/m/Y',strtotime($t->date))}} | {{$t->entry_no}} | {{$t->cheaque_no}} | {{$t->controlAccount ? $t->controlAccount->name : ''}} | {{$t->memo}} | {{$t->amount > 0 ? number_format(abs($t->amount)) : '-'}} | {{$t->amount < 0 ? number_format(abs($t->amount)) : '-'}} | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif
{{$sCA->number}} | CLOSING BALANCE | @if($debit < 0) ({{number_format(abs(number_format($debit)))}}) @elseif($debit > 0) {{number_format($debit)}} @else - @endif | @if($credit < 0) ({{number_format(abs(number_format($credit)))}}) @elseif($credit > 0) {{number_format($credit)}} @else - @endif | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif||||||||||
Total | @if($tdebit < 0) ({{number_format(abs(number_format($tdebit)))}}) @elseif($tdebit > 0) {{number_format($tdebit)}} @else - @endif | @if($tcredit < 0) ({{number_format(abs(number_format($tcredit)))}}) @elseif($tcredit > 0) {{number_format($tcredit)}} @else - @endif | @if($tbalance < 0)({{number_format(abs($tbalance))}}) | @elseif($tbalance > 0){{number_format($tbalance)}} | @else- | @endif|||||||||||
Sub Total - Bank Balances & TDR | ||||||||||||||||
Total | @if($ttdebit < 0) ({{number_format(abs(number_format($ttdebit)))}}) @elseif($ttdebit > 0) {{number_format($ttdebit)}} @else - @endif | @if($ttcredit < 0) ({{number_format(abs(number_format($ttcredit)))}}) @elseif($ttcredit > 0) {{number_format($ttcredit)}} @else - @endif | @if($ttbalance < 0)({{number_format(abs($ttbalance))}}) | @elseif($ttbalance > 0){{number_format($ttbalance)}} | @else- | @endif
Code | Head Of Account | Balance | ||
---|---|---|---|---|
{{$cA->name}} SUMMARY | ||||
{{$sCA->number}} | {{$sCA->name}} | @if($balance < 0)({{number_format(abs($balance))}}) | @elseif($balance > 0){{number_format($balance)}} | @else- | @endif
Sub Total - {{$cA->name}} | @if($tbalance < 0)({{number_format(abs($tbalance))}}) | @elseif($tbalance > 0){{number_format($tbalance)}} | @else- | @endif|
Sub Total - Bank Balances & TDR | @if($bankAndTdr < 0)({{number_format(abs($bankAndTdr))}}) | @elseif($bankAndTdr > 0){{number_format($bankAndTdr)}} | @else- | @endif|
GRAND TOTAL | @if($ttbalance < 0)({{number_format(abs($ttbalance))}}) | @elseif($ttbalance > 0){{number_format($ttbalance)}} | @else- | @endif