Report · REP-019 · v1.0
Centauri · Parent company reporting package
The subsidiary's monthly package in the group's chart of accounts, currency and format: mapped, translated, with intercompany items reconciled and every variance split into operating and exchange-rate effects.
Turns the local trial balance, the mapping to the group chart of accounts, the exchange rates and the intercompany items into the month's reporting package: income statement for the month and year to date and balance sheet in local and group currency, an intercompany schedule with each counterparty's confirmations, the translation reserve with its movement and commentary on variances against the group budget.
Before calculating, the AI checks with code that the trial balance balances, that 100% of detail accounts have a group account, that every exchange rate and opening balance exists and that each intercompany item sits in the local account it cites. If something fails, it stops and asks. Differences with counterparties are never adjusted: they are shown with their cause or as «[to be reconciled]».
Every variance against budget is split into an operating effect (at the budget rate) and an exchange-rate effect, and the translation reserve is the only item that balances the translated balance sheet. Delivers the package in Excel with the group's sheets and a Control sheet, plus a memo for the group controller, using the terms and number format of the Repporti Standard in your profile; the script checks every figure before printing the seal.
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
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 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
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
- Governance and financing
- 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
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