The financial reports

Nine reports covering the money. All of them count money that actually moved, never list price, and all of them sit behind the finance capability.

Sales

Gross takings, refunds and net for the period, cut by payment type, method, VAT category, practitioner and day, with the discounts given beside them. A staff filter narrows it to one practitioner.

Gross takings is every succeeded payment in the period that is not a refund. Pending and failed payments never count.
Refunds and corrections is every succeeded payment recorded as a refund. They are stored as negative amounts, so net takings is simply gross plus refunds.
A payment counts on the day it was taken, on the clinic's own clock.
Practitioner comes from the appointment the payment is attached to. Retail, account top-ups and gift vouchers have no appointment, so they get their own row and are never spread across the team.
Discounts given is money never asked for, so it sits beside the takings rather than being subtracted from them. It covers visits in the period that were not cancelled, and matches the discounts tile on the Finance page.

Service sales

Money taken against appointments, by category and treatment, with visits and the average per visit. Staff and appointment location filters both apply.

This is money taken, not the list price of what was booked, for the reason set out in the overview article.
A treatment's figure is every succeeded payment attached to an appointment for it, whether that was a reservation fee, a balance or a missed-appointment fee.
Visits counts a grouped booking once, however many treatments were on it, so the per-visit average is a real average. Payments are counted individually.
A visit booked as an appointment type with no treatment on it, and money with no appointment behind it at all, each get their own row rather than being dropped or shared out.

Product sales

Retail by product: units, revenue, cost and margin, with counter sales and online shop orders together.

Counter sales and shop orders are the same sale here, separated only by how the goods left the clinic. Anything still to be collected or posted counts as awaiting fulfilment.
Cost and margin are at current cost price. The cost on a product record is a single figure rather than a price captured on each sale, so a unit sold earlier in the period is costed at whatever the record says today. Treat the margin as an indication of which products earn, not as a year-end figure.
Refunds are not attributed to a product, because a refund is a payment with no product lines behind it. Net takings with refunds included are on Sales.
A postage or handling line earns revenue, moves no stock and has no cost, so it appears marked as not a stocked product.

Takings by day

One row per day, split by cash, card terminal, online, bank transfer, account credit and other, with a running total.

This is what should be in the till and in each account for the day. It is not a cash-up: nothing here counts a float, a drawer or a banking, and a cash-up with only an expected side always balances. Compare these figures against what you count.

Each column is net of refunds, so the columns add across to the day's total and a cash refund comes out of the cash figure.
A payment counts on the day it was taken, on the clinic's own clock.
Every day in the period has a row, including the ones that took nothing, so the running total never jumps without explanation.
Click a day to open its receipts in the finance ledger.

Refunds and corrections

Money is never voided in AesthetiClinic. Undoing a payment always writes a new negative payment, so the original receipt stays exactly as it was issued and the change is on the record. This report splits those negatives into three lanes:

A correction carries the payment it reverses, and that receipt number is in the Reverses column. No money moved: a cash or card-terminal payment was keyed wrongly and put right.
A refund carries a Stripe refund reference. That money went back to the patient's card.
Recorded by hand has neither. It is money the clinic gave back some other way and wrote down here.

The total refunded to cards is summed in the database over the whole period, so it is right even when the table below is showing only part of it.

Deposits

Three figures that are often confused, kept apart on purpose:

Taken is a flow: every succeeded deposit dated inside the period, whether the visit has happened yet or not.
Held right now is a balance, not a period figure. It is every deposit sitting against an appointment that has not happened yet, as at today, and it does not change when you change the period.
Kept as a missed-appointment fee is money charged in this period for a missed visit. What the missed visits were worth at list price is on the executive summary.

A deposit refunded later still shows here, and its refund is on the Refunds and corrections report.

Invoices

Invoices issued in the period with what is still owed on each. Four tabs: All, Unpaid, Overdue and Void.

An invoice is in this period when it was issued in it. Drafts are not documents and are never listed; a voided invoice keeps the date it was issued.
Balance is the invoice total less every payment carrying that invoice, worked out in the database rather than added up on the page. A refunded part-payment reopens the balance rather than hiding it.
Overdue is worked out from the due date every time the page loads and is never stored: an invoice becomes overdue because the date passed, with nothing having to run. Overdue is a subset of unpaid.
Void has its own tab and is deliberately not counted as unpaid. A void invoice is not paid, and it is not owed either.
The unpaid and overdue totals cover the whole period, whichever tab is showing.

Stored value

The three things the clinic has already been paid for and still owes in treatment: gift vouchers, account credit and package sessions. Each section shows what was sold or topped up in the period, what was redeemed or spent, and the balance still outstanding as at today.

A voucher is redeemed either against a booking, where its balance is drawn down, or by being converted in full to account credit. Both are counted. The converted ones also appear as an account top-up, because the value moved from one liability to the other rather than leaving.
Package sessions outstanding are valued at what that patient paid per session, so a package sold at a discount is owed back at the discounted rate.
All three are one question at year end, which is why they are one page rather than three.

VAT split

Gross takings split into VAT-exempt medical care and standard-rated cosmetic treatments, by method and by type, with a CSV for your accountant. It is now reached from the Reports page like everything else, and it uses the same shared period picker. The article on the VAT split report covers how the categories are set, what the stored value section means and the two caveats worth reading before you send it on.