> ## Documentation Index
> Fetch the complete documentation index at: https://docs.yorlet.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Yorlet Prism

> Write SQL against a snapshot of your Yorlet data to answer questions that standard reports do not cover.

Prism is SQL analytics over a snapshot of your Yorlet data. Use it when you need a rent roll, arrears ageing, a leasing funnel, or any other cut that is not already on [Reports](/reporting/introduction) or [Overview](/reporting/dashboard-reports).

Open [Prism](https://dashboard.yorlet.com/prism) from the sidebar after you start a plan. If you work across an organisation, you can also open [Prism](https://dashboard.yorlet.com/org/prism) in organisation view.

<Note>
  If you do not see **Prism** in the sidebar or on [Your plans](https://dashboard.yorlet.com/settings/plans), it is not available on this account yet. Talk to your account manager.
</Note>

## How it works

Prism copies the records you already have in Yorlet — customers, invoices, tenancies, payouts, and more — into a snapshot you can query. The editor shows **Data as of** when that snapshot was last built. **Standard** refreshes overnight; **Premium** refreshes every hour.

You write SQL, run it, and inspect the rows as a table or a chart. Starter queries fill the editor for common reports. Save a query to run it again, or schedule it to email a CSV.

Amounts are stored in pence. Divide by 100 when you want pounds.

## Enable Prism

Prism is a subscription billed on units under management, with a 14-day trial. You need the admin role to start it.

To start a trial, follow these steps:

1. Go to [Your plans](https://dashboard.yorlet.com/settings/plans).
2. Find **Yorlet Prism** and click **Get started**.
3. Choose **Monthly** or **Annual · save 20%**, then **Standard** or **Premium**.
4. Click **Start 14-day trial** and complete checkout.

Once the trial is active, **Prism** appears in the sidebar. See [Plans](/prism/plans) for what each plan includes and how pricing scales with your portfolio.

## Get started

<CardGroup cols={2}>
  <Card title="Plans" icon="credit-card" iconType="duotone" color="#6366f1" href="/prism/plans">
    Choose Standard or Premium, start a trial, and see how units are billed
  </Card>

  <Card title="Write a query" icon="play" iconType="duotone" color="#6366f1" href="/prism/write-a-query">
    Run SQL, ask the assistant to edit it, and download the result
  </Card>

  <Card title="Templates" icon="file-lines" iconType="duotone" color="#6366f1" href="/prism/templates">
    Start from rent roll, arrears, leasing, owners, and maintenance queries
  </Card>

  <Card title="Save and schedule" icon="clock" iconType="duotone" color="#6366f1" href="/prism/save-and-schedule">
    Name a query, keep a history of runs, and email a CSV on a cadence
  </Card>

  <Card title="Schema" icon="table" iconType="duotone" color="#6366f1" href="/prism/schema">
    See which tables you can query and how tenancies relate to applications
  </Card>
</CardGroup>