Question: how to do ageing analysis in excel?
Answer: Label the following cells: A1: Customer. B1: Order # C1: Date. D1: Amount Due. Enter in the corresponding information for your customers and their orders underneath the headlines.
Add additional headers for each column as: E1: Days Outstanding. F1: Not Due. G1: 0-30 Days. H1: 31-60 days. I1: 61-90 days. J1: >90 days.