How to handle unapplied cash advances

Summary:

Hi,

I want to know how to handle the unapplied cash advance balances in expense.

I came across the below advise..

"Close the Cash advance from Auditor page which will make the cash advance no longer available for settling after collecting the cash".

But how to record the collected balance in system.

Business does not want to go with manual JV. Expectation is system should automatically create a Credit memo to nullify or record the JV for the balance.

Please clarify if we can achieve one of these by enabling setup, no manual.

Thanks.

Content (please ensure you mask any confidential information):