How to Track Income, Costs and Profit Across Multiple Properties

Why portfolio totals are not enough

Knowing that a property portfolio generated £300,000 of rent last year is useful.

Knowing that it incurred £190,000 of costs is useful too.

But neither figure tells the owner which properties are performing well, which are consuming disproportionate amounts of cash, or where the result is changing.

This is one of the challenges that appears as a property portfolio grows.

With one property, the owner often has a good intuitive understanding of the numbers.

They know roughly what rent comes in, what the mortgage costs, what maintenance has been completed and whether the property has had an expensive year.

With 10, 20 or 100 properties, that becomes much harder.

The portfolio starts producing a large consolidated number, but the individual assets underneath it can behave very differently.

Effective financial tracking therefore needs to answer two questions simultaneously:

How is each property performing?

and:

How is the portfolio performing as a whole?

The second should be built from the first.

Start by recording income and costs against the property

Wherever practical, property income and expenditure should be associated with the asset to which it relates.

That sounds obvious, but it is easy for portfolio records to become increasingly consolidated.

For example, an owner might know that the property business spent £40,000 on maintenance during the year.

But which properties generated that cost?

Suppose a ten-property portfolio incurred £40,000 of maintenance expenditure.

An average calculation gives:

£40,000 ÷ 10 = £4,000 per property

But perhaps the real position was:

• six properties cost £1,000 each;
• three properties cost £3,000 each; and
• one property cost £25,000.

The £4,000 average conceals the most important information.

One asset generated more than 60% of the portfolio's maintenance expenditure.

Recording expenditure at property level allows the consolidated portfolio number to remain useful without losing the detail underneath it.

What counts as property income?

For many residential landlords, rent is the primary recurring income.

Depending on the property and circumstances, other income may also arise.

The important point is to categorise income consistently.

A property record might distinguish between:

• contractual rent;
• rent actually received;
• other property-related income;
• one-off receipts; and
• amounts outstanding.

This matters because rent due and cash received are not necessarily the same thing.

Imagine a property with rent of £1,500 per month.

Its contractual annual rent is:

£1,500 × 12 = £18,000

But if only £16,500 was actually received during the period, using £18,000 as though it were cash collected would give an incomplete picture.

At portfolio level, the distinction becomes even more important.

An annual rent roll of £500,000 does not automatically mean £500,000 entered the bank account.

The owner may therefore want visibility of both:

expected income

and:

income actually received.

Track costs consistently

Property portfolios generate many different types of expenditure.

Depending on the assets and ownership structure, these might include:

• repairs and maintenance;
• property management fees;
• insurance;
• service charges;
• ground rent where applicable;
• utilities paid by the owner;
• safety and compliance costs;
• licences;
• professional fees;
• cleaning;
• gardening or grounds maintenance;
• contractor costs;
• finance costs;
• capital works; and
• other property expenditure.

The categories used should be sufficiently detailed to be useful without becoming so complicated that nobody maintains them properly.

Consistency is more valuable than creating hundreds of categories.

If boiler repairs are classified as "maintenance" for one property, "repairs" for another and "contractor expense" for a third, portfolio comparisons become harder.

A consistent cost structure makes the consolidated information more meaningful.

Do not confuse every outgoing with an expense

This is where property financial reporting can become misleading.

Cash leaving a bank account does not necessarily mean the same thing as an expense for every reporting purpose.

For example, mortgage payments can contain different elements.

On a repayment mortgage, a payment may include:

• interest; and
• repayment of loan principal.

The whole payment reduces cash.

But repaying principal also reduces the outstanding debt.

Likewise, significant property expenditure may sometimes represent capital expenditure rather than an ordinary operating cost.

Accounting treatment and tax treatment depend on the circumstances.

For management purposes, the owner may still want to understand the cash impact.

But Fructus should not label every cash outgoing as "expense" or every residual cash amount as "profit" without defining what the number represents.

This is why terminology matters.

Cash flow and profit are different

Consider a simplified example.

Cash flow is affected by operating costs, finance costs and debt repayments.

Cash remaining after payments does not necessarily equal accounting or taxable profit.

The appropriate accounting and tax treatment of property income and expenditure depends on the owner, property, financing and circumstances.

For portfolio management, the important point is to label the measurement correctly.

Useful concepts may include:

• gross rental income;
• operating costs;
• net operating income;
• finance costs;
• debt principal repayment;
• capital expenditure;
• cash flow;
• accounting profit; and
• taxable profit.

These terms should not be used interchangeably.

Why property-level cash flow matters

A portfolio can be profitable overall while containing individual properties that regularly consume cash.

That is not automatically a problem.

A property might deliberately be held because of:

• expected long-term capital growth;
• redevelopment potential;
• strategic location;
• future rent growth;
• diversification; or
• another investment objective.

But the owner should know that the property is consuming cash.

Property-level analysis can reveal what a positive portfolio total hides.

Despite the positive £14,000 portfolio result, Property D is consuming cash on this simplified measure. Property C's comparatively high operating costs also warrant attention.

Compare properties on a consistent basis

Property comparisons become useful only when the underlying calculations are consistent.

Suppose one property reports maintenance but excludes insurance.

Another includes insurance but excludes management fees.

Another includes every cash outgoing, including mortgage principal.

The resulting "profit" figures cannot be meaningfully compared.

Before comparing assets, define what the metric means.

For example:

Operating result

could be defined for internal management purposes as:

Property income – defined operating property costs

A separate measure might then include finance costs.

Another could show actual cash movement after debt payments.

The precise management framework can vary.

The important part is that the same definition is used across the portfolio and clearly labelled.

Gross yield does not show the full financial picture

A property with a high gross rental yield can still have weak underlying performance.

Our guide to Rental Yield Explained: Gross, Net and Portfolio Yield explains why gross yield considers rental income relative to property value but does not incorporate all the costs associated with operating the asset.

Consider two properties worth £250,000.

Current property value changes the interpretation

Property performance can also be viewed against current asset value.

Suppose a property was bought for £150,000 several years ago and now has a management value of £300,000.

It generates £15,000 of annual rent.

Yield on original purchase price:

£15,000 ÷ £150,000 = 10%

Yield on current value:

£15,000 ÷ £300,000 = 5%

Both calculations may answer useful but different questions.

The first helps describe the relationship between current rent and original purchase price.

The second describes the income yield being generated against the capital currently represented by the asset.

This can become relevant when deciding whether to:

• retain;
• refinance;
• improve;
• restructure; or
• dispose of a property.

Again, the important point is not choosing one universal calculation.

It is knowing which calculation is being displayed.

Debt needs to sit alongside income and costs

Property performance cannot be considered entirely separately from financing.

Two otherwise identical properties may produce very different cash outcomes if one is unencumbered and the other is highly leveraged.

Useful property-level finance information can include:

• current mortgage balance;
• interest rate;
• finance cost;
• monthly payment;
• repayment type;
• product expiry; and
• loan-to-value.

At portfolio level, this allows the owner to understand where financing costs and leverage are concentrated.

Our guide to Property Portfolio LTV: How to Calculate and Monitor It explains why both individual-property and consolidated leverage matter.

A highly leveraged property may still be an excellent investment.

But its cash flow will respond differently to interest-rate changes from an equivalent property with little or no debt.

Separate operating expenditure from capital expenditure

This distinction is important for both management and professional accounting.

Replacing a broken component and substantially improving or extending a property may have very different characteristics.

For portfolio management, owners should at least be able to distinguish ordinary recurring property expenditure from significant capital projects.

The correct accounting and tax treatment depends on the circumstances and should be determined using appropriate professional guidance.

But even before considering that treatment, separating major projects from routine operating costs improves portfolio analysis.

Otherwise, a property undergoing a deliberate £50,000 refurbishment could appear to be catastrophically underperforming when compared with an otherwise identical property requiring no work.

Context matters.

Track maintenance as both a cost and an operational event

Maintenance expenditure is particularly useful because it connects financial and operational information.

A £900 invoice tells the owner how much was spent.

A maintenance record can explain:

• what went wrong;
• when it was reported;
• who attended;
• what work was completed;
• whether the problem had occurred previously;
• which invoice relates to it; and
• whether further action is required.

Over time, this can reveal patterns.

One property may repeatedly require plumbing repairs.

Another may have unusually high heating-system expenditure.

Another may require little intervention for years.

The cost tells one part of the story.

The maintenance history explains it.

Keep property and business overheads separate

Not every cost incurred by a property business belongs to an individual property.

Examples might include:

• general software;
• company administration;
• professional services;
• office expenditure;
• group-level staff;
• general marketing; and
• other business overheads.

Trying to force every business cost onto an individual property can create artificial property-level results.

A useful structure can therefore distinguish between:

direct property costs

and:

portfolio/business overheads.

The owner can then view:

individual asset performance

while still understanding:

the cost of operating the wider property business.

How overheads are allocated for accounting, tax or other formal purposes is a separate question.

Multiple companies make consolidation more important

Property portfolios are often held across several ownership entities.

For example:

Company A

• Property 1
• Property 2
• Property 3

Company B

• Property 4
• Property 5

Personally owned

• Property 6

The owner may want to understand:

Property 4's performance

then:

Company B's performance

and finally:

the economic position of the wider portfolio.

These are different reporting levels.

A good property-management structure should retain the legal ownership relationship while still allowing useful consolidated management information.

This becomes increasingly important as the number of SPVs or ownership entities grows.

The accounting records of separate legal entities should not simply be merged as though the legal distinction does not exist.

Portfolio-level management reporting can provide a consolidated operational view while retaining the entity underneath each property.

Monthly reporting is usually more useful than waiting for year end

Annual figures are important, but they can arrive too late for day-to-day management.

A simple monthly portfolio review can help identify changes earlier.

Useful areas to review might include:

Income

• rent due;
• rent received;
• arrears;
• other property income.

Costs

• maintenance;
• management;
• insurance;
• service charges;
• compliance;
• utilities;
• other operating expenditure.

Finance

• interest;
• mortgage payments;
• balances;
• upcoming product expiries.

Cash

• property-level cash movement;
• portfolio cash requirements;
• significant upcoming expenditure.

Performance

• yield;
• costs as a proportion of income;
• unusual property-level movements;
• properties outside expected ranges.

The objective is not to turn every landlord into a management accountant.

It is to identify exceptions while there is still time to act.

Look for exceptions, not just totals

A portfolio dashboard becomes more useful when it helps the owner find what deserves attention.

Suppose total maintenance expenditure is exactly on budget.

That sounds reassuring.

But perhaps:

• eight properties are below budget;
• one is moderately above;
• one has incurred five times its expected maintenance cost.

The portfolio total can look normal while an individual asset is behaving abnormally.

The same applies to:

• arrears;
• vacancy;
• finance costs;
• insurance;
• service charges;
• yield;
• cash flow; and
• other expenditure.

Historical trends matter

A single month's result can be misleading.

A property may have an expensive month because a major repair happened to fall within it.

That does not necessarily indicate a long-term problem.

Comparing performance over time helps provide context.

Useful periods might include:

• current month;
• year to date;
• trailing 12 months;
• previous year; and
• longer-term property history.

This can help distinguish between:

one-off expenditure

and:

a recurring pattern.

It can also show whether rent growth is being offset by rising operating costs.

Budget versus actual can improve control

For more developed property businesses, budgeting adds another useful layer.

Suppose a portfolio expects:

Annual rent: £400,000

Operating expenditure: £100,000

Actual performance can then be compared with those expectations.

If insurance is materially higher than budget, investigate.

If maintenance is lower, determine whether that represents genuine efficiency or simply work that has been deferred.

If rent is below expectation, look at vacancy, arrears or assumptions.

The purpose of a budget is not to predict the future perfectly.

It creates a benchmark against which actual performance can be understood.

Be careful with the word "profit"

This deserves repeating.

Property owners use "profit" to describe several different things.

Someone might say:

“The property makes £500 a month.”

They could mean:

• rent less mortgage payment;
• rent less interest;
• rent less operating costs;
• cash after all payments;
• accounting profit;
• taxable profit; or
• simply the amount left in a bank account.

Those are not necessarily the same number.

Software should therefore define its financial metrics clearly.

A label such as:

Net cash flow

is more useful when the calculation underneath it is known.

Likewise:

Operating costs

should have a defined scope.

For formal accounts and tax calculations, the appropriate accounting and tax rules apply and professional advice may be required.

A portfolio-management system should help organise the underlying information rather than pretending to replace that process.

What should a portfolio owner be able to see?

There is no universal dashboard, but a useful financial view might include:

Portfolio level

• current portfolio value;
• secured debt;
• gross property equity;
• portfolio LTV;
• expected rent;
• rent received;
• operating expenditure;
• finance costs;
• maintenance expenditure;
• cash flow;
• arrears;
• occupancy.

Property level

• current value;
• mortgage balance;
• property LTV;
• rent;
• costs;
• finance;
• maintenance;
• cash flow;
• yield;
• significant upcoming events.

The important requirement is traceability.

If the portfolio says:

Operating expenditure: £120,000

the owner should be able to identify which properties and cost records create the £120,000.

A portfolio figure that cannot be explained is difficult to trust.

Spreadsheet or dedicated property software?

Spreadsheets remain extremely useful for financial analysis.

Our guide to Property Portfolio Spreadsheet vs Property Management Software explains why spreadsheets are particularly strong for:

• modelling;
• forecasting;
• custom calculations;
• sensitivity analysis; and
• bespoke reporting.

The difficulty arises when the same spreadsheet is also expected to become the permanent operational record for every property.

Income and expenditure may need to connect with:

• ownership;
• tenancies;
• mortgages;
• maintenance;
• documents;
• compliance; and
• disposals.

At that point, the challenge is less about calculation and more about structure.

How Fructus approaches portfolio financial visibility

Fructus is being built around the principle that portfolio-level information should come from reliable property-level records.

Rather than starting with a dashboard and manually typing consolidated figures into it, the intended structure connects the underlying information.

Those records can then contribute to the wider portfolio view.

This follows the approach described in our guide to How to Manage a Property Portfolio Effectively:

record information where it belongs, then consolidate it.

Fructus is currently in development.

We are not claiming that every capability discussed in this article is already available today.

The objective is to give property owners a clearer understanding of both the portfolio and the individual assets creating its performance.

Key takeaway

Tracking property performance across a portfolio requires more than knowing total rent and total expenditure.

The portfolio total should be built from individual property records so the owner can understand what is driving the result.

That means consistently tracking:

• income;
• operating costs;
• finance;
• maintenance;
• capital expenditure;
• cash movement; and
• relevant performance measures

at the appropriate level.

It also means being precise about terminology.

Cash flow is not automatically accounting profit.

Accounting profit is not automatically taxable profit.

Mortgage principal repayment is not the same thing as mortgage interest.

Gross yield is not the same thing as net performance.

The objective is not to create more financial reports.

It is to make the economics of the portfolio easier to understand.

At portfolio level, you should know how the estate is performing.

At property level, you should know why.

Property. Under control.

Fructus is being built to bring property, finance, tenancy, compliance, maintenance and documents together in one place.