Skip to content
Next drop: Friday, October 9

Chart · GRF-001 · v1.0

EBITDA bridge

The budget-to-actual EBITDA bridge (waterfall) that checks the math before drawing, rounds without breaking the totals and uses IBCS colors.

FreeGlobal standardStandard 2026.10Controls 4/4XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · EBITDA bridge · October 2026GRF-001 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-001 v1.0
Meridian Coffee Co. (Demo) · EBITDA bridge · October 2026GRF-001 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-001 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
GRF-001 · EBITDA bridge · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx) with a native stacked-column chart linked to formulas and a Control sheet
  • PNG (2×, 16:9) and SVG for Word or PowerPoint
  • Alt text (alt.txt) ready to paste

One chart that answers what moved EBITDA: from budget (or prior year) to actual, step by step, with the start and end bars resting on zero and the effects floating between them.

Before drawing, the script checks that start plus steps equals end and reconciles it to the income statement; if it does not tie, it does not draw. It picks the scale (thousands or millions of your currency) so the labels are readable and, if rounding breaks the total, it allocates the difference by largest remainder: the bridge as shown always ties.

It produces a native Excel chart (stacked columns linked to formulas, Control sheet = 0), the PNG and SVG for Word or PowerPoint, and the alt text. The AI only writes the title, and the script checks its figures and direction. EBITDA is labeled as an alternative performance measure, as your framework requires.

What it includes

4 sections, in this order

  1. 01Action title at the top left
  2. 02Solid start and end bars; floating steps with signs
  3. 03Dotted connectors and direct labels
  4. 04Footer with source, unit and seal

Controls 4/4

What it checks before writing a single figure

  • C1Structure: unique labels, at least one step, an action title and a subtitle.

  • C2The bridge ties: start + Σ steps = end, within half a displayed unit.

  • C3Reconciliation to source: start and end = budget and income statement EBITDA (N/A if not given).

  • C4Figures in the title, subtitle, source and alt text traceable, and a title in the bridge's direction.

If the script ran

Repporti controls 4/4 · GRF-001 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}

If it did not run

NOT VERIFIED — controls not executed by code. Review the Control sheet of the XLSX.

If a control fails, the AI stops, shows the difference and asks how to proceed. It never forces the numbers to reconcile.

Prompt outline

What the prompt contains, block by block

  1. 0Before you pasteFixed393
  2. 1Role, audience and business context378
  3. 2Parameters597
  4. 3Repporti standard301
  5. 4Data contract: puente.json715
  6. 5Questions first177
  7. 6Validation with a hard stop297
  8. 7Calculation and drawing by code521
  9. 7-bisNo-code modeFixed318
  10. 8Numeric rules262
  11. 9Chart structure430
  12. 10Title and texts329
  13. 11Notation (IBCS / ISO 24896:2026) and accessibility398
  14. 12QA, traceability and seal587
The text is delivered when you copy, with your license. It is never on this page.≈ 25,699 characters + cuadre.py (426 lines)

Core available in: Spanish · English

Repporti Standard

It comes out adapted to your report profile

Compatible with every country and framework in the Standard: when you copy, it is composed with your profile (country, accounting framework, report language, currency, unit and year-end). Terminology, number format and statement names come from the Standard, not from the prompt.

See the Repporti Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck your report profile (country, framework, language, currency) and the period. The prompt is assembled in your browser.
  2. 02Paste into your AIOpen ChatGPT or Claude, attach your anonymized files and paste the prompt.
  3. 03Review and deliverReview the controls table and the seal. If something does not reconcile, the AI stops and asks.

Anonymize before pasting

  • Company name → an alias (“Client 07”); tax ID → “ID-XX”.
  • Customers, suppliers and employees → codes (C001, P001, E001). The mapping table stays on your computer.
  • Use an AI that does not train on your data: business plan, API or training turned off.

Repporti neither receives nor stores your files or your figures: the prompt is assembled in your browser and your files go straight to your AI.

Who it is for

Made for whoever delivers the report

Finance manager / CFOAccountant / firmFounder
Area
Profitability and costs
Frequency
Whenever you need it
Industry
All

Compatibility

Which AI it works with

LevelAI
With code executionChatGPT · ClaudeDesigned for plans with data analysis (ChatGPT) or code execution (Claude): cuadre.py runs inside the AI.
No-code modeCopilot · GeminiGenerates the Excel file with formulas and a Control sheet. The footer says “NOT VERIFIED” unless you run cuadre.py on your computer.

Questions

About this chart

Why not use Excel's «Waterfall» chart?

Because it cannot be generated reliably by code and does not open in older versions. Stacked columns with an invisible base work in any Excel and stay linked to formulas.

Can I go from prior year to current year?

Yes. Change the start and end labels and the steps; the tie-out check and the rounding work the same way.

Is it called EBITDA in every country?

The chart uses the Standard's term for your country and language (EBITDA, UAFIDA, EBE…) and labels it as an alternative measure with its definition.

What if my AI cannot run code?

It delivers the table with formulas and instructions to build the chart in Excel, and the footer says «NOT VERIFIED».

Profitability and costs

More from this area to combine

See the whole area