Vacation rental trust account reconciliation is the monthly proof that the money in a trust bank account equals the money the brokerage's records say it holds for owners, guests, and other beneficiaries. The practical checklist is simple to state: use one cutoff date, reconcile the bank to the trust cash record, reconcile that cash record to the beneficiary or owner ledgers, investigate every difference, and retain evidence of the review. For vacation rentals, add a tie-out from reservation or tenant subledgers when those details roll into a property or owner ledger.
The hard part is not the arithmetic. It is proving that every dollar is assigned to the right party and that no owner deficit is being covered by another owner's funds. This checklist is a narrow companion to our broader guide to multi-market trust accounting automation, not a replacement for state-specific procedures.
Requirements vary by state, license type, account purpose, and contract. This article is educational and is not legal, tax, or accounting advice. Have the broker-in-charge, controller, CPA, and qualified counsel confirm the controls for each market.
What must a trust account reconciliation prove?
A complete reconciliation should prove three things as of the same date:
- Bank to books: the adjusted bank balance agrees with the trust cash record, journal, or check register after valid outstanding checks, deposits in transit, and bank items are considered.
- Books to liabilities: the trust cash record agrees with the sum of the separate balances owed to beneficiaries, properties, owners, or transactions.
- Detail to owner: the reservation, tenant, tax, deposit, and other subsidiary detail rolls into the correct property or owner balance without unexplained gaps.
California's Department of Real Estate describes two end-of-month comparisons: the bank account record to the bank statement, and the bank account record to the separate beneficiary or transaction records. Its Trust Funds guide identifies the beneficiary-record comparison as a monthly regulatory requirement and describes the bank-statement comparison as essential accounting practice, even though the guide says that comparison is not required by the Real Estate Law or Commissioner's Regulations. The cash-record balance should equal the total of the beneficiary balances, and a record of the required reconciliation must be maintained. The DRE also publishes sample audit record forms, including a bank-account record, separate beneficiary records, and a separate record for each managed property.
North Carolina's Real Estate Commission explains the same control as a bank-to-books-to-property-trial-balance reconciliation. Its vacation-rental guidance adds a fourth step: reconcile subsidiary ledgers to the property or owner ledgers. The NCREC's monthly reconciliation bulletin also emphasizes that the broker-in-charge retains fiduciary responsibility even when bookkeeping is delegated.
These are useful control models, not a universal statement of every state's law.
Which records should be frozen before the work begins?
Do not start with three reports run at three different times. Establish a cutoff, close posting through that point, and preserve the source package used for the reconciliation.
Collect at least:
- the full bank statement and bank activity through the cutoff;
- the trust cash record, journal, or check register for the same account;
- the complete beneficiary, property, or owner ledger trial balance;
- reservation, tenant, security-deposit, tax, or other subsidiary ledgers that feed those balances;
- the prior month's signed reconciliation and outstanding-item schedules;
- deposit records, processor settlements, and transfer confirmations;
- canceled-check images, ACH detail, invoices, approvals, and payout support;
- a list of manual journal entries, voids, reversals, and reopened periods;
- the account agreement, management-fee terms, and approved reserve rules.
Use a unique close-package identifier and record when each report was generated. If a report is rerun after a correction, retain both the original and revised version with the reason for the change. Silent replacement destroys the review trail.
What is the monthly reconciliation checklist?
Run the steps in an order that narrows the search area instead of moving numbers until they agree.
1. Confirm the account and cutoff
Verify the legal entity, bank-account identifier, currency, statement ending date, and accounting cutoff. Confirm that the opening book balance agrees with the prior signed close. A difference at opening belongs to the prior period or to a documented post-close correction; do not bury it in current activity.
2. Post all activity through the cutoff
Make sure deposits, checks, electronic payments, bank charges, returned items, refunds, reversals, and internal transfers are recorded. California DRE guidance recommends recording transactions daily and using consistent source documents. Missing activity should be added through an approved correcting entry that preserves the original transaction date and review history.
3. Reconcile the bank statement to the trust cash record
Start with the statement balance and identify legitimate deposits in transit and outstanding disbursements. Then inspect every bank transaction that has no book match and every book transaction that has no bank match. Do not carry a plug called "timing difference" without a transaction-level schedule.
4. Test old and unusual reconciling items
Review stale checks, deposits that did not clear promptly, rejected ACH payments, duplicate processor settlements, chargebacks, and unexplained bank adjustments. Confirm whether each item remains valid, requires reissue, needs escheat or unclaimed-property analysis, or indicates an error. Those decisions are jurisdiction-specific.
5. Total the beneficiary or owner ledgers
Produce a trial balance listing every beneficiary, property, owner, transaction, and authorized company-funds ledger associated with the account. The total should equal the trust cash-record balance. California DRE guidance states that aggregate trust liability is based on the total positive balances owed; a negative beneficiary balance should not be used to reduce the liability owed to others.
6. Tie vacation-rental detail to the owner balance
Confirm that guest receipts, taxes, security deposits, damage holds, fees, refunds, and property expenses land in the correct subsidiary ledger and roll up to the correct owner. This is where a bank reconciliation that appears perfect can still fail: the total cash is right, but its ownership is wrong.
7. Resolve differences without cross-owner netting
Classify each exception as timing, missing entry, duplicate, wrong amount, wrong owner, wrong account, unsupported payment, bank error, or system-mapping failure. Assign an owner and due date. Never clear one owner's deficit with another owner's positive balance merely to force the total to agree.
8. Sign, lock, and retain the evidence
The preparer should certify the source package and explain every open item. A separate reviewer should inspect high-risk entries, negative balances, stale items, and material manual corrections before approval. Lock the period according to company policy and retain the signed reconciliation with its supporting schedules.
What does a clean reconciliation look like in practice?
Hypothetical example: for illustration only: A property manager's statement shows $120,000. The trust cash record shows $119,400 because a $600 guest refund cleared the bank on the last day but was not posted. Separately, the owner-ledger trial balance totals $119,400, yet one $350 cleaning invoice is assigned to Owner B instead of Owner A.
Posting the missing refund makes the cash record agree with the bank. That fixes bank-to-books, but it does not fix ownership. Reclassifying the cleaning invoice between the two owner ledgers corrects books-to-liabilities without changing total cash. The final evidence package should show both corrections, their source documents, who approved them, and when they were posted.
That example is why the checklist has layers. A single green check beside the bank balance is not enough.
Which exceptions should block signoff?
Some items require escalation rather than a routine carryforward:
| Exception | Why it matters | Minimum next action |
|---|---|---|
| Negative owner or beneficiary balance | May indicate deficit spending or an unsupported allocation | Stop related payouts; trace transactions and funding authority |
| Unexplained bank overage | Ownership is unknown and the money cannot be treated as company income | Preserve the funds and create a dedicated exception record |
| Missing property or owner ledger | The firm cannot prove whose money it holds | Reconstruct from source records and obtain qualified review |
| Unsupported disbursement | The payment lacks invoice, contract authority, or beneficiary mapping | Suspend or recover the payment and investigate access controls |
| Old outstanding item | The liability may be stale, void, reissued, or subject to another legal process | Confirm payee status and apply the relevant state procedure |
| Prior-period edit after signoff | The approved close no longer matches the books | Reopen formally or document a controlled subsequent-period correction |
The NCREC's trust-account software guidance is a useful reminder that choosing software does not remove the brokerage's duty to understand it. The Commission points brokers toward outputs such as journals, deposit worksheets, disbursement worksheets, ledgers, and monthly reconciliations.
How should property managers and franchisors divide responsibility?
For a property manager, the named accountable role should own the bank account, access list, close calendar, reviewer assignment, and exception escalation. Accounting may prepare the work, but operations must supply invoices and job approvals, revenue teams must explain reservation changes, and market leaders must resolve owner-specific questions.
For a franchisor, standardize the control objective, required reports, naming convention, evidence retention, and escalation levels. Then keep each franchise entity's reconciliation separate. A consolidated dashboard may show whether every location closed on time, whether exceptions remain open, and whether reviewer evidence exists. It should not net one franchisee's shortage against another franchisee's overage or imply that a central report replaces local broker responsibility.
How can automation support the checklist without weakening control?
Automation is useful when it preserves transaction lineage. It can import bank activity, match known items, sum owner ledgers, identify negative balances, detect edits after cutoff, and assemble a close package. It becomes risky when it auto-clears differences, groups unrelated owners, or allows the person who creates a correcting entry to approve it.
VR Goals can make the control visible across markets: assign the monthly business goal, collect evidence from the accounting stack, route exceptions to the responsible team, and show franchisors which entities are complete or blocked. Bank Reconciliation and Full Accounting Suite workflows keep the review status visible, but VR Goals does not decide what the law requires or replace the licensed broker, controller, CPA, or counsel. The underlying bank, trust journal, and beneficiary ledgers remain the accounting records.
If the checklist reveals that reconciliation work is consuming the entire reporting cycle, use it alongside the month-end close workflow to separate data assembly from accountable review.
Ready to make every market's reconciliation status visible without flattening local responsibility? Request access →
