Skip to content
Next drop: Friday, October 9

Chart · GRF-003 · v1.0

Bullet chart: actual vs target

Several KPIs in little space: each with its actual bar, its target marker and three qualitative ranges, on its own scale.

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

The bullet chart replaces the gauge: in a single row it shows the actual, the target and whether the value sits in a poor, acceptable or good zone. From 3 to 8 KPIs stack one under another, each on its own scale from zero, so nobody compares the length of a currency bar with that of a margin in percent.

Before drawing, the deterministic kit checks that the table is complete, with no duplicate rows and numeric figures, and the chart script checks that every KPI has a target and that the ranges are in order. If something is missing, it stops and asks: it does not invent targets or ranges.

It delivers a native Excel chart linked to a data sheet with formulas, 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 against calculo.json.

What it includes

5 sections, in this order

  1. 01Action title: which KPIs reach their target and which do not
  2. 02One row per KPI on its own scale, from zero
  3. 03Poor, acceptable and good ranges in grays; actual in graphite; target as a vertical marker
  4. 04Direct label with actual, ▲▼, variance and variance % against target
  5. 05Note with where targets and ranges come from, source and seal

Controls 4/4

What it checks before writing a single figure

  • C1Complete data: recognized headers, numeric figures, no repeated KPIs 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 KPI it mentions.

If the script ran

Repporti controls 4/4 · GRF-003 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 pasteFixed317
  2. 1Role, audience and business context433
  3. 2Parameters406
  4. 3Repporti standard262
  5. 4Data contract: kpis.csv or .xlsx630
  6. 5Questions first242
  7. 6Validation with a stop432
  8. 7Calculation and drawing by code588
  9. 7-bisNo-code modeFixed270
  10. 8Numeric rules351
  11. 9Chart structure491
  12. 10Title and texts330
  13. 11Notation (IBCS / ISO 24896:2026) and accessibility220
  14. 12QA, traceability and seal463
The text is delivered when you copy, with your license. It is never on this page.≈ 25,375 characters + cuadre.py (919 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
Close and accounting
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 a bullet chart and not a gauge?

Because a gauge takes a lot of space for a single figure and cannot be compared. The bullet shows actual, target and ranges in one row, and several KPIs fit in half a page.

What if I have no ranges?

The prompt asks for them. If you reply «continue», it uses 70%, 90% and 115% of the target and states it as an assumption in the chart note.

Does it work for KPIs where lower is better, such as days sales outstanding?

Yes. With better = down the ranges are reversed and the label marks an actual below target as favorable.

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

More charts in this area

See the whole area