ORIGINAL STABLE REPORTING RULES
No temporary business facts are stored here.
Required fictional CSV fields: job_id, date, client, status, amount_usd. One row is one job. Currency USD.
Period is inclusive. Select by date; group by status in the supplied cutoff snapshot. No completion timestamps are supplied by the lesson inputs.
Completed value sums valid amounts for selected completed jobs only. Scheduled and cancelled groups remain separate. Account for all rows once, and reconcile completed client amounts with the headline total. Show empty groups as zero.
Blank numeric values are unknown. Do not infer zero, copy a value from a clean fixture, or call a known subtotal the full amount. Identify missing IDs and state which totals are unavailable. Valid counts can still be reported.
Duplicate IDs, ambiguous dates, unknown statuses, missing columns, mixed currencies, or source conflicts require a stated treatment rather than silent cleaning.
Notes supply follow-ups, requested dates, and owner status. A requested follow-up date is not a completion deadline. Unknown owners/reasons/dates stay unknown. Proposed actions remain proposals.
No payment, costs, profit, tax, refund, cause, or trend claims without current supporting sources. No external action authority is supplied by this procedure.
