Automatic interest calculation sheet
Budget: ₹600 – ₹650 INR
Loan open date 30-3-20
Amount -37000
Part payment receipt -
1-5-20 -15000
1-8-20-5000
26-3-21-100
2-4-21-500
10-3-21 -500
20-3-21-500
30-3-22-400
I need a data what is closing Balance on 31-3-21
And 30-4-21,31-5-21 (so on closing balance on last date of month of 1-4-21 to 31-3-33 )with penal interest and interest receivable( which we will actual we charge on customer)
If customer pay timely
Amount -37000
Part payment receipt -
1-5-20 -15000
1-8-20-5000
26-3-21-100
2-4-21-500
10-3-21 -500
20-3-21-500
30-3-22-400
I need a data what is closing Balance on 31-3-21
And 30-4-21,31-5-21 (so on closing balance on last date of month of 1-4-21 to 31-3-33 )with penal interest and interest receivable( which we will actual we charge on customer)
If customer pay timely