Skip to content

Report guide · REP-026 · v1.0

Saturn · Quarterly owner report with cash forecast

Quarter and six-month cash by scenario.

PaidGlobal standardStandard 2026.10Controls 7/7QuarterlyXLSXDOCXPPTX
Meridian Coffee Co. (Demo) · Quarterly owner report with cash forecast · October 2026REP-026 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 7/7 · REP-026 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 7/7
REP-026 · Quarterly owner report with cash forecast · October 2026 · illustrative example with fictitious data
  • Word (.docx), 8 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, Quarter, Trend, Forecast (editable assumptions), Control and Charts sheets
  • Optional 3-slide PowerPoint (.pptx): results, projected cash and decisions

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

What it includes

8 sections, in this order

  1. 01Cover
  2. 02In 30 seconds: bottom line, 3 bullets and 5 KPI cards
  3. 03Results for the quarter against budget, prior year and prior quarter, with year to date
  4. 04Trend for the quarter's 3 months and the last 12 months
  5. 05Cash for the quarter: opening, closing and change
  6. 066-month cash forecast: base and downside cases against the minimum balance
  7. 07Decisions and risks, with owner and date
  8. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed711
  2. 1Role, audience and business context795
  3. 2Parameters734
  4. 3Repporti standard439
  5. 4Data contract1,279
  6. 5Questions first556
  7. 6Validation with a hard stop1,609
  8. 7Calculation by code340
  9. 7-bisNo-code modeFixed481
  10. 8Formulas1,075
  11. 9Structure1,790
  12. 10Writing without «AI slop» and without invention926
  13. 11Theme and notation1,316
  14. 12QA, traceability and seal1,233
The licensed prompt is provided when copied.≈ 35,521 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
Quarterly
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 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.