Landlord Rent Ledger Template: Track Payments and Reconcile the Balance

A useful rent ledger records what was charged, what was actually received and how each receipt was allocated. Keep those facts separate, and the outstanding balance becomes something you can explain rather than a number you have to trust.

The copyable template below suits a landlord reconciling an ordinary tenancy in a spreadsheet or record system. It includes an opening balance, partial payments and a correction. It is an operational template, not a prescribed rent book, statutory notice, tax return or substitute for legal advice. The worked figures are fictional.

1. Keep a rent ledger, not just a list of bank deposits

A bank statement tells you when money arrived. It does not necessarily tell you which tenancy or rent period it covers. A ledger adds that explanation. A tenant paying £750 against £1,000 rent has made a real payment, but the period is not fully paid.

HMRC expects rental records to include rent received and supporting material such as receipts and bank statements. Keep those sources alongside your working ledger; the spreadsheet is an index and calculation, not a replacement for the evidence. See HMRC’s rental-record guidance.

2. Copy these fields into your template

Use a tenancy summary followed by one chronological entry for each charge, receipt or adjustment. These fields can become spreadsheet columns or individual entries in a record system:

• Tenancy reference: a stable identifier, property and tenant name; avoid unnecessary identity information.
• Rent terms: agreed amount, frequency, due date and the date those terms took effect.
• Opening position: outstanding amount or credit, effective date and the supporting previous ledger.
• Entry reference and date: a unique reference and the actual event date.
• Entry type: rent charge, receipt, approved credit or correction.
• Rent period: the period affected, including both start and end dates.
• Amount: charge, receipt or adjustment in a clearly named field.
• Allocation: how much of a receipt belongs to each period.
• Evidence: bank reference, receipt, agreement or approval reference.
• Running balance: calculated outstanding amount after the entry.
• Review note: author, explanation, unresolved question and next action.

Set a visible sign convention. In this template, a positive balance means rent remains outstanding; a negative balance means a recorded credit. Do not mix the two conventions midway through a sheet.

3. Establish the opening balance before adding new rent

Choose a start date and reconcile everything immediately before it. If £200 is already outstanding, bring it forward once, with a link to the earlier periods. Do not also import those old charges as new entries: that would count the same balance twice.

If the opening amount is disputed or unverified, label it accordingly rather than presenting it as settled fact. Record what you checked and what remains unresolved. A rent credit needs the same explanation as an outstanding amount.

4. Worked example: two payments and an approved credit

Fictional training example: Sample House has £200 brought forward from August. September rent is £1,000. There are no other charges or receipts. For this example, the recorded allocation applies receipts to August first, then September; document the actual allocation agreed or applicable to your own tenancy.

1. 1 September: £200 opening balance plus £1,000 September charge gives £1,200 outstanding.
2. 3 September: £750 received. Allocate £200 to August and £550 to September. Outstanding balance: £450.
3. 15 September: £300 received and allocated to September. Outstanding balance: £150.
4. 16 September: a £50 September rent credit is approved and recorded with its reason. Outstanding balance: £100.

Check: £200 + £1,000 − £750 − £300 − £50 = £100. The bank receipts total £1,050. August is cleared; September has £850 allocated receipts plus a £50 credit against £1,000 charged, leaving £100. A credit is not money received and must not increase your receipts total.

5. Use a repeatable monthly reconciliation

1. Check that rent charges match the recorded terms and periods.
2. Compare every receipt with the payment source, including date and reference.
3. Resolve unmatched money before assigning it to a tenant.
4. Check that each receipt’s allocations add up to its recorded amount.
5. Review credits, reversals and corrections with their explanations.
6. Recalculate the closing balance and carry it forward once.
7. Save a dated copy and note unresolved differences.

For the simple example above, closing balance equals opening balance plus rent charged, less allocated receipts and approved credits. Refunds, reversals and additional adjustments need their own clearly documented treatment; do not silently rewrite the original payment.

6. Avoid the errors that make a ledger unreliable

Importing the same bank file twice can duplicate receipts. Test the duplicate-checking behaviour or mark which source rows you have already processed. A “paid” tick without an amount can conceal a partial payment. Replacing the original receipt with a new total hides the sequence.

Keep tenancy deposits and other non-rent money separately identifiable instead of calling every incoming transfer rent. If a managing agent deducts fees before paying you, obtain the statement explaining gross receipts and deductions: the net transfer is not the whole story.

7. Make the history useful to someone else

Before sharing, include the date range, opening position, charges, receipts, adjustments and closing balance. Check that evidence references work and remove unrelated personal information. A reader should be able to reproduce the balance without calling you.

The arrears evidence checklist covers subsequent communications and arrangements; the digital property-file guide explains where to keep the supporting history.

8. Rent-ledger questions

Is this a downloadable spreadsheet?

No. It is a copyable field template and worked example on this page. Copy the fields into your own sheet or inspect Tendmere’s rent-tracking workspace; do not assume a download or automatic bank connection is included.

Does an outstanding balance prove legal arrears?

It explains the recorded position, subject to your terms, allocations and unresolved corrections. Reconcile it and obtain appropriate advice before formal action; this template is not a possession assessment.

Does the spreadsheet meet MTD requirements?

Not by itself. A compliant record-to-filing arrangement depends on compatible software and digital links. Check HMRC’s digital-record guidance with your accountant. Tendmere’s production HMRC filing is not enabled.

General record-keeping guidance. The Tendmere editorial team checked the linked primary sources on 6 September 2026; this is not a claim of professional legal or tax review.