How to keep proper records for rental properties

Most landlords already keep some kind of record. The problem is almost never a total absence of records — it's that the records exist in the wrong shape for the moment they're actually needed: a tax filing, a dispute with a tenant, a bank asking for proof of income against a loan application, or simply handing the portfolio to someone else to manage for a few months. A record that only makes sense to the person who wrote it isn't really a record — it's a memory aid.

What a rental record actually needs to answer

A useful record for a single unit should be able to answer four questions without a phone call: who is the current occupant, what do they owe and by when, what have they already paid, and what does the paperwork (lease, ID, guarantor details) actually say. If any of those four requires asking someone rather than looking something up, the record has a gap.

Where informal record-keeping actually breaks

• Payment proof lives in a chat, not a ledger. A screenshot of a bank transfer sent over WhatsApp is evidence of one transaction, not a record of the tenant's full payment history — and chat history gets deleted, phones get replaced, and screenshots get lost in the scroll.
• The lease exists, but only as a photo. A photographed or scanned lease agreement stored on one person's phone isn't backed up, isn't searchable, and isn't accessible to anyone else who might need to check a clause during a dispute.
• Receipts are written by hand, inconsistently. A handwritten receipt book is a real record, but only for as long as the book exists and only for whoever can read the handwriting.
• Nobody separates rent from other money changing hands. Caution deposits, service charges, and rent often get lumped into the same mental bucket, which makes it genuinely difficult to answer “how much rent has this tenant actually paid this year” without manually re-deriving it.

A minimum standard worth holding every property to

Whatever system you use — software, a shared spreadsheet, or a well-organized folder — it should let you produce, for any single unit, on request: the current occupant's contact and lease details, a dated list of every payment received against that lease, the current balance owed, and copies of the lease and any ID or guarantor documents collected at move-in. If producing that list for one unit takes more than a few minutes, the underlying record-keeping needs attention before the portfolio grows any further.

Where this connects to bigger problems

Weak records don't usually cause a crisis on their own — they make every other problem worse. A tenant dispute over whether rent was paid becomes a real argument instead of a quick lookup. A tax season becomes a scramble instead of an export. Chasing rent arrears becomes guesswork about who actually owes what. Fixing the records fixes the surface area of all of those problems at once, which is usually a better use of time than trying to solve each one individually as it comes up.

This is one of the reasons landlords eventually move to dedicated property management software — not because a spreadsheet is technically incapable of holding this information, but because keeping it consistently organized by hand, indefinitely, across every unit and every tenant, turns out to be harder to sustain than it looks at the start.