How to prepare instant Aging / debtor analysis in Excel
How we can Use the excel to check that since how long customer has not paid his due amount , which can further categorize in #SLAB according to pending days since last paid ( #DPD ),
Such analysis is required to check whether debtor position and organization's financial health in terms of debtors collection.
Higher the Slab , higher the urgency of collection
#Debtor Analysis
#DPD
#Aging Analysis
#Backoffice
#MIS Executive
#Back Support officer
#EXCEL
#Vlookup