Report guide · REP-028 · v1.0
Neptune · SaaS metrics (MRR, churn, CAC, LTV)
MRR, retention, acquisition and cash runway.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01In 30 seconds: bottom line, 3 bullets and 6 KPI cards
- 02Growth: the month's MRR bridge and a 12-month series
- 03Retention: customer and MRR churn, NRR and GRR, and cohorts if available
- 04Efficiency: CAC, ARPA, gross margin, capped LTV, LTV/CAC, payback, quick ratio and burn multiple
- 05Cash: net burn, financing and runway
- 06Decisions and an appendix with definitions, assumptions, 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).
C2Accounting subtotals reconcile when the table includes them (cuadre.py).
C3Consistent sign convention: costs and expenses with a single sign (cuadre.py).
C4MRR bridge: opening + new + expansion + reactivation − contraction − churn = closing, and each month's opening = the prior month's closing (Control sheet = 0).
C5Customer bridge: opening + new + reactivated − churned = closing, month by month (Control sheet = 0).
C6Expenses = sum of their lines every month; the AI stops if revenue and MRR differ by more than 10% (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-028 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 filesFixed640
- 1Role, audience and business context791
- 2Parameters840
- 3Repporti standard421
- 4Data contract1,083
- 5Questions first468
- 6Validation with a hard stop1,623
- 7Calculation by code346
- 7-bisNo-code modeFixed444
- 8Formulas1,597
- 9Structure1,216
- 10Writing without «AI slop» and without invention917
- 11Theme and notation961
- 12QA, traceability and seal1,165
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
- Startups and investors
- Frequency
- Monthly
- Industry
- Software, Subscriptions, Startups
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
Why is LTV capped?
Because with low monthly churn the implied customer lifetime explodes (at 0.9% it would be over 100 months) and LTV stops being credible. The default cap is 60 months; you change it on the Assumptions sheet and the report also shows the uncapped value.
Is my MRR calculated like revenue?
No. MRR is the monthly value of active subscriptions at month end (annual plans divided by 12, no one-off services or taxes); revenue follows the accounting framework in your profile. If they differ by more than 10% in any month, the AI stops and asks why.
What about customers who come back?
They count as reactivations, not new customers: they are excluded from CAC and NRR and appear as their own step in the MRR bridge.
Does it work with less than 12 months of history?
Yes. Trailing 3-month metrics start once there are 3 months; year-on-year growth and 12-month series are skipped and the gap is stated under «Limitations».
Does it compare against industry benchmarks?
Only if you attach them with their source. The prompt does not invent market references.
Startups and investors