Skip to content

Chart · GRF-007 · v1.0

Pareto 80/20

Which categories explain 80% of the total.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Pareto 80/20 · October 2026GRF-007 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-007 v1.0
Meridian Coffee Co. (Demo) · Pareto 80/20 · October 2026GRF-007 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-007 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
GRF-007 · Pareto 80/20 · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx) with value, % and cumulative % in formulas, a native combo chart and a Control sheet
  • PNG (2×, 16:9) and SVG for Word or PowerPoint
  • Alt text (alt.txt) ready to paste

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

What it includes

5 sections, in this order

  1. 01Action title: how many categories explain the cut-off and what share of the total
  2. 02Columns from largest to smallest; the vital few in a dark tone and the rest in gray
  3. 03Cumulative % curve on the right axis (0–100%) with a dotted cut-off line
  4. 04Vertical marker after the last category within the cut-off, labeled «N of M = X%»
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed364
  2. 1Role, audience and business context391
  3. 2Parameters281
  4. 3Repporti standard244
  5. 4Data contract: valores.csv or .xlsx693
  6. 5Questions first144
  7. 6Validation with a stop475
  8. 7Calculation and drawing by code419
  9. 7-bisNo-code modeFixed273
  10. 8Numeric rules185
  11. 9Chart structure436
  12. 10Title and texts291
  13. 11Notation and accessibility233
  14. 12QA, traceability and seal486
The licensed prompt is provided when copied.≈ 26,742 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 / firmFounder
Area
Profitability and costs
Frequency
Whenever you need it
Industry
All

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 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.