Report guide · REP-011 · v1.0
Antares · Profitability by customer, product or line
Which clients and products retain margin after service.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01In 30 seconds: how many items make 80% of contribution, how much the tail destroys and the decision being asked for
- 02Profitability map by the main dimension: revenue, gross profit, cost to serve and contribution
- 0380/20 Pareto with the cumulative curve
- 04Tail and low margin, each item with its measurable cause or «[to be confirmed]»
- 05Contribution margin by line and channel
- 06Decisions with impact, owner and date; appendix with the allocation method, the bridge to operating profit, controls and glossary
Controls 6/6
What it checks before writing a single figure
C1Complete sales: no repeated rows, codes present, numeric revenue and cost; negative revenue only with the credit note explained.
C2Reconciled to the trial balance: total net revenue and cost of sales match the period's trial balance (N/A without a trial balance).
C3Reconciled cost to serve: each item adds up to its account balance and no customer with cost to serve is missing from sales.
C4Gross margins between 0% and 90% or explained, and the bridge on the Control sheet: total contribution − unallocated fixed costs = operating profit per the trial balance.
C5Figures table valid for the kit: numeric values, no repeated lines, valid units, costs with a single sign and gross profit = revenue − cost of sales (cuadre.py validar).
C6Traceable figures: every figure in the Word file (and the PowerPoint) exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-011 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}
If it did not run
UNVERIFIED: code not run. Review Control in Excel.
What the prompt contains, block by block
Prompt outline
- 0Before you paste your filesFixed594
- 1Role, audience and business context741
- 2Parameters1,049
- 3Repporti standard328
- 4Data contract1,245
- 5Questions first542
- 6Validation with a hard stop1,057
- 7Calculation by code1,213
- 7-bisNo-code modeFixed497
- 8Formulas1,526
- 9Structure1,639
- 10Writing without «AI slop» and without invention1,002
- 11Theme and notation1,019
- 12QA, traceability and seal976
Core available in: Spanish · English
It comes out adapted to your report profile
Repporti Standard
Your profile sets country, framework, language, currency, scale and year-end.
See the Repporti StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Profitability and costs
- Frequency
- Monthly
- Industry
- Retail and wholesale, Manufacturing, Services
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel with Control sheet; UNVERIFIED until cuadre.py runs. |
Questions
About this report guide
Can I analyse it by product or channel instead of by customer?
Yes. You choose the main dimension (customer, product, line or channel) and the others come out as summaries. A customer's cost to serve is split across its lines or channels in proportion to its revenue in each.
What if I don't have cost to serve by customer?
You give the total of each item (its account in the trial balance) and the driver used to allocate it: kg, orders, deliveries or % of revenue. The AI states it as an assumption and leaves the drivers editable on the Allocation sheet.
Why doesn't it allocate fixed costs to customers?
Because any allocation of overheads or depreciation is arbitrary and can make a contributing customer look unprofitable. They are shown separately, in the bridge from contribution to operating profit. If you ask, the AI allocates them and flags the allocation as arbitrary.
What about credit notes and returns?
Sales must be net of discounts and returns. A row with negative revenue is only accepted if notas.txt explains the credit note; otherwise the AI stops and asks.
What if my AI cannot run code?
It switches to no-code mode: it builds the Excel file with formulas by dimension and a Control sheet, and the Word footer says «NOT VERIFIED». You can run cuadre.py on your computer and get the seal later.
Profitability and costs