Report · REP-002 · v1.0
Sirius · Month-end management pack
The 10-section pack the management committee uses to review the month and year to date, understand the EBITDA bridge and leave with assigned decisions.
From the month's trial balance it builds the full pack for the management committee: month and year-to-date results against budget and prior year, EBITDA bridge, top 5 material variances, statement of financial position against the prior month, working capital, cash movement and decisions with an owner and a date.
The script calculates everything from the trial balance: the prior-month balance sheet comes from the opening balances, the EBITDA bridge is written to puente.json and the cash movement runs from opening to closing balance with no differences. If a derived check does not close, the AI stops before writing.
Delivers a Word file of up to 12 pages and an Excel workbook with Month, YTD, Bridge, Balance Sheet, Cash Flow and Control sheets with live formulas, using your framework's statements and terms. If the committee has commitments from last month, the pack closes with their follow-up.
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
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 filesFixed688
- 1Role, audience and business context739
- 2Parameters814
- 3Repporti standard367
- 4Data contract1,702
- 5Questions first462
- 6Validation with a stop343
- 7Calculation by code520
- 7-bisNo-code modeFixed460
- 8Formulas1,039
- 9Structure1,798
- 10Writing without “AI slop” or inventions857
- 11Theme and notation1,073
- 12QA, traceability and seal986
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
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