Dashboard guide · TAB-002 · v1.0
Cash and treasury
Banks, forecast and weeks below minimum.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01Action headline on cash at cut-off and the lowest week
- 02Cards: cash in the books, available cash, headroom over the minimum, lowest week and month accuracy
- 03Balances by account and concentration by bank, with the statement-to-books reconciliation
- 0412 months of cash and the 13-week forecast with the minimum and the lowest week
- 05Inflows and outflows by week, and actual against forecast for the month by category
- 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 accounts or categories and valid units.
C2Income statement subtotals tie if the table includes them (N/A for treasury; the dashboard script checks the reconciliation and the 13 weeks).
C3Sign convention: inflows and outflows with a single sign.
C4Figures in the headline, alerts, notes and alt texts traceable to calculo.json.
If the script ran
Repporti controls 4/4 · TAB-002 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 pasteFixed482
- 1Role, audience and business context688
- 2Parameters440
- 3Repporti standard262
- 4Data contract1,166
- 5Questions first429
- 6Validation with a stop832
- 7Calculation and build by code781
- 7-bisNo-code modeFixed322
- 8Formulas and measures792
- 9Dashboard structure1,028
- 10Headline, alerts and texts740
- 11Theme, notation (IBCS / ISO 24896:2026) and accessibility344
- 12QA, traceability and seal513
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
- Treasury and cash
- 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 the AI build the 13-week forecast?
No. It uses the one you give it (for example, the one from REP-008 Orion). The dashboard presents it, joins it to actual cash and measures its accuracy.
What if the banks do not reconcile to the books?
It stops and shows the difference. You need to bring the missing item (uncleared check, deposit in transit, unrecorded fee); it never invents one.
Do I have to show account numbers?
No, and you should not: banks and accounts appear as codes (B01-CTE, B02-CTE…).
Does it work with several currencies?
Yes, if each balance comes converted to the reporting currency with its exchange rate in the note. The dashboard does not look up exchange rates on its own.
Treasury and cash