Chart · GRF-002 · v1.0
KPI card with sparkline
Value, variance and twelve-month trend.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
4 sections, in this order
- 01KPI name
- 02Value for the month
- 03Variances with ▲▼ against Budget, PY and prior month
- 0412-month sparkline with minimum, maximum and last point
Controls 3/3
What it checks before writing a single figure
C1Complete series: valid, consecutive months with no duplicates and at least 6 months of the KPI.
C2Reconciliation: the series' last month is the income statement or dashboard figure (N/A if not given).
C3Figures in the subtitle, alt text and title traceable, and a title in the direction of the variance it mentions.
If the script ran
Repporti controls 3/3 · GRF-002 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 pasteFixed435
- 1Role, audience and business context510
- 2Parameters357
- 3Repporti standard194
- 4Data contract: serie.csv or .xlsx850
- 5Preliminary questions250
- 6Validation with a hard stop403
- 7Calculation and drawing by code338
- 7-bisNo-code modeFixed273
- 8Numeric rules350
- 9Card structure422
- 10Title and texts289
- 11Notation (IBCS) and accessibility270
- 12QA, traceability and seal560
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
How many months do I need?
At least six; ideally twelve for the sparkline and thirteen if you want the variance against the same month last year.
Does it work for KPIs in percent or days?
Yes. Give the unit (pct, days, months, times or number) and whether higher or lower is better; percentage changes come out in percentage points.
What if a month is missing?
The script does not draw: it shows the gap and asks. It never fills in months on its own.
Close and accounting