How to reconcile a vacation rental trust account with Claude
Trust-account reconciliation is the single most important compliance task in property management. The Finance & Trust skill runs it the way trust accounting requires: owner funds never co-mingled, every dollar in matched to a dollar out, every property on its own ledger.
Step by step
Load the Finance & Trust skill
In Claude.ai, create a Project, paste the Finance & Trust SKILL.md into the Project instructions and save. Or run
npx github:msg2ai/vacationrental-team-skills installonce and Claude Code picks the right skill from your prompt.Check the daily balance
Pull the trust-account bank balance, sum the per-property owner ledgers, and verify they match.
Run the weekly 3-way reconciliation
Bank balance = sum of property ledgers + held funds (security deposits, future-stay receivables).
Chase every variance over $1
Flag any variance over $1 and investigate and resolve it before close of week, keyed back to the property and reservation in the transaction log.
Verify the OTA payouts
Reconcile each Airbnb / VRBO / Booking.com payout to the channel-manager booking record — dates, nights, ADR, fees withheld, taxes withheld — to catch missing or duplicate payouts, misapplied partial refunds and incorrect host-cancellation fees.
File the reconciliation
With a Knowledge Base connected, the weekly reconciliation saves to 07-finance-trust/reconciliation/{YYYY-WW}.md and feeds the owner payout run.
The prompt to paste
What you get back
- A 3-way reconciliation with variances surfaced and explained
- OTA payout mismatches flagged per channel, with dispute candidates
Tips from the skill
- Owner funds are sacred. No co-mingling, no shortcuts, no rounding.
- Every published number must trace back to the bank or the channel manager.
- Treat the output as a draft — have your bookkeeper or accountant review it.