Report guide · REP-026 · v1.0
Saturn · Quarterly owner report with cash forecast
Quarter and six-month cash by scenario.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
8 sections, in this order
- 01Cover
- 02In 30 seconds: bottom line, 3 bullets and 5 KPI cards
- 03Results for the quarter against budget, prior year and prior quarter, with year to date
- 04Trend for the quarter's 3 months and the last 12 months
- 05Cash for the quarter: opening, closing and change
- 066-month cash forecast: base and downside cases against the minimum balance
- 07Decisions and risks, with owner and date
- 08Appendix: forecast assumptions, limitations, controls and glossary
Controls 7/7
What it checks before writing a single figure
C1Complete data: headers, numeric figures, no duplicate lines and valid units (cuadre.py).
C2Quarterly income statement subtotals reconcile: gross profit, EBITDA, operating profit and profit for the period with their lines (cuadre.py).
C3Consistent sign convention: costs and expenses with a single sign (cuadre.py).
C4The quarter is the sum of its 3 months and year to date the sum of the fiscal year's months, by line and scenario (Control sheet = 0).
C5Cash continuity: the forecast starts from reconciled closing cash and every month meets opening + inflows − outflows = closing (Control sheet = 0).
C6The downside case differs from the base case only by the declared adjustment, month by month (Control sheet = 0).
C7Traceable figures: every figure in the Word file exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 7/7 · REP-026 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 filesFixed711
- 1Role, audience and business context795
- 2Parameters734
- 3Repporti standard439
- 4Data contract1,279
- 5Questions first556
- 6Validation with a hard stop1,609
- 7Calculation by code340
- 7-bisNo-code modeFixed481
- 8Formulas1,075
- 9Structure1,790
- 10Writing without «AI slop» and without invention926
- 11Theme and notation1,316
- 12QA, traceability and seal1,233
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
- Quarterly
- 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 I don't have a cash forecast?
The AI proposes a simple one from the budget and your collection and payment days, shows you every assumption and waits for your confirmation before calculating. In the report it is labelled as a proposal, not as management's forecast.
What is the downside case?
The one agreed with the owner and written in notas.txt. If there is none, it uses customer collections 10% lower and nothing else, stated as an assumption. The Excel file lets you change it.
Why 6 months by month and not 13 weeks?
Because it is an owner report and the decision horizon is the half year. If you need cash week by week, use Orion · 13-week cash flow.
Does it work if my fiscal year is not the calendar year?
Yes. The quarter is built from the months of your fiscal year (the year-end in your profile) and year to date starts in that year's first month.
What if I don't have the quarter's cash flow statement?
The report shows opening cash, closing cash and the change, and says the cash flow statement is missing to explain it by line. It never allocates the change on its own.
Treasury and cash