If employee is taking an advance then status of advance payment can be seen from this report. The From Date / To Date range is linked to advance payment date. The From Date / To Date is linked to the Date Paid.

Status of advances
1. Paid : Advance has been paid to employee but has not adjusted or refunded by employee
2. Settled : Advance has been fully adjusted through an expense claim or payroll recovery

Report can be generate separately for active and resigned employees separately. Click on "Export to Excel" to get out in excel.