← Blog

A simple system for tracking rent due dates without a calculator

2026-05-18 · 4 min read

It's the 3rd of the month and you're standing in the kitchen doing math in your head. Apt 2 is due on the 1st, Apt 5's lease started mid-month so they're due on the 15th, and didn't unit 3 pay early last time? You open the spreadsheet, squint at a formula you wrote eight months ago, and hope it's still right.

Why mental math falls apart

With one or two units, you just know. Rent is due on the 1st, you check your bank app, done. The system in your head works because there's almost nothing to remember.

Then you add a unit, and another. Now due dates are scattered: some on the 1st, some on the 15th, one that's prorated for a move-in. Mental math turns into guesswork, and guesswork is how a late payment slips by for a week before you notice.

Why the spreadsheet formula isn't better

A formula feels like an upgrade until it isn't. You build a column that calculates the next due date, then a tenant moves out, a lease renews at a new rent, someone pays late, and the formula no longer matches reality.

  • The formula assumes every unit is due on the same day, which stops being true the moment you have more than a couple of leases.
  • Prorated first months and mid-cycle move-ins break the math, so you patch a cell by hand and forget you did.
  • There's no record of what's actually been paid, only what should be owed in theory.
  • When you copy a row to add a unit, you drag along the old rent and a stale due date.

A simple system that holds up

You don't need accounting software. You need four boring things to be true, and to stay true as the portfolio grows.

  • One source of truth per unit: the rent amount and the due date live on the lease, not in your head or a side tab.
  • The due date is on the record, so it's correct for that unit even when units differ.
  • A nudge before it's due, so you're never relying on remembering the 1st across a dozen leases.
  • A clear paid and unpaid view, so at a glance you know who's current and who isn't.

The point is to stop calculating. Once the due date lives on each lease, the question 'who's due and when?' has an answer you can read instead of derive.

How Unitly helps

In Unitly, rent and dates live on each lease, so the due date is right for every unit without a formula. Leases carry their own start, rent, and renewal, and a prorated first month doesn't blow up a shared column because there isn't one.

Your dashboard surfaces what needs attention so you're not hunting, and leases expiring soon are flagged before they sneak up on you. Up to five active units are free, so you can put every lease's rent and due date on the record and stop doing the math in your head.

Ready to get off spreadsheets?

Try Unitly free