Rental statements: where the missing rent went

You have Owner_Annual_Statement.pdf open on one screen and the client's bank transactions on the other. The rent on the statement is higher than the deposits. You ask whether another account received some of it. The client replies, quite reasonably, that the agent takes their fees out first.

Then a second email arrives with the plumber's invoice. It is already in the agent's statement. You have now found the same expense twice and are still looking for part of the rent.

A rental statement reconciliation should explain how the money moved before anyone starts copying figures into the return. Build the bridge from gross receipts to owner payments, account for funds still held by the agent, then decide the tax treatment of each line. Trying to do all three by matching bank deposits to a column headed “rent” is how a tidy file acquires a very untidy problem.

Gross rent and the owner payment answer different questions

The ATO's rental income guidance says to report gross rent before property management fees and expenses paid on the owner's behalf. Rent paid to an agent or property manager is included; looking only at deposits in the owner's bank account misses that distinction.

The bank deposit tells you what the agent sent through. The annual statement should tell you what came in and what was paid out before that transfer. Those amounts can both be correct and quite different.

This also means “add the fees back” is only a starting point. An agent might have paid a council bill, received money from the owner to cover work, or kept funds on hand. Each belongs in the cash reconciliation. Each needs its own classification before it reaches a tax schedule.

Keep two visible outputs: the reconciliation of the agent's funds, and the income-and-expense schedule. A zero difference on the first does not approve the deductions on the second.

Establish which property and which period the PDF covers

Before the arithmetic, read the top of the statement. It is the least interesting part of the page, which gives it an excellent chance of being ignored.

Check the property address, owner, management period and report dates against the file. An annual statement from the new agent may cover only the months since the handover. Two PDFs headed “annual” do not necessarily describe two years, and two owners do not necessarily own two properties.

Start one reconciliation per property. The ATO's rental record-keeping guidance asks owners of multiple properties to keep separate records for each. That separation is useful at review too: a missing payment for one address cannot quietly cancel an extra payment for another.

For the property you are working on, assemble:

• The annual agent statement and the transaction detail supporting its totals.
• The opening and closing amounts the agent held for the owner, if any.
• Bank evidence for the payments the agent sent and any funds the owner paid in.
• Invoices behind expenses that need investigation, plus expenses paid directly by the owner.
• Handover records if the property changed agents during the year.

This is a list of evidence to check, not a demand to resend everything. If the file already holds the first six months, ask for the second six. A client should not have to work out which half you lost.

A worked rental statement reconciliation

Here is an illustrative example, using invented amounts to show the method. It is not a client case, a typical fee quote or a calculation of tax payable. Assume one property, no owner contributions, no other receipts and all owner payments clearing the bank within the same reporting period.

Movement in the agent's funds	Amount
Opening funds held for the owner	$500
Gross rent received during the year	$31,200
Less agent fees paid	($1,872)
Less council rates paid	($1,800)
Less plumbing invoice paid	($1,008)
Less payments sent to the owner	($26,620)
Closing funds held for the owner	$400

The agent paid out $4,680 in fees and bills: $1,872 + $1,800 + $1,008.

So the reconciliation is $500 + $31,200 − $4,680 − $26,620 = $400. Match that last amount to the agent's closing balance, and match the $26,620 to the owner's bank evidence. Neither match should be a figure typed back in from your own calculation.

The apparent gap between gross rent and owner payments is $4,580. That is $4,680 of outgoings, reduced by the $100 decrease in funds retained by the agent. Adding only the agent's fee to the deposits would leave most of the difference unexplained.

The rent figure in this example is $31,200. The $26,620 is a cash distribution to the owner. Whether all of the $4,680 belongs in current-year deductions is a separate review of the supporting expenses. The heading “plumbing” has not settled the treatment of the work.

For a less tidy file, expand the bridge rather than forcing the example to fit:

Opening funds + rent + other receipts + owner contributions − paid expenses − owner payments − other transfers = closing funds.

Keep other receipts and owner contributions on separate rows. An owner topping up the agent's account to pay for work must not become rent because it arrived in the same cash ledger. Equally, a receipt labelled “other” needs investigation; the ATO's income guidance includes rental-related receipts such as certain retained bond amounts and insurance payments. A label is a place to start reading.

A difference needs a document, not a balancing entry

When the bridge does not close, leave the difference visible and give it a next action. Do not put it into repairs because that is the biggest number nearby.

What you find	What to check next
Agent payments exceed bank receipts for the period	Trace individual remittances around the period end and check whether a payment went to another owner account.
Bank receipts exceed payments on this agent's report	Look for a former agent, a direct tenant payment, or a receipt unrelated to this property.
The closing funds differ from your calculation	Obtain the detailed owner ledger and check contributions, reversals, withheld funds and transfers.
The year appears to stop partway through	Confirm management dates and obtain the other agent's statement or the missing period.
A bill appears in both the statement and the client's uploads	Match the supplier, invoice reference, date and amount before recording another expense.

A remittance recorded by the agent on 30 June and received by the owner on 2 July is a reason to inspect timing. Keep the remittance and the bank entry together and show the outstanding transfer in the bridge between those two records. Do not count it as funds still held by the agent as well if the agent's closing balance already excludes it.

And do not use the date the owner saw the deposit as the sole basis for deciding when rent is reportable. The ATO guidance includes amounts received by the property manager. The cash-receipt check and the income-year decision need to remain distinguishable on the paper.

Where an agent changed, identify any balance transferred from the old agent to the new one. It explains how opening funds arrived with the new manager; it is not another tenant payment. Retain the old agent's closing record and the new agent's opening record beside the transfer. Otherwise the same money can enter your combined rent total twice while both individual reports look perfectly sensible.

One plumbing bill, two pieces of evidence

Return to the invoice in the second email. In the example, the $1,008 already appears among payments made by the agent. The emailed invoice supports that payment. It does not create another one.

Give the expense one row and attach both references: the invoice and the line in the agent's ledger. Then note who paid it. That small field stops the invoice from being added again when somebody later works through the client's bank account or the folder of loose receipts.

Amount alone is a poor duplicate check. Two garden visits can cost the same. One invoice can be paid in instalments. Use the property, supplier and invoice reference as well as the date and amount, and record a part-payment as a part-payment.

Now read what the plumber actually did.

The ATO's repair and maintenance guidance distinguishes deductible repairs from improvements and initial repairs, which are capital in nature. An agent's category cannot make that decision for you. Where the description is “works as discussed”, ask for the scope of work, what was repaired or replaced, and when the damage arose. Keep the classification open until the evidence supports a conclusion.

A useful review note is specific: “Invoice paid by agent and included once; scope of replacement outstanding; treatment awaiting review.” The much shorter “repairs checked” saves several seconds now and spends them with interest later.

Finish the property, including the things the agent never saw

Even a fully reconciled agent statement covers only what passed through that agent's records.

Ask about property costs the owner paid directly. Check the lender's interest evidence separately from the loan repayments leaving the bank. Look for the relevant insurance and rates documents, capital expenditure records and any existing depreciation schedule. The ATO's record-keeping page lists loan records, expense receipts and capital works documentation for a reason: the agent's annual PDF cannot stand in for all of them.

Keep these direct costs outside the agent's cash bridge. They belong in the broader rental working paper, with their own evidence and treatment. Adding them to the agent's outgoings would break a reconciliation you have just finished correctly.

Before allocating amounts to individual owners, establish whether the statement reports the whole property or only a particular owner's share. Write the basis on the schedule. A report addressed to two people does not, by itself, tell you how its figures have been split.

For the gaps that remain, send a short request that names the document and the problem it resolves. For example: “Please send the old agent's final statement and the new agent's first statement for the unit, including any balance transferred between them. We have the rent summaries but cannot yet tie the handover.” That is an answerable request. “Please confirm rental income” is an invitation to receive the same PDF again.

This is the practical version of asking for the missing documents: the question comes from the file you have actually read.

Leave a review note someone can use

At the front of the rental schedule, leave a short record of what has been established:

• Coverage: property, reporting period and every agent included.
• Receipts: gross rent and separately identified other receipts, with source references.
• Cash: owner payments traced to the bank, opening and closing funds agreed, and timing items explained.
• Expenses: direct and agent-paid costs combined once, with uncertain treatments identified.
• Outstanding: the exact document or decision still needed, and who is following it up.

That is the same standard we argue for in working papers that survive review: somebody else should be able to follow the figure without finding the person who prepared it.

BeforeMay's working paper templates are one place to look at the schedule structure. Whatever software holds the file, the test stays simple. Pick the owner's bank deposit, follow it back through the agent's payments and retained funds, and arrive at the gross receipts with every difference explained.

The missing rent may never have been missing. The explanation was.