Skip to content

Dashboard guide · TAB-001 · v1.0

CFO cockpit

Eight KPIs, cash and alerts on one screen.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXPower BI
Meridian Coffee Co. (Demo) · CFO cockpit · October 2026TAB-001 · Dashboard · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · TAB-001 v1.0
Meridian Coffee Co. (Demo) · CFO cockpit · October 2026TAB-001 · Dashboard · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · TAB-001 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
TAB-001 · CFO cockpit · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx): Dashboard, Data, Calculation with live formulas, Control and Notes
  • Power BI: model in CSV (dimensions and facts), medidas.dax, tema_powerbi.json and a layout guide
  • PNG (2×, 16:9) of the screen and alt text per block

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

What it includes

6 sections, in this order

  1. 01Action headline with the month’s conclusion
  2. 028 KPI cards: value, ▲▼ against budget and a 12-month sparkline
  3. 0312 months of revenue and EBITDA: actual, budget and prior year
  4. 04Month-end cash against the minimum balance and weekly forecast
  5. 05Working capital: receivable, inventory and payable days and the cash cycle against target
  6. 06Alerts (3 to 5) and a note with sources, policies and seal

Controls 4/4

What it checks before writing a single figure

  • C1Complete data: recognized headers, numeric figures, no repeated lines or KPIs and valid units.

  • C2The month’s income statement subtotals tie (gross profit, operating profit, EBITDA, before tax and for the period); the dashboard script repeats the test for all 12 months.

  • C3Sign convention: costs and expenses with a single sign.

  • C4Figures in the headline, alerts, notes and alt texts traceable to calculo.json, and a headline in the direction of the key figure.

If the script ran

Repporti controls 4/4 · TAB-001 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 pasteFixed543
  2. 1Role, audience and business context615
  3. 2Parameters476
  4. 3Repporti standard312
  5. 4Data contract1,166
  6. 5Questions first412
  7. 6Validation with a stop747
  8. 7Calculation and build by code962
  9. 7-bisNo-code modeFixed343
  10. 8Formulas and measures931
  11. 9Dashboard structure916
  12. 10Headline, alerts and texts669
  13. 11Theme, notation (IBCS / ISO 24896:2026) and accessibility451
  14. 12QA, traceability and seal530
The licensed prompt is provided when copied.≈ 31,101 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
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 dashboard guide

Does it create the Power BI .pbix file?

No: it delivers the model in CSV, the DAX measures, the JSON theme and a guide with the position of every visual. You import the CSVs, paste the measures and apply the theme in a few minutes.

What if I have no budget?

The cards compare against the prior month and the prior year, and the note says so. The dashboard never invents a budget.

Can I change the 8 KPIs?

Yes: the prompt asks which ones you want. If you reply «continue», it uses revenue, gross margin, EBITDA, profit for the period, cash, working capital, days sales outstanding and the cash conversion cycle.

How does it relate to the monthly close?

It summarizes REP-001 Polaris on one screen. If you use both, the figures match because they come from the same validated data.