Skip to content
Next drop: Friday, October 9

Chart · GRF-002 · v1.0

KPI card with sparkline

A card with the month's value, its variance with ▲▼ and sign against budget, prior year or prior month, and a 12-month sparkline.

FreeGlobal standardStandard 2026.10Controls 3/3XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · KPI card · October 2026GRF-002 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 3/3 · GRF-002 v1.0
Meridian Coffee Co. (Demo) · KPI card · October 2026GRF-002 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 3/3 · GRF-002 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 3/3
01 / 02
GRF-002 · KPI card · October 2026 · illustrative example with fictitious data
  • PNG (1200 × 675 px) and SVG of the card
  • Excel (.xlsx) with Data, Card with formulas, native sparkline and Control
  • Alt text (alt.txt) ready to paste

A KPI card you understand in three seconds: name, big number, one variance line per comparative and, next to it, the sparkline for the last twelve months with the minimum, maximum and last point marked.

Before drawing, the script checks that the series is complete, with no repeated or missing months, and reconciles the last month to the income statement figure if you provide it. The sparkline's last point is exactly the card's value.

It comes out as PNG and SVG for Word or PowerPoint and as an Excel file with a native sparkline linked to the data, plus the alt text. It works for revenue, margin, cash, DSO or any monthly KPI.

What it includes

4 sections, in this order

  1. 01KPI name
  2. 02Value for the month
  3. 03Variances with ▲▼ against Budget, PY and prior month
  4. 0412-month sparkline with minimum, maximum and last point

Controls 3/3

What it checks before writing a single figure

  • C1Complete series: valid, consecutive months with no duplicates and at least 6 months of the KPI.

  • C2Reconciliation: the series' last month is the income statement or dashboard figure (N/A if not given).

  • C3Figures in the subtitle, alt text and title traceable, and a title in the direction of the variance it mentions.

If the script ran

Repporti controls 3/3 · GRF-002 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 pasteFixed435
  2. 1Role, audience and business context510
  3. 2Parameters357
  4. 3Repporti standard194
  5. 4Data contract: serie.csv or .xlsx850
  6. 5Preliminary questions250
  7. 6Validation with a hard stop403
  8. 7Calculation and drawing by code338
  9. 7-bisNo-code modeFixed273
  10. 8Numeric rules350
  11. 9Card structure422
  12. 10Title and texts289
  13. 11Notation (IBCS) and accessibility270
  14. 12QA, traceability and seal560
The text is delivered when you copy, with your license. It is never on this page.≈ 25,447 characters + cuadre.py (784 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

How many months do I need?

At least six; ideally twelve for the sparkline and thirteen if you want the variance against the same month last year.

Does it work for KPIs in percent or days?

Yes. Give the unit (pct, days, months, times or number) and whether higher or lower is better; percentage changes come out in percentage points.

What if a month is missing?

The script does not draw: it shows the gap and asks. It never fills in months on its own.

Close and accounting

More charts in this area

See the whole area