Skip to content

Block · BLQ-005 · v1.0

Line-by-line P&L commentary

One action sentence per material line.

PaidGlobal standardStandard 2026.10Controls 4/4DOCXXLSXPPTX
Meridian Coffee Co. (Demo) · Line-by-line P&L commentary · October 2026BLQ-005 · Block · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · BLQ-005 v1.0
Meridian Coffee Co. (Demo) · Line-by-line P&L commentary · October 2026BLQ-005 · Block · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · BLQ-005 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
BLQ-005 · Line-by-line P&L commentary · October 2026 · illustrative example with fictitious data
  • One-page Word (.docx) section with the commented table
  • Excel (.xlsx) with Data, Calculation (variance, favorable and material as formulas) and a subtotal Control sheet
  • Optional PowerPoint (.pptx) slide with the material lines

Instructions for your AI; check sections, output files and controls before copying.

What it includes

5 sections, in this order

  1. 01Action title with the line that explains the result
  2. 02Income statement table: actual, comparative, variance and variance %
  3. 03One-sentence comment on every material line: what, why and who
  4. 04Margins with their difference in percentage points
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed530
  2. 1Role, audience and business context522
  3. 2Parameters593
  4. 3Repporti standard369
  5. 4Data contract963
  6. 5Questions first307
  7. 6Validation with a stop407
  8. 7Calculation by code407
  9. 7-bisNo-code modeFixed519
  10. 8Formulas and comment rules771
  11. 9Structure880
  12. 10Writing without “AI slop” or inventions634
  13. 11Notation and accessibility446
  14. 12QA, traceability and seal860
The licensed prompt is provided when copied.≈ 30,258 characters + cuadre.py (1,124 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

Accountant / firmFinance manager / CFO
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 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.