Landlord Record Keeping: What to Track, and What It Is Worth

Record keeping is the least interesting thing a landlord does and the most expensive thing to do badly.

Not because it is hard. Because it is boring, individually trivial, and the cost of skipping it never arrives on the day you skip it. It arrives eleven months later, in three places at once.

This is what to keep, how long for, and what the gap is actually worth.

The three ways poor records cost you money

1. Unclaimed expenses

The obvious one, and the smallest. Landlords do not under-claim because they are cautious — they under-claim because the 14 at the hardware shop, the 63 of mileage and the 78 void-period electricity bill never got written down.

In the sample portfolio we use in our own spreadsheet, five properties generated 10,958 in costs across a year, of which 7,558 was deductible. The long tail alone — gutter clearing, void utilities, mileage, council tax on an empty flat — came to over 400. Money spent, deductible, and gone because nobody logged it.

2. Lost borrowing capacity

This one is much larger and almost nobody connects it to bookkeeping.

When you apply for finance on the next property, the underwriter needs to believe your rent figure. If you cannot evidence twelve months of rent actually received, they do not refuse you — they use the conservative number. Every month you cannot evidence reduces the income they will lend against.

Applications that arrive incomplete also get referred rather than auto-approved, and referred cases frequently come back with a higher rate or a lower loan-to-value. That cost recurs every month for the life of the loan.

Our guide to financing your next rental property works through the arithmetic. The short version: your records are not admin, they are collateral.

3. Decisions made on feel

The expensive one, and the hardest to see.

A landlord who cannot state their net yield, their real monthly cash flow and their existing debt position cannot tell whether the next purchase is a good idea. They find out eighteen months later, from a property that was never going to work.

The six records worth keeping

1. Rent received — not rent due

Month by month, per property, the amount that actually landed and the date it landed. The tenancy agreement says what is owed; only your bank statement says what arrived.

Track arrears as the difference. It is the earliest possible warning that a tenancy is going wrong, and it is invisible if you only record the expected figure.

2. Expenses, categorised, with the deductible flag

Four fields: date, property, category, amount — plus the receipt. Add a yes/no for deductible and your year-end becomes reading a total rather than an archaeology project.

The categories that matter are covered in full in our rental expenses checklist.

3. Mortgage interest, separated from capital

Your monthly mortgage payment is not an expense. Only the interest portion has any claim to be.

On a 135,000 loan at 5.5% over 25 years the payment is 829.02, but only 618.75 of the first payment is interest. The other 210.27 is you buying your own house back. Deducting the whole payment is simply wrong, and it is an easy mistake to make from a bank statement.

Keep the split. Both your accountant and any future lender will ask for it.

4. Void periods

Dates a property sat empty, per property. Two reasons: the costs during a void are deductible and routinely missed, and lenders assessing a portfolio will ask.

5. Tenancy documents

Signed agreements, the inventory with photographs, deposit protection confirmation where required, and every safety certificate. These are the documents whose absence is discovered at the worst possible moment.

6. Screening decisions

Who applied, what they were scored against, and why each decision was made — recorded on the day. If a rejected applicant ever challenges you, a contemporaneous note is evidence and a reconstruction is your word. See how to screen a tenant for the full sequence.

How long to keep it

Retention periods vary by country, so treat this as orientation rather than instruction:

• Tax records — commonly five to seven years after the filing deadline. The UK expects at least five years after the 31 January submission deadline; US guidance is generally three years, extending to six or seven in some circumstances.
• Purchase and improvement records — keep for as long as you own the property, plus the tax retention period after you sell. These establish your cost base for capital gains, and that can be decades later.
• Tenancy documents — typically the length of the tenancy plus several years, to cover any later dispute.
• Screening records — long enough to defend a decision, short enough to respect data protection. Data protection law generally requires you not to keep personal data indefinitely, so set a retention period and hold to it.

Confirm the specifics for your jurisdiction with an accountant. The principle that holds everywhere: capital records outlive tax records by a long way.

The habit that makes it work

Almost every landlord who fails at this fails the same way — not by finding it difficult, but by trying to reconstruct twelve months in one sitting, the week before a deadline.

Log costs as they happen, tagged to the right property, and the job takes about four minutes a month. Reconstruct it in January and it takes a weekend, you will miss the long tail entirely, and you will not enjoy any of it.

Photograph receipts the day you get them. A bank statement proves money left; it does not prove what it bought or which property it belonged to.

Frequently asked questions

Is a spreadsheet enough, or do I need accounting software?

For one to twenty properties, a properly built spreadsheet is enough and costs nothing per month. Software earns its subscription when you have staff, many units, or need bank feeds.

Do I need a separate bank account per property?

Not per property, but a single account used only for the rental business is worth a great deal. It turns reconciliation into a matching exercise rather than a filtering one.

What if I have already lost a year of records?

Reconstruct what you can from bank statements and start logging properly from today. A partial history that improves is far better than waiting for a clean starting point that never comes.

Can I claim the cost of the tools I use to keep records?

Generally yes — software and tools bought specifically to run the rental business are a normal business expense.

What this looks like in practice

Every record on this page is a tab in the Rental Property Tracker: a rent log with arrears and collection rate worked out for you, a categorised expense log with a deductible flag on every row, a mortgage tab that separates interest from capital, and a tax summary that nets it all per property. Up to twenty properties, Excel and Google Sheets, $27 once.

Screening decisions live in the Tenant Screening System, which keeps the criteria, the scores and the recorded reason for every applicant.

General information for landlords, not tax or legal advice. Record retention periods, deductible categories and mortgage interest treatment differ between countries and change over time. Confirm your position with a qualified accountant before filing.