> ## Documentation Index
> Fetch the complete documentation index at: https://sailia-mintlify-5b02008a.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Financial reporting

> View payment data, export transaction records, and monitor your business performance.

Sailia provides a financial dashboard where you can view payment activity, monitor payouts, and export data for reporting or tax purposes.

## Financial dashboard

The financial dashboard gives you a centralized view of all payment activity across your account. From here you can:

* View gross revenue, Stripe fees, and net payouts
* Browse individual transactions with payment method, status, and customer details
* Filter by date range, payment method, or transaction type
* Compare periods and see percentage changes at a glance in chart tooltips
* Track [instalment plan](/payments/instalments) progress
* Monitor [gift card](/pricing/gift-cards) balances and redemptions

<Note>
  Access to the financial dashboard requires the **Financial Dashboard** [permission](/staff/management#permissions). Staff without this permission cannot view payout data or export reports.
</Note>

### Baskets table

The **Baskets** tab lists every basket on your account. Each row shows the most relevant details at a glance:

| Column             | Description                                                                                                             |
| ------------------ | ----------------------------------------------------------------------------------------------------------------------- |
| **Amount**         | Basket total in your account currency                                                                                   |
| **Status**         | Current basket status (for example, Paid, Pending, Refunded)                                                            |
| **Payment Option** | How the basket was paid — including [card brand and last four digits](#card-details-on-card-payments) for card payments |
| **Customer**       | The customer name, or **Guest** for guest checkouts                                                                     |
| **ID**             | Basket identifier. Click the copy icon to copy the full UUID                                                            |
| **Last Updated**   | When the basket last changed status                                                                                     |

Click any row to open the full receipt, where you can issue refunds, view items, and inspect the payment method used.

#### Card details on card payments

For card and invoice baskets, the **Payment Option** column displays the card brand logo (Visa, Mastercard, American Express, Discover, JCB, Diners Club, UnionPay) alongside the last four digits of the card. If the customer paid with a digital wallet such as Apple Pay, Google Pay, or Stripe Link, the wallet's underlying card details are shown.

The same card details also appear in the **Payment Method** row of the receipt popup so you can confirm which card a customer used without leaving Sailia.

<Note>
  Card brand and last four digits are captured automatically from Stripe at the time of payment. Older baskets paid before this feature was released may not show card details.
</Note>

## Payouts

Stripe sends payouts to your connected bank account on a regular schedule. Each payout in Sailia shows:

| Field                     | Description                                           |
| ------------------------- | ----------------------------------------------------- |
| **Gross amount**          | Total revenue collected before fees                   |
| **Stripe fees**           | Processing fees deducted by Stripe                    |
| **Net payout**            | The amount deposited to your bank account             |
| **Transaction breakdown** | Individual charges and refunds included in the payout |

If you use [Xero accounting sync](/integrations/accounting-sync), each payout is automatically sent to Xero as a categorized invoice with full VAT breakdowns.

## Cash payouts

Cash payments taken through the [point of sale](/point-of-sale/overview) are tracked separately from card payments. Cash payouts appear in a dedicated section of the financial dashboard with:

* Transaction amounts from each [till shift](/point-of-sale/overview#till-shifts)
* Cash refunds issued
* Net cash totals

If accounting sync is enabled, cash payouts are sent to the **Sailia Cash Clearing Account** in Xero.

## Exporting data

You can export transaction data as CSV files from the financial dashboard. Click **Export Data** to open a dropdown where you choose the type of export:

| Export type                      | What it includes                                                                                                            |
| -------------------------------- | --------------------------------------------------------------------------------------------------------------------------- |
| **Baskets**                      | One row per basket with totals, payment method, status, and customer details                                                |
| **Basket items**                 | One row per line item across all baskets, with product and pricing details                                                  |
| **Donations**                    | Donation records for charity reporting or Gift Aid claims (see [donation exports](/payments/donations#exporting-donations)) |
| **Course purchases by end date** | Course bookings filtered by when the course ends rather than when the customer purchased                                    |
| **Planned activities**           | Upcoming scheduled sessions within the selected date range                                                                  |

After selecting an export type, a dialog appears where you set a date range and optional filters before downloading the CSV.

#### Basket item amounts

Basket item exports include both the pre-discount row cost and any discounts as separate columns, plus a computed line total so you can read the final per-line amount without doing arithmetic in your spreadsheet.

| Column                            | Description                                                                                                  |
| --------------------------------- | ------------------------------------------------------------------------------------------------------------ |
| `item_unit_cost`                  | Unit price of the product, in pounds                                                                         |
| `item_quantity`                   | Quantity purchased on this line                                                                              |
| `item_row_cost_pre_discount`      | Row total before discounts (`item_unit_cost` × `item_quantity`), in pounds                                   |
| `total_item_discounts_value`      | Total discounts applied to this line, in pounds                                                              |
| `item_line_total_after_discounts` | Final line total after discounts (`item_row_cost_pre_discount` − `total_item_discounts_value`), in pounds    |
| `accounting_category_name`        | The [accounting category](/integrations/accounting-sync) assigned to the product, or blank if none is mapped |

<Tip>
  Use `item_line_total_after_discounts` when reconciling line-level revenue against basket totals or when summing net revenue per product in a spreadsheet.
</Tip>

<Tip>
  Sort or pivot on `accounting_category_name` to total revenue by accounting category — useful when reconciling sales against the categories you sync to Xero.
</Tip>

### Export filters

Depending on the export type, you can narrow down which records are included.

#### Paid baskets only

Toggle **Include paid baskets only** to exclude baskets that are still pending, failed, or expired. This is available for baskets, basket items, and course-by-end-date exports. Donation exports always include only successful baskets.

#### Payment options

Filter by the payment method used to complete the basket. The available groups are:

| Group     | Includes                                                                 |
| --------- | ------------------------------------------------------------------------ |
| **Card**  | Card payments, pay-later arrangements, and invoiced payments             |
| **Cash**  | Cash payments taken through the [point of sale](/point-of-sale/overview) |
| **Other** | Any other payment method                                                 |

All payment options are selected by default. Deselect a group to exclude those records from the export. At least one group must remain selected.

<Note>
  Payment option filters are not available for the **Planned activities** export type since planned sessions are not tied to a specific payment method.
</Note>

### Payout exports

Each individual payout includes a downloadable CSV breakdown showing the transactions, amounts, fees, and product categories included in that payout. This is the same CSV that gets attached to Xero invoices when [accounting sync](/integrations/accounting-sync) is enabled.

You can also export payout data across a date range from the **Payouts** tab of the financial dashboard.

#### Export payouts

Click **Export Data** on the Payouts tab to download a list of recent payouts as a CSV. Each row represents a single payout from Stripe to your connected bank account.

| Column                | Description                                                     |
| --------------------- | --------------------------------------------------------------- |
| `payout_id`           | The Stripe payout identifier                                    |
| `payout_amount`       | Net payout amount (in your account currency)                    |
| `payout_status`       | Stripe payout status (for example, `paid`, `pending`, `failed`) |
| `payout_arrival_date` | Date the payout is expected in your bank account                |
| `payout_source_type`  | Source of the funds (typically `card`)                          |
| `payout_currency`     | Three-letter currency code                                      |
| `created`             | Date the payout was created                                     |

The export includes up to the 100 most recent payouts, filtered to the date range you select. Use the quick presets (**Today**, **Month to date**, **Last 7 days**, **Last month**, **Year to date**, **All time**) or pick custom start and end dates.

#### Export transactions

Click **Export Transactions** on the Payouts tab to download a transaction-level CSV across a date range. Each row represents a single charge or refund.

| Column                   | Description                                                   |
| ------------------------ | ------------------------------------------------------------- |
| `amount`                 | Gross transaction amount (negative for refunds)               |
| `available_on`           | Date the funds become available in your Stripe balance        |
| `balance_transaction_id` | Stripe balance transaction identifier                         |
| `created`                | Date and time the transaction was created (UTC)               |
| `currency`               | Three-letter currency code                                    |
| `description`            | Linked basket UUID or membership invoice reference            |
| `fee`                    | Application and processing fees deducted from the transaction |
| `net`                    | Net amount after fees                                         |
| `reporting_category`     | Either `charge` or `refund`                                   |
| `basket_id`              | UUID of the linked basket, if any                             |

Pick a date range using the same quick presets as the payouts export, or enter custom start and end dates. The export includes only card transactions with a Stripe balance transaction ID.

<Tip>
  Use the transaction export to reconcile individual charges and refunds against your Stripe dashboard. Use the payouts export when you only need totals per payout.
</Tip>

## Monitoring automated emails

Track the volume of automated communications through [meter usage tracking](/api-reference/meter-tracking#built-in-meters):

| Meter                 | What it tracks                                                 |
| --------------------- | -------------------------------------------------------------- |
| `workflow-email-sent` | Emails sent by [automated workflows](/integrations/workflows)  |
| `campaign-email-sent` | Recipients of [marketing campaign](/customers/campaigns) sends |
| `waitlist-notified`   | [Waitlist](/activities/waitlists) notification emails          |
| `order-completed`     | Completed purchases across all channels                        |

## Related guides

<Columns cols={2}>
  <Card title="Payments and Stripe" icon="credit-card" href="/payments/stripe">
    Connect Stripe and manage payment processing.
  </Card>

  <Card title="Xero accounting sync" icon="arrows-rotate" href="/integrations/accounting-sync">
    Automatically sync payouts to Xero.
  </Card>
</Columns>