Report guide · REP-007 · v1.0
Rigel · Financial ratios for the period
Eighteen ratios with formulas and trends.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
7 sections, in this order
- 01Summary: traffic-light count and 3 messages with figures
- 02Dashboard of the 18 ratios with prior month, prior year and trend
- 03Liquidity: current ratio, quick ratio, cash ratio and working capital
- 04Leverage: debt ratio, debt-to-equity, short-term share and interest coverage
- 05Profitability: margins, annualized ROA and ROE
- 06Efficiency: DSO, DIO, DPO and cash conversion cycle
- 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.
What the prompt contains, block by block
Prompt outline
- 0Before you paste your filesFixed670
- 1Role, audience and business context763
- 2Parameters662
- 3Repporti standard277
- 4Data contract1,373
- 5Preliminary questions428
- 6Validation with a hard stop442
- 7Calculation by code377
- 7-bisNo-code modeFixed535
- 8Formulas1,419
- 9Structure1,214
- 10Writing without “AI slop” and without inventions897
- 11Theme and notation988
- 12QA, traceability and seal886
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
- Close and accounting
- 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
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.
Close and accounting