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
• See the card brand and last four digits on card transactions at a glance
• Filter by date range, payment method, or transaction type
• Compare periods and see percentage changes at a glance in chart tooltips
• Track instalment plan progress
• Monitor gift card balances and redemptions

Access to the financial dashboard requires the Financial Dashboard permission. Staff without this permission cannot view payout data or export reports.

Card details on transactions

Card transactions in the financial dashboard and on order receipts display the card brand logo alongside the last four digits of the card used — for example, a Visa logo followed by •••• 4242. This makes it easier to identify which card a customer paid with when reconciling a payment or handling a customer query.

Brand logos are shown for Visa, Mastercard, American Express, Discover, Diners Club, JCB, and UnionPay. For wallet payments (Apple Pay, Google Pay), the wallet is shown in addition to the underlying card. Cash, invoice, and other non-card payments are unaffected.

Card brand and last four digits are populated automatically from Stripe and only appear for transactions completed after this feature shipped. Older transactions continue to display the payment method without card details.

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, 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 are tracked separately from card payments. Cash payouts appear in a dedicated section of the financial dashboard with:

• Transaction amounts from each till shift
• 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)
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

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

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
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.

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

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 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.

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.

Monitoring automated emails

Track the volume of automated communications through meter usage tracking:

Meter	What it tracks
workflow-email-sent	Emails sent by automated workflows
waitlist-notified	Waitlist notification emails
order-completed	Completed purchases across all channels

Related guides

Payments and Stripe

Connect Stripe and manage payment processing.

Xero accounting sync

Automatically sync payouts to Xero.