What three-way reconciliation is
Each month, three numbers have to agree:
- Your bank. The trust bank balance on the statement, plus deposits that haven’t arrived yet, minus payouts that haven’t cleared.
- Your books. The trust cash balance in your accounting.
- What you hold. The total of every owner’s and guest’s balance, plus any of your own money sitting in the account.
When all three match, the month reconciles and can be signed off. When they don’t, the difference tells you where to look.
The reconciliation is one monthly check inside trust accounting as a whole. For the bigger picture, read our guide to vacation rental trust accounting.
Why it matters
Money you hold for owners and guests isn’t yours. A three-way reconciliation is how you show it is all there, kept apart from your own money, and owed to the right people. It is also the record your accountant, broker or an auditor may ask to see.
Trust rules come from your state and your license. VacayOps gives you and your accountant or broker the records, checks and signed reconciliations to work from; meeting those rules and making your filings stay with you.
A worked example
The bank statement shows $48,200.00. A guest payment of $1,350.00 was recorded on the last day of the month but lands in the bank next month, and owner payouts of $3,050.00 haven’t cleared yet. Adjusted bank balance: $48,200 + $1,350 − $3,050 = $46,500.00.
The books show trust cash of $46,500.00. Owner and guest balances add up to $44,900.00, and $1,600.00 of the company’s own money is in the account: $46,500.00. All three agree.
Trust reconciliation · September
Balanced · signed1 · Bank
$46,500.00
- Statement
- $48,200.00
- + In transit
- $1,350.00
- − Not yet cleared
- $3,050.00
2 · Books
$46,500.00
Trust cash in your books
3 · What you hold
$46,500.00
- Held for owners, guests & tax
- $44,900.00
- + Your own money
- $1,600.00
Example figures. Signing freezes the month; the PDF carries the worksheet, the schedules by property and by owner, and the sign-off lines.
Deposits in transit and payouts not yet cleared
The bank and your books record the same money on different days. A deposit in transit is money your books already count — a guest payment, a processor payout — that the bank shows after the statement date. A payout not yet cleared is an owner payment or check you have sent and recorded that the bank hasn’t paid out yet. Adjusting for both turns the bank statement into the number your books should match. Items that are still open a month later are worth chasing.
Common reasons it doesn’t balance
- A deposit hasn’t reached the bank yet
- Add it as a deposit in transit, and check it clears next month.
- An owner payout hasn’t cleared
- Subtract it as a payout not yet cleared; chase it if it is still open next month.
- Bank fees or interest aren’t in the books
- Record them, and decide whose money they touch.
- Money with no owner attached
- A payment for a property with no owner set. Assign it before you sign.
- An owner balance below zero
- You paid an owner more than you held for them — other owners’ money is covering the gap.
- A statement not issued yet
- The owner’s balance isn’t final until the month’s statement is issued.
- Fees taken before they were earned
- Moving your fee to operating before the owner’s statement is issued can leave trust short.
- A typo or a duplicate entry
- An entry recorded twice, or for the wrong amount, shows up as a difference.
Month-end checklist
- Download the month’s trust bank statement.
- List deposits recorded in the books that the bank hasn’t shown yet (in transit).
- List owner payouts and checks the bank hasn’t cleared yet.
- Work out the adjusted bank balance: statement + in transit − not yet cleared.
- Take the trust cash balance from your books.
- Add up what you hold for every owner and guest, plus any of your own money in the account.
- Compare the three. If they don’t agree, find each difference before you sign — or write down why.
- Sign and date it, have your accountant review it, and keep it with the bank statement.
Free worksheet template
A CSV you can open in Excel, Google Sheets or Numbers — no sign-up. One row per month: bank statement balance, deposits in transit, payouts not yet cleared, adjusted bank balance, trust cash per books, owner and guest balances, company funds in trust, the differences, who prepared it, who signed it off and the date. The first row is the example above.
Download the worksheet (CSV)Doing it in VacayOps
If your reservations run on VacayOps, trust accounting is part of the Full Platform. Guest payments are recorded into trust automatically, issued owner statements build each owner’s balance, and the Trust screen lays out the three numbers each month — with schedules by owner and by property, plain-language checks for money without an owner or a balance below zero, sign-off that freezes the month, and a PDF for your accountant. VacayOps records and reconciles the money in your own bank and processor accounts. It never holds or moves funds.