Report guide · REP-002 · v1.0
Sirius · Month-end management pack
Ten sections to review the month and decide.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
10 sections, in this order
- 01Cover and contents
- 02Committee summary: 120-word bottom line and 6 KPI cards
- 03Results for the month against budget and prior year
- 04Year-to-date results
- 05EBITDA bridge from budget to actual
- 06Top 5 material variances: what happened, why and what to do
- 07Statement of financial position against the prior month
- 08Working capital and liquidity: DSO, DPO, DIO and cash conversion cycle
- 09Cash movement for the month
- 10Decisions, follow-up on commitments and risks
Controls 6/6
What it checks before writing a single figure
C1The trial balance balances: debits = credits, balances net to 0 and there are no duplicate accounts.
C2Continuity by account: opening balance + debits − credits = closing balance.
C3Signs by line item: assets carry debit balances and liabilities credit balances; otherwise, reclassify.
C4Hierarchy and mapping: subtotals equal the sum of their detail accounts and 100% of detail accounts are mapped (by the reference chart or by the «rubro» column).
C5Derived checks: the statement of financial position balances at month-end and prior month, the EBITDA bridge closes and the cash movement lands exactly on the closing balance.
C6Traceable figures: every figure in the Word file (and the PowerPoint) exists in calculo.json with the same rounding.
If the script ran
Repporti controls 6/6 · REP-002 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 filesFixed688
- 1Role, audience and business context739
- 2Parameters814
- 3Repporti standard367
- 4Data contract1,702
- 5Questions first1,047
- 6Validation with a stop343
- 7Calculation by code1,878
- 7-bisNo-code modeFixed460
- 8Formulas1,039
- 9Structure1,942
- 10Writing without “AI slop” or inventions857
- 11Theme and notation1,073
- 12QA, traceability and seal986
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
How is it different from Polaris (REP-001)?
Polaris is a short report for the owner. Sirius is the management committee pack: it adds year to date, the EBITDA bridge, the top 5 variances, the balance sheet against the prior month and the cash movement.
Do I need the prior month's balance sheet?
No. The month's opening balances are the prior month's closing balances: the script builds the comparative balance sheet and the cash movement from the same trial balance.
What if the budget is not monthly?
The month is compared and year to date against budget shows «N/A», stated under «Limitations». With a month column, the script adds up the year to date from the start of the fiscal year.
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