Block · BLQ-005 · v1.0
Line-by-line P&L commentary
One action sentence per material line.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the line that explains the result
- 02Income statement table: actual, comparative, variance and variance %
- 03One-sentence comment on every material line: what, why and who
- 04Margins with their difference in percentage points
- 05Note: comparative, materiality and assumptions
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no duplicate lines and valid units.
C2Gross profit, operating profit, EBITDA, profit before tax and profit for the period add up to their lines in actual and in every comparative (N/A if the table has no complete subtotals).
C3Sign convention: costs and expenses with a single sign.
C4Every figure in the document exists in calculo.json with the same rounding and the title goes in the direction of the key figure.
If the script ran
Repporti controls 4/4 · BLQ-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 paste your filesFixed530
- 1Role, audience and business context522
- 2Parameters593
- 3Repporti standard369
- 4Data contract963
- 5Questions first307
- 6Validation with a stop407
- 7Calculation by code407
- 7-bisNo-code modeFixed519
- 8Formulas and comment rules771
- 9Structure880
- 10Writing without “AI slop” or inventions634
- 11Notation and accessibility446
- 12QA, traceability and seal860
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 block
Which lines get a comment?
Only those above both the percentage threshold and the amount threshold against the main comparative. The rest show «—».
Can I add cost centers or product lines?
Yes, as sub-lines under their line. They are compared and commented the same way, but they are not part of the subtotal check.
What if I have no budget?
It comments against prior year or prior month, whichever is in your table, and says so in the note.
Close and accounting