AI, set up properly for your team.

SELECT billing_country AS market, SUM(total) AS revenue_usd, COUNT(DISTINCT customer_id) AS customers FROM invoice WHERE EXTRACT(YEAR FROM invoice_date) = 2025 GROUP BY billing_country ORDER BY revenue_usd DESC, market LIMIT 5;

Assumption: "customers" means anyone with at least one 2025 invoice billed to that market.

The latest invoice in the warehouse is dated 22 December 2025. I don't know if later sales are missing or if there were none.

## Problem
"Every purchase is its own invoice, in its own email", so a video studio builds its monthly statement by hand.
Its accountant rejects invoices that "show my name, not the studio or our tax number", and the studio "would shop elsewhere" after its books close in December.

## Requirements
1. Offer one monthly statement per account, listing that month's invoices (assumption: calendar month).
2. Save a company name and tax number once, then print both on every later invoice.
3. Let buyers type a free text reference at checkout that prints on the invoice.
4. Let customers get old invoices on the site, not only by email.

## Open questions
1. Should the statement be a PDF, a spreadsheet or both? Owner: the customer's accountant.
2. Must we check the tax number, or is typing it in enough? Owner: Finance.
3. How many of our 10 business customers have this problem? Owner: Dana.

## Acceptance criteria
1. Given several invoices in one calendar month, when the month ends, then one statement lists them all.
2. Given a saved company name and tax number, when the next invoice is issued, then it shows both.
3. Given a reference typed at checkout, when the invoice is issued, then it shows that reference.

Checkout kit has problems in all three groups: 2 duplicate color pairs, 5 layers with raw values and 3 broken variants.

## Duplicate colors: 2 pairs
- `color/text/muted` and `color/gray/600` are both #52525B. `color/text/muted` is bound on `Label` in the two Disabled `Button` variants. No layer in this file is bound to `color/gray/600`.
- Style `Brand/Blue` and variable `color/brand/primary` are both #1F6FEB. The variable is bound on four layers: `Type=Primary, State=Default`, `Type=Primary, state=Focus`, `State=Focus` in `Input`, and `Promo banner`. No layer in this file uses the style.

## Raw values: 5 layers, 6 values
- `Order summary`: fill #F4F4F5 is not bound. Same value as `color/surface/subtle`.
- `Price`, inside `Order summary`: fill #52525B is not bound. Same value as `color/text/muted` and `color/gray/600`.
- `Promo banner`: corner radius 6 is not bound. No radius token is 6. The tokens are 4, 8 and 999.
- `Payment form`: left padding and right padding are 13 and not bound. That is two values. No space token is 13. The nearest is `space/3` at 12.
- `Pay button`: the instance overrides the fill with #1F6FEA and binds it to nothing. Its component uses `color/brand/primary`, #1F6FEB. The two are one hex digit apart.

## Broken variants: 3
- Name off the pattern: `Type=Primary, state=Focus`. It says `state` in lower case. The other five variants say `State`. So the set has a second property, `state`, with Focus as its only option.
- Missing state: `Type=Secondary, State=Hover`. Primary has Hover.
- Missing state: `Type=Secondary, State=Focus`. Primary has Focus, in the misnamed variant.