How to Keep a Rent Schedule So You Know Who Paid Which Period

Keep one rent schedule per UK tenancy: one row per period, due versus paid, partials, and a running balance you can show the tenant and match to the bank.

6 September 2026•1 min read•Article•IziRento Editorial

Rental operations notes from the IziRento team. Not legal advice.

Key takeaways

Knowing how to keep a rent schedule for landlords UK means a living period file: one row per contractual rent period, not per bank ping. Record amount due, amount received, value date, status (due, paid or partial) and a running balance. Apply a late transfer to the period it covers, reconcile each row to the bank, then share a dated statement the tenant can verify.

A late or partial bank transfer with no period label leaves you unable to say whether April is closed or May is half-paid. Knowing how to keep a rent schedule for landlords UK means one file per tenancy, one row per rent period, then apply every credit to the period it covers. You leave with due, paid and partial kept apart, plus a statement the tenant can read.

Two flats, standing orders plus a WhatsApp “paid you”, and one tenant pays April on 2 May. Without a period column you chase May and they swear they are current. The kitchen-table screenshot does not settle it. One shared row on the schedule does.

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

Why does a bank ping fail to tell you who paid which period?

A bank credit is a date and an amount. It does not name the contractual month. In practice a 2 May standing order can be April rent arriving late, or a partial against an older shortfall. Open one schedule per tenancy so you can answer who paid which period from the file.

Do start a header with property, tenant names, contractual rent, due day and opening balance, then add one row per rent period. Do not add one row per bank ping. That typical mistake turns a late April credit into a fake May receipt.

A rent schedule — a living table of what was due and what arrived — stays one running table for the tenancy. Process guides treat that as one row per rent period, with period, due date, amount due, date arrived, amount received, method or reference, and running balance.

In England and Wales a statutory rent book is only required where rent is payable weekly — see Landlord and Tenant Act 1985 section 4. A monthly landlord still needs a period schedule for ops. A rent-book log is a receipt-style job, not the period file you export as a statement.

Same 500 credit read as a 2 May bank ping and as late April rent

One row per ping

Typical mistake: logging each bank credit as a new month. A 2 May transfer then looks like May rent. Post the credit onto the period it covers.

What fields keep due, paid and partial apart?

Do not collapse “paid?” into one tick. Keep amount due, amount received, due date and value date — the date the bank shows the credit — as separate fields, plus a status of due, paid or partial. That split is what stops a leftover sum from looking like a closed month.

Lock the columns before the first payment arrives. UK landlord-association ledgers use rent due versus rent received, running balance, and payment-plan notes. Update the file when rent becomes due and when money lands.

Do not overwrite amount due when a partial lands. For example, if £900 is due and £500 arrives, the row stays partial with a £400 remainder. A worked ledger keeps the shortfall on the same period. A later top-up clears that remainder. Inventing a new month hides the problem.

April row with due 900, received 500, value 2 May, remainder 400

What to record on a rent schedule

Field	What it answers	Do not
Period from / to	Which contractual window this row covers	Skip dates on a mid-month move-in
Amount due + due date	What the tenancy asked for, and when	Overwrite due when a partial arrives
Amount received + value date	What landed, and when the bank shows it	Treat the value date as the period name
Method + reference	How it arrived; the bank line to tick	Rely on a chat note as the reference
Status + remainder	Due, paid or partial; what is still missing	Tick “paid” on a short payment
Running balance + notes	What both sides can read	Rebuild the balance after a dispute

Rent book versus rent schedule

A weekly statutory rent book is a receipt-style duty in a narrow case. A rent schedule is the ops file that answers who paid which period.

How do you apply a late transfer to the period it covers?

When money lands, apply it to the period it covers. April rent arriving on 2 May is an April payment with a May value date. May stays due on its own row until May is paid. If the tenant does not name the period, match amount plus the standing-order reference.

Do write that allocation on the statement you later share. Do not mark May paid because the calendar said May. Due date and value date are two clocks.

Post the 500 credit onto the April row and leave 400 remainder

Post a payment onto the right period

Open the tenancy schedule, not the whole bank feed
Header: property, tenant names, contractual rent, due day, opening balance. One file per tenancy, not a portfolio rent roll.
Add or open one row for the contractual period
Set period from/to, amount due and due date before you touch the credit.
Match the credit to the period it covers
April arriving on 2 May stays on the April row. Put 2 May in value date, not in the period name.
Record a partial on the same row
Enter amount received, status partial, remainder still due. A later top-up is not a fresh month.
Refresh status and the running balance
Mark paid only when amount received meets amount due. Carry any shortfall on the balance.
Tick the bank line, then file the evidence
Reconcile the row to the credit and value date. A chat receipt without that bank line is not a closed period.

How do you keep a running balance the tenant can be shown?

A running balance is the number both sides can read when the tenant asks whether they are up to date. Charge the period, post the payment, carry any shortfall. The statement you share is a dated slice of that living file, not a rebuilt memory after a dispute.

A rent statement — the tenant-facing slice — lists parties, the statement period, opening balance, then dated lines. Live rent statement template UK guides keep Period From/To, charge, payment, reference and running balance on those lines. A statement is not a single-payment receipt.

Tenants ask for that slice for a benefit claim or a reference. There is no single statutory layout for a private-landlord statement. Contemporaneous records beat a file you rebuild later.

Do set the opening balance (treat a credit as negative) and one event per line. Do not treat the PDF as the only file. Some record-keeping guides split three files: what was due, what arrived, and an arrears log if payments slip. Keep them with the bank statements for that tenancy.

Reconcile the schedule against the bank, not memory

A schedule you typed is only as strong as the bank line behind it. Tick each row against the credit and value date. Reconcile to the bank, not to memory or a chat that never named the period.

A simple workflow: open the tenancy file → add or open the period row → apply the credit → update status and running balance → tick the bank line → file the statement PDF with that period’s evidence.

Do file the bank evidence with the period. Do not close a row because someone sent a photo of a transfer. Two units that share one chat and one current account need two schedules. Unit A’s standing order cannot close unit B’s period.

Stop at the ops file

This guide ends when you can show who paid which period and hand the tenant a dated statement. A first written follow-up in the next 30 days is another job.

When is a WhatsApp receipt not a closed period?

A chat receipt is supporting colour. It is not a closed period unless the amount, reference and bank credit match a named row. A “paid you” with no period still risks chasing the wrong month.

Do paste the message into notes and keep the period open until the bank line matches. Do not let two flats share one thread as the source of truth.

Success bar: one schedule per tenancy, one row per period, a 2 May credit on April, a partial without a new month, and a statement the tenant can read against the bank. If a period stays unpaid, the first 30 days is another file.

If the spreadsheet already mixes two flats and a WhatsApp thread, keep the weekly habit on the spreadsheet process. Try the IziRento workspace to hold the same period file.

FAQ

What if a tenant pays April rent on 2 May?

Allocate the credit to April and leave May as its own unpaid row. Put 2 May in the value-date field, not in the period name.

How do I record a partial payment?

Post it on the same period row with status partial and a remainder. Do not invent a new month. Spreadsheet weekly habit: https://izirento.com/en-gb/blog/rent-tracking-spreadsheet-process

Do I need a separate schedule per unit?

Yes. Keep one schedule per tenancy or unit, then reconcile each row to its own bank reference.

What should I record on a rent schedule?

Record period from/to, amount due, due date, amount received, value date, method and reference, status, remainder, running balance and notes.

Do monthly landlords need a statutory rent book in England and Wales?

A statutory rent book is required where rent is payable weekly, not merely because you let monthly. You still want a period schedule for ops.

How do I reconcile a rent schedule to the bank?

Tick each schedule row against the credit and value date. A chat note without a matching bank credit is not a closed period.

Try the IziRento workspace

Keep properties, leases and rent-period records in one file for evaluation.

Try the workspace

Keep one rent schedule per UK tenancy: one row per period, due versus paid, partials, and a running balance you can show the tenant and match to the bank.

Sources

Next steps