Bank Statement for Rental Property Income (Australia) — Convert to Excel

What the rental schedule needs

Rental income is assessable, and against it you can claim a specific set of deductions. From the bank account, over the 1 July to 30 June year, you need:

• Rent received. Credits from tenants or the managing agent's payouts, totaled for the year.
• Deductible expenses. Council rates, water, insurance, repairs and maintenance, and agent's management fees.
• Interest on the loan. For an investment property this is deductible, and it's often the largest single claim, so it has to be identified and totaled correctly rather than buried among other costs.

Depreciation is usually handled from a quantity surveyor's schedule rather than the bank, but everything you actually paid for the property shows in the account.

From PDF to a rental spreadsheet

1. Download the year's statements as PDFs — CommBank's NetBank, Westpac, NAB, ANZ and the rest keep them in online banking.
2. Convert each to Excel or CSV. Every transaction returns as a row — date, description, debit, credit and balance — with the closing figure checked.
3. Combine the months into one sheet for the full financial year.
4. Sort rent and expenses. Total the rent credits, then add a category column for the expense types and total each for the rental schedule.

If the rent comes through a managing agent, their statement shows the gross rent, fees and any costs they paid; the net payout is what reconciles to your bank deposit.

Negative gearing and getting the interest right

Many Australian investors negatively gear — the deductible costs, interest especially, exceed the rent, and the loss reduces other taxable income. That makes the interest figure one of the most important on the return, and one the ATO checks. If the loan repayment leaves your account and you only claim the interest portion, you need the statements to separate it cleanly. With every transaction as a sortable row, the loan interest, the principal and the offset movements are each identifiable, so the deduction is right and you can show how you arrived at it. Guessing at it from a PDF is exactly how a rental claim gets adjusted.

What the converter handles that a copy-paste won't

Australian statements often wrap a long payee or a BPAY reference onto a second line, and a plain copy-paste turns that into a phantom row that throws the columns out — so your rent total or a deduction is wrong. The converter joins each wrapped line back to its transaction and checks the balance across the year, so the schedule is built on complete, reconciled data.

Keeping records for capital gains too

The rental schedule is the annual job, but a rental property also has a longer tail: when you eventually sell, capital gains tax is worked out over the whole period you owned it, and the cost base can include capital improvements you paid for along the way. Those improvement payments — a new kitchen, a deck, a re-roof — sit in the same bank account as the year's ordinary expenses, and they're easy to lose if you only ever look at one year at a time. Converting each year's statements and keeping the reconciled records builds, almost as a by-product, the trail you'll want years later to support the cost base and reduce the eventual CGT. It's far easier to keep that as you go than to reconstruct it from old PDFs when the property sells.