Chart · GRF-012 · v1.0
RAG KPI table
KPIs, defined thresholds and deterioration signals.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the count by status and the indicators outside green
- 02Indicator and formula, actual, green threshold and red threshold
- 03Status with a dot and a word (Green, Amber, Red, No threshold)
- 04Trend against prior year with ▲▼ and a figure
- 05One-line comment, only with a source; note with where thresholds come from, source and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no repeated indicators and valid units.
C2Income statement subtotals tie if the table includes them (N/A for an indicator table).
C3Sign convention: costs and expenses with a single sign.
C4Figures in the title, comments, note and alt text traceable to calculo.json (values, thresholds and counts by status).
If the script ran
Repporti controls 4/4 · GRF-012 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 pasteFixed398
- 1Role, audience and business context498
- 2Parameters327
- 3Repporti standard219
- 4Data contract: indicadores.csv or .xlsx512
- 5Questions first303
- 6Validation with a stop489
- 7Calculation and drawing by code451
- 7-bisNo-code modeFixed243
- 8Rules444
- 9Table structure439
- 10Title and texts368
- 11Notation and accessibility310
- 12QA, traceability and seal461
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
- Governance and financing
- 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 the AI propose the thresholds?
No. Thresholds are a management or committee decision. If one is missing, the indicator stays «no threshold» and the note says so.
How does it handle indicators where lower is better?
With better = down, green sits below red: 36 days sales outstanding with green up to 35 and red above 50 is amber.
Where do the comments come from?
From your notes for the month or from the data. If there is no source, the comment says «[cause to be confirmed by …]» instead of inventing one.
Can I use it with the indicators from REP-007?
Yes: REP-007 calculates the indicators from the trial balance and this table presents them with your thresholds.
Governance and financing