Report guide · REP-008 · v1.0
Orion · 13-week cash flow
Receipts, payments and cash-risk weeks.
The Process organizes manual work; it does not run or validate resources.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Summary: lowest-balance week, headroom, weeks at risk and net flow
- 02Chart of the 13 weekly closing balances against the minimum balance
- 0313-week table by cash-flow line
- 04Risks and decisions: quantified levers with an owner and a date
- 05Assumptions and bank reconciliation of the opening balance
Controls 5/5
What it checks before writing a single figure
C1Reconciled opening balance: bank + reconciling items = book cash (N/A if you do not attach the trial balance).
C2Complete data with no double counting: valid categories and signs, dates within the horizon, third parties as codes and no collection or payment repeated with receivables or payables.
C3Weekly continuity: opening + inflows − outflows = closing, and each closing balance is the next week's opening.
C4Cross totals: the sum by line, the sum by week and the change in balance match; collections do not exceed receivables and payments do not exceed payables.
C5Traceable figures: every figure in the Word file exists in calculo.json with the same rounding.
If the script ran
Repporti controls 5/5 · REP-008 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 filesFixed627
- 1Role, audience and business context772
- 2Parameters671
- 3Repporti standard271
- 4Data contract1,761
- 5Questions first645
- 6Validation with a hard stop502
- 7Calculation by code380
- 7-bisNo-code modeFixed555
- 8Formulas and rules894
- 9Structure1,257
- 10Writing without «AI slop» and without invention826
- 11Theme and notation949
- 12QA, traceability and seal946
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
- Weekly
- 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 goes in partidas.csv?
Everything that moves cash and is not in receivables or payables: payroll, social charges, employee benefits, taxes, rent, debt, capex, cash sales and expected new sales, with date, amount and recurrence.
How is each customer's payment timing estimated?
Due date plus a lag in days. If you don't give one, the script uses the weighted average days late of your overdue receivables and states it as an assumption.
How do I update it every week?
Run it again with the new bank balances, receivables and payables. The previous week 1 moves to the Actual_vs_Forecast sheet to measure the difference.
Does it work in any country?
Yes. You set up your reporting profile once (country, framework, report language, currency, unit and year-end) and the prompt comes out with the Repporti Standard for that profile: terms, statements, number format and country pitfalls. The report core is the same everywhere.
Treasury and cash