Description
LOAN BOOK and PAYMENT TRACKER with CUSTOM RATE & PAYMENT is an Excel template to calculate custom payment schedule and amount as well as record payment in the same worksheet for particular borrower/client as agreed by both parties. Each client will have its own worksheet to ease tracking their monthly due amount and summary of their payment.
This spreadsheet allow you to set different principal and interest payment amount as well as their payment date. You can set their payment into daily, weekly, monthly, bimonthly or any period. It should be useful for you who run your business with payment flexibility. Also, if you run a sharia business where you are not implementing interest system, then you can find that this spreadsheet is useful.
This mortgage calculator and tracker log also has a summary page that will list due amount and total unpaid amount that should help you tracking payment from all of your clients. You can use this for any type of businesses that provide loan to your customers.
You may find this is a useful spreadsheet to manage your business, especially if you are running a Credit and Savings Cooperative business that provide loan to your member.
There are two models of flat interest rate spreadsheet that you can purchase. Monthly and Weekly amortization model.
One Excel template can accommodate up to 100 clients. You can duplicate and re-use this workbook to cover as many clients as you want.
Check my other loan amortization book template for other interest rate or other amortization period.
