/bff/branch/monthly-breakdown

Month identifier in "YYYY-MM" format.

Gross revenue (storno excluded).

Real money actually received in this calendar month: successful gateway transactions (status PAID/COMPLETE) + auto-matched Fio bank wires + manually-recorded bank transfers, all paired to orders that have at least one item attributed to the branch. Dated by the day the money moved, NOT by the order's revenue date — cash-flow figure, not turnover. Cross-branch orders are pro-rated by each branch's share of the order's revenue, so summing this column across branches reproduces the gateway/bank totals (no double-counting). Cash receipts, manual_mark write-offs and credit/voucher redemptions are excluded; multiple gateway attempts collapse naturally (only PAID/COMPLETE rows contribute); manual price edits on the order do NOT change payment-row price, so this figure is free of operator distortion.

Net credit balance moved in the month.

Sum of write-offs effective in the month.

Subset of writeoff whose SUPPLIER (příjemce) is the franchisor / organisation contact. Since 2026-07 this is the ONLY figure that feeds the settlement / vyrovnání — write-offs with a third-party supplier or with the supplier still unset remain visible under writeoff for record-keeping but do NOT contribute to the branch↔org settlement price (they are settled outside the franchisee relationship).

Franchise-fee rate that fired in this month, picked from shop__branch_franchise_fee by the rule whose [fromDate, toDate] window covers the month's last day. 0 when no rule covers it. Equals the top-level franchiseFeePercentage for months in which the current rule has been in force; differs for older months whose rule has since been superseded — the whole point of the history table.

revenue × franchiseFeePercentage ÷ 100 (rounded). Computed with the per-MONTH rate, not the live rate — a mid-year rate change is attributed to the months that actually experienced each rate.

Free-form description attached to the franchise-fee rule that fired for this month (services, agreement scope). Rendered into the finance-report PDF. null when no rule covers the month or the rule has no note.

Money the payment gateway pocketed as commission on the gateway-routed slice of this month's cash-in. Only the gateway leg of cashInAmount is fee-bearing (bank wires and auto-matched Fio transfers contribute zero). The rate applied to each transaction is the commission period (configured on the gateway detail) whose [fromDate, toDate] window covers the payment date; latest fromDate wins when overlaps exist. Pro-rated across branches the same way as cashInAmount. Subtracted in net. Zero when no commission period is configured.

Sum of recurring FIXED branch costs (rent, energy, …) that apply to this month, computed from shop__branch_cost + variable monthly entries. Displayed as "Fixní náklady" in the Finance grid.

Subset of costAmount whose supplier (shop__branch_cost.contact_id) matches the parent branch's branchContact (or the org internal contact for top-level branches). Flows into the settlement — the rest is paid to unrelated third parties (energy, cleaning, …) and settled outside this report.

Variable cost — sum of shop__order_item.cost × count (snapshotted internal cost per unit at item-create time, FX-converted to the order currency) for every non-storno item attributed to this branch whose revenue date falls in the month. Positive magnitude; subtracted from net and displayed as a signed negative number in the Finance grid + PDF report ("Variabilní náklady" column).

revenue − franchiseFeeAmount + writeoff − costAmount − gatewayFeeAmount − variableCost (what the branch keeps).

Most recent settlement order for this month, including storno rows so the Finance grid can render "storno" as a distinct icon state. Omitted only when no order has ever been issued.