Skip to content

Block · BLQ-006 · v1.0

Cash and cash conversion

From EBITDA to reconciled closing cash.

PaidGlobal standardStandard 2026.10Controls 5/5DOCXXLSXPPTX
Meridian Coffee Co. (Demo) · Cash and cash conversion · October 2026BLQ-006 · Block · 16:9
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · BLQ-006 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
BLQ-006 · Cash and cash conversion · October 2026 · illustrative example with fictitious data
  • One-page Word (.docx) section with the waterfall
  • Excel (.xlsx) with Data, Bridge (live formulas), Reconciliation and Control
  • puente.json ready for the waterfall chart (GRF-001)
  • Optional PowerPoint (.pptx) slide

Instructions for your AI; check sections, output files and controls before copying.

What it includes

5 sections, in this order

  1. 01Action title with the change in cash and cash conversion
  2. 02Waterfall from EBITDA to the change in cash, with opening and closing balance
  3. 03Cash conversion, free cash flow and closing balance
  4. 04Reconciliation of book cash to the bank statements
  5. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed556
  2. 1Role, audience and business context651
  3. 2Parameters554
  4. 3Repporti standard449
  5. 4Data contract1,058
  6. 5Questions first406
  7. 6Validation with a stop385
  8. 7Calculation by code250
  9. 7-bisNo-code modeFixed431
  10. 8Formulas697
  11. 9Structure1,047
  12. 10Writing without “AI slop” or inventions607
  13. 11Notation and accessibility377
  14. 12QA, traceability and seal824
The licensed prompt is provided when copied.≈ 30,342 characters + cuadre.py (968 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 / CFOAccountant / firmFounder
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 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.