Report guide · REP-004 · v1.0
Altair · Budget vs actual with variance commentary
Material variances and causes to confirm.
The Process organizes manual work; it does not run or validate resources.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
8 sections, in this order
- 01Cover
- 02Summary: variance in profit for the period and the 3 largest material variances
- 03Month by line item: actual, budget, variance and execution
- 04Year to date by line item
- 05By cost center, with each center's operating profit
- 06Commentary on each material variance: what happened, why, type and what to do
- 07Non-material items and follow-up for the next close
- 08Appendix: controls, assumptions, limitations and glossary
Controls 7/7
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).
C5Consistent budget: valid line items and months, no duplicate rows and rows for the report period.
C6Actuals by cost center add up to the trial balance for each line item (N/A if you do not attach the cost-center file).
C7Traceable figures: every figure in the Word file (and the PowerPoint) exists in calculo.json with the same rounding.
If the script ran
Repporti controls 7/7 · REP-004 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 filesFixed605
- 1Role, audience and business context749
- 2Parameters734
- 3Repporti standard280
- 4Data contract1,462
- 5Questions first397
- 6Validation with a hard stop450
- 7Calculation by code332
- 7-bisNo-code modeFixed503
- 8Formulas870
- 9Structure1,621
- 10Writing without «AI slop» and without invention945
- 11Theme and notation1,039
- 12QA, traceability and seal948
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
- Profitability and costs
- 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
What format should the budget have?
One row per line item and month (YYYY-MM) with its amount in your currency and, if you have it, the cost center. Line items can be given by code (ING, GADM…) or by name.
What if I don't have actuals by cost center?
The analysis stays by line item, control 6 shows «N/A» and the cost-center section says «N/A». Nothing is allocated on assumptions.
Who decides whether a deviation is timing or permanent?
You or management. The AI only classifies it if notas.txt or your answer says so; otherwise it stays «[type to be confirmed]».
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.
Profitability and costs