Skip to content

Report guide · REP-007 · v1.0

Rigel · Financial ratios for the period

Eighteen ratios with formulas and trends.

PaidGlobal standardStandard 2026.10Controls 6/6MonthlyXLSXDOCX
Meridian Coffee Co. (Demo) · Financial ratios · October 2026REP-007 · p. 1/2
FICTITIOUS DATA · USD thousands · RS2026.10Prepared with Repporti
Meridian Coffee Co. (Demo) · Financial ratios · October 2026REP-007 · p. 2/2
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 6/6 · REP-007 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 6/6
01 / 02
REP-007 · Financial ratios · October 2026 · illustrative example with fictitious data
  • Word (.docx), 5 to 6 A4 pages
  • Excel (.xlsx) with one sheet per trial balance, Bases, Ratios with live formulas, Thresholds, Traffic light, Control and Charts

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

What it includes

7 sections, in this order

  1. 01Summary: traffic-light count and 3 messages with figures
  2. 02Dashboard of the 18 ratios with prior month, prior year and trend
  3. 03Liquidity: current ratio, quick ratio, cash ratio and working capital
  4. 04Leverage: debt ratio, debt-to-equity, short-term share and interest coverage
  5. 05Profitability: margins, annualized ROA and ROE
  6. 06Efficiency: DSO, DIO, DPO and cash conversion cycle
  7. 07Appendix: bases, thresholds, assumptions and limitations

Controls 6/6

What it checks before writing a single figure

  • C1Every trial balance balances: debits = credits, balances net to 0 and there are no duplicate accounts.

  • C2Continuity by account and between months: the opening balance of every asset and liability is the prior month's closing balance.

  • C3Signs by line item in the period's trial balance: assets with debit and liabilities with credit balances.

  • C4Hierarchy and mapping in every trial balance: subtotals = sum of detail accounts and 100% of detail accounts mapped.

  • C5Consistent thresholds: each threshold belongs to a valid ratio and green is on the good side of red (N/A without thresholds).

  • C6Traceable figures: every figure in the Word file exists in calculo.json with the same rounding.

If the script ran

Repporti controls 6/6 · REP-007 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 filesFixed670
  2. 1Role, audience and business context763
  3. 2Parameters662
  4. 3Repporti standard277
  5. 4Data contract1,373
  6. 5Preliminary questions428
  7. 6Validation with a hard stop442
  8. 7Calculation by code377
  9. 7-bisNo-code modeFixed535
  10. 8Formulas1,419
  11. 9Structure1,214
  12. 10Writing without “AI slop” and without inventions897
  13. 11Theme and notation988
  14. 12QA, traceability and seal886
The licensed prompt is provided when copied.≈ 33,246 characters + cuadre.py (794 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

Accountant / firmFinance manager / CFO
Area
Close and accounting
Frequency
Monthly
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

Do I need 12 trial balances?

No. The period's trial balance gives the 18 ratios; the prior ones add the trend and comparisons. Name each file with its month (balanza_2026-10).

How do I set up the traffic light?

With an umbrales.csv file: ratio id, green value and red value (and the direction if you want to change it). Without it, the report shows values and trends, with no colors.

Why doesn't it compare with the sector average?

Because there is no verifiable source for every sector, size and country. If you have a sector study, attach it and use it as a threshold.

What if my chart of accounts is not the reference one?

Add a «rubro» column to the trial balance with the ID of each detail account (ING, CV, GADM, GVEN, CLI, PROV…): it overrides the account code. The AI proposes it from the account names and asks you to confirm before calculating.