Outgoings reconciliation in commercial property: What it is and how to automate it

At year-end, at the end of a lease or when a property is sold, outgoings reconciliation is needed to work out whether tenants have paid too much or too little towards the cost of managing the property.

Across a portfolio of 20 or 30 tenancies, each with its own NLA proportion, lease obligations and timelines, this is one of the most time-consuming and error-prone tasks. It’s also where commercial property management accounting software earns its keep.

Errors in outgoings reconciliation lead to tenant disputes, funding shortfalls for owners and potential legal exposure. A single misapplied apportionment can affect a positive relationship with a tenant.

This guide explains how outgoings reconciliation works, how it differs from end-of-month trust accounting reconciliation, and which parts of both processes can be automated with the help of the right software.

What is outgoings reconciliation in commercial property management and how is it handled?

Outgoings reconciliation is the process of comparing the actual outgoings a building incurred against the amounts originally estimated and paid by the tenant. The calculation will identify under or overpayments, and an adjustment invoice or credit can be issued. The process is handled at the end of an accounting period or lease, based on the outgoings provisions in each lease.

The cycle for managing outgoings reconciliation has four stages:

1. Outgoings budget: At the start of the lease year, the property manager prepares an estimate of the building’s recoverable costs. The Property Council’s Benchmark of Operating Expenses Report can help figure out these costs. 
2. Periodic invoicing: Tenants pay their share of the estimate, typically monthly alongside rent, based on their net lettable area (NLA) proportion or another split their lease specifies, such as a set percentage.
3. Actual costs: Invoices for rates, insurance, cleaning, maintenance and other outgoings accumulate through the year. Coding each invoice to its outgoings account as it arrives, and checking year-to-date spending against the budget before approving payment, catches overruns months before the wash-up.
4. Year-end reconciliation: Actual costs are compared with the budget, each tenant’s share is recalculated, and the difference is issued as an adjustment.

The amount tenants contribute to outgoings depends on the lease structure. Under a net lease, recoverable outgoings are charged on top of base rent. Under a gross lease, they’re built into the rent and not recovered separately.

On multi-tenanted commercial, retail and industrial properties, recoverable costs are usually collected in two ways. 

Directly recoverable expenses, such as a tenant-specific plumbing repair or metered water use, are on-charged as they arrive. 

Variable outgoings are paid as a fixed monthly contribution based on the annual budget, and these are what the year-end reconciliation tests.

The outgoings reconciliation methodology must match the lease exactly: applying the wrong apportionment formula for even one tenancy may create a dispute that can result in a refund obligation or legal challenge.

Accounting software for commercial property management will help by automating reconciliation throughout the year and keeping track of itemised expenses and payments.

How do commercial property agencies handle end-of-month trust accounting reconciliation?

End-of-month trust accounting reconciliation matches the agency’s trust ledger against the trust account bank statement, resolves any differences and gets principal sign-off before money is disbursed to owners. It’s a different process from outgoings reconciliation, and the two are often confused.

Outgoings reconciliation is about what tenants owe.

Trust reconciliation is about whether the money held on their behalf is fully accounted for.

Trust reconciliation happens every month, and the steps include:

1. Import the trust account bank feed or statement file for the period.
2. Match each bank transaction to its entry in the trust ledger.
3. Investigate and resolve unmatched items, such as unidentified deposits, timing differences or data entry errors.
4. Confirm the trust ledger balance, the bank statement balance and the total of owner and tenant ledgers all agree.
5. Generate end-of-month reports for principal review and sign-off.
6. Process owner disbursements once the reconciliation is signed off.

Done manually, step two is where most of the time goes. With an automated receipting workflow, most of that matching happens daily as payments arrive. By the time the month closes, reconciliation becomes a review-and-exceptions task, and managers only deal with the items the system couldn’t match.

How does automated reconciliation work within commercial property management accounting software?

Automated reconciliation in a purpose-built platform covers the full outgoings cycle from budget setup at the start of the financial year through to wash-up statements at year end, not just the reconciliation step itself.

At the start of the financial year, Rex Cirrus8’s budget wizard pulls the previous year’s actual expenses directly from the ledger by Chart of Account codes, eliminating the need to re-key historical data from Excel. A single building budget can accommodate both net and gross leases simultaneously, with account code groups separating owner expenses, variable outgoings and directly recoverable costs. Once the budget is locked, the system automatically updates the recurring monthly variable outgoings charge across all active tenant lease cards. Personalised Estimate of Outgoings notices can then be generated and sent to every tenant in the building in a single step.

During the year, invoices arriving via work orders or document scanning are pre-coded to the relevant outgoings account. Managers and accountants can check real-time year-to-date spending against the budget before approving any payment, catching overruns months before the wash-up rather than discovering them at year end.

At year end, automated reconciliation starts with bank data, which comes in either through a direct bank feed or an imported statement file in a standard format such as QIF or TXN.

Automation works on two layers:

For trust account reconciliation, automated bank and lease matching handles the bulk of the daily receipting.

For outgoings reconciliation, the system calculates each tenant’s share using net lettable area (NLA) drawn from registered unit dimensions or a custom percentage where the lease requires one. It then produces a year-end report comparing actual costs against estimated tenant contributions, pro-rated by exact occupancy dates for any tenant who moved in or out mid-year. The report can also be run for a custom date range, such as a two-month wash-up when a property is sold.

Platforms such as Rex Cirrus8 bring both layers together, so the same system that receipts rent and pays invoices also holds each tenant’s lease terms and produces their year-end statement.

What automated reconciliation handles vs. what still requires manager review:

• Automated: importing bank feeds or statement files.
• Automated: matching incoming funds to the correct property, lease or debtor file using payment descriptions, CRNs and BPAY details.
• Automated: flagging transactions that can’t be matched.
• Automated: calculating each tenant’s share of outgoings by NLA or custom split.
• Automated: producing the year-end outgoings wash-up, pro-rated for mid-year tenancy changes.
• Automated: posting adjustments in bulk for each property, instead of as individual journal entries.
• Automated: generating and emailing wash-up statements to every tenant.
• Manager review: resolving unmatched or unusual transactions.
• Manager review: principal sign-off on month-end reconciliation.
• Manager review: lease-specific judgment calls, such as how a cap, base year or excluded category applies.

Automation removes the manual data matching that creates most of the reconciliation workload, and frees managers to focus on resolving exceptions and validating outcomes against each lease.

If you’re wondering what accounting software systems for commercial property management will help you stay on top of outgoings, an industry-specific platform is a good option to explore.

How is outgoings reconciliation handled at year-end for commercial property tenants?

At year-end, at the end of a lease or when a property is sold, the property manager will collect the building’s actual costs, check the lease to confirm which costs are recoverable, and calculate the tenant’s share by NLA proportion and any lease-specific adjustments.

The next step is to prepare a reconciliation statement for the tenant and issue an adjustment invoice or credit for the difference between what they paid and what they owe.

Year-end outgoings reconciliation process: 

1. Collect all outgoings costs: Gather every invoice and cost for the period and confirm each is coded to the right building and outgoings category. If the owner paid a bill directly, such as land tax or council rates, record it as a recognised expense so it counts towards the wash-up without triggering a second payment to the supplier.
2. Validate recoverable costs: Check each tenant’s lease to confirm which categories are recoverable, which are excluded, and whether caps or a base year apply.
3. Apply the correct NLA proportion: Calculate each tenant’s share using the apportionment set out in their lease, adjusting for vacancies, part-year occupancy (pro-rated to exact move-in and vacate dates, including where two tenants occupied the same unit during the year) or any agreed variations.
4. Prepare reconciliation statements: Produce a formal statement for each tenant showing budgeted and actual costs by category, with supporting documentation and an audit where the lease or legislation requires one.
5. Issue adjustments: The adjustment is the tenant’s actual share minus the outgoings contributions they paid. A positive figure means the tenant underpaid and receives an adjustment invoice. A negative figure means they overpaid and receive a credit. Depending on the lease, overpayments are often held as a credit on the tenant’s ledger instead of being refunded, which gives the building a cash-flow buffer for large bills such as council rates and land tax that tend to arrive early in the financial year.

If disputes arise, they can usually be traced back to a handful of issues:

• Outgoings caps: A lease may limit annual increases or set a maximum contribution, and charging above it is an easy mistake to make.
• Excluded categories: Costs the lease excludes, such as capital works or certain management costs, slip into the recoverable pool.
• Management fee limits: Leases often cap the management fee as a percentage, and the cap must be applied tenant by tenant.
• Land tax treatment: Whether land tax can be recovered, and on what basis, depends on the lease and on state legislation, particularly for retail tenancies.

The outgoings reconciliation statement is a legal document that must align precisely with each tenant’s lease: a manager who includes costs the lease excludes, or applies the wrong apportionment formula, is exposed to a legitimate dispute.

Make outgoings reconciliation faster and more accurate

Outgoings reconciliation is one of the most time-consuming and legally sensitive processes in commercial property management.

To reduce errors and the time required to prepare reports, look for a tool that calculates and displays each tenant’s share by NLA, separates directly recoverable expenses from variable outgoings, and pro-rates the year-end or end-of-lease wash-up for tenancy changes.

When the commercial property management accounting software does the heavy lifting, your professional judgment then goes where it matters most: applying each lease correctly, reviewing reports and managing client relationships.

Cirrus8 is built to help manage the complexity of commercial property outgoings management. Book a demo to see how it can support your portfolio's outgoings reconciliation.