Skip to content

Report guide · REP-019 · v1.0

Centauri · Parent company reporting package

Accounts, currency and comparisons for the parent.

PaidGlobal standardStandard 2026.10Controls 5/5MonthlyXLSXDOCXMD
Meridian Coffee Co. (Demo) · Parent company reporting package · October 2026REP-019 · p. 1/1
FICTITIOUS DATA · USD thousands · RS2026.10Repporti checks 5/5 · REP-019 v1.0
FICTITIOUS DATA · Meridian Coffee Co. (Demo)Checks 5/5
REP-019 · Parent company reporting package · October 2026 · illustrative example with fictitious data
  • Excel (.xlsx): the package with Cover, PL, BS, IC, CTA, FX, Commentary, Control and Mapping sheets, with live formulas
  • Word (.docx) or email of 1 to 2 pages for the group controller

Instructions for your AI; check sections, output files and controls before copying.

What it includes

6 sections, in this order

  1. 01Cover: entity, period, rates used, preparation and review
  2. 02Income statement for the month and year to date in local and group currency against budget
  3. 03Translated balance sheet with the translation reserve and its movement
  4. 04Intercompany schedule: local, confirmed, difference and cause
  5. 05Variance commentary: operating and exchange-rate effects shown separately
  6. 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.

On failure, instructions require a stop and an explanation.

What the prompt contains, block by block

Prompt outline

  1. 0Before you paste your filesFixed774
  2. 1Role, audience and business context882
  3. 2Parameters802
  4. 3Repporti standard329
  5. 4Data contract1,550
  6. 5Questions first478
  7. 6Validation with a hard stop1,271
  8. 7Calculation by code995
  9. 7-bisNo-code modeFixed485
  10. 8Formulas1,298
  11. 9Structure1,075
  12. 10Writing without «AI slop» and without invention868
  13. 11Theme and notation758
  14. 12QA, traceability and seal1,240
The licensed prompt is provided when copied.≈ 35,017 characters + cuadre.py (1,124 lines)

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 Standard

How to use it

From the trial balance to the report in three steps

  1. 01Configure and copyCheck profile and period before copying.
  2. 02Paste into your AIPaste the prompt and attach anonymized files in your AI.
  3. 03Review and deliverCheck controls and seal before sharing.

Anonymize before pasting

  • Company → alias; tax identifier → ID-XX.
  • People → codes. Keep the mapping on your device.
  • Use business AI, API or disable training.

Files and figures go to your AI; Repporti does not receive them.

Made for whoever delivers the report

Who it is for

Finance manager / CFOAccountant / firm
Area
Governance and financing
Frequency
Monthly
Industry
All

Which AI it works with

Compatibility

LevelAI
With code executionChatGPT · ClaudeRequires file analysis and Python execution for cuadre.py.
No-code modeCopilot · GeminiExcel 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.