The owner statement, automated: a complete blueprint

Who this is for: anyone managing units for owners — from a broker with five landlords to a PM company with five hundred — who spends the first days of every month turning a spreadsheet into statements.

Three days of month-end Excel is not an accounting problem. It's a formatting problem, and formatting problems are exactly what AI is good at.

1 · The data

Everything starts from one export. Most PMS systems (and most spreadsheets) can produce a monthly CSV with a row per unit. You need at minimum:

• unit — building, unit number, type
• owner — who receives the statement
• status — occupied / vacant, and since when
• rent_collected — actual receipts for the month
• expenses — maintenance and charges, itemised with short descriptions
• notes — anything the team logged (renewals, complaints, works)

Do not clean the data beyond this. The point of the workflow is that it consumes what you already have.

2 · The prompt

Open Claude (claude.ai — a free account works). Paste this prompt, attach your portfolio spreadsheet (.xlsx or .csv) to the same message, change two things — the owner name and the month — then send. Run it once per owner:

You are an assistant to a property manager in Dubai. You are
preparing the monthly report for a property owner.

HARD RULE: Use only the numbers present in the attached
spreadsheet. Do not calculate, invent, or assume any figures,
dates, or statuses. If something is missing from the data,
write "no data" — do not guess. No legal or tax advice.

Owner: [OWNER NAME]
Period: [MONTH YEAR]

From the attached spreadsheet, prepare the report for
Owner: [OWNER NAME] only. Ignore rows for other owners.

Produce TWO parts.

PART 1 — REPORT (structured, business tone):
1. Portfolio summary: number of units, occupied / vacant,
   total rent collected this month, total arrears.
2. Per-unit table: unit, tenant (or Vacant), annual rent,
   received this month, arrears, contract end date, status.
3. Arrears & risks: list units with arrears, amount, and
   recommended next step.
4. Maintenance this month: item, cost (AED), vendor, owner
   approval status.
5. Vacant units: vacant since when, re-letting actions taken.
6. Needs your decision: short numbered list of items requiring
   the owner's response or approval.

PART 2 — WHATSAPP / EMAIL SUMMARY (5–7 lines, conversational
tone): Friendly, no jargon. Key monthly figures + 1–2 items
needing the owner's input. Close with a short question.

The full portfolio is in the attached spreadsheet. Use only
the data in that file — no other source.

3 · The checks — this is the part people skip

The prompt above already contains the most important control: anything missing from your data is written as "no data" — never invented or guessed. Add two human checks on top:

• Totals check. The sum of all net amounts across statements must equal the net of the source CSV. Thirty seconds in Excel. Do it every month.
• One full read. Read one statement end to end — a different owner each month. You're checking tone and sanity, not arithmetic.

With these two checks, the workflow is a drafting assistant, not an accountant — and that's exactly the right altitude for it.

4 · The three ways it breaks

• Dirty notes columns. If your team logs "spoke to owner, angry" in the notes, it will end up in a statement. Fix the logging culture or add a rule excluding sentiment from output.
• Mid-month ownership changes. The CSV shows one owner; reality had two. This is a data problem no prompt can fix — handle transfers manually.
• Silent format drift. The PMS update renames a column and the numbers land in the wrong place. The totals check catches this — which is why it's non-negotiable.

5 · What this costs and saves

Cost: roughly the price of a coffee in API or subscription fees per month-end. Saving: for a 50–200 unit portfolio, typically two to three working days per month, converted into a fifteen-minute review. The owners also get better statements — consistent, readable, on time — which is worth more than the saved days.