Chart · GRF-007 · v1.0
Pareto 80/20
Which categories explain 80% of the total.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title: how many categories explain the cut-off and what share of the total
- 02Columns from largest to smallest; the vital few in a dark tone and the rest in gray
- 03Cumulative % curve on the right axis (0–100%) with a dotted cut-off line
- 04Vertical marker after the last category within the cut-off, labeled «N of M = X%»
- 05Note with what was left out (negatives, «Other»), source and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures and no repeated category.
C2Income statement subtotals tie if the table includes them (N/A for a Pareto).
C3Sign convention: costs and expenses with a single sign.
C4Figures in the title, subtitle, note and alt text traceable to calculo.json (number of categories, cut-off and cumulative %).
If the script ran
Repporti controls 4/4 · GRF-007 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 pasteFixed364
- 1Role, audience and business context391
- 2Parameters281
- 3Repporti standard244
- 4Data contract: valores.csv or .xlsx693
- 5Questions first144
- 6Validation with a stop475
- 7Calculation and drawing by code419
- 7-bisNo-code modeFixed273
- 8Numeric rules185
- 9Chart structure436
- 10Title and texts291
- 11Notation and accessibility233
- 12QA, traceability and seal486
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
- Whenever you need it
- Industry
- All
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 chart
Does it work for expenses or suppliers, not just customers?
Yes. Any list of positive values by category: sales by product, spend by account, purchases by supplier or receivables by customer. The title changes with what is measured.
What if my cut-off is not 80%?
The prompt asks: you can use 70%, 90% or whatever you decide. If you reply «continue», it uses 80%.
What about credit notes or negative balances?
They are not drawn inside the columns: the note reports them with their total, so the cumulative never exceeds 100%.
What if I have hundreds of categories?
It shows up to 25 and groups the rest in «Other» at the end. «Other» never counts toward the cut-off.
Profitability and costs