Back to templates

What’s included

Template files and a getting-started guide

Personal use, customize to fit your needs

Re-download from your library

Excel

Multi-Borrower Loan Ledger (Monthly or Daily Interest)

A lender's ledger for up to 10 borrowers, one tab each, with a summary of principal left, interest received, interest due next and who has paid off. Choose per borrower whether interest is a monthly rate (a full month earns balance × rate) or an annual rate counted by actual days. Reducing balance on every payment, with worked examples for extra borrowing, interest-only payments, paying down principal to zero and mid-month payments. Flags rates above the legal cap, shows Thai Buddhist-era dates, and works in Excel and Google Sheets.

tTemply StudioDesigned for easier days
THB 299.00One-time purchase

Free vs Premium

FeatureFreePremium
One tab per borrower + summary
Borrowers3 borrowers10 borrowers
Reducing balance, monthly rate
Extra borrowing · interest-only · paying down
Interest due next + paid-off status
Annual rate by actual days, per borrower
Worked examples of all 3 cases
Sheets5 sheets12 sheets
Try the free edition first