Chart · GRF-004 · v1.0
P&L table with traffic lights
Actual, budget and variance with economic signals.
The Process organizes manual work; it does not run or validate resources.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
4 sections, in this order
- 01Line · Actual · Budget · Var · Var % · traffic light
- 02Subtotals in bold on a light background
- 03Note with the traffic-light rule and materiality
- 04Footer with source, unit and seal
Controls 5/5
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no duplicate lines and valid units.
C2Subtotals add up: UB, UO, EBITDA, UAI and UN equal the sum of their lines, in actual and in the comparative.
C3Sign convention: costs and expenses with a single sign.
C4There is a comparative with figures for the traffic light: budget or prior year.
C5Figures in the subtitle, alt text, document and title traceable to calculo.json.
If the script ran
Repporti controls 5/5 · GRF-004 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 pasteFixed379
- 1Role, audience and business context493
- 2Parameters465
- 3Repporti standard349
- 4Data contract: pyg.csv or .xlsx678
- 5Questions first198
- 6Validation with a hard stop311
- 7Calculation and drawing by code344
- 7-bisNo-code modeFixed394
- 8Traffic-light rules376
- 9Table structure452
- 10Title and texts313
- 11Notation (IBCS / ISO 24896:2026, theme TEM-001) and accessibility348
- 12QA, traceability and seal545
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 is each line's color decided?
Green if the variance is favorable for that line type; amber if it is unfavorable and below materiality; red if it is unfavorable and above materiality in both percentage and amount.
Can I compare against prior year?
Yes: choose prior year as the traffic-light comparative. If you have both, budget rules and prior year can go in an extra column.
Does it work with my company's own lines?
Yes. Add the «mejor» column (sube or baja) so the traffic light does not have to infer the direction from the name.
Close and accounting