Loan Working Paper with Daily Interest

An auditor-style working paper for loans to related parties: date, voucher and receipt numbers, description, amount paid, debit, credit and balance, interest period, days, rate and interest on every line. Interest accrues on the reducing balance for the actual number of days (balance × rate × days ÷ 365, unrounded), and each repayment is split into interest and principal automatically. Handles extra loans, payments off the month end and mid-year rate changes, and reconciles the year's interest against the books. Dates display in the Thai Buddhist era and the sheet is print-ready. Works in Excel and Google Sheets.