Monthly Expense knockoff for Laptop Advances as Expense Reports through excel

Hi Team,

I have an requirement ,My Client Wants to create Expense report through Excel and should be applied automatically to advances earlier created.

In Brief My client has two levels I.e state level and district level operations.

When state level authority gives an laptop advances to district level employee for their operations once district level employee utilized that prepayment ,He need to send a expense report invoice to State level where they want to upload it through excel and then should be applied to prepayment earlier created automatically .

Once expense report invoice is created through interface ,With that expense report invoice number we need to query on expense report invoice screen where we have only base tables called "AP_expense_report_headers_all,AP_expense_report_lines_all. we are not using OIE(Oracle Internet Expense).