Report guide · REP-019 · v1.0
Centauri · Parent company reporting package
Accounts, currency and comparisons for the parent.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01Cover: entity, period, rates used, preparation and review
- 02Income statement for the month and year to date in local and group currency against budget
- 03Translated balance sheet with the translation reserve and its movement
- 04Intercompany schedule: local, confirmed, difference and cause
- 05Variance commentary: operating and exchange-rate effects shown separately
- 06Memo for the group controller and Control sheet
Controls 5/5
What it checks before writing a single figure
C1Complete mapping: 100% of detail accounts fall into a single group account and every group account has its exchange rate.
C2Rates and opening balances: every rate the mapping requires exists with date and source, plus the prior package balances for equity.
C3A translated balance sheet that balances: assets = liabilities + equity, with the translation reserve as the only balancing item.
C4Reconciled intercompany: every item against the counterparty's confirmation, with the difference in group currency, the tolerance and the cause.
C5Traceable figures and variances that add up: operating + exchange rate = variance, and every figure in the memo exists in calculo.json.
If the script ran
Repporti controls 5/5 · REP-019 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 filesFixed774
- 1Role, audience and business context882
- 2Parameters802
- 3Repporti standard329
- 4Data contract1,550
- 5Questions first478
- 6Validation with a hard stop1,271
- 7Calculation by code995
- 7-bisNo-code modeFixed485
- 8Formulas1,298
- 9Structure1,075
- 10Writing without «AI slop» and without invention868
- 11Theme and notation758
- 12QA, traceability and seal1,240
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
- Governance and financing
- 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
Does it do the group consolidation?
No. It prepares the subsidiary's package so the group can consolidate: it maps, reclassifies intercompany items, translates and reconciles against confirmations. Eliminations are done by the group.
What if my currency is the same as the group's?
There is no translation and no translation reserve: the package is built in your currency with the group's chart of accounts and format.
What if a new account is not in the mapping?
The AI stops and lists it. It never assigns it on its own: the mapping is defined by the group manual.
Does it adjust intercompany differences?
No. It calculates each difference in group currency, compares it with the tolerance and explains it with your notes or leaves it «[to be reconciled with the counterparty]».
Can it come out in English for the group?
Yes: change the report language in your profile. The sheets use the group's account codes and names as they come in the mapping.
Governance and financing