LOCAL EXPENSE REPORT & LOCAL EXPENSE BILL CLAIM

1. Employee PIN : {{ tour_claim.user.userName }}

2. Name : {{ tour_claim.user.fullName }}

3. Designation : {{ tour_claim.user.designation }}

4. Department : {{ tour_claim.user.department }}

5. Report submission date : {{ tour_claim.submitionDate|date("d-m-Y") }}

6. Conveyance starting date : {{ tour_claim.startingDate ? tour_claim.startingDate|date('d-m-Y') : '' }}

7. Conveyance ending date : {{ tour_claim.endingDate ? tour_claim.endingDate|date('d-m-Y') : '' }}

8. Conveyance Details : {{ tour_claim.tourDetails }}

{% set grandTotalAmount = 0 %} {% for tourClaimDetailsGroup in localExpenseDetailsGroupBy %}


Category : {{tourClaimDetailsGroup.category}}

{% set totalAmount = 0 %} {% for tourDetails in tour_claim.tourClaimDetails %} {% if tourClaimDetailsGroup.category == tourDetails.category %} {% set counter = ( counter | default(0) ) + 1 %} {% set totalAmount = ( totalAmount | default(0) ) + tourDetails.amount %} {% set grandTotalAmount = ( grandTotalAmount | default(0) ) + tourDetails.amount %} {% endif %} {% endfor %}

Customer	Reason	From / Location	To / Location	From Date	To Date	Mode of Transportation	Amount	Remarks
{{ tourDetails.customerName }}	{{ tourDetails.expensePurpose.name }}	{{ tourDetails.fromPlace }}	{{ tourDetails.toPlace }}	{{ tourDetails.startingDate ? tourDetails.startingDate\|date('d-m-Y') : '' }}	{{ tourDetails.endingDate ? tourDetails.endingDate\|date('d-m-Y') : '' }}	{{ tourDetails.travelMode }}	{{ tourDetails.amount \|number_format(2, '.', ',')}} {{ tourDetails.amountCurrency }}	{{ tourDetails.remarks }}
Total Amount:							{{ totalAmount\|number_format(2, '.', ',') }}

{% endfor %}

Grand Total Amount :

{{ grandTotalAmount |number_format(2, '.', ',')}}

{# #} {# #}

Superviser / Functional Head Approval	Department's Head Approval	CBO's Approval	HR Department's Comment
{% if functionalHeadObj is not null %} Approved By {{ functionalHeadObj.fullName }} {{ tour_claim.fhApprovalDate\|date('d-m-Y') }} {% else %} N/A {% endif %} --------------------- Signature & Date	Approved By {{ departmentHeadObj.fullName }} {{ tour_claim.dhApprovalDate\|date('d-m-Y') }} --------------------- Signature & Date	{% if ceoObj is not null %} Approved By {{ ceoObj.fullName }} {{ tour_claim.ceoApprovalDate\|date('d-m-Y') }} {% else %} N/A {% endif %} --------------------- Signature & Date	--------------------- Signature & Date

This is a system generated bill and does not require a signature.

Note:
1. Original Invoices/Bills must be attached in support of expenses (Hotel, Transportation, Tickets, Food Bills etc). No claim shall be honored without proper supportive invoices/bills.
2. TR to be submitted within two days of tour completion
3. Extra page can be used if required
4. One copy of the Tour report to be kept in the personal file of the employee
5. CBO’s approval is required only for Manager’s and above.