iExpense & Payables - To track Travel Advance to Employees

iExpense & Payables - To track Travel Advance to Employees

Hi,

Would like to seek inputs on Payable (iExpense)

The scenario is Travel advance is being given to employees before they travel.

#1 - Employees raise an expense report and seek travel advance of (say) $15000

#2 - Post expense report approval, through AP Invoice processing the payment of $15000 being done to employee

#3 - Challenge / Problem Statement:

(a) There is only one Natural Account for employee advance purpose

(b) The target population of employees required to be tracked is 100

(c) Claims / Settlement - The tracking is a problem - How to track at the time of settlement to compare the claimed figure against the earlier advance and how much was over-paid to an employee?