Report guide · REP-010 · v1.0
Arcturus · 12-month cash forecast
Spot months below minimum cash.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01In 30 seconds: lowest-cash month, headroom and funding need by scenario
- 02Chart of the monthly closing balance with the downside case and the minimum balance
- 0312-month table for the base case: collections, payments, taxes, debt, capex and balance
- 04Assumptions by scenario, dated commitments and sensitivity of the lowest balance
- 05Risks and decisions: options with an amount and a deadline month
- 06Appendix: downside case, controls, limitations and glossary
Controls 6/6
What it checks before writing a single figure
C1Reconciled opening balance: cash in the trial balance matches its accounts and, if provided, the banks plus reconciling items.
C2Complete history: 12 consecutive months ending at the cut-off, with revenue and cost of sales in every month.
C3Valid assumptions and commitments: every driver in every scenario and within range; commitments inside the horizon, with a coherent category and sign and no duplicates.
C4Continuity and identities on the Control sheet: closing = opening + net flow, each closing balance is the next month's opening, and collections and payments reconcile with receivables and payables.
C5Figures table valid for the kit: numeric values, no repeated lines, valid units and outflows with a single sign (cuadre.py validar).
C6Traceable figures: every figure in the Word file exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-010 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 filesFixed602
- 1Role, audience and business context731
- 2Parameters736
- 3Repporti standard385
- 4Data contract1,454
- 5Questions first595
- 6Validation with a hard stop991
- 7Calculation by code1,936
- 7-bisNo-code modeFixed522
- 8Formulas1,582
- 9Structure1,514
- 10Writing without «AI slop» and without invention954
- 11Theme and notation1,026
- 12QA, traceability and seal941
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
Where do forecast sales come from?
From the same month of the prior year times each scenario's growth, so seasonality is kept. If you attach your sales budget, it governs the base case.
What if I have no supuestos.csv?
The AI proposes assumptions from history (last month's days and margin, 0% growth) and asks you to confirm them before forecasting. Every assumption is written into the report.
Does it include the loan I plan to request?
No, unless it is approved and you load it as a commitment. The report shows the funding need and the options to cover it; it never takes a loan for granted.
What about my country's taxes?
Names come from your profile's Standard, but you give the dates and amounts as commitments: the AI asks for them and does not assume them.
How is it different from the 13-week cash flow?
This one looks 12 months ahead by month to decide investment and financing; the 13-week one looks week by week to decide payments and collections. They work together.
Treasury and cash