In the Excel itself, you can get a Loan template, Open an Excel workbook-> Go to File -> Right side you see many inbuilt template search for Loan schedule, Hope it helps you
We need to add negative numbers, eg : -50,-40,-30,-20,-10 in these order, as per your Criteria 2 columns Days Ageing Category -20 Less than -20 Days will be in due -10 Less than -10 Days will be in due
Thank you
How to make 36 bank installments of any employee change every month in excel sheet
In the Excel itself, you can get a Loan template, Open an Excel workbook-> Go to File -> Right side you see many inbuilt template search for Loan schedule, Hope it helps you
Hi, if less than zero how will come
We need to add negative numbers, eg : -50,-40,-30,-20,-10 in these order, as per your Criteria
2 columns
Days Ageing Category
-20 Less than -20 Days will be in due
-10 Less than -10 Days will be in due
How to find 30,60,90,120 days
Just consider 29,59,89,119 days reduce one number