A three-way reconciliation compares three figures that should all agree: the adjusted bank balance of the trust account, the trust ledger balance in your books, and the total of the individual owner and tenant balances held within it.

Most explanations stop there. The useful part is what you do when they disagree, which is the situation you will actually be in.

This walks through one, with a deliberate break and the order to find it.

The Three Balances

Each answers a different question, which is why all three are needed.

The first two are the familiar components of a bank reconciliation. The third leg adds the trust account allocation check, because bank and ledger can agree perfectly while the money inside is attributed to the wrong people.

A trust account that balances to the bank but not to its sub-ledgers is holding the right amount of money without a reliable record of how that money is allocated.

A Worked Example

Illustrative figures for a single trust account at 31 March.

Step one: adjust the bank.

Step two: compare to the trust ledger.

Agrees. Two legs down.

Step three: sum the sub-ledgers. This example assumes tenant deposits are held in the same trust account; where they sit in a separate account, they reconcile separately.

Step four: compare.

Bank and ledger agree. Ledger and sub-ledgers do not, by $600. The reconciliation has failed. The difference needs to be resolved before relying on these balances for statements or distributions.

Finding the $600

The order matters, because each step eliminates a category and narrows what is left.

1. Confirm the direction. The ledger is higher than the sub-ledgers. That means the trust account holds $600 more than the sum of what you have attributed to individual owners and tenants. Money is present in the trust ledger but has not been allocated to an owner or tenant balance. Had it been the other way around, you would be looking at a situation where the sub-ledgers show more money allocated than the trust ledger holds, which requires investigation.

2. Look for unapplied receipts. This is the first place to check when the ledger exceeds the sub-ledgers. A receipt posted to the trust control account but never applied to a specific tenant or owner sits in the ledger and not in any sub-ledger. Run the receipt activity for the period and compare the amounts and transactions against their owner or tenant allocations.

3. Check the amount for a single-transaction match. A round $600 difference makes a single $600 transaction worth checking before assuming the difference comes from several smaller errors.

4. Match against the period's activity. In this case, a rent payment of $600 arrived on 28 March by bank transfer, with a reference that did not identify the tenant. It was deposited, so it hit the bank and the control account, and it was left unapplied pending identification. Nobody came back to it.

5. Resolve and re-run. Identify the tenant, apply the receipt to the correct sub-ledger, and run all three comparisons again. The sub-ledger total becomes $48,962.00 and the reconciliation balances.

6. Record what happened. The cause, the correction, the date, and who did it. A reconciliation that balanced after an unexplained adjustment is worth very little to whoever reviews it later.

Note what you did not do: post a balancing entry to make the numbers agree. An adjustment made to force a reconciliation removes the only signal that something was wrong, and leaves the trust account holding money attributed to nobody.

Five Common Causes of Reconciliation Breaks

Most breaks trace to one of these.

• Unapplied receipts. Money received and banked but not allocated to the correct owner or tenant balance. This is one of the first areas to check when the trust ledger exceeds the sub-ledger total.

• Disbursements posted to the wrong sub-ledger. A vendor payment for Owner B's property charged to Owner C. The total is right, so bank and ledger agree, and the sub-ledgers are individually wrong in offsetting directions. This one hides from the total and only appears when someone queries their balance.

• Timing differences recorded inconsistently. A payment recorded in the sub-ledger on the date instructed but hitting the bank two days later, at a period boundary. Legitimate, but only if it is identified as a reconciling item rather than left as an unexplained difference.

• Fees or bank charges. A bank charge, returned-payment fee or other deduction can reduce the bank balance without a corresponding entry in the books. The appropriate treatment depends on the account structure, the management agreement and applicable law.

• Manual adjustments to balances. Someone corrects a sub-ledger balance directly instead of posting a transaction. The figure looks right and the audit trail is gone. This is the one that turns a reconciliation difference into a records problem, and it is the same failure that undermines an owner ledger.

Reconciling Items Versus Breaks

Worth separating, because they are treated differently.

• A reconciling item is a known, documented timing difference. An outstanding cheque, a deposit in transit, a payment instructed but not cleared. It explains a difference between the bank and the books, it is listed on the reconciliation, and it clears in the following period.

• A break is a difference with no identified cause. It is not a reconciling item until you know what it is.

Two disciplines that keep the distinction honest. Age your reconciling items: an outstanding cheque from four months ago should no longer be treated as a routine timing difference without investigation. And never list a difference as a reconciling item without naming the transaction behind it, because "timing" used as a category rather than an explanation is where small unresolved breaks accumulate.

When It Will Not Balance

Sometimes a reconciliation does not resolve on the day. What matters then is what you do next.

• Do not release statements or distributions from an unreconciled position. The owner statements produced from these balances inherit whatever is wrong, and a distribution paid on an unreconciled balance can move one person's money to another.

• Quantify and isolate. Record the difference, the direction, and what you have eliminated. A documented $600 break under investigation is a very different position from a reconciliation that was never completed.

• Escalate on a threshold and a timeline. Both should be set in advance rather than judged case by case. A small difference resolved promptly is different from the same unexplained difference remaining open across multiple reconciliation periods. The longer a break stays unresolved, the more important escalation becomes.

• Fix the cause, not the instance. A receipt unapplied because a payment reference was unclear will happen again. The durable fix is at intake, not at reconciliation.

Frequency and Evidence

Trust account reconciliation requirements vary by state and licence type, including frequency, record retention, review and the handling of trust funds. In many jurisdictions, monthly reconciliation is required, but the applicable rule should be confirmed for the relevant state and licence.

What is worth retaining regardless of the local rule:

• The bank statement for the period

• The reconciliation itself, showing all three balances and the comparison

• The list of reconciling items with the transaction behind each

• The sub-ledger listing that sums to the total

• Any break, its cause and its correction

• Who prepared it and who reviewed it, with dates

A practical test is whether you can produce a current, complete reconciliation when it is requested. A trust account that cannot be reconciled on a given date creates an unresolved control issue regardless of how well the properties are managed, and it is the first thing examined in a trust account review.

Separation of Duties

One structural point, because it prevents more problems than any procedure.

Ideally, the person who reconciles should be separate from the person who posts receipts and disbursements. Where the team is too small for full separation, a documented review by someone other than the preparer provides an additional control.

This is not about suspicion. Reconciliation is a check on the accuracy of the posting, and someone checking their own work will read the ledger as they intended it rather than as it is.

Frequently Asked Questions

1. What is a three-way reconciliation in property management?
A comparison of three balances that should agree: the adjusted bank balance of the trust account, the trust ledger balance in the accounting records, and the total of all individual owner and tenant sub-ledger balances held within that account. The first two are the components of a bank reconciliation. The third leg confirms the funds are correctly allocated.

2. What does it mean if the bank and ledger agree but the sub-ledgers do not?
That the trust account holds the right total but the money is not correctly allocated. Where the ledger exceeds the sub-ledgers, funds are typically unapplied, meaning received and banked but not attributed to an owner or tenant. Where the sub-ledgers exceed the ledger, more has been allocated than is held, which needs immediate investigation.

3. How often should a trust account be reconciled?
Requirements vary by state and licence type, along with rules on record retention and who prepares and reviews. Monthly reconciliation is required in many jurisdictions, but the applicable requirement should be confirmed locally rather than assumed.

4. What is the difference between a reconciling item and a break?
A reconciling item is a documented timing difference with an identified transaction behind it, such as an outstanding cheque or a deposit in transit, which clears in the following period. A break is a difference with no identified cause. A difference does not become a reconciling item until the transaction causing it has been named.

5. Can you post an adjustment to make a trust reconciliation balance?
Forcing a reconciliation to agree with a balancing entry removes the signal that something is wrong and leaves funds attributed to nobody. The difference should be investigated and corrected at its source, with the cause, the correction and the date recorded.

6. Who should perform the trust reconciliation?
Ideally someone separate from the person posting receipts and disbursements, so the reconciliation acts as an independent check. Where the team is too small for that separation, a documented review by a second person provides an additional control.

The Reconciliation Is the Control

A three-way reconciliation is not a monthly administrative task that produces a document. It is the control that proves the money you hold is the money you say you hold, allocated to the people it belongs to.

Everything downstream depends on it. Owner statements, distributions, deposit dispositions and year-end reporting all assume the balances are right. When the reconciliation is skipped or forced, none of those assumptions holds, and the failure surfaces at the worst possible moment: during an examination, or when someone asks for money that is not there.

RIOO is built directly on NetSuite, so property accounting sits within the same underlying system. For property teams working through reconciliations, this provides a common accounting foundation for the records being reviewed. 

Note: Figures in this article are examples only. Trust account reconciliation frequency, record retention, review requirements and the handling of fees and interest vary by state and by licence type, and the applicable rules should be confirmed for the relevant jurisdiction.