Description
LOAN BOOK and PAYMENT TRACKER LOG is an Excel spreadsheet to generate amortization table automatically and record payment in the same tab for each borrower/client. By having each client written within similar worksheet tab, lender can track their monthly due amount and summary of their payment.
This is the version with EFFECTIVE INTEREST RATE METHOD CALCULATION and WEEKLY AMORTIZATION
Maximum 100 Clients per template. Duplicate the file and re-use it as many as you want for more clients.
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 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.