Chart · GRF-003 · v1.0
Bullet chart: actual vs target
Each KPI against target and ranges.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title: which KPIs reach their target and which do not
- 02One row per KPI on its own scale, from zero
- 03Poor, acceptable and good ranges in grays; actual in graphite; target as a vertical marker
- 04Direct label with actual, ▲▼, variance and variance % against target
- 05Note with where targets and ranges come from, source and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no repeated KPIs and valid units.
C2Income statement subtotals tie if the table includes them (N/A otherwise).
C3Sign convention: costs and expenses with a single sign.
C4Figures in the title, subtitle, note and alt text traceable to calculo.json, and a title in the direction of the KPI it mentions.
If the script ran
Repporti controls 4/4 · GRF-003 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 pasteFixed317
- 1Role, audience and business context433
- 2Parameters406
- 3Repporti standard262
- 4Data contract: kpis.csv or .xlsx630
- 5Questions first242
- 6Validation with a stop432
- 7Calculation and drawing by code588
- 7-bisNo-code modeFixed270
- 8Numeric rules351
- 9Chart structure491
- 10Title and texts330
- 11Notation (IBCS / ISO 24896:2026) and accessibility220
- 12QA, traceability and seal463
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
- Close and accounting
- 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
Why a bullet chart and not a gauge?
Because a gauge takes a lot of space for a single figure and cannot be compared. The bullet shows actual, target and ranges in one row, and several KPIs fit in half a page.
What if I have no ranges?
The prompt asks for them. If you reply «continue», it uses 70%, 90% and 115% of the target and states it as an assumption in the chart note.
Does it work for KPIs where lower is better, such as days sales outstanding?
Yes. With better = down the ranges are reversed and the label marks an actual below target as favorable.
What if my AI cannot run code?
It delivers the table with formulas and the steps to build the chart in Excel, and the footer says «NOT VERIFIED».
Close and accounting