Skip to content

Chart · GRF-008 · v1.0

Line with forecast band

Actual, forecast and uncertainty in one series.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Cash balance · actual and forecastGRF-008 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-008 v1.0
Meridian Coffee Co. (Demo) · Cash balance · actual and forecastGRF-008 · Chart · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · GRF-008 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
GRF-008 · Cash balance · actual and forecast · illustrative example with fictitious data
  • Excel (.xlsx) with the series, band and threshold in formulas, a native chart and a Control sheet
  • PNG (2×, 16:9) and SVG for Word or PowerPoint
  • Alt text (alt.txt) describing trend, threshold crossing and band

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

What it includes

5 sections, in this order

  1. 01Action title: where the figure is heading and whether it crosses the threshold
  2. 02Actuals as a solid line with markers and a dotted forecast from the last actual
  3. 03Uncertainty band in light gray, behind the line
  4. 04Labeled horizontal threshold and a marker on the lowest week
  5. 05Note with the forecast source, the band rule, source and seal

Controls 4/4

What it checks before writing a single figure

  • C1Complete data: recognized headers, numeric figures, no repeated months and valid units.

  • C2Income statement subtotals tie if the table includes them (N/A for a series).

  • 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 figure it mentions against the threshold.

If the script ran

Repporti controls 4/4 · GRF-008 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 pasteFixed338
  2. 1Role, audience and business context478
  3. 2Parameters286
  4. 3Repporti standard223
  5. 4Data contract642
  6. 5Questions first261
  7. 6Validation with a stop597
  8. 7Calculation and drawing by code437
  9. 7-bisNo-code modeFixed343
  10. 8Numeric rules309
  11. 9Chart structure566
  12. 10Title and texts295
  13. 11Notation (IBCS / ISO 24896:2026) and accessibility218
  14. 12QA, traceability and seal463
The licensed prompt is provided when copied.≈ 27,285 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

Finance manager / CFOFounderAccountant / firm
Area
Treasury and cash
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 chart

Does the AI build the forecast?

No. It draws the forecast you give it (your 13-week cash flow, your budget or your forecast). If you do not have one, build REP-008 or REP-010 first.

Where does the band come from?

If your model has pessimistic and optimistic scenarios, they are used as they are. If not, the prompt applies ±5% in the first forecast month, ±10% in the second and so on, and states it as an assumption in the note.

Does it work for revenue or EBITDA, not just cash?

Yes. Any monthly series with actuals and a forecast; the threshold can be a target or a covenant.

What if the forecast does not start from the last actual?

It stops: it shows the difference between the forecast opening balance and the last actual, and asks. It is the most common error of an outdated forecast.