Skip to content
Next drop: Friday, October 9

Dashboard · TAB-001 · v1.0

CFO cockpit

One screen with 8 KPIs, 12 months of results, cash, working capital and alerts, in Excel and as a Power BI package (model, DAX measures, theme and guide).

ProGlobal 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

The dashboard the owner or the committee reads every month in 60 seconds: an action headline, 8 KPI cards against budget with a 12-month sparkline, 12 months of revenue and EBITDA in IBCS notation, cash against the minimum balance, working capital (days sales, inventory and payables outstanding and the cash cycle) and 3 to 5 alerts ranked by impact.

Before building anything, the deterministic kit checks the month’s subtotals and the dashboard script checks all 12 months: gross profit, operating profit, EBITDA and profit for the period against their lines in every month, the same months in every file and the cash cycle equal to receivable + inventory − payable days. If a month does not tie, it stops and asks.

It delivers the Excel workbook (screen, data, calculation with live formulas and a Control sheet) and a Power BI folder with the model in CSV, the DAX measures, the JSON theme and the layout guide. Alerts only quote figures from the calculation and causes with a source.

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

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 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 text is delivered when you copy, with your license. It is never on this page.≈ 29,217 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 / CFOFounderAccountant / firm
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 dashboard

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

More from this area to combine

See the whole area