Skip to content

Report guide · REP-011 · v1.0

Antares · Profitability by customer, product or line

Which clients and products retain margin after service.

PaidGlobal standardStandard 2026.10Controls 6/6MonthlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Profitability by customer, product or line · October 2026REP-011 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 6/6 · REP-011 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 6/6
REP-011 · Profitability by customer, product or line · October 2026 · illustrative example with fictitious data
  • Word (.docx), 6 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Sales, Cost_to_serve, Allocation, Profitability, Pareto, Bridge, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with 1 to 3 slides

Instructions for your AI; check sections, output files and controls before copying.

What it includes

6 sections, in this order

  1. 01In 30 seconds: how many items make 80% of contribution, how much the tail destroys and the decision being asked for
  2. 02Profitability map by the main dimension: revenue, gross profit, cost to serve and contribution
  3. 0380/20 Pareto with the cumulative curve
  4. 04Tail and low margin, each item with its measurable cause or «[to be confirmed]»
  5. 05Contribution margin by line and channel
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed594
  2. 1Role, audience and business context741
  3. 2Parameters1,049
  4. 3Repporti standard328
  5. 4Data contract1,245
  6. 5Questions first542
  7. 6Validation with a hard stop1,057
  8. 7Calculation by code1,213
  9. 7-bisNo-code modeFixed497
  10. 8Formulas1,526
  11. 9Structure1,639
  12. 10Writing without «AI slop» and without invention1,002
  13. 11Theme and notation1,019
  14. 12QA, traceability and seal976
The licensed prompt is provided when copied.≈ 35,540 characters + cuadre.py (1,124 lines)

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 Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck profile and period before copying.
  2. 02Paste into your AIPaste the prompt and attach anonymized files in your AI.
  3. 03Review and deliverCheck controls and seal before sharing.

Anonymize before pasting

  • Company → alias; tax identifier → ID-XX.
  • People → codes. Keep the mapping on your device.
  • Use business AI, API or disable training.

Files and figures go to your AI; Repporti does not receive them.

Made for whoever delivers the report

Who it is for

Finance manager / CFOAccountant / firm
Area
Profitability and costs
Frequency
Monthly
Industry
Retail and wholesale, Manufacturing, Services

Which AI it works with

Compatibility

LevelAI
With code executionChatGPT · ClaudeRequires file analysis and Python execution for cuadre.py.
No-code modeCopilot · GeminiExcel 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.