Three-Way Reconciliation for Vacation Rental Trust Accounts, Step by Step

A three-way reconciliation proves that three numbers agree at the same cutoff date: the trust bank balance (adjusted for timing items), the balance in your trust ledger, and the total of every individual owner and guest ledger. If all three match to the penny, the money you hold for other people is all there and correctly assigned. If they do not, something is missing or sitting against the wrong person. Do it monthly, keep the worksheet, and investigate every difference before it ages. This guide covers the steps, a worked example, and the most common reasons vacation rental accounts fail to match.

What the three balances are

Rentvine's guide to three-way reconciliation defines the three records clearly:

• Trust bank statement: the balance reported by the bank.
• Firm trust ledger: your internal master record of all trust activity (the cash account in your books).
• Individual client ledgers: balances for each owner, property or guest, which together must equal the firm trust ledger.

The North Carolina Real Estate Commission's bulletin on reconciling trust accounts monthly calls that third list the Property Trial Balance: a list of every property or owner ledger and its month-end balance, so that every dollar in the trust account can be identified by whose money it is.

A two-way reconciliation (bank to books) only proves your cash account is right. It does not prove the money is assigned to the right owners. That is why regulators ask for the third leg.

Who is responsible

Rules differ by state, so check with your state's real estate commission for the exact requirements where you operate. The NCREC bulletin makes one point that applies almost everywhere: the broker in charge is responsible for safeguarding trust money. The reconciliation and bookkeeping can be delegated, but the fiduciary responsibility stays with the broker in charge.

In North Carolina, the same bulletin notes that a reconciliation must be kept on file under Commission Rule A.0117(e), and it suggests, as a best practice rather than a requirement, completing the three-way reconciliation within 48 hours of receiving the bank statement.

The steps

Step 1: Pick one cutoff date and gather the records

Use the bank statement ending date, ideally the last day of the month, as the cutoff for everything. Pull the bank statement, the trust ledger (cash account) report and the owner and guest ledger balances, all at that same date. Rentvine stresses that matching dates across the three sets of records is critical.

Step 2: Reconcile the bank to the books

Tick every item that appears on both the bank statement and your books. The unticked items are your reconciling items. NCREC gives the formula:

Ending bank balance + deposits in transit - outstanding checks = your book balance.

Post bank charges and interest to your books where they belong, and adjust for any bank errors. If the adjusted bank balance does not equal the trust ledger, stop and find out why before going further. Rentvine warns that an unexplained difference at this stage will cascade into the client ledgers.

Step 3: Total the owner and guest ledgers

List every owner ledger and every guest ledger with its month-end balance. For vacation rentals this usually means two groups:

• Owner funds: rent collected for each owner, less expenses and payouts, plus any reserve you hold for them.
• Guest funds: advance payments and deposits for future stays, which belong to guests until the stay happens.

Check for negative balances. A negative owner ledger means you have paid out someone else's money on that owner's behalf. Rentvine recommends flagging overdrawn ledgers, stale outstanding checks and unallocated deposits every month.

Step 4: Compare all three

Adjusted bank balance, trust ledger and the total of the individual ledgers must match exactly. Rentvine notes that, under industry guidance, even a $1 variance leaves a trust account out of compliance.

NCREC adds a point specific to vacation rentals: property managers handling vacation rentals have a fourth step, reconciling the subsidiary ledgers to the property or owner ledgers. In practice that means making sure guest advance payments sit against the right future stays, and that they move to the owner's ledger when the stay happens.

Step 5: Document it

Keep a monthly package: the bank statement, the reconciliation worksheet showing all three balances, support for every adjustment, and a sign-off. NCREC asks for a worksheet showing the balancing of the bank statement, the books and the Property Trial Balance.

Step 6: Fix the cause

Correct differences straight away and write down what caused them. Rentvine's guidance includes two controls worth copying: bank fees are never paid from a trust account (they belong in the operating account), and posting, reconciling and approving should be done by different people where possible.

Worked example (illustrative numbers)

Example only. The figures are invented to show the method.

A manager's trust account at 31 May:

Bank to books

Owner and guest ledgers

All three agree at $178,000.00. The account reconciles.

Now a common break. In June, the bank takes a $25 monthly service fee from the trust account. Nobody posts it. At 30 June the adjusted bank balance is $25 lower than the trust ledger, and the ledgers are $25 higher than the cash that exists. The fix is to post the fee, have the operating account reimburse the trust account, and move the bank fee to the operating account going forward. Small, but it is exactly the kind of item that turns into a finding if it repeats for years.

The most common breaks

• Deposits in transit that never arrive. A deposit recorded on the 30th should clear in days. One still open next month needs chasing.
• Stale outstanding checks. An owner check that never cleared is still that owner's money.
• Guest payments left in guest ledgers after checkout. The stay happened, but the money never moved to the owner's ledger.
• Operating costs paid from trust. Bank fees, software subscriptions or management fees taken before they were earned.
• One bank account for everything. Guest deposits and operating revenue in a single account. This is the hardest one to unwind.

What happens when it has not been done for years

NCREC notes that if reconciliations have not been done in the past, the first one could be a long process. One of our case studies shows how long.

One client, a 7-year-old vacation rental management company, had guest deposits (escrow) and operating revenue in a single bank account for 3 to 4 years. We carried out a 48-month forensic reconciliation, categorizing every bank transaction, and established the correct escrow liability at $87,000. The actual escrow balance was $34,000, a $53,000 shortfall. The shortfall was corrected, a two-account structure (escrow plus operating) was set up, and a full audit trail package was prepared for regulators. The company passed its state audit with zero findings, avoiding an estimated $50,000 to $150,000 in fines. Read the escrow compliance case study.

If your trust or escrow account has not been reconciled in months, or ever, a rebuild like this is part of our cleanup and catch-up service.

A monthly checklist

• One cutoff date for bank, books and ledgers.
• Bank to books reconciled, reconciling items listed.
• Owner and guest ledgers totalled, no negative balances.
• All three balances equal.
• Guest payments moved to owners after each stay.
• No operating costs in the trust account.
• Worksheet saved and signed off.

Your broker in charge remains responsible for the trust account, and your state's rules decide the details. If the account needs rebuilding before you can reconcile it monthly, our cleanup team can reconstruct the history and hand you a documented starting balance. Book a 15-minute call to talk it through.