Overview
Loading dashboard data…
Monthly income & expenses last 24 months (Xero)
Revenue by stream
Profit & loss by site Xero site net · monthly or year to date
Vacancy opportunity cost available operating bedrooms · potential SDA + RRC income
Latest analyst notes
No insights yet — the nightly analyst task writes these.
Beds on hold reserved on the bedroom board — committed, income starts at move-in
Building-type funding variance current funded build type vs budgeted, in $/yr
Income vs Budget
Each month shows three columns — Actual (Xero delivered — blank for months that haven't happened yet), Budget (Xero budget for costs; engine income at the planned mix) and Contracted (engine at the signed run-rate; Bud and Con both include scheduled site consulting income and enrolment incentives). The Actual column is shaded by collection vs contracted (green ≥ 98%, amber, red < 90%) for completed months. Click ▸ a line for the per-site breakdown.
P&L by financial year
Monthly trend
Monthly P&L detail
Account-level monthly figures from Xero. Budget row = portfolio site budgets straight-lined /12. Select a year with the chips above; "All years" shows the latest complete + current FY.
Annualised profitability by month
Income mix
Top expenses
Income accounts by year
Expense accounts by year
Financial year summary
FY24 seeded from final Xero actuals. FY27 YTD updates with the 3x-daily sync.
By state
Occupancy by site
Margin ladder FY26 net margin per site, live from Xero
Portfolio occupancy trend builds from 3x-daily snapshots
Site scorecards click a row to drill down · actuals live from Xero per-site tracking, monthly since Jul 2023
Opportunity cost sums each available operating bedroom's budget SDA rate plus RRC. Reserved, on-hold, absorbed and offline bedrooms are excluded. This is potential income, not guaranteed funding or profit.
Property portfolio the Avenu property register
Care providers — dwelling allocations who is pre-marketing or servicing each house · writes a note to the provider’s CRM account
Pick the site, then a dwelling when the site has more than one house (or leave Whole site to cover every dwelling until a house is overridden). Add two or more providers to the same site or dwelling; each keeps its own status, agreement end date and notes. Adding a provider keeps existing allocations. To finish an allocation, set that provider to ended. Provider from the CRM list or free-text. Statuses: pre-marketing → active → ended; the end date is the marketing-agreement expiry and shows amber when inside 60 days. Allocations appear on Pipeline, Site file, Portfolio and Development.
Portfolio map every site across Australia — hover for details
Live
In development
Pipeline
marker size = beds
Coordinates are suburb-level. Zoom into Adelaide, Newcastle or the mid-north coast to separate clustered sites; hover any marker for the site's status and beds, click to open its statement.
Residents & funding live from the bedroom board · edit funding status and plan category
Loading…
Rooms live feed
Loading…
Chasing participants and leads we could place — match against the vacancies above
Houses & beds click a house to expand · charged vs approved shown per resident
Loading…
Investor occupancy (per site)
Rooms entering portfolio by quarter
Pipeline coverage participant demand vs rooms coming online
Rent-free window opportunity rooms filled before rent starts contribute income with zero rent cost
Developments grouped by location
13-week cash projection driver-based: occupancy ramp, NDIS collection lag, rent-free periods
13 weeks (~3 mo)
Bank balance trend
Builds over time from 3x-daily snapshots.
Balance sheet
Awaiting first balance sheet sync.
Receivables approved invoices only — what Xero calls AR
Awaiting first AR sync.
Forecast accuracy what we forecast vs what happened
Accumulates after the first month of stored forecasts.
Fill planner one plan of record per site — remaining beds fill over 6 months · two sliders bend the curve · the number that matters is cumulative cash vs plan
How to read this card: green line = the plan of record (all remaining beds filled in 6 months). Amber line = your scenario from the two sliders. Bars = the scenario\u2019s monthly net. The one number to watch is Δ vs plan — everything else explains it. Tap any i for the exact formula with this site\u2019s numbers. Sliders and the fitout box save automatically; Accrual vs Cash-timed shifts income by the NDIS collection-lag assumption.
Portfolio vs plan deltas add — a site is here because it exists · marketing = base % × day-one-fill upside × geo risk
How hard to push: marketing buys earlier fills, and the return is biggest where the upside column is biggest — a bed filled during rent-free is nearly pure margin. Spend where upside-per-dollar is highest; ease off once a site is tracking at or ahead of plan. Base % is editable above; geo risk per site in Admin.
Care providers warming dwellings live allocations — managed on the Property page
Loading…
Deal pipeline by stage
Stage detail
Won deals represent annualised participant income. Pipeline feeds vacancy-fill projections.
Active deals
By team member
Funnel conversion
Rooms by investor
Investor occupancy active properties only
Investor portfolio detail
Occupancy joined per-dwelling from the live rooms feed. Use this for investor reporting packs.
Scenario levers drivers from the live system — three-measure model
Saved scenarios load · compare · primary is tracked nightly by the analyst
Loading…
vs
Monthly projection
Monthly numbers
Budget monthly budgeting for overheads and wages · keyed on the Xero account code, so a renamed account keeps its history and a new account appears on its own · ex GST · the active version is what the P&L forecast and the cash model read
Loading…
Budget vs actual the active budget against what Xero actually recorded · keyed on the account code · ex GST · the current calendar month is never counted as an actual
Loading…
Operating ratios the percentages that tie the dollars together · last complete month per site · income is SDA + RRC only · worst first · click a site to open its statement
Loading…
Project management consulting and PM engagements that may never become a head lease · fees are stored ex GST and flow into the P&L forecast and the Forecasting panel · forecast only, with no Xero link yet
Loading…
Report builder build a report from any registered dataset without writing SQL · save it, share it, schedule it · every run goes through fn_report_run as you, so you can only ever pull what you are allowed to see
Loading…
Report builder
Print uses your browser's Save-as-PDF for the cleanest output. Download builds a PDF file directly. Reports render on white for paper.
Analyst insights
Add a new site one guided flow — site, houses, bedrooms, pricing, map and Zoho in a single pass
Answer three short steps; everything else (dwelling rows, engine pricing, dev profile, map pin, Zoho houses + bedrooms) is created for you.
Site planning edit dwelling configurations — income prices live from the SDA engine (price guide × location factor + RRC)
Zoho houses at this site explicit ID link — occupancy and residents flow from Zoho through this attachment, no name matching
For houses that already exist in Zoho and aren't linked yet.
Plan changes record a funded-category change — history is kept as dated funding periods
Site statement
Beds live from Zoho · funded amounts priced by the engine today
Occupancy trend 3x-daily snapshots
Plan variance at this site funded vs planned, engine-priced
Calendar
12 monthsAdd milestone
Vacant beds now live from Zoho · ageing builds as the room-events ledger accrues
Head lease register layer 1 — leases in from investors · click a row for the full deal
Loading…
Sunset watch an exit opportunity if the Certificate of Occupancy is late — never a blocker on progress
Loading…
Critical dates derived from lease terms — never typed
Loading…
Development timeline planning → construction → OC → SDA enrolment · enrolment sets lease commencement, rent-free start and SDA income start
SDA enrolment is the trigger. Handover happens, enrolment follows, and at enrolment the lease commences, the rent-free clock starts and SDA income becomes claimable. Planned enrolment drives the forecast and forward budgets; actual enrolment replaces it the day it happens and becomes the concrete date. Planning, construction and OC dates are project tracking — they validate the enrolment date but do not move money on their own. A planned date whose month has passed is treated as not having happened: that site is held out of the forecast rather than booking income for months that did not occur.
Commercials rent, recoveries and the cash model · lease start is set by SDA enrolment above
Geo risk — how the number works: it is a difficulty multiplier for filling rooms at that location, used by the Fill Planner and Forecasting. 1.0 = neutral baseline (fills at our historical average pace, standard marketing allocation). 2.0 = twice as hard — expect roughly double the time/marketing spend to fill a room (budget = base % × upside × urgency × geo). 0.8 = easier than average — strong local demand, fills faster with less spend. Typical range 0.7–1.5. Judge it on: local SDA supply vs participant demand, SIL provider density nearby, how fast this site filled historically, and active pipeline deals in the region. "% plans incorrect" is separate — that's the share of residents whose NDIS funding needs a plan change (drives cash-timing, not fill difficulty).
Per-resident cash paths switch a site once you know part of the resident mix — projections stop using the cohort % and follow each resident
Loading…
The cash model is a statement of what we know, not a what-if: Cohort = the site-level "% plans needing change" assumption (fine from ~6 months out). Per resident = each identified resident carries their own delay switch (Auto follows funding status: pending = delays on); beds with nobody identified yet still project at budget on the fill plan. Every projection — forecast, fill planner, cash, portfolio balance — follows whichever model the site is set to.
Investors & lessors counterparties on the head leases · a related party is an Avenu entity leasing to itself
Loading…
Forecast assumptions
Changes apply to the next forecast render immediately and to the nightly stored forecast.
Sync health every scheduled job and pipeline, and anything that finished without doing what it was supposed to
Loading…
Approved recipients nothing outside this list can be emailed by any agent, job or RPC — a block rule always beats an allow rule
Loading…
Ratio thresholds what counts as good and what counts as a problem · portfolio-wide · these drive the colours on the P&L ratio layer, the site statement and the ratios board
Loading…
Team access who can sign in, and what they can see
Access is invite-only — nobody can sign themselves up. Inviting creates their account here and now. Choose Microsoft sign-in for avenu.au people (no email is sent — they just go to www.avenu.business and click Sign in with Microsoft), or Email invite for anyone else (they get a link to set their own password).
Roles: Director and Finance see everything. Operations sees Property, Residents, Calendar and Map — no rent, outgoings or P&L. Removing someone revokes access immediately, even if they are already signed in.
Roles: Director and Finance see everything. Operations sees Property, Residents, Calendar and Map — no rent, outgoings or P&L. Removing someone revokes access immediately, even if they are already signed in.
Site file call sheet first — who is in, care company, how to get in, photos and work
Loading…
Building specifications handover packs read by Claude — searchable specs per site · originals downloadable · filed to WorkDrive Building record
Loading…
Who built it, who to call contractors and trades taken from each site’s handover pack
Loading…
Residents every resident — funding, $ value, status, move-in. Quick-edit; funding changes reprice via the engine and sync to the CRM.
Loading business development…
Main contacts every participant, live from Zoho CRM · click a row to edit — saves write back to the contact record
SDA claim issues one or more claims per resident · sequential enquiry then escalation · Save to move stage · notes still add immediately
Documents sensitive documents read by Claude — leases, agreements, NDIS plans, funding letters · director & finance only
Loading…
Document audit every document the system has handled — where it came from, what Claude made of it, and where it ended up
Loading…
Lease terms what the documents say, waiting to go into the head-lease register
Approving writes the register and records the document it came from.
Loading…
Transitions checklist one checklist — the CRM blueprint · ✓ done · P pending · N/A optional · click a cell to tick (saves to Zoho), a name for notes
Money stuck every dollar delayed or at risk, ranked by $ × days · real figures from Xero · ~ estimates from funded SDA rates
~ = estimated exposure (funded SDA rate × days unclaimed), not an invoice — if it was actually claimed, tick the blueprint/CRM and it clears. SLA: a claim issue with no note for 14 days turns amber. Sources: Xero AR aging · claim issues · CRM transitions.
Billing runs every line belongs to a run · nothing posts to Xero while Re-Leased is still live
Claim window
to
The claim window decides which service periods are picked up. SDA runs on each participant's own monthly cycle, so a line's service period will often straddle the window — that is correct, not a fault.
Amounts are computed by the billing engine, not read from Xero. A blocked line is still shown — never hidden — with the reason it cannot be issued. Posting to Xero is disabled at database level during the parallel run.
Email delivery drafts only — no receivables sending address is configured yet
Nothing is sent. accounts@avenu.au is inbound-only and auto-forwards to Xero for supplier-bill reading, so sending receivables from it would turn every reply and bounce into a spurious draft bill. A dedicated address (invoices@ or billing@) with SPF and DKIM is needed before delivery can be switched on — until then the database refuses to mark any row as sent.