Can Your Accounting and Property Systems Explain the Revenue Variance?

Can Your Accounting and Property Systems Explain the Revenue Variance?

Summary:

National rents dipped month over month in September while annual growth improved. For multifamily finance teams, the harder question is internal: can accounting and property systems produce reconciled, property-level numbers that explain revenue variance, and is there a process that turns those findings into accountable operational decisions?

CoStar’s September 30 Apartments.com report showed the national average rent slipping 0.08% month over month to $1,752, while annual rent growth accelerated to 1.5%, up from 1.3% in August. Those readings don’t contradict each other. One compares September with August. The other compares September with a year ago. Both can be true at once. The more useful question for a multifamily finance team isn’t what the national market did. It’s whether your organization can explain what your own portfolio did, property by property, with numbers everyone trusts.

For many operators, that’s harder than it sounds.

The forecast is only as good as the close

Before anyone revises a rent growth assumption, the underlying numbers have to hold up. That means four things are in place.

Receivables are reconciled. The tenant ledger in the property management system ties to the general ledger. Unapplied cash, duplicate charges and stale balances get cleaned up, not carried forward.

Concessions are recorded correctly. A month free shouldn’t quietly disappear into net rent at one property and show up as a separate line at another. If concessions are booked inconsistently, you can’t tell whether pricing softened or just got recorded differently.

Account mapping is consistent. Revenue lines map to the same accounts across every property and every entity. Otherwise the portfolio rollup mixes categories, and variance analysis compares things that aren’t comparable.

Month-end reporting is timely. If the close takes three weeks, finance is analyzing September in late October. By then, more leasing decisions have already been made on instinct.

None of this is glamorous. All of it is prerequisite. A reforecast built on unreconciled data is just a confident guess.

Why leasing and accounting can’t agree

Ask the leasing team what revenue looked like last month. Then ask accounting. In a lot of organizations, you’ll get two different answers, usually for three reasons.

First, report definitions differ. Leasing might report scheduled rent or effective rent on new leases. Accounting reports revenue based on the organization’s accounting policies, including the treatment of concessions and other income. Both are legitimate. They’re just not the same number, and nobody labeled them.

Second, the systems don’t talk. Leasing data lives in the PMS. The general ledger may sit in the same platform or a different one. Pricing tools, CRMs and resident portals add more sources. Each holds part of the picture. None holds all of it.

Third, the gaps get patched by hand. Someone exports a rent roll, adjusts it in a spreadsheet to “fix” a concession timing issue, and that file becomes the version the asset manager sees. Next month, someone else makes a slightly different adjustment. Over time, the spreadsheet becomes the system of record, and nobody can trace how a number was built.

The result is predictable. Variance meetings turn into reconciliation meetings. The first 40 minutes go to figuring out whose number is right, and the decision gets pushed to next month.

Build a bridge that separates revenue from cash

Once the numbers are clean, a variance bridge from budget to actual shows where the gap came from. For an accounting audience, it needs to keep three things distinct.

Revenue. What was earned and recognized: rent on occupied units, net of concessions, plus other income. The drivers here are occupancy, new lease pricing, renewal increases and concession levels.

Receivables. What was billed but not yet paid. A rising balance warrants investigation. It doesn’t, by itself, mean recognized revenue fell.

Cash collected. What actually hit the bank. Slow collections hurt cash flow and may call for a review of collectibility and any required accounting adjustments. That’s a separate judgment, not an automatic revenue hit.

Blur these together and you risk the wrong fix. A property with on-plan revenue and rising receivables needs a closer look before anyone touches pricing. The cause could be delinquency. It could also be billing errors, payment timing or unapplied cash. Cutting rent won’t solve any of those. Finding the actual cause will.

Hand off the findings, then follow through

Clean numbers and a good bridge don’t change anything on their own. The variance has to move from finance to the people who can act on it, with clear roles.

Accounting validates the variance. Is it real, or is it a timing difference, a misposted concession or a mapping error? This step keeps operations from chasing phantom problems.

Operations investigate the cause. Once a variance is confirmed, property and regional teams explain what’s driving it. Slower traffic? A competitor’s concessions? Long unit turns? A shift in renewal acceptance?

Leadership approves the response. Pricing, concession policy, staffing, capital timing. Whatever the action, someone with authority signs off, and it flows into the revised forecast.

Then assign an owner and a date, and decide in advance which metric will show whether the action worked. Check it at the next close. If renewals were the problem and the response was a new renewal offer strategy, look at retention and achieved renewal increases next month. If nothing moved, the response gets revisited. Not forgotten.

Where an outsourced accounting partner fits

Plenty of operators outsource some or all their accounting. That can work well in this process, but only if the partner is built into it rather than handed a ledger and a deadline.

A few things make the difference. Shared definitions, so the partner’s revenue figures and the leasing team’s figures reconcile to the same terms. Direct access to the PMS and general ledger, not exported files that are already out of date. Documented close responsibilities that spell out who reconcile receivables, who records concessions and who signs off, by when. And a clear escalation process, so an unusual variance reaches the right operator quickly instead of sitting in a month-end email.

With those in place, the outside team isn’t just closing the books. It’s the first line of validation in the variance workflow.

The real test

September’s rent report is useful context. It isn’t an answer. National averages move, local markets diverge and plenty of portfolios will look nothing like the headline.

The question worth asking is simpler and a little more uncomfortable. If revenue came in below plan this quarter, could your accounting and property systems tell you why, within days rather than weeks, in numbers both finance and operations accept?

If the answer is yes, a soft month is just information. If the answer is no, you have an internal visibility problem to solve alongside whatever the market is doing. Fixing it takes disciplined accounting, connected systems and a clear operating rhythm between finance and the field.

Get that right, and the next rent report becomes something you can act on. Not something you have to explain away.

Ready to Transform Your Real Estate Operations?

Discover more from Atlas Global Advisors

Subscribe now to keep reading and get access to the full archive.

Continue reading