# Rapports

`VERIFIED LIVE`

## Purpose

Local SQL aggregates. Live: “Aggrégats SQL locaux”. “CA = bookingId + CONFIRMED/BOOKED. Prebook exclu. Pas Analytics Connect.”

## Who / permission

`alya_hs_view_reports`. Staff: yes. Export CSV: same view.

## Where

`#reports` · WP `page=alya-hs-reports`

## Screenshot

![Reports](../screenshots/backoffice/06-reports-01-overview.png)

## Fields / filters observed

Date Du/Au, status “Arrivée”, environment “Sandbox+Live”, category “Tous”. **Filtrer**, **Export CSV**.

KPIs: Revenue confirmé **3446.72 EUR**, Confirmées **4**, Commission **313.30 EUR**, Annulées **1**.

Table PAR DEVISE EUR: CA 3446.72, **MARKUP 0.00**, COMMISSION 313.30, FOURNISSEUR 3446.72.

## Actions

Filter, CSV. Not clicked CSV this pass (`SCREENSHOT REQUIRED` for file contents).

## Workflow

Confirmed rows with bookingId → SUM selling / commission / markup columns.

## Observed formula

See [pricing-markup-commission.md](../business/pricing-markup-commission.md). `3446.72 × 10 / 110 ≈ 313.34` vs displayed **313.30**. `OBSERVED / VERIFIED FORMULA` for this 10% config when estimate is used.

## API

No Nuitee analytics endpoints in ReportsPage. `NOT FOUND`

## 13. Limitations

Not a finance settlement report. Markup 0.00 means supplier_price equals selling on stored rows.

## 14. Evidence status

`VERIFIED LIVE`

## Related

[dashboard.md](dashboard.md)