Home / Templates / Owner Statement Helper

Templates

Owner Statement Helper

The monthly owner statement is not a dashboard, it is an auditable document where every dollar ties out. Owner Statement Helper reconciles your PMS, the OTA payouts, the bank deposits, and your QuickBooks expenses into one statement per owner, drafts the plain-English cover note, and refuses to let you send until it balances to the cent.

Hire this Sidekick

How to use this template

  1. Hire the template in your Sidekicks dashboard
  2. Connect your PMS, OTA payouts, Stripe, QuickBooks, and your trust account
  3. Map each property to its QuickBooks class once
  4. Go live in draft, nothing sends to an owner without you

What this does

  • Three-way reconciles every reservation, PMS recognized against OTA reported against the bank deposit, and flags any gap over a dollar
  • Recognizes revenue on checkout, not booking, and traces a late Airbnb credit back to the stay it belongs to
  • Computes gross to net per reservation, minus commission, cleaning, expenses, taxes, and reserves, down to the owner distribution
  • Builds the line-item PDF and drafts a calm two-to-four sentence cover note that opens with the number and the pay date
  • Keeps the send button locked until the statement ties, and tells you exactly what is off when it does not

Saves

  • The two-day month-end close across spreadsheets, payout files, and QuickBooks, run for every property at once
  • The owner trust you lose when a statement does not add up, because this one cannot be sent until it does

Workflow

Trigger
The 1st of the month, or on demand
Drafts a statement for every active property on the 1st, aiming for your send by the 7th business day, or re-runs a single property when a late expense posts.
Tool call
Pull every source of truth
reservations + journal entries + OTA payout files + stripe.payouts + qbo.query() · the checked-out stays, what each channel paid, and the expenses per property.
Prompt
Reconcile it three ways
Match PMS recognized against OTA reported against the bank deposit for each reservation. A late resolution-center credit gets traced back to the stay it came from, even when it lands in another month.
Draft
Build the statement and the note
statement.buildPdf() · a line-item PDF from gross to owner distribution, plus a two-to-four sentence cover note that leads with the number, the pay date, and anything unusual over $250.
Watch
Check that it ties
Owner balances plus commission plus tax plus vendor payable must equal the trust balance. If it does not, the send button stays locked and the variance is spelled out for you.
Approval
You review and send
One card shows the diff from last month, the flagged mismatches with one-click fixes, and the editable note. On approve it emails the owner, logs the timeline, and writes back to your PMS. It never sends on its own.

Hire your first Sidekick

Every template drafts first. You approve what matters.