Account Statement & Recovery Sheet

Date: {{date('d/m/Y')}}
User ID: {{Auth::user()->name}}

@foreach($blocks as $b) @foreach($due as $statement) @if($b->id == \App\UnitBlock::find($statement->inventory->floor->unit_block_id)->id) @endif @endforeach @endforeach

FGI						RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS	RECOVERY &	RECEIVABLE	STATUS
							25 % Down Payment			Advance Tax - Downpayment			1 Installment			Advance Tax 1 - Installment			2 Installment			Advance Tax 2 - Installment			3 Installment			Advance Tax 3 - Installment			4 Installment			Advance Tax 4 - Installment			5 Installment			Advance Tax 5 - Installment			6 Installment			Advance Tax 6 - Installment			7 Installment			Advance Tax 7 - Installment			8 Installment			Advance Tax 8 - Installment			9 Installment			Advance Tax 9 - Installment			10 Installment			Advance Tax 10 - Installment			11 Installment			Advance Tax 11 - Installment			12 Installment			Advance Tax 12 - Installment			13 Installment			Advance Tax 13 - Installment			14 Installment			Advance Tax 14 - Installment			15 Installment			Advance Tax 15 - Installment			16 Installment			Advance Tax 16 - Installment			Possession			Advance Tax - Possession
Sr. No	Floor No	Appt. No	Allotee Name	Net Price	Booking / DP Date	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable	Due	Received	Receivable
{{$b->name}}
{{$serial_no++}}	{{$statement->inventory ? $statement->inventory->floor->name : ''}}	{{$statement->inventory ? $statement->inventory->unit_number : ''}}	{{$statement->customer ? $statement->customer->name: ''}}	{{number_format($statement->net_pay)}}	{{date('d/m/Y' , strtotime($statement->booking_date))}}	{{number_format($downPayment_dueAmt[$statement->id])}}	{{number_format($downPayment_receivedAmt[$statement->id])}}	{{number_format($downPayment_receaviable[$statement->id])}}	{{number_format($downpayment_tax_due[$statement->id])}}	{{number_format($downpayment_tax_received[$statement->id])}}	{{number_format($downpayment_tax_receaviable[$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{number_format($possession_dueAmt[$statement->id])}}	{{number_format($possession_receivedAmt[$statement->id])}}	{{number_format($possession_receaviable[$statement->id])}}	{{number_format($possession_tax_due[$statement->id])}}	{{number_format($possession_tax_received[$statement->id])}}	{{number_format($possession_tax_receaviable[$statement->id])}}
Sub Total						{{number_format($downpayment_due_total)}}	{{number_format($downpayment_received_total)}}	{{number_format($downpayment_receaviable_total)}}	{{number_format($downpayment_tax_due_total)}}	{{number_format($downpayment_tax_received_total)}}	{{number_format($downpayment_tax_receaviable_total)}}																																																																																																	{{number_format($possession_due_total)}}	{{number_format($possession_received_total)}}	{{number_format($possession_receaviable_total)}}	{{number_format($possession_tax_due_total)}}	{{number_format($possession_tax_received_total)}}	{{number_format($possession_tax_receaviable_total)}}
GRAND TOTAL						{{number_format($downpayment_due_grand_total)}}	{{number_format($downpayment_received_grand_total)}}	{{number_format($downpayment_receaviable_grand_total)}}	{{number_format($downpayment_tax_due_grand_total)}}	{{number_format($downpayment_tax_received_grand_total)}}	{{number_format($downpayment_tax_receaviable_grand_total)}}																																																																																																	{{number_format($possession_due_grand_total)}}	{{number_format($possession_received_grand_total)}}	{{number_format($possession_receaviable_grand_total)}}	{{number_format($possession_tax_due_grand_total)}}	{{number_format($possession_tax_received_grand_total)}}	{{number_format($possession_tax_receaviable_grand_total)}}

@stop @section('js') @stop

{{env('APP_NAME')}}

Account Statement & Recovery Sheet