Property is a funny business to manage financially. On the surface it looks simple: you buy something, you rent it out or sell it, money comes in. But spend five minutes inside the actual books of a real estate agent or a multi-property investor and the picture gets complicated rather quickly.
Commission structures that vary by transaction. Properties in different ownership entities. Rental income arriving at different times from different tenants. Capital works versus repairs, a distinction that sounds small until you understand that getting it wrong changes your tax position significantly. Depreciation schedules. GST or VAT on some transactions but not others. Agent trust accounts that have to be kept entirely separate from operating funds.
We work with real estate professionals and property investors across the UK, Australia, Canada, and the US. From individual landlords with two buy-to-let flats near Elephant and Castle in London to property management agencies running portfolios across Melbourne’s inner suburbs, the financial complexity is real and the cost of poor bookkeeping in this sector is higher than most.
This article covers the full picture: what bookkeeping for real estate and property investment actually involves, which income and expenses need careful tracking, how software like Xero and QuickBooks handles property-specific accounting, and what a professional bookkeeper does for property clients that general-purpose accounting cannot replicate.
Why Property Bookkeeping Is Different from Standard Business Bookkeeping
Most standard bookkeeping setups are built around a relatively straightforward flow: revenue comes in, costs go out, profit is what remains. Property complicates that in several specific ways that require a different approach from the start.
Multiple Entities and Ownership Structures
Property investors rarely hold everything in a single personal name by the time they have a portfolio of any size. Limited companies, limited liability partnerships, trusts, joint ownership arrangements, and SPVs (Special Purpose Vehicles) are all common. Each entity needs its own set of books. Transactions between entities, intercompany loans, management fees, and profit distributions all need to be recorded accurately and consistently. Conflating personal finances with entity finances, or mixing two entities together, is one of the most common and most expensive mistakes we see.
The Capital vs. Revenue Distinction
This is the one that causes the most trouble. In most countries, spending money on a property falls into one of two categories: capital expenditure (adding value, improving, extending) or revenue expenditure (maintaining, repairing, keeping the property in its current condition). Capital expenditure is not fully deductible in the year it is incurred. Revenue expenditure usually is.
Replacing a boiler that broke is revenue. Adding a conservatory is capital. Repainting internal walls is revenue. Converting a loft is capital. The distinction matters because miscategorising capital as revenue inflates your deductible expenses, which HMRC, the ATO, or the IRS will take a close interest in if they look. And miscategorising revenue as capital means you are paying more tax than you need to. Both errors cost money. Getting it right requires someone who knows the rules.
Depreciation and Capital Allowances
Properties depreciate. Fixtures, fittings, and plant within properties depreciate faster. In Australia, the ATO allows property investors to claim depreciation on the building itself (Division 43) and on fixtures and fittings (Division 40), but only if a formal tax depreciation schedule has been prepared by a quantity surveyor. In the UK, residential landlords cannot claim capital allowances on the property itself but can claim on fixtures in commercial property. In the US, residential investment property is depreciated over 27.5 years under MACRS.
None of this is captured automatically. It requires a depreciation schedule to be set up correctly in the bookkeeping system and updated each year, and someone needs to make sure the annual depreciation charge is reflected accurately in the accounts.
Trust Accounts (Real Estate Agents)
Licensed real estate agents in most jurisdictions are legally required to maintain separate trust accounts for client funds; primarily rental income collected on behalf of landlords and deposits held during sales transactions. These funds cannot be mixed with the agency’s own operating money. Trust banking is run by unique laws in every state and country, with constant audits and tight checking rules. The penalties for trust account breaches are severe, up to and including loss of licence.
Key Income Categories to Track in Property Bookkeeping
| Income Type | Who It Applies To | Bookkeeping Notes |
| Rental income | Landlords and property investors | Track by property, separate gross rent from agent management fees deducted at source |
| Sales commission | Real estate agents | Record per transaction, track by sales person if commission sharing applies |
| Property management fees | Property management agencies | Often a percentage of rent collected; track separately from trust account flows |
| Holiday let income | Short-term rental operators (Airbnb etc.) | May attract different tax treatment to long-term rental; track platform fees and cleaning costs against gross income |
| Capital gain on sale | Property investors | Not income in the traditional sense but must be recorded and tax calculated separately; timing of the sale matters for CGT |
| Referral and trail commissions | Real estate agents | Can come from mortgage brokers, conveyancers, insurance providers; keep separate from property sale commission |
| Interest income | Investors with cash reserves | Track separately; relevant for offset account strategies in Australia |
Deductible Expenses: What You Can and Cannot Claim
This is where a lot of property investors leave money on the table, usually because they are not tracking expenses carefully or are not aware of what is allowable. Here is a breakdown across the major categories:
| Expense Category | Typically Deductible? | Notes and Caveats |
| Mortgage interest (investment property) | Yes (UK: restricted to basic rate tax credit for residential; AU and US: generally fully deductible) | UK rules changed significantly from 2020 for residential landlords |
| Property management fees | Yes | Fully deductible as a business expense against rental income |
| Letting agent fees | Yes | Finder’s fees, renewal fees, and ongoing management costs |
| Repairs and maintenance | Yes (revenue expenditure) | Must be genuine repair to existing condition, not improvement |
| Buildings and contents insurance | Yes | Proportion of any personal use property may need to be excluded |
| Council tax or rates (landlord-paid) | Yes | Only when landlord pays directly rather than tenant |
| Utilities (landlord-paid) | Yes | Only periods where the landlord is responsible |
| Legal and professional fees | Sometimes | Fees for new leases may be capital; fees for renewals generally revenue |
| Depreciation and capital allowances | Yes (via formal schedule) | Requires correct categorisation and often a specialist schedule |
| Travel to inspect property | Partially (rules vary by country) | Mileage or public transport; personal travel must be excluded |
| Home office (property managers) | Partially | Proportion of home used exclusively for property management work |
| Capital improvements | Not immediately (capitalised and depreciated) | Adding value to the property is capital, not revenue expenditure |
The rules above reflect general principles and differ in detail between the UK, Australia, US, and Canada. Always confirm the specific treatment with a qualified accountant familiar with property tax in your jurisdiction.
How Xero and QuickBooks Handle Property Bookkeeping
Both platforms can be configured to handle property accounting effectively, but neither is purpose-built for it out of the box. The setup matters enormously. A generic chart of accounts is not going to give a property investor the reporting visibility they need.
Setting Up a Property-Specific Chart of Accounts
The chart of accounts needs to reflect the way property income and expenses are actually structured. For a landlord with multiple properties, that means tracking income and expenses by property from the start, not pooling everything together and trying to split it out later. Xero and QBO both support tracking categories or classes that allow transactions to be tagged by property without creating a completely separate set of books for each one.
A well-structured property chart of accounts typically includes separate income accounts for each rental income stream, separate expense accounts for the main cost categories (maintenance, insurance, rates, agent fees, mortgage interest, depreciation), and holding accounts for trust funds if managing property on behalf of others.
Bank Feed Configuration
Real estate buyers usually juggle several bank accounts: one for every property setup, maybe a specific rent collection account, and personal accounts that must stay completely hidden away. Linking all these accounts through open banking in Xero or QBO offers a full view without typing numbers manually. By defining simple matching rules for common transactions like home loan repayments or manager fee payments those routine tasks become automatic.
Depreciation Schedules in Xero and QBO
Both platforms support fixed asset registers and can calculate and post depreciation automatically once the schedule is set up. For Australian property investors using a quantity surveyor’s depreciation report, the figures from that report need to be entered into the system manually each year. For UK commercial property investors claiming capital allowances, the allowances need to be calculated and entered at year-end. Neither platform does this automatically without correct initial configuration.
Trust Account Reconciliation
For real estate agencies managing trust accounts, the bookkeeping needs to track every dollar that moves through the trust separately from the agency’s operating accounts. That means a specific trust bank account linked in Xero or QBO, with every single payment and payout tracked against the right landlord or client. Monthly trust account reconciliations are typically required by regulation, and the audit trail needs to be clear enough to satisfy a licensing authority if one ever asks.
Bookkeeping Tasks That Run on a Regular Cycle in Property
| Frequency | Task | Why It Matters |
| Weekly | Record rental receipts and match to tenancy ledgers | Keeps income tracking current and flags missed payments early |
| Weekly | Process maintenance invoices and supplier payments | Ensures costs are recorded in the period they relate to |
| Monthly | Bank reconciliation for all property accounts | Confirms records match actual bank activity; catches errors before they compound |
| Monthly | Trust account reconciliation (agents) | Regulatory requirement in most jurisdictions; must balance to the cent |
| Monthly | Management reporting by property | Gives the investor a clear view of which properties are performing and which are not |
| Quarterly | VAT or GST return (if applicable) | Commercial properties and some short-term rentals may attract VAT or GST obligations |
| Annually | Depreciation schedule update | Ensures annual depreciation charges are correctly calculated and posted |
| Annually | Capital gains calculation for any disposals | Needs to be prepared accurately before tax filing; timing of sale affects CGT liability |
| Annually | Year-end accounts and tax return preparation | All records need to be clean and reconciled before the accountant can file |
Property Bookkeeping Across Different Countries: Key Differences
The principles are broadly similar across markets, but the specific tax rules, allowable deductions, and reporting requirements vary enough to matter. Here is an orientation:
| Country | Key Tax Considerations | Notable Bookkeeping Requirements |
| United Kingdom | Mortgage interest restriction for residential landlords (basic rate credit only); CGT on disposal; SDLT on purchase; potential ATED for high-value properties held in companies | Separate SA105 supplement for rental income on self-assessment; Making Tax Digital will apply to landlords above income threshold from 2027 |
| Australia | Negative gearing rules (rental losses offset against other income); CGT discount of 50% for assets held over 12 months; land tax varies by state; PAYG withholding on foreign investors | Division 40 and 43 depreciation schedules; STP for any staff; GST on commercial property and new residential sales |
| United States | Schedule E for rental income and expenses; depreciation over 27.5 years (residential) or 39 years (commercial); 1031 exchanges for deferring CGT; passive activity loss rules | State-by-state variations in landlord-tenant law and reporting; 1099s for contractors; robust record-keeping for depreciation basis |
| Canada | Rental income reported on T776; CCA (Capital Cost Allowance) for depreciation; principal residence exemption on disposal; HST/GST on new builds and commercial property | Separate income tracking by property on T776; CCA class determination for each asset type |
What Square Accounting Does for Real Estate and Property Clients
Property accounting is one of our specialist areas. Not because we decided to pick a niche, but because the volume of property clients who came to us with tangled books, missed deductions, and compliance gaps made it an area we developed specific depth in. We know what the books need to look like and we know what goes wrong.
Here is what we typically do for real estate and property clients:
- Chart of accounts setup in Xero or QuickBooks, structured specifically for property income and expense tracking by individual property or portfolio
- Bank feed configuration and reconciliation rules set up so routine transactions post automatically and exceptions are flagged for review
- Trust account bookkeeping for real estate agencies, including monthly reconciliation and audit-ready records
- Depreciation schedule integration from quantity surveyor reports (Australia) or capital allowance calculations (UK) into the accounting system
- Monthly management reports by property, showing income, expenses, net position, and comparison to prior periods
- Capital gains tracking for disposal transactions, with clear records of purchase price, improvement costs, and disposal costs to support accurate CGT calculation
- VAT or GST treatment review for commercial properties, holiday lets, or new residential developments where indirect tax applies
- Year-end accounts preparation in a format ready for the client’s accountant to use for tax filing without significant additional reconstruction
- Ongoing advice on the capital versus revenue distinction for maintenance and improvement decisions, before the invoice is raised rather than after
We cover clients in London (including portfolios around areas like Canary Wharf, Clapham, and Islington), across Australian cities including Sydney, Melbourne, and Brisbane, and US and Canadian markets including Toronto, Vancouver, Los Angeles, and New York. The specific tax rules differ by location but our process does not: clean books, correct categorisation, timely reconciliation, and reporting that actually tells you something useful.
Property Bookkeeping Done Well Is an Asset in Itself
Clean books do not just keep the taxman satisfied. They tell you which properties are actually working for you and which ones are quietly draining resources you did not realise were going out.
We have seen investors holding properties they believed were profitable, and when the books were properly organised for the first time, it turned out the maintenance costs and void periods had made those properties net negative for two consecutive years. Nobody had noticed because the income was being pooled and the costs were not being tracked per property. That is an expensive thing not to know.
Good property bookkeeping gives you that visibility. It also means that when the time comes to sell, refinance, or bring in a partner or investor, the financial records are there, clean, complete, and credible. That matters more than people expect until the moment it is needed.
If your property books are currently a mix of spreadsheets, paper receipts, and vague estimates, we can sort that out. And if you are setting up a new investment or agency from scratch and want to start with proper financial infrastructure rather than building it later, that is even better. Starting clean is always easier than fixing retrospectively.
Contact us today to learn more.