Skip to content

Report guide · REP-009 · v1.0

Capella · Working capital and cash conversion cycle

Tied-up cash and impact of cycle improvements.

PaidGlobal standardStandard 2026.10Controls 6/6MonthlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Working capital and cash conversion cycle · October 2026REP-009 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 6/6 · REP-009 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 6/6
REP-009 · Working capital and cash conversion cycle · October 2026 · illustrative example with fictitious data
  • Word (.docx), 5 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, Series, AR, AP, Bridge, Targets, Control and Charts sheets, with live formulas
  • Optional PowerPoint (.pptx) with 1 to 3 summary slides

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

What it includes

6 sections, in this order

  1. 01In 30 seconds: bottom line, 3 bullets and 5 cards (DSO, DIO, DPO, cycle and operating working capital)
  2. 0213-month trend in small multiples on the same scale
  3. 03Where the cash is: working capital bridge against prior year (activity and days)
  4. 04Receivables and payables: ageing, concentration and agreed terms
  5. 05Targets and decisions: the cash each day of improvement frees up, with an owner and a date
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed670
  2. 1Role, audience and business context745
  3. 2Parameters878
  4. 3Repporti standard346
  5. 4Data contract1,493
  6. 5Questions first488
  7. 6Validation with a hard stop1,016
  8. 7Calculation by code1,112
  9. 7-bisNo-code modeFixed521
  10. 8Formulas1,590
  11. 9Structure1,190
  12. 10Writing without «AI slop» and without invention1,000
  13. 11Theme and notation1,051
  14. 12QA, traceability and seal1,062
The licensed prompt is provided when copied.≈ 35,241 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 / CFOAccountant / firm
Area
Treasury and cash
Frequency
Monthly
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 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.