Report · REP-007 · v1.0
Rigel · Financial ratios for the period
18 liquidity, leverage, profitability and efficiency ratios with visible formulas, a 12-month trend and a traffic light against the targets you set.
Calculates 18 ratios from the period's trial balance: current ratio, quick ratio, cash ratio and working capital; debt ratio, debt-to-equity, short-term share and interest coverage; gross, operating, EBITDA and net margins, annualized ROA and ROE; DSO, DIO, DPO and cash conversion cycle.
With trial balances for up to 12 prior months it adds the trend, the comparison with the prior month and the same month last year, and the period's minimum and maximum. The script checks that each trial balance balances and that the opening balance of every asset and liability is the prior month's closing balance.
The traffic light only uses your thresholds («On target», «Watch», «Off target», with icon and text). There are no sector averages or invented «ideal levels»: each ratio is compared with the company itself and with the target you set, with the formula in view and the Standard's names for your language.
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
NOT VERIFIED — controls not executed by code. Review the Control sheet of the XLSX.
Prompt outline
What the prompt contains, block by block
- 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
Repporti Standard
It comes out adapted to your report profile
Compatible with every country and framework in the Standard: when you copy, it is composed with your profile (country, accounting framework, report language, currency, unit and year-end). Terminology, number format and statement names come from the Standard, not from the prompt.
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 name → an alias (“Client 07”); tax ID → “ID-XX”.
- Customers, suppliers and employees → codes (C001, P001, E001). The mapping table stays on your computer.
- Use an AI that does not train on your data: business plan, API or training turned off.
Who it is for
Made for whoever delivers the report
- Area
- Close and accounting
- Frequency
- Monthly
- Industry
- All
Compatibility
Which AI it works with
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Designed for plans with data analysis (ChatGPT) or code execution (Claude): cuadre.py runs inside the AI. |
| No-code mode | Copilot · Gemini | Generates the Excel file with formulas and a Control sheet. The footer says “NOT VERIFIED” unless you run cuadre.py on your computer. |
Questions
About this report
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