Landlord Rent Tracking: The Spreadsheet Process That Stops Losing Who Paid What

A bank ping or a WhatsApp “paid you” leaves you unable to say which tenant, which property, and which period the money covered. The working file writes period-from and period-to on every payment line the week it hits the bank, plus a searchable reference. You will leave with a column set, a same-week habit, and a single live file plus a backup.

Two flats, one standing order labelled only with a surname. March looks “paid” as a monthly total. In May the tenant asks for a Universal Credit statement, and you cannot split March from a February catch-up. Period-from and period-to on the payment line the week the money landed would have closed it.

Disclaimer: IziRento is operations software, not legal advice. Local tenancy rules vary; check a qualified adviser for binding decisions.

Why does a monthly total fail as a rent record?

A monthly total or a paid/unpaid tick cannot say which period a credit covered. In practice a standing order that lands in May can be May rent, late March, or a February catch-up plus a partial. Open period-from and period-to so March and a catch-up stay two answers.

Here is the surprising bit. A monthly total is not a rent record. Process guides treat a rent schedule as one row per period — due, arrived, method, reference, running balance. A weekly tenancy may need a rent book under Landlord and Tenant Act 1985 section 4; a monthly standing order does not, but it still needs a period ledger. A one-row-per-property year-to-date total is a rent roll. That layout loses which period a catch-up covered. For April arriving on 2 May, use the period schedule: keep one schedule so you know who paid which period. Do start a header with property, tenant, rent and due day. Do not keep one “paid” cell for the month.

What to record so columns survive a later question?

Do not collapse “paid?” into one tick. The columns that survive a later question are Date, Period from, Period to, Description, Amount due, Amount received, Method, Bank or receipt reference, Running balance, and Notes. A header holds property, tenant, contractual rent and due day.

A rent statement — the extract you send — is drawn from that ledger: opening balance, then one line per event with Period From and Period To. Those fields stop a mid-month move-in vanishing into “September paid”. A receipt proves one payment; a statement shows the account. Write the period the payment covers as soon as money arrives, for example 1–31 March. Do not overwrite amount due when a partial lands.

How do you log one row the week the money lands?

Write the row the same week the credit hits the bank. Assign the period the payment covers, including a catch-up or a mid-month start. Do not fold the amount into a monthly total and stop. A chat photo can sit behind that row; it does not replace it.

A WhatsApp screenshot can support a row if it shows date, time and sender and is logged. It is not the ledger. Typical mistake: a handful of screenshots without a schedule. Keep the ledger contemporaneously, not after a dispute. A spreadsheet is easiest to update; a PDF is what you send. If they paid cash, write the row the same day and keep a receipt number.

When to use one sheet per property instead of one tab?

Use one file per property when you have one or two doors, or you keep overwriting the wrong tenant. Use one workbook with one tab per tenancy when you review several lets together and want the same column set. Never one blended “all rent” total without period rows.

Keep property records separate, especially with more than one let. NRLA record-keeping guidance is written around that split. Do not merge two standing orders that share a surname into one tab.

How do you keep one working file plus a backup?

Keep a single live file and a backup — cloud sync or a dated copy off the laptop. Do not email around versioned finals. Name the working file so you can find it next week, and keep personal spend out of the same sheet.

The cheap insurance is a weekly reminder plus an off-device copy of that same file. Process listicles keep flagging the laptop-only copy. Do not treat five “final” copies as a backup.

Which habit beats a year-end reconstruction?

A weekly habit the week rent is due beats a January pile. Check the bank, write missing rows, and note any unpaid period on the same schedule. Record income and times rent was not paid, a little at a time.

Do the bookkeeping when you already check the bank. NRLA practice, via Sage, is income and unpaid periods in one rent statement, not a January rebuild. HMRC wants accurate records of rent received kept at least five years after the 31 January deadline for that tax year.

Workflow: open the file → log the credit the same week → write the reference → refresh the balance → confirm the backup. Success bar: name the columns, verify the bank line the week it lands, and keep one live file plus a backup. That is the checklist. If a period stays unpaid, the first written follow-up is another job: handle the first 30 days of rent arrears as a written file. If two flats share one chat thread, try the IziRento workspace to keep the lease, period and payment note together — assistive ops only.