Skip to content

Report guide · REP-028 · v1.0

Neptune · SaaS metrics (MRR, churn, CAC, LTV)

MRR, retention, acquisition and cash runway.

PaidGlobal standardStandard 2026.10Controls 7/7MonthlyXLSXDOCXPPTX
Brewline Labs Inc. (Demo) · SaaS metrics (MRR, churn, CAC, LTV) · October 2026REP-028 · p. 1/2
FICTITIOUS DATA · USD · RS2026.10Prepared with Repporti
Brewline Labs Inc. (Demo) · SaaS metrics (MRR, churn, CAC, LTV) · October 2026REP-028 · p. 2/2
FICTITIOUS DATA · USD · RS2026.10Repporti checks 7/7 · REP-028 v1.0
FICTITIOUS DATA · Brewline Labs Inc. (Demo)Checks 7/7
01 / 02
REP-028 · SaaS metrics (MRR, churn, CAC, LTV) · October 2026 · illustrative example with fictitious data
  • Word (.docx), 6 A4 pages, ready to export to PDF
  • Excel (.xlsx) with Data, Metrics (12 months), Assumptions, Control and Charts sheets
  • Optional 2-slide PowerPoint (.pptx) for the board

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

What it includes

6 sections, in this order

  1. 01In 30 seconds: bottom line, 3 bullets and 6 KPI cards
  2. 02Growth: the month's MRR bridge and a 12-month series
  3. 03Retention: customer and MRR churn, NRR and GRR, and cohorts if available
  4. 04Efficiency: CAC, ARPA, gross margin, capped LTV, LTV/CAC, payback, quick ratio and burn multiple
  5. 05Cash: net burn, financing and runway
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed640
  2. 1Role, audience and business context791
  3. 2Parameters840
  4. 3Repporti standard421
  5. 4Data contract1,083
  6. 5Questions first468
  7. 6Validation with a hard stop1,623
  8. 7Calculation by code346
  9. 7-bisNo-code modeFixed444
  10. 8Formulas1,597
  11. 9Structure1,216
  12. 10Writing without «AI slop» and without invention917
  13. 11Theme and notation961
  14. 12QA, traceability and seal1,165
The licensed prompt is provided when copied.≈ 34,613 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

FounderFinance manager / CFO
Area
Startups and investors
Frequency
Monthly
Industry
Software, Subscriptions, Startups

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

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.