End-of-Month Reconciliation for Property Managers: A Checklist

Why end-of-month reconciliation matters (and what happens when you skip it)

End-of-month reconciliation is the process of matching every dollar in your property management trust account to a specific owner, tenant, or disbursement before you lock the books for the month. Done correctly, it catches misallocated rent, duplicate invoices, and bank errors before they snowball into compliance breaches or furious landlord phone calls. Skip it—or rush through it—and you'll spend the next quarter chasing phantom balances, explaining why Mrs Chen's repair invoice appeared on Mr Patel's statement, or worse, fronting a state revenue office audit with incomplete records.

The hard truth: most property managers who "reconcile monthly" are really just printing a trust account report and eyeballing the closing balance. That's not reconciliation—it's hope dressed up as process. Real reconciliation means ticking every transaction against source documents, matching bank feeds to internal ledgers, confirming tenant bonds are correctly held, and ensuring every owner's opening balance plus rent received minus disbursements equals their closing ledger balance. In NSW, VIC, QLD, and WA, trust account regulations demand this level of precision, and a single unexplained variance can trigger a compliance notice or freeze your operating account.

This checklist walks through the nine steps that turn chaos into clean books, whether you manage five properties or five hundred.

Step 1: Reconcile the trust account bank statement

Start with your trust account bank statement for the month just closed. Every state mandates a separate trust account for client funds—this is the account holding tenant bonds, prepaid rent, and landlord disbursements before they're distributed.

Download the bank statement (PDF and CSV if available) and compare the closing balance to your property management software's trust ledger. If they don't match to the cent, stop. You have a discrepancy that needs resolution before you move forward.

Common culprits:

• Bank fees deducted mid-month that weren't recorded in your ledger
• Dishonoured payments (tenant direct debits that bounced) not yet reversed
• Deposits in transit recorded in your software on the 30th but credited by the bank on the 1st
• Duplicate entries where a landlord payment was recorded twice

If your software uses bank feeds (Xero, MYOB, or specialist PM platforms like PropertyMe or Console), confirm every feed transaction has been coded and accepted. Unmatched items sitting in a "For Review" queue are invisible to your reconciliation and will throw your numbers out.

For investors managing their own small portfolios via InvestorJoint's rental cashflow calculator, the same principle applies: your bank balance must match your internal rent roll before you proceed.

Step 2: Verify rent receipts and arrears

Pull a rent roll report showing every property, expected rent, and actual receipts for the month. This is your master list.

For each tenancy:

1. Confirm rent received matches the lease agreement (weekly × 52 ÷ 12, or the agreed monthly amount).
2. Flag part-payments and ensure arrears are correctly tracked. If Tenant A paid $1,800 of a $2,000 monthly obligation, your ledger should show $200 in arrears carried forward to next month.
3. Check payment method codes to distinguish rent (credited to owner) from bond top-ups or utility reimbursements (held separately or passed through).
4. Reconcile vacancy periods where no rent was expected. If a property was vacant from 10 March, your software should show $0 rent for that period—not a missing transaction.

Run an arrears aging report. Anything over 14 days should have a corresponding note (payment plan agreed, tribunal hearing scheduled, or eviction in progress). Silent arrears are a red flag for either tenant default or data-entry error.

If you're holding rent in advance (common in QLD and VIC when tenants pay fortnightly but you disburse monthly), ensure it's correctly allocated to the tenant ledger, not the owner's account. Mixing these up is a trust account breach.

Step 3: Match invoices to disbursements

Every expense paid on behalf of an owner—repairs, rates, insurance, strata levies, management fees—must have a supporting invoice or receipt, and every invoice must tie to a trust account payment.

Open your accounts payable report and cross-check:

• Invoice date, amount, and payee against the trust account payment
• Owner allocation (especially important if you manage multiple properties for the same landlord)
• GST treatment for landlords registered for GST vs. those who aren't
• Duplicate payments where a tradie submitted the same invoice twice or an auto-payment wasn't cancelled

Flag any disbursement over $500 that lacks a scanned invoice. In VIC, the Estate Agents (Professional Conduct) Regulations 2018 require written authority for non-routine expenses; in NSW, the Property and Stock Agents Act 2002 demands contemporaneous records. Missing documentation is an audit liability.

If you use InvestorJoint's depreciation calculator to track capital works vs. repairs for tax purposes, now is the time to code invoices correctly: immediate deduction (repair) or schedule (capital improvement). Your accountant will thank you in July.

Step 4: Reconcile tenant bonds and RTBA/RTA lodgements

Tenant bonds are trust monies, but they're not your trust monies—they belong to the tenant until the lease ends and any claim is settled. Most states require bonds over a threshold (e.g., $10,000 in NSW, all bonds in VIC) to be lodged with a statutory authority within a set timeframe.

Check:

• Every active lease has a bond ledger entry matching the lease agreement
• Lodgement receipts from the Rental Bond Board (NSW), RTBA (VIC), RTA (QLD), or Bond Administrator (WA/SA) are on file
• Bond refunds processed last month have corresponding authority forms (signed by tenant and landlord or tribunal order)
• Interest accrued (in states where bond interest is payable) is correctly allocated

If your software shows a $2,400 bond for 12 Smith Street but the RTBA portal shows $2,000, you have a discrepancy. Either the tenant topped up the bond mid-lease (and you didn't lodge the extra $400), or your ledger is wrong.

Bond mismanagement is the fastest way to lose your licence. Treat this section as non-negotiable.

Step 5: Review owner statements and opening balances

Before you issue owner statements for the month, confirm each landlord's opening balance (what they were owed or owed you on 1 March) matches last month's closing balance. If it doesn't, your prior reconciliation had an error or someone made a manual adjustment without documentation.

For each owner:

• Opening balance (1 March)
• + Rent received (gross, before fees)
• – Management fees
• – Disbursements (repairs, rates, etc.)
• = Closing balance (31 March)

Then compare the closing balance to what's flagged for payment. If you owe the owner $4,200 but your trust account only shows $3,800 in their sub-ledger, you've either misallocated funds or failed to record a receipt.

Some landlords operate via trust or company structures (common for investors with multiple properties). If you're managing a property held by the "Smith Family Trust," ensure disbursements are coded to the trust's ABN, not the individual trustee. Mismatched entity records create havoc at tax time. InvestorJoint's family trust guide covers the accounting nuances.

Step 6: Code and categorise for tax reporting

Property management isn't just about collecting rent—it's about delivering clean data for your owners' tax returns. March is the final month of Q3, and June will arrive faster than you think.

For each transaction this month, confirm:

• Income codes: Rent vs. lease break fees vs. insurance payouts
• Expense codes: Repairs & maintenance vs. capital works vs. loan interest (if you're paying mortgages on behalf of SMSF landlords)
• GST status: Residential rent is input-taxed (no GST), but your management fee, commercial leases, and some disbursements attract GST
• Claimable vs. non-claimable: Body corporate admin fees (claimable) vs. capital levies (not immediately claimable)

If an owner uses InvestorJoint's negative gearing calculator, they'll import this data directly. Mis-coded transactions mean they'll either overpay tax (missing deductions) or face an amendment notice (claiming what they shouldn't).

For properties held in an SMSF, the stakes are higher. SMSF landlords must comply with the Superannuation Industry (Supervision) Regulations 1994, meaning every expense must be solely for the fund's benefit. Personal use or mixed-purpose spending can trigger non-compliance penalties of up to 45%. See InvestorJoint's SMSF property guide for the full framework.

Step 7: Flag and resolve variances

You've matched bank to ledger, rent to roll, invoices to payments, and bonds to lodgements. Now pull a variance report: transactions that don't balance, unexplained adjustments, or accounts with negative balances.

Common variances and fixes:

| Variance | Likely cause | Fix |
|--------------|------------------|---------|
| Owner ledger shows -$300 | Disbursement exceeded available rent | Contact owner for top-up or carry forward (with written authority) |
| Tenant ledger shows $150 credit | Overpayment or misallocated bond refund | Refund tenant or apply to next month's rent (with notice) |
| Trust account $87 short | Bank fee not recorded | Journal entry to record fee, debit owner or PM business |
| Rent recorded twice | Duplicate bank feed + manual entry | Reverse duplicate, note date and user |

Never resolve a variance with a "balancing journal" unless you can trace it to a specific error. "Miscellaneous adjustment to square the books" is a compliance officer's favourite red flag.

Step 8: Generate and review end-of-month reports

With reconciliation complete, run your core month-end reports:

1. Trust account reconciliation statement (bank balance vs. ledger balance)
2. Owner statements (one per landlord, detailing rent, fees, disbursements, net payment)
3. Rent roll summary (total properties, occupancy %, arrears by property)
4. Aged payables (outstanding invoices not yet paid)
5. Bond register (all active bonds, lodgement status, amounts held)

In NSW, agents must reconcile the trust account monthly and retain records for seven years (Property and Stock Agents Regulation 2014, cl. 31). VIC requires monthly reconciliation within five business days of month-end (Estate Agents Regulations, r. 17). QLD and WA have similar mandates.

Print or PDF these reports, file them in a dedicated folder (cloud or physical), and have your principal or trust account auditor review them quarterly. If your trust account is audited annually, the auditor will sample three months—make March, June, and December especially bulletproof.

For self-managing investors, InvestorJoint consolidates rent, expenses, depreciation, and loan interest into a single dashboard, auto-generating the month-end picture without manual reconciliation. Explore pricing here.

Step 9: Lock the period and prepare for next month

Once reconciliation is signed off, lock the accounting period in your software. Period locks prevent backdated entries that would throw April's opening balances out of alignment.

Before you close:

• Disburse owner payments (via EFT by the agreed date, typically 10th–15th of the following month)
• Chase outstanding arrears flagged in Step 2
• Schedule repairs or inspections arising from this month's maintenance requests
• Update rent roll for lease renewals, terminations, or rent increases effective 1 April

If any owner has switched structures mid-year (e.g., transferred the property from personal name to a discretionary trust), confirm the new entity details are live in your system. Payments to the wrong ABN or bank account can't be easily reversed and may constitute a breach of trust obligations.

What this means for your portfolio

End-of-month reconciliation isn't glamorous, but it's the difference between a portfolio that scales smoothly and one that haemorrhages time, money, and compliance risk. Whether you're a licensed property manager juggling 200 tenancies or an investor self-managing three properties, the principle is identical: every dollar must tie to a source, every variance must have a reason, and every record must be audit-ready.

InvestorJoint is built for investors who manage complex ownership structures—Trust, Company, SMSF, or joint—and need entity-first accounting that doesn't require a reconciliation marathon every month. The platform auto-matches bank feeds, splits rent and expenses by ownership percentage, tracks depreciation schedules, and generates tax-ready reports for each entity in your structure. You get the control of self-management with the rigour of a licensed agent's trust account.

If you're closing the books manually in spreadsheets or paying a PM 7–9% to do what software should handle, it's time to rethink your workflow. Start a free trial and see how much faster March can close when your reconciliation runs itself.