Skip to content

Chart · GRF-012 · v1.0

RAG KPI table

KPIs, defined thresholds and deterioration signals.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · RAG KPI table · October 2026GRF-012 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-012 v1.0
Meridian Coffee Co. (Demo) · RAG KPI table · October 2026GRF-012 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-012 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
GRF-012 · RAG KPI table · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx) with status and trend in formulas, conditional formatting 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 with the count by status and the indicators outside green
  2. 02Indicator and formula, actual, green threshold and red threshold
  3. 03Status with a dot and a word (Green, Amber, Red, No threshold)
  4. 04Trend against prior year with ▲▼ and a figure
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed398
  2. 1Role, audience and business context498
  3. 2Parameters327
  4. 3Repporti standard219
  5. 4Data contract: indicadores.csv or .xlsx512
  6. 5Questions first303
  7. 6Validation with a stop489
  8. 7Calculation and drawing by code451
  9. 7-bisNo-code modeFixed243
  10. 8Rules444
  11. 9Table structure439
  12. 10Title and texts368
  13. 11Notation and accessibility310
  14. 12QA, traceability and seal461
The licensed prompt is provided when copied.≈ 27,295 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
Governance and financing
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 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.