Report · REP-026 · v1.0
Saturn · Quarterly owner report with cash forecast
How the business did in the quarter and how much cash it will have over the next 6 months, in a base case and a downside case against the minimum cash balance.
Turns the results of the quarter's three months, month-end cash and management's cash forecast into an 8-page report for the owner: results against budget, prior year and prior quarter, cash for the quarter, and the 6-month monthly forecast with its low point and headroom over the minimum balance.
The quarter is summed by code and reconciled month by month; the forecast starts from reconciled closing cash and every month balances opening + inflows − outflows = closing. The downside case changes only what management declares. If anything does not reconcile, the AI stops and asks; it never adjusts the forecast to make it look better.
Delivers a Word report for the owner and an Excel workbook with editable assumptions: change collections or the minimum balance and the forecast and controls recalculate. Terms, statements and number format come from the Repporti Standard in your profile.
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
NOT VERIFIED — controls not executed by code. Review the Control sheet of the XLSX.
Prompt outline
What the prompt contains, block by block
- 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
Repporti Standard
It comes out adapted to your report profile
Compatible with every country and framework in the Standard: when you copy, it is composed with your profile (country, accounting framework, report language, currency, unit and year-end). Terminology, number format and statement names come from the Standard, not from the prompt.
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 name → an alias (“Client 07”); tax ID → “ID-XX”.
- Customers, suppliers and employees → codes (C001, P001, E001). The mapping table stays on your computer.
- Use an AI that does not train on your data: business plan, API or training turned off.
Who it is for
Made for whoever delivers the report
- Area
- Treasury and cash
- Frequency
- Quarterly
- Industry
- All
Compatibility
Which AI it works with
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Designed for plans with data analysis (ChatGPT) or code execution (Claude): cuadre.py runs inside the AI. |
| No-code mode | Copilot · Gemini | Generates the Excel file with formulas and a Control sheet. The footer says “NOT VERIFIED” unless you run cuadre.py on your computer. |
Questions
About this report
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