Aging And Receivable 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	Total Received	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue	Due	Received	Receivable	Days Overdue
{{$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($receivedAmt[$statement->id])}}	{{number_format($downPayment_dueAmt[$statement->id])}}	{{number_format($downPayment_receivedAmt[$statement->id])}}	{{number_format($downPayment_receaviable[$statement->id])}}	{{$downPayment_latedays[$statement->id]}}	{{number_format($downpayment_tax_due[$statement->id])}}	{{number_format($downpayment_tax_received[$statement->id])}}	{{number_format($downpayment_tax_receaviable[$statement->id])}}	{{$downPayment_tax_due_latedays[$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{($installment_dueAmt[$i][$statement->id])}}	{{($installment_receivedAmt[$i][$statement->id])}}	{{($installment_receaviable[$i][$statement->id])}}	{{$installment_latedays[$i][$statement->id]}}	{{($installment_tax_due[$i][$statement->id])}}	{{($installment_tax_received[$i][$statement->id])}}	{{($installment_tax_receaviable[$i][$statement->id])}}	{{$installment_tax_due_latedays[$i][$statement->id]}}	{{number_format($possession_dueAmt[$statement->id])}}	{{number_format($possession_receivedAmt[$statement->id])}}	{{number_format($possession_receaviable[$statement->id])}}	{{$possession_latedays[$statement->id]}}	{{number_format($possession_tax_due[$statement->id])}}	{{number_format($possession_tax_received[$statement->id])}}	{{number_format($possession_tax_receaviable[$statement->id])}}	{{$possession_tax_due_latedays[$statement->id]}}
Sub Total				{{number_format($net_price)}}		{{number_format($total_received)}}	{{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($net_grand_total)}}		{{number_format($grand_total_received)}}	{{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')}}

Aging And Receivable Sheet