Block · BLQ-006 · v1.0
Cash and cash conversion
From EBITDA to reconciled closing cash.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title with the change in cash and cash conversion
- 02Waterfall from EBITDA to the change in cash, with opening and closing balance
- 03Cash conversion, free cash flow and closing balance
- 04Reconciliation of book cash to the bank statements
- 05Bullets on the material movements and a note on assumptions
Controls 5/5
What it checks before writing a single figure
C1Complete data: recognized identifiers, numeric figures, no duplicates, with opening and closing cash and the period's EBITDA.
C2Signs: balance sheet balances and outflow lines in positive.
C3The bridge closes: EBITDA plus working capital, taxes, capital expenditure, financing and other items equals the change in the cash balance.
C4Bank reconciliation: closing book cash equals the bank statements plus cash on hand, less outstanding cheques and plus deposits in transit (N/A without a statement).
C5Every figure in the document exists in calculo.json with the same rounding and the title goes in the direction of the change in cash.
If the script ran
Repporti controls 5/5 · BLQ-006 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 paste your filesFixed556
- 1Role, audience and business context651
- 2Parameters554
- 3Repporti standard449
- 4Data contract1,058
- 5Questions first406
- 6Validation with a stop385
- 7Calculation by code250
- 7-bisNo-code modeFixed431
- 8Formulas697
- 9Structure1,047
- 10Writing without “AI slop” or inventions607
- 11Notation and accessibility377
- 12QA, traceability and seal824
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 block
Is this the statement of cash flows?
No. It is a management presentation that starts from EBITDA; the section says so and labels operating and free cash flow as management measures, under your framework.
What if the bridge does not close?
The script stops and shows the unexplained difference. The AI asks what is missing (a balance, a dividend, a contribution) and never adds a plug.
What if I do not have the bank statement?
The bridge is calculated anyway, but the reconciliation is marked not applicable and the section says cash was not reconciled to the bank.
Treasury and cash