Turn your Yorlet data into answers

Build the report your operation needs with templates, AI-assisted SQL and a curated snapshot of your Yorlet data. Explore once, save for later or schedule the result to arrive automatically.

Rent by building

Saved query

Run
1SELECTbuilding_name,
2 COUNT(*) AS active_tenancies,
3 SUM(monthly_rent) / 100 AS rent
4FROM tenancies
5WHERE status = 'active'
6GROUP BY building_name

3 rows · 146ms · Data as of today, 09:00

TableChart
building_nameactive_tenanciesrent
Aster House42£61,250
Canal Works31£48,900
West Court27£39,650

Prism reporting features

Start from a proven report

Use templates for rent roll, arrears, occupancy, leasing, owners, finance and maintenance.

Ask AI to write the SQL

Describe the result you need, refine an existing query or ask the assistant to fix an error.

See the answer your way

Review results as a table or chart, then download a CSV for the next step.

Save and schedule

Keep useful queries, inspect run history and email fresh reports on a cadence.

From question to report

Custom reporting without starting from scratch

Prism brings the schema, editor, assistant and result together in one workspace, so you can move from a business question to a reusable report without exporting and stitching data together.

Begin with the question, not a blank editor

Pick a template for a familiar property workflow or describe the report in plain English. The assistant can draft the SQL, adapt a template and explain what changed.

17 templates across six reporting areas

Searchable tables and columns

AI-assisted editing and error fixes

Plain-English analysis through Yorlet AI

Start with a template

Choose a report, then make it yours.

No SQL needed

Rent roll

Portfolio

Arrears ageing

Billing

Occupancy by building

Portfolio

Leasing funnel

Leasing

Owner payouts

Owners

Open issues by priority

Maintenance

Ask the assistant to compare occupancy this quarter…

Make the useful answer repeat itself

Name and save the reports your team relies on. Schedule them for the right moment and Prism emails the latest CSV to the people who need it.

Saved queries and run history

Flexible recurring schedules

Automatic CSV email delivery

Complete Premium exports for large results

Scheduled reports

Run queries and deliver CSVs automatically

Weekly rent roll

Every Monday · 08:00

Arrears review

Every weekday · 09:00

Owner payout check

Monthly · 1st day

Last run · 84 rows · deliveredView run history
Built for trusted analysis

Powerful enough to explore, controlled enough to trust

Read-only by design

Prism analyses a reporting snapshot and cannot change or delete operational records.

Freshness made visible

Every result shows when its snapshot was built, with nightly or hourly refresh by plan.

Across your organisation

Choose a query scope and compare Prism-enabled accounts from organisation view.

API access on Premium

Run Prism queries from another system with a secret key when reporting needs to travel further.

Plans

Choose the refresh and reach your reporting needs

Both plans include a 14-day trial, templates, saved queries, tables and charts, and the first 100 units under management. Annual billing is 20% off.

Standard

£50 / month

or £480 / year

Nightly reporting for teams building and scheduling day-to-day analysis.

Nightly snapshot refresh

5 active scheduled queries

10,000 rows in the editor

25 AI SQL generations each month

Premium

£150 / month

or £1,440 / year

Fresher data, complete exports and API access for advanced reporting.

Hourly incremental refresh

Unlimited scheduled queries

Full-result CSV exports

Secret-key API access

Unlimited AI SQL assistance

FAQ

Yorlet Prism questions

Do I need to know SQL to use Prism?
No. Start with a reporting template, ask the built-in SQL assistant to create or change a query, or ask Yorlet AI to explore a question in plain English.
Can a Prism query change my Yorlet records?
No. Prism queries a curated, read-only snapshot. A query can analyse your data but cannot edit or delete records in Yorlet.
How current is the data?
Standard refreshes its snapshot overnight. Premium uses hourly incremental refreshes. Prism shows “Data as of” beside every result so you can see when the snapshot was built.
Can Prism send reports automatically?
Yes. Save a query, choose a schedule and add recipients. Prism runs it on that cadence and emails the result as a CSV.
Can I report across more than one account?
Yes. Organisation view lets you choose a query scope and analyse the Prism-enabled accounts you can access.
How is Prism priced?
Prism is billed per account based on units under management. Standard starts at £50 per month and Premium at £150 per month, including the first 100 units. Both include a 14-day trial, and annual billing is 20% off.

Built for the future.

Available today.

Turn the questions your team asks into reports they can reuse.