Blog

Trust account three-way reconciliation: the monthly routine, step by step

Zrico team ·
In short

A three-way reconciliation proves that the adjusted bank balance, the trust cash balance in your books and the total you hold for each owner and tenant are the same number. Run it monthly for every trust bank account, then check that no property is below zero, because a total that ties can still hide one owner's shortfall.

Most property managers know what a three-way reconciliation is. Fewer have a routine that finds the difference fast when the three numbers don't agree. This guide is that routine: which reports to pull, the order to work in, what each kind of difference usually means, and what a reviewer should sign. It goes deeper than the summary in our month-end close checklist and assumes you run one reconciliation for each trust bank account.

What are the three numbers?

  • The adjusted bank balance: the bank statement ending balance, plus deposits in transit, less outstanding checks and payments, plus or minus any bank errors.
  • The book balance: the balance of the trust cash account in your general ledger on the same date.
  • The client total: the sum of everything you hold for other people in that account, usually owner cash by property, tenant security deposits held there, and prepaid rent and tenant credits.

Each pair tests something different. Bank against books tests your recording. Books against the client total tests your allocation, meaning whether every dollar in the account is assigned to the right owner or tenant. You need both tests, which is why two numbers agreeing is not a pass.

Before you start: pull five reports as of the same date

  1. The bank statement for the month, with its ending balance and a list of cleared items.
  2. Your bank reconciliation report for the account, showing deposits in transit and outstanding items.
  3. The trial balance or general ledger balance for the trust cash account.
  4. An owner balance report that lists cash held for each property tied to that bank account.
  5. The security deposit liability and prepaid rent reports, filtered to the same properties.

Every report must use the same cutoff date and the same set of properties. A surprising share of failed reconciliations are not errors at all: one report was run as of the 30th and another as of the 31st, or one included a property that banks somewhere else.

Step 1: Reconcile the bank to the books

Match every cleared bank item to an entry in the books. What is left falls into four groups:

  • Deposits in transit: money recorded and deposited, not yet on the statement. These should clear in a few business days. A deposit in transit older than about five business days usually means it was never actually deposited, or was deposited to a different account.
  • Outstanding checks and payments: recorded and sent, not yet cleared. Anything older than 60 to 90 days needs a call. It is usually a lost check, a voided check that was never recorded as void, or a vendor who was paid twice.
  • Bank items not in the books: fees, interest, returned payments and chargebacks. Record them now, against the right property or your company's own books.
  • Book items not at the bank: duplicate entries, entries posted to the wrong bank account, or a payment recorded but never sent.

When the adjusted bank balance equals the book balance, leg one is done. Do not move on while this leg is off. A difference here will show up again in leg two and be much harder to find.

Step 2: Build the client total

Add up what you hold for others in this account. Most companies need three lines, some need more:

  • Owner cash for each property that banks in this account
  • Security deposits held in this account
  • Prepaid rent and tenant credits
  • Any other money that belongs to someone else, such as an application fee you hold until a decision

If your management company's own earned fees are still sitting in the trust account because the month's fee transfer hasn't run, list them as a separate line called company funds in trust. That line should be small, known and moved out on a schedule. How much, if any, of a manager's own money may sit in a trust account varies by state, so confirm your own rules with your accountant or counsel. This is not legal advice.

Step 3: Compare the books with the client total

If the trust cash balance in the books equals the client total, leg two ties. If not, the difference almost always comes from an entry that touched trust cash without being assigned to a property, or an entry assigned to a property in this account but posted against a different bank account. Run the general ledger for the trust cash account, filter to entries with no property, and you will usually find it in minutes.

Step 4: Look for properties below zero

This is the step most often skipped. The client total is a sum, and a sum can tie while one property is negative. A property at minus $1,460.00 means $1,460.00 of another owner's money paid that property's bills. The account balances, and the reconciliation looks clean, but you have used one client's funds for another. List every property with a negative balance on the reconciliation, with the amount and the plan to fix it.

A worked example

Here is one month for an example trust account that holds funds for six properties, including Hudson Lofts and Maple Court. The numbers are made up but realistic.

  • Bank statement ending balance: $312,480.55
  • Plus deposits in transit: $6,215.00
  • Less outstanding checks: $9,742.30
  • Adjusted bank balance: $308,953.25
  • Trust cash in the books, before fixes: $309,038.25

Leg one is off by $85.00, with the bank lower than the books. Matching the statement shows an $85.00 account service fee the bank charged that nobody recorded. The fee is recorded against the management company, which reimburses the trust account the same day, per this company's policy. After that entry, the books show $308,953.25 and leg one ties.

  • Owner cash by property: $241,118.25
  • Security deposits held: $59,700.00
  • Prepaid rent and tenant credits: $8,135.00
  • Client total: $308,953.25

All three numbers now equal $308,953.25. But the owner cash report shows Maple Court at minus $1,460.00, after a $3,900.00 boiler repair landed before rent came in. The other five properties are holding $242,578.25 between them, and $1,460.00 of it is covering Maple Court. The reconciliation is signed with a note: owner contribution requested on the 2nd, received on the 5th, balance restored. Without step 4, this account would have passed with a hidden problem.

How do you find a difference quickly?

Work in this order, because it goes from the most common cause to the least:

  1. Dates: are all five reports run as of the same day, for the same properties?
  2. Timing: are there deposits in transit or outstanding items you haven't listed?
  3. Exact amounts: search the ledger for the exact difference, and for half of it. A difference that equals one entry is usually a missing or duplicate entry. A difference that equals twice an entry is usually an entry posted with the wrong sign.
  4. Divisible by 9: a difference evenly divisible by 9, such as $90.00 or $540.00, often means two digits were transposed, for example $1,560.00 keyed as $1,650.00.
  5. Unassigned entries: entries to trust cash with no property, or with a property that banks elsewhere.
  6. Journal entries: manual entries made this month, which skip the checks that bills and receipts go through.

What should the signed reconciliation include?

Treat each reconciliation as a small file someone could audit a year from now without asking you questions:

  • The bank statement and the bank reconciliation report
  • The book balance and the client total, with the reports behind them
  • Every reconciling item with its date, amount and age
  • The list of properties below zero, with the fix and the date it was resolved
  • Who prepared it, who reviewed it and the dates of each

The reviewer should be someone other than the preparer whenever your team is big enough. A good target is to finish each reconciliation within 10 business days of month-end, and before owner distributions go out.

Red flags worth escalating

  • The same reconciling item carried for three months or more
  • Recurring small differences that get written off instead of explained
  • A property that is negative at every month-end
  • Deposits in transit that never seem to clear
  • Manual journal entries to trust cash without a written reason
  • Security deposits on the books that don't match the deposit liability report

The monthly checklist

  1. Pull the five reports as of the same date and for the same properties.
  2. Reconcile the bank to the books; record bank fees, interest and returns.
  3. Build the client total, including any company funds in trust as a separate line.
  4. Compare the books with the client total and fix unassigned entries.
  5. List every property below zero with its fix.
  6. Attach the reports, sign as preparer, get a second signature as reviewer.
  7. Only then release owner distributions.

How Zrico helps

Zrico tracks owners' cash and tenants' deposits by property inside each trust bank account, and keeps the management company's own books apart. Its three-way reconciliation shows whether the bank's reconciled balance, the books and the money held for each property agree, and lists any difference line by line. Properties short of cash are flagged before month-end, and a payment that would take a property below zero asks staff to confirm, or is refused if you set it that way. Read more at /product/accounting and /answers/does-zrico-do-trust-accounting.

See Zrico run your portfolio.

Bring a property. We will show you, on your own data, what Zrico would have handled last month.