Skip to content

Dashboard guide · TAB-002 · v1.0

Cash and treasury

Banks, forecast and weeks below minimum.

PaidGlobal standardStandard 2026.10Controls 4/4XLSXPower BI
Meridian Coffee Co. (Demo) · Cash and treasury · October 2026TAB-002 · Dashboard · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · TAB-002 v1.0
Meridian Coffee Co. (Demo) · Cash and treasury · October 2026TAB-002 · Dashboard · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 4/4 · TAB-002 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 4/4
01 / 02
TAB-002 · Cash and treasury · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx): Dashboard, Data, Calculation with live formulas, Control and Notes
  • Power BI: model in CSV (accounts, weeks, balances and flows), 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 on cash at cut-off and the lowest week
  2. 02Cards: cash in the books, available cash, headroom over the minimum, lowest week and month accuracy
  3. 03Balances by account and concentration by bank, with the statement-to-books reconciliation
  4. 0412 months of cash and the 13-week forecast with the minimum and the lowest week
  5. 05Inflows and outflows by week, and actual against forecast for the month by category
  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 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you pasteFixed482
  2. 1Role, audience and business context688
  3. 2Parameters440
  4. 3Repporti standard262
  5. 4Data contract1,166
  6. 5Questions first429
  7. 6Validation with a stop832
  8. 7Calculation and build by code781
  9. 7-bisNo-code modeFixed322
  10. 8Formulas and measures792
  11. 9Dashboard structure1,028
  12. 10Headline, alerts and texts740
  13. 11Theme, notation (IBCS / ISO 24896:2026) and accessibility344
  14. 12QA, traceability and seal513
The licensed prompt is provided when copied.≈ 30,836 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 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.