HARTHERLetting records software

Home / Resources

Notes for anyone keeping letting records

Practical, general guidance on organising records. Not legal, tax or financial advice; official government guidance is the authority on requirements.

The one-folder rule

Give every tenancy one folder, and inside it the same set of sub-folders in the same order: agreement, inventory, deposit, certificates, rent, repairs, correspondence. Name files with the date first (2026-03-14 gas safety record) so they sort themselves. The habit costs nothing and makes any later move to software dramatically easier.

A year of letting dates

Most tenancy files need to track a handful of recurring dates: certificate renewals linked to the property, the end of the fixed term, rent review points, planned visits and alarm checks. Put each in one diary with a lead time long enough to arrange the work, and record when it was done, not only when it was due. Our key-dates planner drafts the tenancy-related ones.

Before migrating a spreadsheet

  • Make a copy and work on the copy.
  • One row per thing: do not mix property rows and payment rows.
  • One fact per column: split “12 Mar, paid cash” into a date and a note.
  • Consistent dates and amounts, with no currency symbols in number cells.
  • Write down what every colour and abbreviation means.
  • Remove personal data you no longer need.

After a tenancy ends

Decide in advance how long you keep each kind of record once a tenancy has ended, and why. Some records may need keeping for financial or legal reasons; others, such as contact details, should not be kept indefinitely. Write the periods down and apply them. Software can do the reminding; the decision is yours and your adviser’s.

Glossary

Fixed term
The initial agreed period of a tenancy.
Periodic tenancy
A tenancy that continues period by period after, or instead of, a fixed term.
Inventory
A dated record of a property’s contents and condition, usually at check-in and check-out.
Deposit reference
The identifier given when a deposit is protected in a scheme.
Rent schedule
A list of rent amounts expected on given dates.
Reconciliation
Checking migrated records against originals by counts, totals and samples.
Retention period
How long a record is kept before deletion or archiving.
Controller
Under data protection law, the person or organisation deciding why and how personal data is used.