Published 8 September 2026 by Prop-Pocket Team
Build a rental property cash flow template that tracks rent, mortgages, repairs and real profit, so you can make better decisions with confidence daily.
A property can look profitable on paper and still leave you short of cash before the end of the month. That is why a rental property cash flow template should do more than total rent and subtract a few bills. It needs to show what is actually coming in, what is leaving your account, what is due next, and whether each property is funding itself.
For landlords with one buy-to-let or a growing portfolio, this visibility is the difference between reacting to surprises and running the portfolio with control. A missed rent payment, an annual insurance renewal or an unexpected boiler repair can quickly distort the picture if your records sit across bank statements, notes and several spreadsheets.
Cash flow is the money moving through a property over a defined period, usually monthly. It is not exactly the same as profit. A property may generate positive cash flow after mortgage payments while its true profit is lower once you account for depreciation, tax treatment, void periods and less frequent costs.
Your template should begin with a separate view for each property, then roll the figures into a portfolio total. Mixing every property into one running list makes it hard to spot the flat with rising maintenance costs, the house with repeated arrears, or the mortgage that is about to move onto a higher rate.
At minimum, each monthly property record should include the following categories:
| Category | What to record | Why it matters | | --- | --- | --- | | Income | Rent due, rent received, late fees and other income | Separates expected income from cash actually collected | | Finance | Mortgage payment, interest and capital repayment | Shows the real monthly commitment and supports accurate reporting | | Operating costs | Letting fees, insurance, service charges, utilities and licences | Captures the routine cost of keeping the property running | | Maintenance | Repairs, planned works and emergency call-outs | Reveals whether a property is becoming expensive to hold | | Reserves | Allowance for voids, compliance, major repairs and tax | Prevents predictable future costs becoming cash emergencies |
The core calculation is straightforward:
Net monthly cash flow = cash received - mortgage payment - operating costs - maintenance - reserve contributions
Keep the calculation visible rather than burying it in a complex formula. The purpose is not to build an impressive spreadsheet. It is to answer a practical question quickly: after all known commitments, how much cash did this property produce or consume this month?
The most common cash flow error is recording income when it is due rather than when it reaches your account. If rent is due on the first but arrives on the tenth, that distinction matters when the mortgage leaves on the fifth.
Include both a “rent due” and “rent received” column. The gap between them flags arrears without altering the contractual rent figure. It also gives you a more reliable cash position across the portfolio, particularly when several tenancy payment dates fall close to mortgage or contractor payments.
Do the same for expenses. Record the date paid, the supplier, the property and the category. A £900 plumbing invoice is useful information, but it becomes much more useful when you can see it was the third repair at the same property in six months.
For annual or irregular bills, spread a monthly reserve across the year. For example, if landlord insurance costs £360 annually, set aside £30 per month in your template. This does not change the insurer’s payment date, but it gives a truer view of the property’s sustainable monthly cash flow.
For repayment mortgages, the monthly payment includes interest and capital. Both affect the cash leaving your bank account, so both belong in a cash flow view. However, they do not mean the same thing financially.
Mortgage interest is a financing cost. Capital repayment reduces the loan balance and builds equity in the property. If you classify the full payment as an operating expense, you may understate the long-term value being created. If you exclude capital repayment from cash flow entirely, you may overstate the cash available to spend.
The practical answer is to track three figures: the total mortgage payment, the interest portion and the capital portion. Your monthly cash flow should use the full payment. Your profit and performance reporting should show the split clearly, so you can distinguish cash pressure from debt reduction.
This is particularly useful when comparing properties. A repayment mortgage may produce tighter cash flow than an interest-only mortgage, even where the underlying rent and property condition are similar. Neither arrangement is automatically better. It depends on your borrowing strategy, tax position, risk tolerance and plans for the portfolio.
A template that only tracks rent, mortgage and repairs will look healthier than reality. The overlooked items tend to be the ones that arrive less often, which is exactly why they catch landlords out.
Build in a reserve or recurring line for voids, reletting, safety certificates, EICR work, gas safety checks where applicable, EPC renewals, landlord insurance, service charges and accountancy fees. If you manage an HMO, include licensing, communal utilities, cleaning and furnishing replacement separately rather than hiding them in general expenses.
You should also decide how to treat your own time. Most individual landlords do not pay themselves a management fee, but logging substantial travel, administration or project work can still inform decisions. A property requiring constant intervention may be technically cash-positive while offering a poor return for the effort involved.
A template only improves decisions if it is updated consistently. Set a fixed date each month after rent has cleared and the main direct debits have left your account. Reconcile the previous month against the bank account, then review the next 30 to 90 days for known commitments.
Look for changes rather than just totals. Has rent received fallen below rent due? Is maintenance increasing at one address? Is a fixed mortgage rate ending soon? Are upcoming certificate renewals likely to create a large bill? These are operational signals, not just accounting entries.
At portfolio level, track total rent received, total outgoing cash, net cash flow, arrears and reserve balance. A single property can have a difficult month without creating a portfolio problem. Equally, several small shortfalls can create a material funding gap when they happen together.
A spreadsheet is a sensible starting point for a single, stable property. It becomes harder to rely on when you are chasing rent, recording repairs, managing several mortgages and monitoring compliance dates at the same time. Manual formulas can be overwritten, receipts can be filed inconsistently, and an expired certificate will not announce itself from a tab you have not opened.
That is where a structured property management system earns its place. Prop-Pocket brings rent tracking, repairs, mortgage capital-and-interest splits, compliance reminders and portfolio financial reporting into one operating view. Instead of rebuilding the same figures at month-end, you can see the numbers alongside the tenancy and compliance events that explain them.
The right approach depends on the size and complexity of your portfolio. Some landlords will continue to use a template for forecasting while using software as the source of record. Others will prefer to remove spreadsheet administration altogether. What matters is that every figure is current, traceable and useful before a decision has to be made.
A well-maintained cash flow record gives you more than a monthly total. It gives you early warning, a realistic reserve target and the confidence to assess the next repair, refinance or purchase against facts rather than assumptions.
Joinlandlords using Prop-Pocket to track certificates, manage repairs and stay compliant — for free.
Try Prop-Pocket Free