Dashboard guide · TAB-001 · v1.0
CFO cockpit
Eight KPIs, cash and alerts on one screen.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01Action headline with the month’s conclusion
- 028 KPI cards: value, ▲▼ against budget and a 12-month sparkline
- 0312 months of revenue and EBITDA: actual, budget and prior year
- 04Month-end cash against the minimum balance and weekly forecast
- 05Working capital: receivable, inventory and payable days and the cash cycle against target
- 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.
What the prompt contains, block by block
Prompt outline
- 0Before you pasteFixed543
- 1Role, audience and business context615
- 2Parameters476
- 3Repporti standard312
- 4Data contract1,166
- 5Questions first412
- 6Validation with a stop747
- 7Calculation and build by code962
- 7-bisNo-code modeFixed343
- 8Formulas and measures931
- 9Dashboard structure916
- 10Headline, alerts and texts669
- 11Theme, notation (IBCS / ISO 24896:2026) and accessibility451
- 12QA, traceability and seal530
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 StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Close and accounting
- Frequency
- Whenever you need it
- Industry
- All
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel 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.
Close and accounting