Accounting & Xero Insights for US Businesses | Logiframe US

Xero for Real Estate for US Businesses | Logiframe US

Written by Wienanto Tanuwidjaja | Aug 11, 2026, 2:54:35 AM

Start here

Three Different Businesses

Real estate covers three models with different accounting. Which one you are decides almost everything that follows.

Model Whose money What the books must do
Landlord or owner Your own, plus tenant deposits Property-level profit, deposits as a liability, depreciation, repairs versus improvements
Property manager Mostly other people’s Trust ledgers per owner and per tenant, owner statements, management fee recognition
Brokerage Escrow and commissions Escrow held per transaction, agent splits, commission timing

A landlord with a handful of properties and no client funds has a straightforward job that Xero handles natively. A property manager holding deposits and rent on behalf of owners has a compliance obligation, and the structure has to be right from day one rather than retrofitted after a state examination.

The foundation

What Xero Owns

Four things work natively and cover most of what a property business needs from its ledger.

  • Property-level profit and loss. Tracking categories separate income and expenses by property, giving a clean view per property and across the portfolio. No add-on required.
  • Rent invoicing that raises itself. Repeating invoice templates issue rent on schedule, bank feeds import the cleared payments, and reconciliation matches them. In a rent-heavy business this removes the largest repetitive task in the month.
  • Standard property reports. A rental summary of income and expenses over a date range, rent received by property, and rent outstanding flagging late or missing payments by tenant. All built in.
  • Reporting you build yourself. Custom profit and loss views, vacancy tracking and tenant aging all come out of Xero’s own reporting with tracking categories behind them.

For a landlord without client trust obligations, that is the whole job. The structure below matters once other people’s money enters the picture.

The obligation

Money That Is Not Yours

A security deposit is a liability, never income. So is rent collected on an owner’s behalf, and so is escrow held for a transaction. Recording any of them as revenue overstates the business and understates what it owes.

Most states require a monthly three-way reconciliation : the trust bank balance, the trust ledger in your accounting system, and the sum of individual owner and tenant balances all agree exactly. California requires it within 30 days of month end. New York requires it within 15. Other states set their own timelines.

The three failures regulators look for are structural rather than dishonest:

  • One client’s funds covering another’s shortfall. Illegal regardless of intent, and usually the result of a single account with no sub-ledger.
  • A deposit applied to the wrong owner’s costs through a posting error nobody caught, because nothing reconciled it.
  • Commission or fees left in the trust account longer than state law permits, which is commingling even when the money is genuinely yours.

An examiner looks at transaction timing, account structure, sub-ledger accuracy and reconciliation documentation. Every one of those is something a chart of accounts either supports or does not.

The build

Building the Trust Structure

Xero’s chart of accounts and tracking categories are precisely the tools this needs. The design is what makes it work.

Separate bank accounts, separately reconciled

Trust funds sit in their own bank account, never the operating account. In Xero that is a separate bank account with its own feed and its own reconciliation, so the trust balance is always visible and always agreed to a statement.

A liability account per fund type

Security deposits held, rent collected for owners, and owner funds on account are three different obligations and three different accounts. Each carries a balance you can point at and explain.

A sub-ledger by stakeholder

Tracking categories carry the individual owner or tenant, so the liability account breaks down to a per-stakeholder balance. This is the third leg of the three-way reconciliation, and it is the leg most files are missing.

The reconciliation itself

  • Trust bank statement balance, from the bank
  • Trust liability accounts, from the Xero balance sheet
  • Sum of individual owner and tenant balances, from the tracking breakdown

All three agree, monthly, within your state’s deadline, with the working papers kept. Xero produces the second and third from the same file, which is what makes the check take minutes rather than a day.

Security deposits, recorded properly

On receipt: debit the trust bank, credit the security deposit liability, tagged to the tenant. On return: reverse it. Where damages are withheld, record the expense and show the tenant the net. Track each deposit by tenant, property, unit, amount, date received and date returned, because that is the documentation a state requires and the evidence you need if a withholding is disputed.

Where state law requires interest on deposits, that calculation and crediting is an annual step rather than something to remember at move-out.

The dimensions

Property, Unit, Tenant

Xero provides two tracking categories, which is a design constraint that rewards deciding what you actually report on.

Three dimensions compete for two slots: property, unit and stakeholder. Which two you choose depends on the business.

Business Category 1 Category 2
Landlord, single-unit properties Property Tenant, or vacant
Landlord, multi-unit buildings Property Unit
Property manager Owner Property
Brokerage Agent Transaction or office

Two other structures solve the same problem where all three dimensions matter at once. A naming convention inside one category, where the option reads as building and unit together, gives unit-level reporting within a property category. And for a portfolio held in separate legal entities, each property already has its own organisation, which frees both categories for unit and tenant.

Where the portfolio is large enough that units need managing rather than reporting, the property management system owns them and Xero receives the financial result. That is the next section.

The architecture

Where the Rent Roll Lives

Xero is accounting software. A rent roll, tenant screening, lease documents, maintenance requests and tenant messaging belong to a property management platform, and the two work well together when each owns its half.

The division that holds up:

  • The property management system owns operations. Leases, units, tenants, work orders, screening, tenant and owner portals, and the rent roll as the master record of what every unit should generate.
  • Xero owns the ledger. The general ledger, the trust liability structure, the bank reconciliation, the financial statements, and the file your CPA works from at year end.
  • The integration carries the result, not a duplicate. One system holds the tenant balances; the other holds the accounting consequence.

Buildium, AppFolio, Propertese and Rentec Direct all connect to Xero on this pattern, and several enforce trust discipline at the point of entry, guiding staff to the right account and running three-way reconciliation with exception flags.

The failure mode is not choosing. Two systems both maintaining tenant balances produces two answers to the same question, and reconciling them becomes a monthly job that neither system was meant to create. Decide which one is the record for each thing before either holds history.

A portfolio under roughly a dozen units, with no client funds, rarely needs the second system. Above that, or the moment you are holding money for someone else, it pays for itself in the reconciliation alone.

The tax decision

Repairs or Improvements

Distinguishing a repair from a capital improvement is the most common tax error in property accounting. A repair is deducted now. An improvement is capitalised and depreciated over years.

Three safe harbors make the decision easier, and each has conditions worth checking against your own position with your CPA.

  • De minimis safe harbor. Under IRS Notice 2015-82 the threshold rose to $2,500 per invoice or per item for taxpayers without an applicable financial statement. Four dishwashers on one $4,000 invoice at $1,000 each qualify individually, because the test is per item.
  • Routine maintenance safe harbor. Work you expect to perform more than once over a ten-year period on a building, treated as a deductible expense.
  • Small taxpayer safe harbor. Where the building’s unadjusted basis is $1 million or less and gross rental income across all activities is under $10 million, total spending on repairs, maintenance and improvements for that building can be expensed if it stays under 2 percent of unadjusted basis and under $10,000 for the year.

Keeping this decision current rather than annual matters. Xero’s fixed asset register holds capitalised improvements with their depreciation running automatically, so the register and the balance sheet agree without a reconciliation. Coding a genuine improvement to repairs overstates this year’s cost and understates the asset; the reverse fills the register with items nobody can find.

The rhythm

Month End and Year End

Every month

  • Rent charges posted by the first of the month, payments recorded within a business day of receipt
  • Trust three-way reconciliation completed within your state’s deadline, working papers kept
  • Owner statements issued: rent collected, maintenance, management fees, utilities, vendor payments, deposits and closing balance
  • Budget against actual reviewed per property, with any line more than 10 percent adrift investigated
  • Vacancy rate and rent collection rate calculated per property

Every year

  • Security deposit interest calculated and credited where state law requires it
  • Fixed asset register updated for capital improvements, depreciation schedules reviewed with your CPA
  • 1099s prepared for vendors paid $600 or more, due 31 January
  • CAM reconciliations completed and billed to commercial tenants, typically within 90 to 120 days of year end
  • Trust records compiled for state regulatory reporting where required

The underlying sequence is in the month-end close checklist . These sit on top of it.

Questions

Commonly Asked

Can Xero handle trust accounting for property managers?
Yes, with a chart of accounts designed for it. Trust funds sit in a separate bank account with its own reconciliation, liability accounts separate deposits held from rent collected for owners and owner funds on account, and tracking categories carry the individual owner or tenant so the liability breaks down per stakeholder. That structure produces two of the three legs of the monthly three-way reconciliation directly from the file. Larger portfolios usually pair Xero with a property management platform that enforces the same discipline at the point of entry.
What is three-way reconciliation and how often is it required?
The trust bank balance, the trust ledger in your accounting system, and the sum of individual owner and tenant balances all agreeing exactly. Most states require it monthly. California requires it within 30 days of month end and New York within 15 days, with other states setting their own timelines. Keep the working papers, because an examiner looks at transaction timing, account structure, sub-ledger accuracy and reconciliation documentation.
How do I record a security deposit?
As a liability, never as income. On receipt, debit the trust bank account and credit a security deposit liability tagged to the tenant. On return, reverse it; where damages are withheld, record the expense and show the tenant the net. Track each deposit by tenant, property, unit, amount, date received and date returned, since that is both the state documentation requirement and the evidence you need if a withholding is disputed. Where state law requires interest, calculate and credit it annually.
Can Xero track individual units in a multi-unit building?
Yes, through the two tracking categories, and the design choice is which two dimensions you report on. A multi-unit landlord typically uses property and unit. A property manager typically uses owner and property, with a naming convention inside the property category that carries the unit. Where each property sits in its own legal entity, both categories are free for unit and tenant. Portfolios large enough to manage units rather than report on them put the rent roll in a property management platform and let Xero carry the financial result.
Is Xero enough on its own for a landlord?
For a landlord with a modest number of properties and no obligation to hold client funds, usually yes. Property-level profit and loss through tracking categories, rent raised by repeating invoices, bank feeds matching the payments, and the built-in rental summary, rent received and rent outstanding reports cover the job without any add-on. The calculation changes once you hold money for other people or the portfolio grows past roughly a dozen units.
Is a new appliance a repair or an improvement?
It depends on cost and on which safe harbor applies. The de minimis safe harbor allows expensing items at $2,500 or less per invoice or per item for taxpayers without an applicable financial statement, so four dishwashers at $1,000 each on one invoice qualify individually. The routine maintenance safe harbor covers work expected more than once in ten years. The small taxpayer safe harbor applies where a building's unadjusted basis is $1 million or less and gross rental income is under $10 million, if total repair and improvement spending stays under 2 percent of basis and under $10,000 for the year. Confirm your position with your CPA.