Rent records

Rent Statement Template and PDF Generator

Give your tenant a clear rent account for a chosen period. This free generator brings the rent due, payments received and any earlier rent owed or held in credit into a PDF you can check and share.

Free PDF rent statement and editable Word template with a fictional worked example.

Free rent statement generator

Make a rent statement your tenant can follow

Add the rent due and payments received, then download a statement for your tenant.

A worked example

Earlier unpaid rent explains the final £400.

The generator and Word example follow Sam Taylor and Alex Morgan’s fictional rent account for Example Flat A, from 1 August to 30 October 2026.

Before 1 August

The account starts with earlier unpaid rent.

Unpaid at the start
£200

Bring this checked balance forward from the earlier records. The rent charge dated 1 August belongs in the new period rather than in that opening amount.

As at 30 October

The later payments still leave £400 unpaid.

Rent charged during the period
£3,000
Payments received during the period
£2,800
Closing amount unpaid
£400

The period adds £200 to the amount unpaid. Together with the £200 opening balance, that leaves £400 on this rent account.

If the opening position is unknown, the same period totals show only the movement during the period. They cannot establish the whole account’s closing balance.

Keep the working rent record in the free Excel tracker.

Give the tenant a rent account they can follow.

Landlords and letting agents preparing a rent statement for one tenancy or a stated joint tenancy account. It turns the relevant part of your working rent records into a document the tenant can read.

Start with the balance before this period.

The generator puts the rent charges and payments you enter in date order. Add the amount owed or held in credit at the start to see the running balance and final total. Leave it blank if unknown, and the statement will show only the change during the period.

The worked example follows a fictional account across three months. An editable Word template is also available. This is a rent account, so keep deposit money, damage deductions and other disputed sums in their separate records.

Check the payments before sharing the statement.

Match the entries to the bank or agent record before issuing a statement. A promised payment is not money received, and a payment after the statement period should not clear the balance shown at that earlier date.

Bring forward the checked balance immediately before the statement starts. The existing Excel tracker can remain your working record while this page creates the tenant’s statement. Keep a copy of each statement you issue, with the records that support it.

Frequently asked questions

What should I enter as the opening balance?

Use the checked rent account balance immediately before the statement period begins. An amount already included there should not also be entered as a new charge during the period.

What if the opening balance is unknown?

Leave it unknown. The generator can still total the rent charges and payments entered for the period, but it will not call the whole account paid, settled or in credit.

Can a statement show a credit?

Yes. A known credit is a negative opening balance. The statement labels a negative closing position as credit on this rent account, which is separate from any decision about refunding or allocating it.

Can I use the existing rent tracker?

Keep using the Excel tracker for the working record. Transfer the relevant tenancy’s dated charges and received payments into this statement, with the checked opening balance for the chosen period.

Keep the rent account separate from other money.

Use the rent agreement and actual payment records to check the account. A holding deposit, tenancy deposit or proposed damage deduction has a different purpose and should not be entered as a new rent payment to make the account appear cleared.

The statement records the account you enter. It does not change the agreement or decide a disputed debt. Keep the supporting records and check the completed PDF before sharing it.

Guidance checked on 30 October 2026.

Download the Rent Statement Template and PDF Generator

Enter your details once and every template in the library unlocks.

Please note: these free templates are practical starting points. Adapt them to your property, booking channel and situation, and take advice where legal or financial decisions are involved. UpgradedPM and The Upgrade Authority Ltd accept no liability for how they are used.

← Back to the full template library

Download the templates

Enter your details for access to the template library. We also send occasional property emails.

These free templates are practical starting points. Adapt them to your property, booking channel and situation, and take advice where legal or financial decisions are involved. UpgradedPM and The Upgrade Authority Ltd accept no liability for how they are used.