Most small landlords do not set out to keep bad records. They set out to keep no records, because the first year is easy — one tenant, one rent, one deposit hitting the account on roughly the same day each month. Then a second property arrives, or a tenant pays half in cash, or a bank transfer fails quietly in July, and by the time the tax return is due there is a weekend of detective work waiting. Keeping track of rental income is not accounting for its own sake; it is the difference between knowing how the investment is doing and hoping. This guide walks through the four basic methods, what each is genuinely good for, the five things worth recording no matter which you choose, and a free Excel template that gives you a year of rental income on a single page.

Why keeping track of rental income matters more than it sounds

A rent record quietly does four jobs at once, which is why the shoebox approach fails in four directions at the same time. It is your cash-flow picture: a monthly total tells you whether the property collected what it was owed, rather than you noticing in November that August was light. It is your tax record: rental income and expenses are reported on Schedule E, and a clean total is the difference between a five-minute hand-off and a reconstruction. It is your evidence if a tenant ever says "I paid that," and it is your early-warning system — a tenant who drifts from the 1st to the 6th to the 12th over three months is telling you something you will only see if you have been writing down the date.

None of that requires bookkeeping skill. It requires doing one small thing consistently, which is really a question of picking the method you will actually keep up with.

Four basic ways to keep track of rental income

These are listed roughly in order of effort, and the honest answer for most small owners is that method three is where you should land and stay for years.

1. The bank statement method

Open a bank account used only for the rental, have every tenant pay into it, and pay property costs out of it. Your statement then is your income record — dated, third-party, and impossible to fudge. This is the lowest-effort option that is still defensible, and it works genuinely well for a single tenant paying a fixed rent on time.

Its limit is that a bank statement records money, not meaning. It cannot tell you that April's deposit was really March's rent paid late, that $2,400 against a $2,450 rent left $50 outstanding, or that $50 of a payment was a late fee rather than rent. For one clean tenancy that rarely matters. For anything messier, the statement becomes the thing you reconcile against rather than the record itself. Even so, do this part regardless of which method you choose — a dedicated account makes every other method easier.

2. The paper rent book

A bound notebook with a page per unit: date, amount, what it covered, initialled. It is nearly free, needs no technology, and is oddly durable — plenty of long-time owners have run portfolios this way for decades, and a contemporaneous handwritten entry is real evidence.

The trade-offs are the obvious ones: nothing totals itself, there is exactly one copy and no backup, and answering "what did this property bring in last year?" means adding up twelve pages by hand. If you like paper, the sensible compromise is to keep writing in the book and type the monthly totals into a spreadsheet once a month.

3. A spreadsheet (the right answer for most small landlords)

A spreadsheet is the sweet spot for one to roughly ten units, and it is where the effort you put in actually compounds. It costs nothing, opens in Excel, Google Sheets or Numbers, backs itself up in the cloud, and — the part that matters — it does the arithmetic. Set it up so each unit is a row and each month is a column, and one screen answers every question you are likely to ask: who paid, who is short, what the year has brought in, and how the collection rate is trending.

The one caveat is that a blank spreadsheet is a project, and projects get abandoned. Start from a file that already has the columns and formulas built — there is a free one further down this page. If you want the more granular version that logs each individual payment as it arrives, our guide on how to track rent payments covers that ledger approach and includes its own template.

4. Property management software

Paid software collects rent through a tenant portal, applies late fees by rule, chases payments without you writing the message, and produces owner statements at year end. It is the right tool once you are past roughly ten units, or the moment you decide you no longer want to be the person sending the "just checking on rent" text.

What you are buying is automation, not accuracy — a spreadsheet kept properly is just as correct. It costs a monthly fee, takes a weekend to set up, and only pays for itself when the manual entry has genuinely become the bottleneck. We compare the practical options in our roundup of apps for self-managing landlords.

Whichever method you pick, record these five things

The method matters less than the fields. Capture these five and any of the four approaches above will hold up:

1. The unit or property. So one record can serve every door and still be filtered down to one.
2. The month the payment covers. Not just the date it arrived — a payment received on 2 April may well be March's rent, and only the period tells you truthfully who is behind.
3. What was due. The benchmark. Keep it fixed so a short payment stands out against it.
4. What actually came in. The figure that has to match a bank deposit. Never edit the amount due down to match a short payment — the gap between the two is the entire point.
5. The date received. Establishes on-time versus late and anchors the whole thing to your bank statement.

Anything beyond base rent — late fees, pet rent, a parking charge, a utility reimbursement — deserves its own line rather than being folded into the rent figure. It is still rental income, but blending it in makes the rent column lie about whether the tenant paid in full.

The ten-minute monthly habit that makes any method work

Reconciling simply means checking that every payment in your record actually landed in your bank — and that nothing landed which you did not record. It is the step that catches a bounced check, a failed transfer, or a payment logged twice, and it takes about ten minutes:

1. Pull the statement for the account rent is deposited into.
2. Tick each entry in your record against a matching deposit.
3. Chase anything that does not match — a missing deposit, a different amount, a duplicate.
4. Confirm your month's collected total equals the deposits for that month.

If a payment is reversed after you have already recorded it, do not delete the original entry. Add a correcting line instead, so the record still tells the truth about what happened and when. That habit — never erase, always correct — is what turns a spreadsheet into evidence.

What actually counts as rental income

More than rent, which is where casual records tend to under-report. Alongside the monthly rent, the IRS generally treats advance rent, late fees, pet rent, parking or storage charges, expenses a tenant pays on your behalf, and any portion of a security deposit you end up keeping as rental income. A deposit you intend to return is not income when you receive it — it is the tenant's money you are holding, which is another good reason to keep it clearly separate.

The general principles are set out in the IRS guidance on rental income, deductions and recordkeeping, and the edges get specific to your situation fast — run your own numbers past a CPA before you file. Keep the records themselves for at least three years, and seven is the safer habit.

When it is worth handing this over

Tracking rental income yourself is entirely doable, and for one or two properties it is often the right call. The point at which owners hand it over is rarely the spreadsheet — it is the collection conversations, the tenant who needs chasing every month, and the realisation that the record only tells you about a problem you now have to go and solve. A managed property gives you a monthly owner statement without you keeping any of it yourself; our fee schedule lays out exactly what that costs, and the services page covers what is included.

Either way, the discipline is the same and it is small: pick one of the four methods, write down the same five fields every time money comes in, and spend ten minutes a month checking it against the bank. Do that and the year takes care of itself — whether you are running one duplex in Stockton or a handful of doors across the Central Valley.