Chart · GRF-005 · v1.0
Actual / plan / prior-year bars (IBCS notation)
Actual, plan and prior year in IBCS notation.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the conclusion and the figure
- 02AC solid, PL outlined and PY gray on a single axis from zero
- 03Signed ΔPL variance bars, green or red depending on the metric
- 04Variance % pins when they fit
- 05Compact IBCS legend, note, source and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no repeated columns and valid units.
C2Income statement subtotals tie if the table includes them (N/A otherwise).
C3Sign convention: costs and expenses with a single sign.
C4Figures in the title, subtitle, note and alt text traceable to calculo.json, and a title in the direction of the column it mentions.
If the script ran
Repporti controls 4/4 · GRF-005 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 pasteFixed368
- 1Role, audience and business context439
- 2Parameters448
- 3Repporti standard280
- 4Data contract: serie.csv or .xlsx506
- 5Questions first199
- 6Validation with a stop464
- 7Calculation and drawing by code475
- 7-bisNo-code modeFixed312
- 8Numeric rules263
- 9Chart structure613
- 10Title and texts302
- 11Notation (IBCS / ISO 24896:2026) and accessibility250
- 12QA, traceability and seal463
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
What is IBCS notation?
An open standard (IBCS, adopted in ISO 24896) so management reports always read the same way: actual in dark fill, plan outlined, prior year gray and forecast hatched, with red and green only on signed variances.
Can I compare against prior year instead of plan?
Yes. You choose it in the initial questions; if there is no plan, variances go against prior year.
Does it work for expenses?
Yes. With better = down, an expense above plan is painted red and one below plan green.
What if my AI cannot run code?
It delivers the table with formulas and the steps to build the chart in Excel, and the footer says «NOT VERIFIED».
Close and accounting