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.
What it does not do: it holds 10 tenants, 12 months, 60 other charges and 400 payments per file. Payments always go to the oldest unpaid charge, and you cannot point one at a chosen charge. It has no expense tracking, reminders or invoices. Late fee rules differ by place, so users must check their own rules and lease. It is not legal, tax or financial advice.
It costs $12: https://9797658955612.gumroad.com/l/kfuybt
I would like feedback on two things. Is oldest-charge-first the right rule for payments, or do you need to choose the charge? What would you want on the dashboard that is not there?
Replies
Be the first to reply
Have a question or a thought to share? Add a comment above to start the conversation.