Block · BLQ-013 · v1.0
Prior-year comparison
Growth and margins against prior year.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with revenue and profit growth
- 02Period table: prior year, actual, variance and variance %
- 03Year-to-date table against the same stretch of the prior year (optional)
- 04Margins with their difference in percentage points
- 05Bullets: growth, margins, lines growing faster than revenue and comparability
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 both actual and prior year (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 revenue.
If the script ran
Repporti controls 4/4 · BLQ-013 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 filesFixed570
- 1Role, audience and business context612
- 2Parameters577
- 3Repporti standard354
- 4Data contract925
- 5Questions first495
- 6Validation with a stop404
- 7Calculation by code305
- 7-bisNo-code modeFixed431
- 8Formulas and rules869
- 9Structure891
- 10Writing without “AI slop” or inventions540
- 11Notation and accessibility372
- 12QA, traceability and seal800
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
What if the prior year is not comparable?
Say so when the AI asks or in your notes: the bullet flags the growth as not comparable. Like-for-like figures only appear if they come as lines in your file.
Does it work in high-inflation countries?
Yes. It asks whether the prior year is restated to closing currency; if not, it warns that growth is nominal.
Do I need year to date?
No. If you add it as «… year to date» lines it is compared the same way; if not, the section covers the period only.
Close and accounting