Forums
I made a rent ledger that charges rent and works out late fees per tenant. What is missing?
Disclosure: I made this and I sell it.
I saw commenters under a free rent-ledger tool ask for automatic late fees with a grace period and daily charge set per tenant. So I built a spreadsheet for that (Excel and Google Sheets, for landlords with 1-10 units).
How it works:
You fill in each tenant once: rent, due day, lease dates and late fee terms. The rent is then charged every month by itself.
Each payment is one row: date, tenant, amount. It pays off that tenant's oldest unpaid charge, so a part payment, or one payment for two months, needs nothing special.
Each tenant has their own grace days and late fee: a flat fee, a percentage, a fee per day late, and a limit. No compounding.
A dashboard shows total due, unpaid rent, unpaid late fees and one coloured line per tenant. A year view shows every month as Paid, Paid late, Partial or Unpaid.
You can print a statement for any tenant and a receipt for any payment.