Report guide · REP-009 · v1.0
Capella · Working capital and cash conversion cycle
Tied-up cash and impact of cycle improvements.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01In 30 seconds: bottom line, 3 bullets and 5 cards (DSO, DIO, DPO, cycle and operating working capital)
- 0213-month trend in small multiples on the same scale
- 03Where the cash is: working capital bridge against prior year (activity and days)
- 04Receivables and payables: ageing, concentration and agreed terms
- 05Targets and decisions: the cash each day of improvement frees up, with an owner and a date
- 06Appendix: controls, assumptions, limitations and glossary
Controls 6/6
What it checks before writing a single figure
C1Complete series: 13 consecutive months ending in the period, no repeated months, with revenue and cost of sales in every month.
C2Reconciled cut-off: the last month matches the trial balance for receivables, inventory, payables, revenue and cost of sales (N/A without a trial balance).
C3Reconciled detail: receivables and payables by document add up to the cut-off balances (N/A without those files).
C4Identities on the Control sheet: working capital = receivables + inventory − payables; cycle = DSO + DIO − DPO; days effect + activity effect = change in working capital.
C5Figures table valid for the kit: numeric values, no repeated lines, valid units and costs with a single sign (cuadre.py validar).
C6Traceable figures: every figure in the Word file (and the PowerPoint) exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-009 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 filesFixed670
- 1Role, audience and business context745
- 2Parameters878
- 3Repporti standard346
- 4Data contract1,493
- 5Questions first488
- 6Validation with a hard stop1,016
- 7Calculation by code1,112
- 7-bisNo-code modeFixed521
- 8Formulas1,590
- 9Structure1,190
- 10Writing without «AI slop» and without invention1,000
- 11Theme and notation1,051
- 12QA, traceability and seal1,062
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
- Monthly
- 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 report guide
What if my system gives year-to-date results?
The prompt takes the month's movement (debits − credits for the month, or the difference between two cumulative balances) and states which one it used. If cumulative and monthly figures are mixed, the jump check catches it and asks before going on.
What if I have no targets in days?
Prior-year days for the same month are used and stated as an assumption. You can give your own targets and recalculate: the cash each one frees up comes from the script.
Why does the DPO target never exceed the agreed terms?
Paying after the due date does not free cash: it is a breach with the supplier. The DPO target is capped at the average agreed terms, calculated from the dates on your payables.
What if receivables include indirect taxes?
The AI asks for the rate and also calculates DSO without the tax, because revenue excludes it. It shows both and says which one governs.
What if my AI cannot run code?
It switches to no-code mode: it builds the Excel file with formulas and a Control sheet, and the Word footer says «NOT VERIFIED». You can run cuadre.py on your computer and get the seal later.
Treasury and cash