Bookkeeping for property investors comes down to one structural decision made early: each property is its own set of accounts, so its profit-and-loss stands on its own. Get that right and depreciation, capital improvements, repairs, and the interest-versus-principal split of every mortgage payment all fall into place. Get it wrong and a portfolio collapses into a single blurred number that tells you nothing about which building is actually earning.
Per-property books, not one portfolio pile
The most common mistake a new landlord makes is running every property through one rent account and one expense account. It looks tidy. It is useless. When three properties share a single income line, there is no way to see that one is subsidising the losses of another, no way to compute a per-property yield, and no way to answer the question a lender or an accountant will eventually ask: how does this asset perform?
The fix is structural. Each property keeps its own set of accounts — its own rent income, its own mortgage interest, its own property tax, insurance, maintenance, and depreciation — so the income statement is produced per property and the portfolio view is the sum of them, not a substitute for them.
The Property / Real Estate template in HQ Wealth seeds this layout automatically. Creating a property portfolio generates a tailored double-entry chart of accounts with, for each building, the accounts you need to run it as a standalone P&L:
- Property at Cost and Accumulated Depreciation — the asset and its running depreciation, held separately so the book value is always the difference of the two.
- Capex Improvements — capitalised work that adds to the asset rather than expensing through the P&L.
- Mortgage Payable — the loan principal outstanding.
- Rent Income, Mortgage Interest, Property Tax, Insurance, Maintenance, and Depreciation — the operating lines the income statement is built from.
The default reports follow the same logic: a balance sheet, an income statement, a rent roll, and a loan amortisation schedule, each readable per property or rolled up across the portfolio.
Depreciation versus capex versus repairs
Three kinds of spending look similar at the bank and behave completely differently on the books. Confusing them is the single biggest source of wrong property numbers.
A repair restores the asset to its existing condition — fixing a leaking tap, repainting a wall, replacing a broken window with a like-for-like one. It is an expense in the period it happens, and it reduces that property's profit immediately. It posts to Maintenance.
A capital improvement (capex) adds something new or materially betters the asset — a new extension, a replaced roof, a kitchen where there was none. It is not an expense this year. It is capitalised onto the asset:
Debit Capex Improvements (asset) $18,000 Credit Property Bank (asset) $18,000
The cost then enters the asset base and is written down over time rather than hitting one year's P&L.
Depreciation is the mechanism that spreads the cost of the building and its capitalised improvements across the years it is used. It is a non-cash expense — no money leaves the bank — recorded periodically against the asset:
Debit Depreciation (expense) $4,000 Credit Accumulated Depreciation $4,000
The difference matters in money, not just in tidiness. A repair shelters income this year; capex shelters it slowly over many years through depreciation. Treating a capital improvement as a repair overstates this year's expenses and understates the asset; treating a repair as capex does the reverse. The rules on what counts as which, and the depreciable life to use, are jurisdiction-specific and genuinely contested at the edges — this is general information, not advice, and the line between a repair and an improvement is worth checking with a professional.
Splitting a mortgage payment into interest and principal
A mortgage payment is the line item most often booked wrong, because it is two transactions wearing one direct debit. A single payment of, say, $1,450 is part interest — a deductible expense — and part principal — a repayment of the loan that is not an expense at all.
Booking the whole payment as an expense overstates costs and never reduces the recorded loan. Booking it all as principal hides the interest deduction. The correct posting splits it:
Debit Mortgage Interest (expense) $1,050 Debit Mortgage Payable (liability) $400 Credit Property Bank (asset) $1,450
The interest portion flows through the income statement and reduces taxable profit; the principal portion reduces the Mortgage Payable balance on the balance sheet and changes the property's equity, not its profit. As an amortising loan matures, the split shifts — more principal, less interest — which is exactly what the loan amortisation report exists to show. HQ Wealth's amortisation schedule gives the period-by-period interest and principal breakdown, so each payment can be posted against the right two accounts rather than guessed.
Where the rent roll fits
The rent roll is the operational counterpart to the income statement. The P&L tells you what was earned; the rent roll tells you what is contracted and collected — which units are let, at what rent, and whether the cash arrived. Reconciling the two is how a vacancy or a missed payment surfaces as a gap rather than a surprise at year end. Because bank feeds connect through Plaid, rent receipts and outgoings land in the books automatically and the rent roll reconciles against what actually hit the account, per property.
Run this way, a portfolio is legible. Each property has a P&L that stands alone, depreciation and capex are kept distinct from repairs, every mortgage payment is split correctly, and the rent roll proves the income line against the bank. The portfolio number means something because the property numbers underneath it do.
Takeaway: Property bookkeeping works when each property is its own set of accounts — separate the building's depreciation and capex from its repairs, split every mortgage payment into deductible interest and non-expense principal, and let the per-property P&L roll up into the portfolio rather than the other way round.