I want to develop an excel file that can help in our aging of receivables & debt collections analysis
I need a pro who can develop a template for me to do the below
An excel file template that has
Pivot, drop down selections, updating the summary page getting the data from the main page.
Summary and analysis per collector
Performance indicators/Rating per collector, per month collections, per annual collections, a note to inform that the account doesnt have update, etc.