Balance Sheet

From: {{ Carbon\Carbon::parse($from)->format('d-m-Y') }} To:{{ Carbon\Carbon::parse($to)->format('d-m-Y') }}

All Time

@csrf

From:

To:

@csrf

From:

To:

Credit/Income/Receipts

@foreach ($booking as $item1) member_id)->first(); ?> @endforeach @foreach ($book_1 as $book_1) member_id)->first(); ?> @endforeach @foreach ($ins as $item2) member_id)->first(); $sale = App\Sale::where('id', $item2->sales_id)->first(); ?> @endforeach @foreach ($incomes as $item3) @php $count = $count + 1; $head = App\IncomeHead::where('id', $item3->income_head_id)->first(); @endphp @endforeach

SL	Date	Title	Amount
{{ $count }}	{{ Carbon\Carbon::parse($item1->date)->format('d-m-Y') }}	Booking {{ $member->name }} ID:{{ $member->serial_id }} File no: {{ $item1->sale_no }}	{{ $item1->paid }}
{{ $count }}	{{ Carbon\Carbon::parse($book_1->date)->format('d-m-Y') }}	Booking {{ $member->name }} ID:{{ $member->serial_id }} File no: {{ $book_1->sale_no }}	{{ $book_1->amount }}
{{ $count }}	{{ Carbon\Carbon::parse($item2->date)->format('d-m-Y') }}	Installments {{ $member1->name }} ID:{{ $member1->serial_id }} File no: {{ $sale->sale_no }}	{{ $item2->amount }}
{{ $count }}	{{ Carbon\Carbon::parse($item3->date)->format('d-m-Y') }}	Income/Credit Purpose: {{ $head->name }}	{{ $item3->amount }}
Total Income			{{ $total_income }}

Debit/Expense/Payments

@foreach ($expenses as $item4) expence_head_id)->first(); ?> @endforeach @foreach ($land as $item5) @endforeach @foreach ($bayna as $item6) @endforeach @foreach ($withdraws as $item7) income_id)->first(); ?> status==1){?> status==2){?> status==3){?> @endforeach

SL	Date	Title	Amount
{{ $count1 }}	{{ Carbon\Carbon::parse($item4->date)->format('d-m-Y') }}	Expense/ Debit Purpose : {{ $head->name }}	{{ $item4->amount }}
{{ $count1 }}	{{ Carbon\Carbon::parse($item5->date)->format('d-m-Y') }}	জমি ক্রয় দলিল নং: {{ $item5->dolil_no }}	{{ $item5->paid_amount }}
{{ $count1 }}	{{ Carbon\Carbon::parse($item6->date)->format('d-m-Y') }}	বায়না স্ট্যাম্প নাম্বার: {{ $item6->dolil_no }}	{{ $item6->paid_amount }}
{{ $count1 }}	{{ Carbon\Carbon::parse($item7->date)->format('d-m-Y') }}	Reference Commission এককালীন {{ $item7->reference->name }}	Reference Commission Booking {{ $item7->reference->name }}	Reference Commission Installment {{ $item7->reference->name }}	{{ $item7->amount }}
Total Expense			{{ $total_expense }}

Credit Ledger

Total Booking amount	{{ $sales + $total_book }}
Total Installment amount	{{ $land_installment }}
Total Credit/Income amount	{{ $income_t }}

Debit Ledger

Total Debit/Expense amount	{{ $expense_t }}
Total Land-Purchase amount	{{ $purchase }}
Total বায়না amount	{{ $bayna_total }}
Total Booking Commision amount	{{ $book_com }}
Total Installment Commision amount	{{ $ins_com }}
Total এককালীন Commision amount	{{ $ek_com }}

Balance	{{ $total_income - $total_expense }}

{{--

Accounts

Director Accounts

Director Finance

DMD

Managing Director/Chairman

--}}