Property Management Triple Tie-Out: A Month-End Reconciliation Guide

A property-management triple tie-out compares three balances as of the same cutoff date: the adjusted trust-bank balance, the trust control or journal balance, and the total of the individual owner, property, or tenant subledgers supported by that account. All three should agree. If only the bank account reconciles, the books can still contain a shortage, an overstatement, or money assigned to the wrong owner.

Property managers use three-way reconciliation and triple tie-out for this control. Agreement supports the cash record, but it does not prove that every beneficiary allocation is correct. Equal and opposite errors can survive all three totals. Review the individual ledgers and source transactions as well. State rules and management agreements determine the required records, frequency and permitted account structure.

Work through the numbers

One account. One cutoff. Three matching balances.

Adjusted bank$40,000$42,000 statement
+ $3,000 in transit
− $5,000 outstanding

=

Trust cash record$40,000Same bank account
Same month-end cutoff
Supported entries

=

Beneficiary total$40,000Owner A: $18,000
Owner B: $12,000
Owner C: $10,000

Now check who owns the cash. If $800 is assigned to Owner A instead of Owner B, the combined total stays $40,000. Equal totals do not catch that allocation error.

The bank adjustment follows the approach in California DRE’s reconciliation form; the three-balance comparison is explained by NCREC. Use the records and rules applicable to your account.

Bank reconciliation vs. three-way reconciliation

These checks answer different questions. Keep the supporting documents for each one.

What each review establishes — and what still needs checking

Review	Compare	Still check
Bank reconciliation	Adjusted bank statement against the trust cash record.	Whether that cash record matches all beneficiary balances.
Three-way reconciliation	Adjusted bank, trust cash record and one complete beneficiary total.	Missing support, negative balances and offsetting allocation errors.
Transaction review	Receipts, payments and transfers against their source records and beneficiary assignments.	Approval, ownership and any unresolved exceptions.

Based on the separate bank and beneficiary comparisons in the California DRE Trust Funds guide, chapter 21. This is a bookkeeping-control comparison, not a software ranking.

Using AppFolio? Start with the reports.

AppFolio describes auto bank reconciliation as automated transaction matching. Its accounting page also lists bank account activity reports and export capabilities. Those features support the work; matching alone does not establish that beneficiary allocations are correct. See AppFolio’s accounting features.

1. Set the account and date. Use the same trust account and cutoff across the statement and every report.
2. Gather all three views. AppFolio’s older auditor guide names Bank Reconciliation Report, Bank Account Activity Report and Bank Balance Detail as checkpoints. Confirm today’s report names, filters and access with your administrator or AppFolio support.
3. Trace the exceptions. Compare the supported totals, then investigate individual allocations and outstanding items before treating the period as complete.

AppFolio auditor guide, pages 12–13. This is a report-based workflow, not a current AppFolio screen tutorial. Daxable is independent of AppFolio.

What are the three balances in a property-management triple tie-out?

First is the adjusted bank balance: the ending statement balance adjusted for legitimate deposits in transit, outstanding checks, and other documented timing items. Second is the trust control balance: the cash-book, journal, or general-ledger amount that represents funds held in that trust account. Third is the subledger total: the sum of the individual balances for the owners, properties, residents, or other beneficiaries whose funds make up the account.

The North Carolina Real Estate Commission describes a trial balance as the sum of all ledgers at a common cutoff date and explains that the total should match both the reconciled bank balance and the journal balance. California's Department of Real Estate publishes a trust-fund reconciliation form and guidance for comparing bank, record, and beneficiary-level balances. These are useful examples, but the property manager must follow the rules in the state or states where it is licensed.

Why is a normal bank reconciliation not enough?

A bank reconciliation proves that recorded cash activity can be explained against the bank statement. It does not prove that the control account agrees with the total of every owner or property ledger. A trust bank account can reconcile while one owner is overstated and another is negative by the same amount, or while a receipt is posted to the wrong property. The total cash looks right, but the ownership of the cash is wrong.

Compare the three totals, then inspect the underlying records. A receipt credited to the wrong owner can leave the bank, control ledger and combined subledger total unchanged. The tie-out identifies an aggregate difference when one exists; ownership and completeness also require transaction-level support. It is a control, not an audit opinion.

How do you perform the triple tie-out at month-end?

Use one bank account and cutoff date. Complete the bank reconciliation, supporting deposits in transit, outstanding payments, bank fees and transfers. Run the trust control balance for the same account and date. Then total a complete, non-overlapping set of beneficiary ledgers. Do not add an owner total to the property or tenant balances already included within it. Document which ledger level supports the account.

Illustration only: a $42,000 bank statement plus $3,000 of deposits in transit less $5,000 of outstanding checks gives a $40,000 adjusted balance. A $40,000 trust control balance and $40,000 beneficiary total agree. Moving $800 to the wrong owner's ledger would not change those totals, so inspect allocations even when the comparison is zero.

Compare the three totals and record the differences, even when the net difference is zero. A zero net difference can hide offsetting problems, such as one owner ledger being negative while another is overstated. Review negative balances, stale checks, unapplied receipts, uncleared electronic payments, management fees not yet transferred, security deposits assigned to the wrong property, and manual journal entries that bypassed normal workflows.

Do not force a reconciliation with an unexplained plug. Every adjustment should identify the source document, affected owner or property, approving person, date, and reason. If the source cannot be established, carry it on an exception log and escalate it rather than presenting the month as fully reconciled.

What should the triple tie-out workpaper contain?

A reviewable packet usually includes the bank statement, completed bank reconciliation, list of outstanding items, trust control-ledger detail, owner or property trial balance, comparison of the three totals, exception log, copies of material source documents, approved adjustment entries, and reviewer sign-off. The packet should be dated and retained under the applicable state and company record-retention policy.

Owner statements should be generated from the same closed period after material exceptions are resolved. If statements are released before the tie-out, later corrections can change management fees, distributions, reserves, or property results after the owner has already relied on the report. Closing first and publishing second protects both the bookkeeping trail and the owner relationship.

How do you investigate a triple tie-out that does not balance?

Start with the direction and timing of the difference. Compare the current month with the last proven tie-out, then narrow the search to transactions posted since that date. Match the difference to common amounts such as one rent receipt, one owner distribution, one management-fee transfer, a batch deposit, a returned payment, or a stale check. Search for duplicate transaction IDs, entries dated in different periods, and changes to property or owner assignments.

Inspect negative owner or property balances separately. The North Carolina commission's case study shows how missing ledgers and negative owner statements can obscure a shortage. Trace any apparent advance, unpaid owner obligation or misposting to its documents and involve the responsible broker promptly. Do not assume that an advance authorizes using another owner's funds.

When should a property manager bring in outside bookkeeping support?

Outside support is useful when reconciliations are behind, owner statements repeatedly change after release, staff cannot reproduce the prior month's tie-out, negative owner balances are unexplained, the bank reconciles but the trial balance does not, or growth has made one-person review impractical. The engagement should begin with source records and a defined cutoff, not with a promise to erase differences quickly.

Daxable can scope a property-management bookkeeping engagement that includes monthly three-way reconciliation, exception tracking, owner-statement support, and historical cleanup assessment. Daxable provides bookkeeping and management-use reporting; it does not provide legal advice, tax filing, CPA attestation, or a guarantee that the records satisfy every state rule. The property manager and designated broker remain responsible for confirming jurisdiction-specific duties.

Use the same cutoff and account for all three balances. Equal totals do not rule out offsetting misallocations, missing evidence or improper transactions.

Explore Daxable bookkeeping for property managers