Skip to content

Chart · GRF-004 · v1.0

P&L table with traffic lights

Actual, budget and variance with economic signals.

Understand simplified results

The Process organizes manual work; it does not run or validate resources.

PaidGlobal standardStandard 2026.10Controls 5/5XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Income statement · October 2026GRF-004 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · GRF-004 v1.0
Meridian Coffee Co. (Demo) · Income statement · October 2026GRF-004 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · GRF-004 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
01 / 02
GRF-004 · Income statement · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx) with live formulas, conditional-format traffic lights and a Control sheet
  • PNG (2×) and SVG of the table 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

4 sections, in this order

  1. 01Line · Actual · Budget · Var · Var % · traffic light
  2. 02Subtotals in bold on a light background
  3. 03Note with the traffic-light rule and materiality
  4. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed379
  2. 1Role, audience and business context493
  3. 2Parameters465
  4. 3Repporti standard349
  5. 4Data contract: pyg.csv or .xlsx678
  6. 5Questions first198
  7. 6Validation with a hard stop311
  8. 7Calculation and drawing by code344
  9. 7-bisNo-code modeFixed394
  10. 8Traffic-light rules376
  11. 9Table structure452
  12. 10Title and texts313
  13. 11Notation (IBCS / ISO 24896:2026, theme TEM-001) and accessibility348
  14. 12QA, traceability and seal545
The licensed prompt is provided when copied.≈ 27,479 characters + cuadre.py (1,249 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
Close and accounting
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

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.