Dear Experts,

Need your help on to set debtor ageing report with adjustment of credit balances against debit balances on FIFO basis with the help of excel formulas and functions. I have given old debtor ageing and desired debtor ageing along with scenario for better understanding. If need further clarification, pls. let me know.



Thanks in advance

Attached Files

Debtor ageing template EF.xlsx (11.8 KB, 3 views)