Investment Property Spreadsheet: Track Costs & Cash Flow (2026)

Investment Property Spreadsheet: Track Costs & Cash Flow (2026)

An investment property spreadsheet should help you understand every dollar flowing in and out of your rental -- from what tenants pay to council rates to that emergency hot water system. Without one, you're generally making decisions in the dark, and the factors that affect your return stay hidden until tax time.

Most people investing in real estate start with a basic spreadsheet and quickly find things get complicated. Important information goes missing, figures aren't updated, and by the end of the financial year you're stuck trying to piece it together. This article covers exactly what to track, provides a worked example with real 2026 numbers, and explains when a spreadsheet stops being the right way to manage a growing portfolio.

What Your Investment Property Spreadsheet Must Track

Every rental generates two streams: income and expenses. Your spreadsheet needs to capture both accurately, designed to hold the type of information your accountant requires at year end. Careful planning helps ensure nothing is missing when you need to claim deductions or calculate tax payable.

Rental Income and Vacancy Periods

Your gross rental income is the starting point. For a typical house in Brisbane where tenants pay $550 per week, that's $28,600 per year -- but only if you have zero vacancy over that period.

Build in a vacancy rate allowance. The national average generally sits around 2-3%, but it varies -- certain suburbs hit 5% or higher between changeovers. A 3% vacancy on that annual rent results in a loss of $858.

It's not uncommon, but many people overlook it when investing. Factoring vacancy in from the start gives you a more accurate picture of your return.

Track what tenants pay weekly (not just what's owed), vacancy weeks, and any arrears. Your property managers' statement is the source of truth -- check it each month and enter the figures to stay prepared.

Home Loan Repayments and Interest

Your mortgage is generally the single largest cost involved in owning a rental. On a $520,000 interest-only loan at 6.39% (a typical investor rate in April 2026), you pay $2,769 per month or $33,228 annually. Mortgage repayments on a principal and interest loan depend on the contract terms.

Track interest separately from principal -- only the interest portion is tax deductible. If you're on a principal and interest home loan, your spreadsheet needs a column splitting each repayment so your accountant can claim the correct deductions and calculate what's applicable for tax purposes.

Include your offset account balance too. A $45,000 offset on that $520,000 mortgage saves you $239 per month -- that directly improves your cash flow. The relationship between savings and what you owe is one of the key factors that affect your bottom line.

Property Management Fees

Property management fees generally cost 7-10% of gross rent plus GST. On $550/week rent at 8.8% (common in QLD), that's $2,517 per year. Property managers handle the day-to-day upkeep, find new tenants through leasing, and protect your interests as an owner -- but their fees need to be calculated and included.

Don't forget the one-off fees: letting fees (1-2 weeks rent for finding tenants), lease renewal fees ($150-$300), and inspection fees. These add $800-$1,500 annually depending on turnover. These fees are applicable in most states.

Property Tax: Council Rates and Land Tax

Council rates vary by local government area and depend on where your house or apartment is built. Brisbane City Council charges approximately $1,800-$2,400 per year. Track the quarterly amounts -- they increase annually across most states.

Land tax applies above your state's threshold. In Queensland, the threshold is $600,000 of unimproved land value (2025-26). Owning a second or third asset can push you over, triggering a land tax bill of $1,500+ that many investors miss. The way land tax is calculated varies between states, so check the guidelines that apply.

Utilities like water rates add another $900-$1,200. Some are passed to tenants under the lease contract, while others remain with the owner.

Landlord Insurance and Maintenance Costs

Landlord insurance covers the building, contents, and loss of rent -- designed to protect you from things like tenant damage and rental default. Budget $1,200-$1,800 per year. Building cover alone won't be enough if something goes wrong during a tenancy period.

Maintenance is the hardest line item to predict. The industry rule of thumb is 1-2% of the purchase price annually -- so $6,500-$13,000 on a $650,000 house. Newer construction generally costs less ($2,000-$4,000) while older properties with ageing systems cost more. Renovations and improvements can affect the market value but taking on major work needs due diligence and careful planning.

Track every repair receipt. The ATO distinguishes between repairs (immediately deductible) and capital improvements (depreciated over time). Getting this wrong at tax time has real consequences -- talk to your accountant about what you can claim.

Stamp Duty and Purchase Costs for ROI

Your initial acquisition -- stamp duty, deposit, legal fees, building inspections, and loan establishment fees -- don't repeat annually but they matter for calculating your true return over the life of the investment.

When you buy a $650,000 Queensland house or townhouse, stamp duty alone is $14,175. Add conveyancing ($1,500), inspections ($800), and loan fees ($600) and you've spent $17,075 before collecting a single week's rent. Many people buying in the current market don't factor these into their planning.

Investment Property Costs: A Real Worked Example

Here's a complete annual cost breakdown for a $650,000 townhouse in Brisbane (2026 figures). This example shows the factors involved in owning and investing:

This asset is negatively geared -- costing $218 per week after tax benefits. That result is not unusual for investing in a capital growth area. The spreadsheet shows you the exact weekly cost so you can budget and make informed decisions.

A positively geared asset would show a positive number in that final row. Regional areas with higher rental yields (6%+) often achieve positive cash flow, while metro locations tend to trade cash flow for growth. The housing market in each area is different, and you should understand what's driving returns before you buy.

How to Calculate Cash Flow from Your Investment Property Spreadsheet

The formula is straightforward -- you don't need complex software or a calculator to work it out:

Annual Cash Flow = Gross Rent - Vacancy - All Operating Costs - Home Loan Repayments

For the example above: $28,600 - $858 - $9,117 - $33,228 = -$14,603 (pre-tax position)

Add back tax deductions (interest, depreciation, operating costs) multiplied by your marginal tax rate to get the after-tax position. The way these figures are calculated depends on your income and the percentage that applies to your bracket. You can generally claim all legitimate costs against your rental income.

Use the PropBoss cash flow calculator to model different scenarios instantly -- adjust mortgage rates, what tenants pay, or vacancy assumptions to find how your weekly position changes. The software connects to your bank and provides insight using real transactions, not estimates. That's simpler than manually entering figures into a spreadsheet and hoping you haven't missed something.

For investors owning multiple rentals, your spreadsheet needs to aggregate across all holdings to show the total portfolio position. This is where tracking in spreadsheet software becomes complex -- one asset might be positively geared while another drains money, and you need the net result. A dedicated calculator handles this automatically.

Why Most Rental Property Spreadsheets Eventually Fail

A spreadsheet works when you have one rental and update it carefully. It breaks down when:

Manual data entry creates gaps. Miss one payment or forget to log a repair, and your year-end figures are wrong. The ATO requires accurate records for every holding you own -- a spreadsheet you haven't touched since March won't cut it.

Multiple holdings multiply complexity. Three rentals means three sets of bank transactions, three manager statements, and three sets of rates notices to enter by hand. Most investors buying their second or third asset find they fall behind within 6 months.

Tax time becomes a scramble. Your accountant needs costs categorised by type (repairs vs capital works vs operating), split by asset, with receipts attached. A spreadsheet gives you the numbers but not the categorisation or receipt trail the ATO requires. You need to be prepared well before the end of the financial year -- not selling yourself short on deductions because information was missing.

Dedicated software solves the root problem. PropBoss connects directly to your bank and automatically categorises transactions for each rental -- what tenants pay, home loan repayments, cover, rates -- across your entire portfolio. No manual entry, no missing data, and your financial position updates in real time. For people who download spreadsheet templates from a website and try to make them work for investing across multiple holdings, there is a simpler way to gain peace of mind and ownership of your numbers.

Frequently Asked Questions

What Is a Positively Geared Property?

A positively geared holding generates more rental income than its total ongoing costs (loan repayments, rates, cover, maintenance, and management fees combined). The surplus is taxable income. In 2026, you'll generally find positive cash flow in regional areas with rental yields above 6% -- think Rockhampton, Bundaberg, or outer Adelaide -- while metro houses in Sydney, Melbourne, and Brisbane usually run at a loss (negative gearing) in exchange for capital growth. The right strategy depends on whether you're investing for cash flow or long-term market value.

How Do I Know If My Rental Is Positively Geared?

Add up every cost for the year (home loan interest, rates, cover, management, maintenance, land tax) and subtract from what tenants transfer into your account. If the number is positive before accounting for depreciation and income tax, your rental is positively geared. Use the PropBoss calculator to model this -- it provides clear answers, not just raw data. You can also use the rental yield calculator to check percentage returns by area.

What Are the Biggest Hidden Costs?

Land tax catches most investors off guard -- especially when owning a second or third asset pushes your total land value above the state threshold. Other commonly missed costs: landlord premium increases (10-15% annually in 2025-26), special body corporate fees for strata apartments, and the gap between vacancy periods (typically 2-4 weeks per changeover). When selling, capital gains tax is another factor that affects your net return.

Is There a Tool That Automates Tracking?

PropBoss tracks rental income, costs, and the net position across all your rentals with automated bank feeds. It categorises transactions, calculates your financial position in real time, and generates ATO-compliant reports at EOFY -- so you don't need spreadsheets for your portfolio. The software handles depreciation schedules, tax deduction categorisation, and multi-asset tracking from $1/holding/month. It's built to suit both new and experienced investors who are buying, owning, or selling.

Stop Managing Spreadsheets -- Start Investing Smarter

A spreadsheet got you started, but if you're spending hours each month updating figures across multiple rentals, you've outgrown it. PropBoss connects to your bank, auto-categorises every transaction, and shows your true financial position across your entire portfolio -- updated daily, not whenever you remember to open the spreadsheet. Whether you're planning to buy your next house, selling an underperformer, or just want to claim every deduction available, the right software makes owning and investing simpler.

Try PropBoss free | Calculate your returns