LOCAL EXPENSE STATEMENT
For the period from {{ fromDate|date("d-m-Y") }} to {{ toDate|date("d-m-Y") }}
Print Date : {{ "now"|date("d-m-Y") }}

{% set totalAmount = 0 %} {% for tour_claim in tour_claims %} {% set totalAmount = ( totalAmount | default(0) ) + tour_claim.amount %} {% endfor %}

SL#	PIN	Employee	Designation	Department	Expense Category	Customer Name	Details of Conveyance	Reason	From / Location	From Date	To / Location	To Date	Mode of Transportation	Amount	Remarks
{{loop.index}}	{{tour_claim.tourClaim.user.username}}	{{tour_claim.tourClaim.user.fullName}}	{{ tour_claim.tourClaim.user.designation }}	{{ tour_claim.tourClaim.user.department }}	{{ tour_claim.category }}	{{ tour_claim.customerName }}	{{ tour_claim.tourClaim.tourDetails\|slice(0, 55) }}	{{ tour_claim.expensePurpose ? tour_claim.expensePurpose.name : '' }}	{{ tour_claim.fromPlace }}	{{ tour_claim.startingDate ? tour_claim.startingDate\|date('d-m-Y') : '' }}	{{ tour_claim.toPlace }}	{{ tour_claim.endingDate ? tour_claim.endingDate\|date('d-m-Y') : '' }}	{{ tour_claim.travelMode }}	{{ tour_claim.amount\|number_format(2, '.', ',') }}	{{ tour_claim.remarks }}
Grand Total :														{{ totalAmount \|number_format(2, '.', ',')}}