Forums

•

4h ago

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.

View more