Rental statement reconciliation is the process of matching the periodic statements (usually monthly) your property manager sends throughout the year against the annual rental summary they issue at end of financial year, and then matching both against the actual deposits in your bank account. The three should agree — and they almost never do on first pass. The gaps are usually fixable, but they have to be found before lodgement.
General process guide for AU property investors using a managing agent. Tenancy and management contract terms vary by state and agency — confirm specifics with your property manager or accountant before relying on any specific approach.
The three numbers that should agree (but rarely do)
Rental statement reconciliation
The end-of-financial-year process of cross-checking three sources of rental income data — the sum of periodic statements, the annual summary, and the bank deposits — so the figure on your tax return is supported by all three.
Three sources, ranked in order of how trustworthy they usually are:
- Annual summary from the property manager. Aggregated, end-of-year-reclassified, signed off by the agency. Treat as authoritative for income.
- Periodic statements (usually monthly). Cash-flow detail, but subject to mid-year reclassification.
- Bank deposits in your linked account. The ground truth for what actually arrived.
Why the three sources disagree (the seven structural reasons)
- Agency-fee netting differences. Periodic statements show rent received then management fee deducted as separate line items. Annual summary often presents fees as a single rolled-up total — easy to double-count if you sum both.
- Trust-account holds. Bond, repair retentions and disbursement-timing differences create amounts that sit in the agent's trust account briefly. They appear in some periodic statements but might not reconcile to a bank deposit that month.
- End-of-year re-categorisation. A $1,200 charge originally classified as "general repairs" in March may get re-classified as "capital improvement" at 30 June — shifting between expense buckets in the annual summary.
- Disbursement timing gaps. A periodic statement dated 28 June reflects rent received in late June. The bank deposit might land 1-3 July — straddling the financial year boundary.
- Tenant arrears recovered later. Rent owed in May, paid in July. Periodic statement and annual summary handle this differently depending on the agency's cash vs accrual policy.
- Insurance claims and rebates. Landlord insurance reimbursements may be netted against an expense in the annual summary but show as separate "other income" in the periodic statement.
- Multiple property pooling. If the agency manages 3 of your properties, a single bank deposit may cover all 3 — you have to split it back per property to reconcile.
The seven-step manual reconciliation process
Step 1 — Sum the rent received column across all periodic statements
Take every monthly statement, extract the "rent received" column (not the net disbursement), sum to a single FY total per property. This is your "periodic gross rent" figure.
Step 2 — Pull the same figure from the annual summary
Find the "gross rent received" line on the annual summary (usually the first or second number on the page). This is your "annual gross rent" figure.
Step 3 — Sum bank deposits flagged as rental income
Pull every bank transaction for the FY tagged as rental income, sum per property. This is your "bank-side gross rent" — though it'll be net of agency fees, not gross.
Step 4 — Add back agency fees + outgoings to the bank-side figure
From the annual summary, pull the total agency fees + outgoings (rates, water, repairs, insurance) the agent paid on your behalf. Add this to bank-side gross rent — that gives a third gross figure to cross-check.
Step 5 — Compare the three gross-rent figures
Differences of 1-2% are usually timing — the late-June deposit that landed 2 July. Differences above 5% indicate a structural issue (missed statement, mis-categorised deposit, multi-property pooling not split, year-end reclassification).
Step 6 — Investigate the difference
The fastest path: find the FY first month and last month of the periodic statements, check if there are deposits sitting just outside the FY boundary that should be in. If not, walk forward through each month and find the deposit that doesn't match the periodic statement.
Step 7 — Reconcile expenses separately
Repeat steps 1–5 for each expense category — agency fees, rates, water, repairs, insurance. Annual summary remains authoritative; periodic statements are the audit trail.
PlotBot's "match-up" approach
PlotBot's rental reconciliation collapses steps 1-7 into an automated check. When you upload both the annual summary and the periodic statements, the system computes the three figures (periodic gross, annual gross, bank gross) per property per period and surfaces a "match-up" badge: green when all three agree within tolerance, amber when the gap needs review, red when the gap exceeds the threshold.
For amber and red, PlotBot shows the per-line difference + a one-click "accept the annual summary" or "query the agent" flow. The reconciled rent figure pushes into the property's income line for the accountant export. No spreadsheet required.
The seven-step manual reconciliation typically takes 2-4 hours per property per year, including the back-and-forth with the property manager. Most investors skip it and trust the annual summary alone — which works until the ATO queries a discrepancy at audit.
If you'd rather not do this by hand
Rental statement reconciliation is one of the original problems that motivated PlotBot. Every property investor doing this by hand either skips it (risk) or burns half a weekend per property per year. The match-up badges turn it into a 5-minute review of the amber and red flags.
See the pricing page for plan details, or jump into the 14-day free trial and upload one annual summary + the matching periodic statements to see the reconciliation flow on your own data.