Close the books before your accountant asks.

My Xero (or QuickBooks) is connected via the Ledger MCP connector. Pull every transaction from the most recent complete BAS quarter for my property investment accounts.

Then do four things:

1. CATEGORISE every expense against the categories an Australian property investor's tax agent cares about: loan/mortgage interest, council rates, water rates, strata / body corporate fees, land tax, property management fees, repairs and maintenance, building & landlord insurance, advertising for tenants, accounting/bookkeeping fees, and other. Split by property where the data allows. If a transaction does not fit cleanly — or looks like a CAPITAL IMPROVEMENT rather than a repair — flag it for me rather than guessing.

2. INCOME by property: rent received per property, plus any other income, with each property's share.

3. VISUALISE the quarterly cash position per property as a bar chart, with a net line and a stacked expense-category breakdown.

4. FLAG anything that needs a human eye: outliers more than two standard deviations above the category average, a category that did not exist last quarter, likely duplicates, and any repair that might actually be a capital works item (different tax treatment).

Produce a single Excel workbook with these tabs:
- Summary: headline numbers (total rent, total expenses, net position, quarter-on-quarter delta), the per-category table, the chart embedded as an image, and the flagged items. Format to print cleanly on one A4 landscape page.
- Transactions: cleaned, categorised, per property.
- Income: rent and other income per property, amounts and % share.
- GST/BAS: GST collected vs GST paid for the quarter. Note: residential rent is generally input-taxed — flag any GST mis-coding.
- Trends: the flagged items with a one-line reason each.

Then draft an email to my registered tax agent at [agent@example.com] via the Gmail connector and save it to Drafts. Do not send. Subject: "Quarterly BAS & bookkeeping summary, [entity name]". Body: three short paragraphs — headline numbers, what changed vs last quarter, and the flagged items — plus a short list of 3-5 questions for them based on the flags (e.g. repair vs capital, GST coding, anything ambiguous). Attach the workbook.

---
IMPORTANT: Educational preparation only. Not tax, accounting or BAS advice. Residential rent is generally input-taxed; depreciation requires a quantity surveyor's schedule; capital works vs repairs is a tax-agent call. A registered tax agent must review before anything is lodged.